C# CoreClientParam类代码示例

        private void DoAdd()
        {
            string strDeviceNo = this.tbDeviceNo.Text.Trim();
            string strCompareDate = this.dtCompareDate.Value.ToString("yyyy-MM-dd HH:mm:ss");
            string strSpecType = this.tbSpecType.Text.Trim();
            string strAllowDiff = this.tbAllowDiff.Text.Trim();
            string strWeight = this.tbWeight.Text.Trim();
            string strShowWeight = this.tbShowWeight.Text.Trim();
            string strDiffWeight = this.tbDiffWeight.Text.Trim();
            string strJudgeResult = this.tbJudgeResult.Text.Trim();
            string strOperator = this.tbOperator.Text.Trim();
            string strShift = this.tbShift.Text.Trim();
            string strTerm = this.tbTerm.Text.Trim();
            string strMemo = this.tbMemo.Text.Trim();
            string strGuid = Guid.NewGuid().ToString();

            string sql  = "insert into DT_COMPAREBALANCE (FS_DEVICENO,FD_COMPAREDATE,FS_SPECTYPE,FS_NUMBER,FN_ALLOWDIFF,";
            sql += "FN_WEIGHT,FN_SHOWWEIGHT,FN_DIFFWEIGHT,FS_JUDGERESULT,FS_OPERATOR,FS_SHIFT,FS_TERM,FS_MEMO) values(";
            sql += "'" + strDeviceNo + "',to_date('" + strCompareDate + "','yyyy-MM-dd hh24:mi:ss'),'" + strSpecType + "',";
            sql += "'" + strGuid + "','" + strAllowDiff + "','" + strWeight + "','" + strShowWeight + "','" + strDiffWeight + "',";
            sql += "'" + strJudgeResult + "','" + strOperator + "','" + strShift + "','" + strTerm + "','" + strMemo + "')";

            CoreClientParam ccp = new CoreClientParam();

            ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo";
            ccp.MethodName = "ExcuteNonQuery";
            ccp.ServerParams = new object[] { sql };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            if (!chkSelectData()) return;

            string strTmpTable, strTmpWhere;
            lstHint1.Items.Clear();

            strTmpTable = "DT_SAP261";
            strTmpWhere = getSelectNo();
            CoreClientParam ccpDel = new CoreClientParam();
            ccpDel.ServerName = "ygjzjl.base.QueryData";
            ccpDel.MethodName = "DeleteData";

            ccpDel.ServerParams = new object[] { strTmpTable, strTmpWhere };

            this.ExecuteNonQuery(ccpDel, CoreInvokeType.Internal);
            if (ccpDel.ReturnCode == 0)
            {
                lstHint1.Items.Add("信息删除成功！");
            }
            else
            {
                lstHint1.Items.Add("信息删除失败！");
            }
            showGridInfo();
        }

        /// <summary>
        /// 计量点查询
        /// </summary>
        private void PointQuery()
        {
            string strSQL = "select 'False' XZ,t.FS_POINTCODE,t.FS_POINTNAME,decode(t.FN_POINTFLAG,0,'未接管',1,'已接管') FN_POINTFLAG,t.FS_IP";
            strSQL += " from bt_pointflag t";
            CoreClientParam ccp = new CoreClientParam();
            this.dataTable1.Rows.Clear();
            ccp.ServerName = "ygjzjl.car.CarCard";
            ccp.MethodName = "queryByClientSql";
            ccp.ServerParams = new object[] { strSQL };
            ccp.SourceDataTable = dataTable1;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

            try
            {

                foreach (UltraGridRow ugr in ultraGrid1.Rows)
                {
                    if (ugr.Cells["FN_POINTFLAG"].Text.ToString() == "已接管")
                    {
                        ugr.Appearance.ForeColor = Color.Red;
                    }
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //从数据库获取磅房对应表面级别
        public void GetBMJBData(ComboBox cb, string PointID)
        {
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "ygjzjl.basedatamanage.QueryPointInfo";
            ccp.MethodName = "QueryBMJBData";
            ccp.ServerParams = new object[] { PointID };

            System.Data.DataTable dt = new System.Data.DataTable();

            ccp.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

            if (dt.Rows.Count > 0)
            {
                DataRow dr = dt.NewRow();
                dt.Rows.InsertAt(dr, 0);

                cb.DataSource = dt;
                cb.DisplayMember = "FS_FACELEVEL";
                cb.ValueMember = "FS_FACELEVEL";

                cb.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
                cb.AutoCompleteSource = AutoCompleteSource.ListItems;
            }
            else
            {
                cb.DataSource = dt;
            }
        }

        /// <summary>
        /// 获取计量点信息
        /// </summary>
        /// <param name="pointType">计量点类型</param>
        /// <returns>计量点数组</returns>
        public BT_POINT[] GetPoints(string pointType)
        {
            BT_POINT[] points = null;
            DataTable dt = new DataTable();
            ArrayList param = new ArrayList();
            param.Add(pointType);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.dbComm.DBComm";
            ccp.MethodName = "query";
            ccp.ServerParams = new object[] { "WEIGHPOINT_02.SELECT", param };
            ccp.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            if (dt.Rows.Count > 0)
            {
                points = new BT_POINT[dt.Rows.Count];
                BT_POINT point = null;
                DataRow dr = null;
                for (int i = 0;i < dt.Rows.Count;i++)
                {
                    dr = dt.Rows[i];
                    points[i] = ConvertDataRowToPointObject(dr);
                }

            }
            return points;
        }

        /// <summary>
        ///查询完整的数据
        /// </summary>
        private void ShowGridInfo()
        {
            TimeSpan ts = new TimeSpan(qDteBegin.Value.Hour, qDteBegin.Value.Minute, qDteBegin.Value.Second);
            qDteBegin.Value = qDteBegin.Value.Add(-ts);//默认当天的0时0分0秒为开始时间
            string beginTime = qDteBegin.Value.ToString("yyyyMMddHHmmss");
            string endTime = qDteBegin.Value.AddMinutes(Convert.ToDouble(1439)).ToString("yyyyMMddHHmmss");
            string stovno = txtLh.Text.Trim();
            string potno = txtGh.Text.Trim();

            ArrayList list = new ArrayList();
            dataSet1.Tables[0].Clear();
            list.Add(beginTime);
            list.Add(endTime);
            list.Add(beginTime);
            list.Add(endTime);
            txtLh.Text = "";
            txtGh.Text = "";
            CoreClientParam ccp = new CoreClientParam();
            if (stovno != string.Empty&&potno!=string.Empty)
            {
                list.Add(stovno);
                list.Add(potno);

                ccp.ServerName = "com.dbComm.DBComm";
                ccp.MethodName = "query";
                ccp.ServerParams = new object[] { "DATAMANAGE_01.SELECT", list };
                ccp.SourceDataTable = dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                return;
            }
            if(stovno==string.Empty&&potno!=string.Empty)
            {
                list.Add(potno);

                ccp.ServerName = "com.dbComm.DBComm";
                ccp.MethodName = "query";
                ccp.ServerParams = new object[] { "DATAMANAGE_01_01.SELECT", list };
                ccp.SourceDataTable = dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                return;
            }
            if (stovno!=string.Empty&&potno == string.Empty)
            {
                list.Add(stovno);

                ccp.ServerName = "com.dbComm.DBComm";
                ccp.MethodName = "query";
                ccp.ServerParams = new object[] { "DATAMANAGE_01_02.SELECT", list };
                ccp.SourceDataTable = dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                return;
            }
            ccp.ServerName = "com.dbComm.DBComm";
            ccp.MethodName = "query";
            ccp.ServerParams = new object[] { "DATAMANAGE_01_03.SELECT", list };
            ccp.SourceDataTable = dataSet1.Tables[0];
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
        }

        private void AddRecord()
        {
            if (!checkItems())
            {
                return;
            }
            string strweightno = Guid.NewGuid().ToString();
            string strStoveSeatNo = (ultraOptionSet1.CheckedIndex + 1).ToString();
            string strStoveNo = txtStoveNo1.Text.Trim().Replace("'", "''");
            string strPotNo = txtPotNo.Text.Trim().Replace("'", "''");
            string strGrossWeight = txtGrossWeight.Text.Trim().Replace("'", "''");
            //string strTearWeight = txtTearWeight.Text.Trim().Replace("'", "''");
            //string strNetWeight = txtNetWeight.Text.Trim().Replace("'", "''");
            string strReceiveFac = (ultraOptionSet2.CheckedIndex + 1).ToString();
            //string strAddRecorder = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
            string strAddRecorder = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName() + "手动新增";
            string strShift = Table_CA02_UserOrder.Static_T_CA02_UserOrder.GetUserOrderName(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserOrder()).ToString();//班次
            string strGroup = Table_CA02_UserGroup.Static_T_CA02_UserGroup.GetUserGroupName(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserGroup()).ToString();//班组
            ArrayList list = new ArrayList();
            list.Add(strStoveSeatNo);
            list.Add(strStoveNo);
            list.Add(strPotNo);
            list.Add(strGrossWeight);
            //list.Add(strTearWeight);
            //list.Add(strNetWeight);
            list.Add(strReceiveFac);
            list.Add(strAddRecorder);
            list.Add(strAddRecorder);
            list.Add(strShift);

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo";
            ccp.MethodName = "ExcuteNonQuery";

            string sql = " INSERT INTO dt_statictrackfirstweight (FS_WEIGHTNO,FS_STOVESEATNO,FS_STOVENO,FS_POTNO,"
                              + "FN_WEIGHT,FS_WEIGHTTYPE,FS_WEIGHTPERSON"
                              + ",FD_WEIGHTTIME,FS_SHIFT,FS_GROUP,fs_weightpoint) VALUES ('"
                              + strweightno + " ','" + strStoveSeatNo + "','" + strStoveNo + "','" + strPotNo + "','" +
                              strGrossWeight + "','" + strReceiveFac + "','" +
                              strAddRecorder + "',sysdate,'" + strShift + "','" + strGroup + "','K38')";

            ccp.ServerParams = new object[] { sql };
            this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode == 0)
            {
                MessageBox.Show("新增记录成功！");
                string strLog = "罐号=" + strPotNo + ",炉座号="//卡号、车号
            + strStoveSeatNo + ",炉号=" + strStoveNo + ",毛重="//物料、发货单位
            + strGrossWeight + ",流向=" + strReceiveFac + ",";
                this.objBi.WriteOperationLog("DT_STATICTRACKFIRSTWEIGHT", strDepartMent, strUserName, "增加", strLog, "数据修改", "静态铁水衡一次数据表", "静态铁水衡");//调用写操作日志方法

            }

            QueryData();
        }

 /// <summary>
 /// 根据订单号从SAP下载订单信息
 /// </summary>
 private void downOrderInfo(string sDdh)
 {
     DataTable dtOrder = new DataTable();
     CoreClientParam ccpProductNo = new CoreClientParam();
     ccpProductNo.ServerName = "ygjzjl.base.SapOperation";
     ccpProductNo.MethodName = "queryProductNo";
     ccpProductNo.ServerParams = new object[] { sDdh };
     dtOrder.Clear();
     ccpProductNo.SourceDataTable = dtOrder;
     this.ExecuteQueryToDataTable(ccpProductNo, CoreInvokeType.Internal);
 }

        private void Query()
        {
            string strQuerySql = "select FS_POINTCODE,FS_POINTNAME,FN_USEDPRINTPAPER FROM BT_POINT t where t.FS_POINTTYPE='QC' order by T.FS_POINTCODE ASC ";

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo";
            ccp.MethodName = "ExcuteQuery";
            ccp.ServerParams = new object[] { strQuerySql };
            ccp.SourceDataTable = this.dataSet1.Tables[0];
            this.dataSet1.Tables[0].Clear();
            ccp = this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
        }

 private void getWeightInfo(string strEnterFacNo)
 {
     string strSelectSql = "select FS_WEIGHTNO,FN_GROSSWEIGHT,to_char(FD_GROSSDATETIME,'YYYY-MM-DD HH24:MI:SS') FD_GROSSDATETIME,FN_TAREWEIGHT,to_char(FD_TAREDATETIME,'YYYY-MM-DD HH24:MI:SS') FD_TAREDATETIME,FN_NETWEIGHT ";
     strSelectSql += "from DT_CARWEIGHT_WEIGHT where FS_ENTERFACNO='" + strEnterFacNo + "'";
     CoreClientParam selectccp = new CoreClientParam();
     selectccp.ServerName = "ygjzjl.carcard";
     selectccp.MethodName = "queryByClientSql";
     selectccp.ServerParams = new object[] { strSelectSql };
     dataSet1.Tables["车辆称重信息"].Clear();
     selectccp.SourceDataTable = dataSet1.Tables["车辆称重信息"];
     this.ExecuteQueryToDataTable(selectccp, CoreInvokeType.Internal);
 }

        //调用SAP的BAPI_GOODSMVT_CREATE
        public string BAPI_GOODSMVT_CREATE(string sCode, string[] sArrayHeader, ArrayList listSubItem)
        {
            ArrayList listItem = new ArrayList();
            CoreClientParam ccp = new CoreClientParam();

            strSapError = "";
            Array.Clear(strArrayUpload, 0, strArrayUpload.Length);
            listItem.Clear();
            listItem.Add(listSubItem);

            strArrayUpload[0] = listSubItem[0].ToString();

            if (sCode == "02")
            {
                strArrayUpload[3] = listSubItem[10].ToString();
                strArrayUpload[1] = "101";
                strArrayUpload[9] = listSubItem[9].ToString();
            }
            if (sCode == "03")
            {
                strArrayUpload[1] = "261";
                strArrayUpload[3] = listSubItem[7].ToString();
                strArrayUpload[9] = "0001";
            }
            strArrayUpload[4] = listSubItem[3].ToString();
            strArrayUpload[5] = Convert.ToDateTime(objBi.GetServerTime()).ToString("yyyy-MM-dd HH:mm:ss");
            strArrayUpload[7] = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
            strArrayUpload[8] = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();

            strArrayUpload[10] = strArrayUpload[5];

            ccp.ServerName = "ygjzjl.sap.UploadSapRfc";

            if (sCode == "02")
                ccp.MethodName = "up_Product";
            if (sCode == "03")
                ccp.MethodName = "fl_Product";
            if (sCode == "04")
                ccp.MethodName = "up_BatchSplit";

            ccp.ServerParams = new object[] { "BAPI_GOODSMVT_CREATE", sArrayHeader, sCode, listItem };
            this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (ccp.ReturnCode == 0)
            {
                return ccp.ReturnObject.ToString();
            }
            else
            {
                return "";
            }
        }

        private void AddSubRecord(string strStoveNo, int i,string strTheorySingleWeight)
        {
            string strPerson = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName() +" 新增";
            string strSql = "insert into DT_STEELWEIGHTDETAILROLL (FS_WEIGHTNO,FS_STOVENO,FN_BILLETINDEX,FN_NETWEIGHT,FS_PERSON,FD_WEIGHTTIME) ";
            strSql += "values('" +Guid.NewGuid().ToString() + "','" + strStoveNo + "'," + i + "," + strTheorySingleWeight + ",'" + strPerson + "',";
            strSql+="sysdate)";

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo";
            ccp.MethodName = "ExcuteNonQuery";
            ccp.ServerParams = new object[] { strSql };
            this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
        }

 /// <summary>
 /// 执行存储过程2
 /// </summary>
 /// <param name="sql"></param>
 /// <param name="param"></param>
 /// <returns></returns>
 protected CoreClientParam excuteProcedure2(string sql, Hashtable param)
 {
     if (param == null)
     {
         param = new Hashtable();
     }
     CoreClientParam ccp = new CoreClientParam();
     ccp.ServerName = "com.dbComm.DBComm";
     ccp.MethodName = "executeProcedureBySql2";
     ccp.ServerParams = new object[] { sql, param };
     ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
     return ccp;
 }

        public void BindData2Grid()
        {
            //由卡号带出绑定的车号
            string strCardIsExist = "select t.fs_sequenceno,t.FS_BINDCARNO from BT_CARDMANAGE t where t.fs_sequenceno='" + m_Reader.CardNo + "'";

            DataTable testdatatable = new DataTable();
            CoreClientParam selectccp = new CoreClientParam();
            selectccp.ServerName = "ygjzjl.carcard";
            selectccp.MethodName = "queryByClientSql";
            selectccp.ServerParams = new object[] { strCardIsExist };
            selectccp.SourceDataTable = testdatatable;
            this.ExecuteQueryToDataTable(selectccp, CoreInvokeType.Internal);
            if (testdatatable.Rows.Count == 0)
            {
                MessageBox.Show("该还未注册，不能使用！");
                return;
            }
            else
            {
                tbCardNo.Text = m_Reader.CardNo;
                tbCarNo.Text = testdatatable.Rows[0]["FS_BINDCARNO"].ToString();
            }

            if (isEnterFac(m_Reader.CardNo))
            {
                //出厂显示计量数据
                if (m_enterFacNo == string.Empty)
                {
                    MessageBox.Show("入厂流水号为空！");
                    return;
                }
                else
                {
                    showWeightInfo(m_enterFacNo);
                }
            }
            else
            {
                //进厂显示预报数据
                if (tbCarNo.Text == string.Empty)
                {
                    this.ultraGroupBox4.Visible = true;
                    this.ultraGroupBox3.Visible = false;
                }
                else
                {
                    showProdictInfo(tbCarNo.Text.Trim());
                }
            }
        }

        private void QueryFirstData()
        {
            string beginDate = dateTimePicker1.Value.ToString("yyyyMMdd0000");
            string endData = dateTimePicker4.Value.ToString("yyyyMMdd2359");

            //DataTable dt = new DataTable();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.dbComm.DBComm";
            ccp.MethodName = "query";
            ArrayList list = new ArrayList();
            list.Add(beginDate);
            list.Add(endData);
            if (!uce1.Checked && !uce2.Checked && !uce3.Checked)
            {
                list.Add("1");
                list.Add("2");
                list.Add("3");
            }
            else
            {
                string strStoveSeat1 = string.Empty;
                string strStoveSeat2 = string.Empty;
                string strStoveSeat3 = string.Empty;

                if (uce1.Checked)
                {
                    strStoveSeat1 = "1";
                }

                if (uce2.Checked)
                {
                    strStoveSeat2 = "2";
                }

                if (uce3.Checked)
                {
                    strStoveSeat3 = "3";
                }

                list.Add(strStoveSeat1);
                list.Add(strStoveSeat2);
                list.Add(strStoveSeat3);
            }
            dataSet1.Tables[2].Clear();
            ccp.ServerParams = new object[] { "FIRSTDATAQUERY_01.SELECT", list };
            ccp.SourceDataTable = dataSet1.Tables[2];
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
        }