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); }
//从数据库获取磅房对应流向 public void GetLXData(ComboBox cb, string PointMZID, string PointPZID) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.GetBaseInfo"; ccp.MethodName = "QueryLXIDData"; ccp.ServerParams = new object[] { PointMZID, PointPZID }; System.Data.DataTable dtLX = new System.Data.DataTable(); ccp.SourceDataTable = dtLX; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dtLX.Rows.Count > 0) { DataRow dr = dtLX.NewRow(); dtLX.Rows.InsertAt(dr, 0); cb.DataSource = dtLX; cb.DisplayMember = "FS_TYPENAME"; cb.ValueMember = "FS_FLOW"; cb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cb.AutoCompleteSource = AutoCompleteSource.ListItems; } else { cb.DataSource = dtLX; } }
//从数据库获取磅房对应表面级别 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> /// <returns></returns> private int checkIsExist() { DataTable dt = new DataTable(); string strSql = "select t.fs_batchno from dt_zkd_qm_batchnoinfo t where t.fs_batchno = '" + this.ugcpFS_BATCHNO.Text + "' and t.fn_bandno = '" + this.ugcpFN_BANDNO.Text + "'"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.base.QueryData"; ccp.MethodName = "queryByClientSql"; ccp.ServerParams = new object[] { strSql }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == 0) { if (dt.Rows.Count > 0) { return(1); } else { return(0); } } else { return(-1); } }
//从数据库中获取磅房对应供应单位 public void GetFHDWData(ComboBox cb, string PointID) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.QueryPointInfo"; ccp.MethodName = "QuerySCDWData"; ccp.ServerParams = new object[] { PointID }; System.Data.DataTable dtFHDW = new System.Data.DataTable(); ccp.SourceDataTable = dtFHDW; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dtFHDW.Rows.Count > 0) { DataRow dr = dtFHDW.NewRow(); dtFHDW.Rows.InsertAt(dr, 0); cb.DataSource = dtFHDW; cb.DisplayMember = "FS_MEMO"; cb.ValueMember = "FS_SENDER"; cb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cb.AutoCompleteSource = AutoCompleteSource.ListItems; } else { cb.DataSource = dtFHDW; } }
private void GetDataName() { string sql = "select fs_weighttype from DT_OPERATIONLOG GROUP BY fs_weighttype";//A.FS_POINTNO ='K02' and CoreClientParam ccp = new CoreClientParam(); //ccp.ServerName = "kiscicplat.dhs.carweight.CarWeightPrediction"; //ccp.MethodName = "QueryFHDWData"; //ccp.ServerParams = new object[] { strBFID }; ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { sql }; System.Data.DataTable dtBF = new System.Data.DataTable(); ccp.SourceDataTable = dtBF; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dtBF.Rows.Count > 0) { DataRow dr = dtBF.NewRow(); dtBF.Rows.InsertAt(dr, 0); this.cbBF.DataSource = dtBF; cbBF.DisplayMember = "fs_weighttype"; cbBF.ValueMember = "fs_weighttype"; cbBF.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbBF.AutoCompleteSource = AutoCompleteSource.ListItems; } else { cbBF.DataSource = dtBF; } }
private void btnSave_Click(object sender, EventArgs e) { if (ultraGrid1.ActiveRow == null) { MessageBox.Show("请先选择做预报记录!"); } else { string strResult = Check(); if (strResult != string.Empty) { MessageBox.Show(strResult); return; } Hashtable param = new Hashtable(); param.Add("I1", txtBatchNo.Text); param.Add("I2", txtStoveNo.Text); param.Add("I3", txtSteelType.Text); param.Add("I4", txtSpec.Text); param.Add("I5", cbPointID.SelectedValue.ToString()); param.Add("I6", txtReel.Text); param.Add("I7", cbBilletStatus.SelectedValue.ToString()); param.Add("I8", txtProductNo.Text); param.Add("I9", this.UserInfo.GetUserName().ToString()); param.Add("I10", this.UserInfo.GetUserOrder().ToString()); param.Add("I11", this.UserInfo.GetUserGroup().ToString()); CoreClientParam ccp = this.excuteProcedure2("{call KG_MCMS_ZKDINFO.ADD_ZKD_PLAN(?,?,?,?,?,?,?,?,?,?,?)}", param); this.GetFlowCardInfo(""); } }
/// <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; }
private bool CheckSteelTypeIsExist(string strSteelType) { try { string sql = "select fn_id,fs_SteelType,fs_Standard from BT_PRINTCARDSTANDARD where fs_steeltype = '" + strSteelType + "'"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "hgjzjl.highspeedwire.HighSpeedWireInfo"; ccp.MethodName = "QueryTableData"; ccp.ServerParams = new object[] { sql }; DataTable dt_temp = new DataTable(); ccp.SourceDataTable = dt_temp; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dt_temp.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception exp) { MessageBox.Show(exp.Message); return(false); } }
//下载流向信息 ,add by luobin private void DownLoadFlow() { DataTable m_FlowTable = new DataTable();//流向数据表 DataColumn dc; dc = new DataColumn("FS_TYPECODE".ToUpper()); m_FlowTable.Columns.Add(dc); dc = new DataColumn("FS_TYPENAME".ToUpper()); m_FlowTable.Columns.Add(dc); string sql = "select FS_TYPECODE, FS_TYPENAME From BT_WEIGHTTYPE order by FS_TYPECODE "; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { sql }; ccp.SourceDataTable = m_FlowTable; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); DataRow dr = m_FlowTable.NewRow(); dr["FS_TYPECODE"] = ""; dr["FS_TYPENAME"] = ""; m_FlowTable.Rows.InsertAt(dr, 0); cbFlow.DataSource = m_FlowTable; cbFlow.DisplayMember = "FS_TYPENAME"; cbFlow.ValueMember = "FS_TYPECODE"; }
//从数据库获取磅房对应物料 public void GetWLData(ComboBox cb, string PointID) { try { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.QueryPointInfo"; ccp.MethodName = "QueryWLData"; ccp.ServerParams = new object[] { PointID }; System.Data.DataTable dtWL = new System.Data.DataTable(); ccp.SourceDataTable = dtWL; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dtWL.Rows.Count > 0) { DataRow dr = dtWL.NewRow(); dtWL.Rows.InsertAt(dr, 0); cb.DataSource = dtWL; cb.DisplayMember = "FS_MATERIALNAME"; cb.ValueMember = "FS_MATERIALNO"; cb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cb.AutoCompleteSource = AutoCompleteSource.ListItems; } else { cb.DataSource = dtWL; } } catch (Exception e) { } }
private void AddRecord() { if (!checkItems()) { return; } string strGrossPoint = "K38"; string strTarePoint = "K38"; 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_STATICTRACKWEIGHT_WEIGHT (FS_WEIGHTNO,FS_STOVESEATNO,FS_STOVENO,FS_POTNO," + "FN_GROSSWEIGHT,FN_TAREWEIGHT,FN_NETWEIGHT,FS_WEIGHTTYPE,FS_GROSSPERSON," + "FS_TAREPERSON,FD_GROSSTIME,FD_TARETIME,FS_GROSSSHIFT,FS_GROSSGROUP,FS_TARESHIFT,FS_TAREGROUP,FS_GROSSPOINT,FS_TAREPOINT) VALUES ('" + strweightno + " ','" + strStoveSeatNo + "','" + strStoveNo + "','" + strPotNo + "','" + strGrossWeight + "','" + strTearWeight + "','" + strNetWeight + "','" + strReceiveFac + "','" + strAddRecorder + "','" + strAddRecorder + "',sysdate,sysdate,'" + strShift + "','" + strGroup + "','" + strShift + "','" + strGroup + "','" + strGrossPoint + "','" + strTarePoint + "')"; ccp.ServerParams = new object[] { sql }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == 0) { MessageBox.Show("新增记录成功!"); string strLog = "罐号=" + strPotNo + ",炉座号=" //卡号、车号 + strStoveSeatNo + ",炉号=" + strStoveNo + ",毛重=" //物料、发货单位 + strGrossWeight + ",皮重=" + strTearWeight + ",净重=" //卸货地点、承运单位 + strNetWeight + ",流向=" + strReceiveFac + ","; this.objBi.WriteOperationLog("DT_STATICTRACKWEIGHT_WEIGHT", strDepartMent, strUserName, "增加", strLog, "数据修改", "静态铁水衡二次数据表", "静态铁水衡"); //调用写操作日志方法 } QueryData(); }
private void Update() { if (IsValid() == false) { return; } m_SelectPointID = this.cbBF.SelectedValue.ToString(); string strCarNo = this.tbCarNo.Text.Trim(); string strCardNo = this.tbCardNo.Text.Trim(); string strTareWeight = this.tbWeight.Text.Trim(); string sql = "update dt_termTare SET FS_CARDNUMBER = '" + strCardNo + "',"; sql += " FS_CARNO = '" + strCarNo + "',"; sql += " FN_TAREWEIGHT = '" + strTareWeight + "' "; sql += " where FS_WEIGHTNO = '" + m_WeightNo + "'"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "updateByClientSql"; ccp.ServerParams = new object[] { sql }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); }
private void DoUpdate() { if (DoCheck()) { string p_OldShift = ""; string p_Shift = tbShift.Text.Trim(); string p_StartTime = dateTimePicker1.Value.ToString("HH:mm:ss"); string p_EndTime = dateTimePicker2.Value.ToString("HH:mm:ss"); UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr == null) { p_OldShift = p_Shift; } else { p_OldShift = ugr.Cells["FS_SHIFTNAME"].Text.Trim(); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.ShiftBaseInfo"; ccp.MethodName = "update"; ccp.ServerParams = new object[] { p_OldShift, p_Shift, p_StartTime, p_EndTime }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.DoClear(); this.DoQuery(); } }
private void showMxsj(string sLh) { string strTmpTable, strTmpField, strTmpWhere, strTmpOrder; CoreClientParam ccpOrderInfo = new CoreClientParam(); ccpOrderInfo.ServerName = "ygjzjl.base.QueryData"; ccpOrderInfo.MethodName = "queryData"; strTmpTable = "DT_PRODUCTWEIGHTDETAIL"; strTmpField = "FS_BATCHNO,FN_BANDNO,FS_TYPE,FN_LENGTH,FN_WEIGHT,FN_BANDBILLETCOUNT,FD_DATETIME,FN_THEORYWEIGHT"; strTmpWhere = " AND FS_BATCHNO = '" + sLh + "' and FS_UPLOADFLAG='1'"; strTmpOrder = " ORDER BY FS_BATCHNO,FN_BANDNO"; System.Data.DataTable dtTmpData = new System.Data.DataTable(); dataSet1.Tables[2].Clear(); ccpOrderInfo.ServerParams = new object[] { strTmpTable, strTmpField, strTmpWhere, strTmpOrder }; ccpOrderInfo.SourceDataTable = dataSet1.Tables[2]; this.ExecuteQueryToDataTable(ccpOrderInfo, CoreInvokeType.Internal); //string strTmp = "明细数据:"; //if (dtTmpData.Rows.Count > 0) //{ // for (int i = 0; i < dtTmpData.Rows.Count - 1; i++) // { // strTmp += " | " + dtTmpData.Rows[i]["FS_BATCHNO"].ToString(); // strTmp += " " + dtTmpData.Rows[i]["FN_BANDNO"].ToString(); // strTmp += " " + dtTmpData.Rows[i]["FS_TYPE"].ToString(); // strTmp += " " + dtTmpData.Rows[i]["FN_WEIGHT"].ToString(); // } // rtxtHint1.Text += strTmp + "\n"; //} }
private void QueryLog() { //if (!limitQueryTime.ParseTimeLegal(BeginTime.Value, EndTime.Value)) //{ // return; //} string strBeginTime = BeginTime.Value.ToString("yyyy-MM-dd 00:00:00"); string strEndTime = EndTime.Value.ToString("yyyy-MM-dd 23:59:59"); string strQuerySql = "select FS_OPERATIONNO,FS_TABLENAME,FS_DEPART,FS_TYPE,to_char(FD_TIME,'yyyy-MM-dd hh24:mi:ss') as FD_TIME ,FS_OPERATOR,FS_DATA,FS_IP,FS_GRAPHNAME,FS_DATANAME,FS_WEIGHTTYPE from DT_OPERATIONLOG t "; strQuerySql += " where t.fd_time between to_date('" + strBeginTime + "', 'yyyy-MM-dd hh24:mi:ss') and to_date('" + strEndTime + "', 'yyyy-MM-dd hh24:mi:ss') "; if (this.cbBF.SelectedValue != null && this.cbBF.SelectedValue.ToString() != "") { strQuerySql += " and t.fs_weighttype='" + this.cbBF.SelectedValue.ToString() + "'"; } strQuerySql += "ORDER BY FD_TIME DESC"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { strQuerySql }; ccp.SourceDataTable = this.dataSet1.Tables[1]; this.dataSet1.Tables[1].Clear(); this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); }
private bool CheckIsExist(string strBatchNo) { try { string strSql = "select * from DT_STEELWEIGHTMAIN where fs_stoveno = '" + strBatchNo + "'"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { strSql }; DataTable dt_temp = new DataTable(); ccp.SourceDataTable = dt_temp; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dt_temp.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception exp) { MessageBox.Show(exp.Message); return(false); } }
/// <summary> /// 从数据库获取发货单位数据(DHS项目实施后要做相应修改,供应商改为发货单位) /// </summary> private void GetFHDWData() //客户端加参数,调用kiscicplat.common.QueryByClient { string sql = "select FS_POINTCODE ,FS_POINTNAME from bt_point where FS_POINTTYPE='QC'"; //A.FS_POINTNO ='K02' and CoreClientParam ccp = new CoreClientParam(); //ccp.ServerName = "kiscicplat.dhs.carweight.CarWeightPrediction"; //ccp.MethodName = "QueryFHDWData"; //ccp.ServerParams = new object[] { strBFID }; ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { sql }; System.Data.DataTable dtBF = new System.Data.DataTable(); ccp.SourceDataTable = dtBF; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dtBF.Rows.Count > 0) { DataRow dr = dtBF.NewRow(); dtBF.Rows.InsertAt(dr, 0); this.cbBF.DataSource = dtBF; cbBF.DisplayMember = "FS_POINTNAME"; cbBF.ValueMember = "FS_POINTCODE"; cbBF.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbBF.AutoCompleteSource = AutoCompleteSource.ListItems; } else { cbBF.DataSource = dtBF; } }
/// <summary> /// 根据物料号获取物料名称信息 /// </summary> public string getMaterialName(string sMaterial) { if (sMaterial == "") { return(""); } string strTmpTable, strTmpField, strTmpWhere; CoreClientParam ccpData = new CoreClientParam(); ccpData.ServerName = "ygjzjl.base.QueryData"; ccpData.MethodName = "queryData"; strTmpTable = "IT_MATERIAL"; strTmpField = "FS_MATERIALNAME"; strTmpWhere = " AND FS_SAPCODE='" + sMaterial + "'"; System.Data.DataTable dtTmpData = new System.Data.DataTable(); ccpData.ServerParams = new object[] { strTmpTable, strTmpField, strTmpWhere, "" }; // dtTmpData.Clear(); ccpData.SourceDataTable = dtTmpData; this.ExecuteQueryToDataTable(ccpData, CoreInvokeType.Internal); if (dtTmpData.Rows.Count > 0) { return(dtTmpData.Rows[0]["FS_MATERIALNAME"].ToString()); } else { return(""); } }
private int getBilletCountByStoveNo(string strStoveNo) { string strSql = "select FN_BILLETCOUNT from dt_steelweightmain where FS_STOVENO='" + strStoveNo + "'"; DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { strSql }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dt.Rows.Count > 0) { try { return(Convert.ToInt16(dt.Rows[0]["FN_BILLETCOUNT"].ToString())); } catch { return(0); } } else { return(0); } }
//本地SAP系统部署 // private SAPLogonControlClass connctl = new SAPLogonControlClass(); // private Connection conn; #endregion #region 数据信息检查 /// <summary> /// 查询数据是否存在,返回布尔 /// </summary> /// <param name="sField">字段</param> /// <param name="sTable">数据库表</param> /// <param name="sWhere">查询条件</param> /// <returns></returns> public bool chkBatchDataExist(string sField, string sTable, string sWhere) { string strTmpOrder; CoreClientParam ccpData = new CoreClientParam(); ccpData.ServerName = "ygjzjl.base.QueryData"; ccpData.MethodName = "queryData"; strTmpOrder = ""; System.Data.DataTable dtTmpData = new System.Data.DataTable(); ccpData.ServerParams = new object[] { sTable, sField, sWhere, strTmpOrder }; // dtTmpData.Clear(); ccpData.SourceDataTable = dtTmpData; this.ExecuteQueryToDataTable(ccpData, CoreInvokeType.Internal); if (dtTmpData.Rows.Count > 0) { return(true); } else { return(false); } }
/// <summary> /// 显示方坯信息 /// </summary> private void showGridInfo() { string strTmpTable, strTmpField, strTmpOrder; CoreClientParam ccpData = new CoreClientParam(); ccpData.ServerName = "ygjzjl.base.QueryData"; ccpData.MethodName = "queryData"; strTmpTable = ""; strTmpField = ""; strTmpOrder = ""; strTmpTable = "DT_PRODUCTWEIGHTMAIN t"; strTmpField = "TO_CHAR(t.FD_ENDTIME,'yyyy-MM-dd HH24:mi:ss') AS GBSJ,t.FS_BATCHNO,t.FS_PRODUCTNO," + "t.FS_ITEMNO,t.FS_SAPSTORE,t.FS_AUDITOR,t.FD_AUDITTIME,t.FS_ISMATCH,t.FS_UPLOADFLAG," + "t.FS_ACCOUNTDATE,t.FS_STEELTYPE,t.FS_SPEC,t.FS_HEADER,"; strTmpField += " (select sum( r.FN_WEIGHT) from DT_PRODUCTWEIGHTDETAIL r where r.FS_BATCHNO=t.FS_BATCHNO and r.FS_UPLOADFLAG='1') as FN_TOTALWEIGHT,"; strTmpField += "(select sum( r.FN_THEORYWEIGHT) from DT_PRODUCTWEIGHTDETAIL r where r.FS_BATCHNO=t.FS_BATCHNO and r.FS_UPLOADFLAG='1') as FN_THEORYTOTALWEIGHT"; strTmpOrder = " ORDER BY FD_ENDTIME"; ccpData.ServerParams = new object[] { strTmpTable, strTmpField, strWhere, strTmpOrder }; // dataSet1.Tables[0].Clear(); ccpData.SourceDataTable = dataSet1.Tables[0]; try { this.ExecuteQueryToDataTable(ccpData, CoreInvokeType.Internal); } catch (Exception) { MessageBox.Show("信息查询异常!"); } }
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> /// <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> /// <param name="cabinetCode">计量点编号</param> /// <returns>计量点设备组</returns> public BTDevice[] GetDevice(string cabinetCode) { BTDevice [] devices = null; DataTable dt = new DataTable(); ArrayList param = new ArrayList(); param.Add(cabinetCode); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.dbComm.DBComm"; ccp.MethodName = "query"; ccp.ServerParams = new object[] { "WEIGHDEVICE_01.SELECT", param }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dt.Rows.Count > 0) { devices = new BTDevice[dt.Rows.Count]; DataRow dr = null; for (int i = 0; i < devices.Length; i++) { dr = dt.Rows[i]; devices[i] = ConvertDataRowToDeviceObject(dr); } } return(devices); }
/// <summary> /// 显示方坯信息 /// </summary> private void showGridInfo() { string strTmpTable, strTmpField, strTmpOrder; CoreClientParam ccpData = new CoreClientParam(); ccpData.ServerName = "ygjzjl.base.QueryData"; ccpData.MethodName = "queryData"; strTmpTable = "DT_CARWEIGHT_WEIGHT"; strTmpField = "TO_CHAR(FD_GROSSDATETIME,'yyyy-MM-dd HH24:mi:ss') AS GBSJ,FS_STOVENO,FS_PRODUCTNO," + "FS_ITEMNO,FS_PLANT,FS_SAPSTORE,FS_UPLOADFLAG,FN_NETWEIGHT,FS_ACCOUNTDATE, FN_COUNT as FN_BILLETCOUNT,FS_MATERIALNAME"; strTmpOrder = " ORDER BY FD_GROSSDATETIME"; ccpData.ServerParams = new object[] { strTmpTable, strTmpField, strWhere, strTmpOrder }; // dataSet1.Tables[0].Clear(); ccpData.SourceDataTable = dataSet1.Tables[0]; try { this.ExecuteQueryToDataTable(ccpData, CoreInvokeType.Internal); } catch (Exception ex1) { MessageBox.Show("信息查询异常!"); } }
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(); }
private void DoUpdate() { if (strNumber == "") { MessageBox.Show("请先选择需要修改的记录"); return; } //string strDeviceNo = this.tbDeviceNo.Text.Trim(); //string strCompareDate = this.dtCompareDate.Text.Trim(); ;//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 strDeviceNumber = this.tbDeviceNumber.Text.Trim(); //string sql = "update DT_CORRENTION_DETAIL set FS_DEVICENO = '" + strDeviceNo + "',FD_COMPAREDATE = to_Date('" + strCompareDate + "','yyyy-MM-dd hh24:mi:ss'),"; //sql += " FS_SPECTYPE = '" + strSpecType + "',FN_ALLOWDIFF='" + strAllowDiff + "',FN_WEIGHT = '" + strWeight + "',FN_SHOWWEIGHT = '"+strShowWeight+"',"; //sql += " FN_DIFFWEIGHT = '" + strDiffWeight + "',FS_JUDGERESULT = '" + strJudgeResult + "',FS_OPERATOR = '" + strOperator + "',FS_SHIFT = '" + strShift + "',"; //sql += " FS_TERM = '" + strTerm + "',FS_MEMO = '" + strMemo + "' where FS_WEIGHTNO = '" + strNumber + "'"; string sql = "update DT_CORRENTION_DETAIL set FS_MEMO = '" + strMemo + "' where FS_WEIGHTNO = '" + strNumber + "'"; 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 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); }
/// <summary> /// 显示方坯信息 /// </summary> private void showGridInfo() { string strTmpTable, strTmpField, strTmpOrder; CoreClientParam ccpData = new CoreClientParam(); ccpData.ServerName = "ygjzjl.base.QueryData"; ccpData.MethodName = "queryData"; // String FN_NETWEIGHT = ""; strTmpTable = "DT_SteelWeightMain t"; strTmpField = "TO_CHAR(t.FD_STARTTIME,'yyyy-MM-dd HH24:mi:ss') AS GBSJ,t.FS_STOVENO,t.FS_PRODUCTNO,t.FS_ACCOUNTDATE,t.FS_MATERIALNAME,t.FS_STEELTYPE,t.FS_SPEC,t.FS_AUDITOR,t.FS_ITEMNO,t.FS_PLANT,t.FS_SAPSTORE,t.FS_UPLOADFLAG,t.FS_ISMATCH,"; strTmpField += " (select count( r.fs_weightno) from dt_steelweightdetailroll r where r.fs_stoveno=t.fs_stoveno) as FN_BILLETCOUNT ,"; strTmpField += "(select cast( sum( r.fn_netweight) as decimal(38,3)) from dt_steelweightdetailroll r where r.fs_stoveno=t.fs_stoveno) as FN_NETWEIGHT"; strTmpOrder = " ORDER BY t.FD_STARTTIME"; ccpData.ServerParams = new object[] { strTmpTable, strTmpField, strWhere, strTmpOrder }; // dataSet1.Tables[0].Clear(); ccpData.SourceDataTable = dataSet1.Tables[0]; try { this.ExecuteQueryToDataTable(ccpData, CoreInvokeType.Internal); //Constant.RefreshAndAutoSize(uGridData); } catch (Exception ex1) { lstHint2.Items.Add("信息查询异常!"); } }
/// <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); } }
/// <summary> /// 显示板坯信息 /// </summary> private void showGridInfo() { string strTmpTable, strTmpField, strTmpOrder; CoreClientParam ccpData = new CoreClientParam(); ccpData.ServerName = "ygjzjl.base.QueryData"; ccpData.MethodName = "queryData"; strTmpTable = "DT_SAP261"; strTmpField = "FS_WEIGHTNO,FN_NETWEIGHT,FS_STOVENO,FS_UPLOADFLAG,FS_AUDITOR,FS_HEADER,FS_PRODUCTNO," + "FS_PLANT,FS_SAPSTORE,FS_ACCOUNTDATE,FS_MATERIAL,FS_MATERIALNAME"; strTmpOrder = " ORDER BY FS_STOVENO"; ccpData.ServerParams = new object[] { strTmpTable, strTmpField, strWhere, strTmpOrder }; // dataSet1.Tables[0].Clear(); ccpData.SourceDataTable = dataSet1.Tables[0]; try { this.ExecuteQueryToDataTable(ccpData, CoreInvokeType.Internal); //Constant.RefreshAndAutoSize(uGridData); } catch (Exception ex1) { lstHint2.Items.Add(ex1.Message + "信息查询异常!"); } }
private void setStoveAsReturnBillet(string strStoveNo) { string strSQL = "update dt_bp_plan set FN_ISRETURNBILLET='1',FS_COMPLETEFLAG='0',"; strSQL += "fs_order=(select to_number(max(fs_order))+1 from dt_bp_plan) where FS_STOVENO='" + strStoveNo + "'"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteNonQuery"; ccp.ServerParams = new object[] { strSQL }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); strSQL = "update it_fp_techcard set FS_BATCHED='0',FS_BATCH_OPTOR=null,FS_BATCH_OPTDATE=null,fs_zc_batchno=null,"; strSQL += "fs_batched_heatno=null,"; strSQL += "FS_SOURCE_HEATNO=null,FS_SYS_BATCHNO=null where FS_GP_STOVENO='" + strStoveNo + "'"; ccp.ServerParams = new object[] { strSQL }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); strSQL = "update it_fp_techcard set fs_batched_heatno=replace(replace(fs_batched_heatno,'" + strStoveNo + ",',''),'," + strStoveNo + "','')"; strSQL += " where fs_batched_heatno like '%" + strStoveNo + "%'"; ccp.ServerParams = new object[] { strSQL }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); strSQL = "delete dt_zkd_plan where fs_stoveno='" + strStoveNo + "'"; ccp.ServerParams = new object[] { strSQL }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); }
private void DoUpdate() { if (DoCheck()) { string p_OldPondTypeNo = ""; string p_PondTypeNo = tbPondTypeNo.Text.Trim(); string p_PondTypeName = tbPondTypeName.Text.Trim(); UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr == null) { p_OldPondTypeNo = p_PondTypeNo; } else { p_OldPondTypeNo = ugr.Cells["FS_PONDTYPENO"].Text.Trim(); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.PondTypeBaseInfo"; ccp.MethodName = "update"; ccp.ServerParams = new object[] { p_OldPondTypeNo, p_PondTypeNo, p_PondTypeName }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.DoClear(); this.DoQuery(); } }
private void DoUpdate() { if (DoCheck()) { string p_OldPrinter = ""; string p_Printer = tbPrinter.Text.Trim(); string p_Describe = tbDescribe.Text.Trim(); int p_PaperNum = Convert.ToInt32(tbPaperNum.Text.Trim()); int p_InkNum = Convert.ToInt32(tbInkNum.Text.Trim()); UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr == null) { p_OldPrinter = p_Printer; } else { p_OldPrinter = ugr.Cells["FS_PRINTTYPECODE"].Text.Trim(); } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.PrinterBaseInfo"; ccp.MethodName = "update"; ccp.ServerParams = new object[] { p_OldPrinter, p_Printer, p_Describe, p_PaperNum, p_InkNum }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.DoClear(); this.DoQuery(); } }
/// <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 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); }
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); }
//调用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 ""; } }
/// <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; }
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); }
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); }
private void AddRecord() { if (!checkItems()) { return; } 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();//班次 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 = "com.dbComm.DBComm"; ccp.MethodName = "save"; ccp.ServerParams = new object[] { "DATAMODIFY_01.ADD", list }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == 0) { MessageBox.Show("新增记录成功!"); string strLog = "罐号=" + strPotNo + ",炉座号="//卡号、车号 + strStoveSeatNo + ",炉号=" + strStoveNo + ",毛重="//物料、发货单位 + strGrossWeight + ",皮重=" + strTearWeight + ",净重="//卸货地点、承运单位 + strNetWeight + ",流向=" + strReceiveFac + ","; this.objBi.WriteOperationLog("DT_IRONWEIGHT", strDepartMent, strUserName, "增加", strLog, "数据修改", "动态轨道衡二次数据表", "动态轨道衡");//调用写操作日志方法 } QueryData(); }
private void DoAdd() { if (DoCheck()) { string p_PondTypeNo = tbPondTypeNo.Text.Trim(); string p_PondTypeName = tbPondTypeName.Text.Trim(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.PondTypeBaseInfo"; ccp.MethodName = "add"; ccp.ServerParams = new object[] { p_PondTypeNo, p_PondTypeName }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.DoClear(); this.DoQuery(); } }
private void DoDelete() { if (strNumber == "") { MessageBox.Show("请先选择需要删除的记录"); return; } string sql = "delete DT_COMPAREBALANCE where FS_NUMBER = '" + strNumber + "'"; 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 DoDelete() { if (strTemp == "") { MessageBox.Show("请先选择需要删除的记录"); return; } string sql = "delete BT_CORRENTION_POINT where FS_POINTCODE = '" + strTemp + "'"; 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 DoAdd() { if (DoCheck()) { string p_Shift = tbShift.Text.Trim(); string p_StartTime = dateTimePicker1.Value.ToString("HH:mm:ss"); string p_EndTime = dateTimePicker2.Value.ToString("HH:mm:ss"); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.ShiftBaseInfo"; ccp.MethodName = "add"; ccp.ServerParams = new object[] { p_Shift, p_StartTime, p_EndTime }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.DoClear(); this.DoQuery(); } }
private void Query() { string strBeginTime = this.dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss"); string strEndTime = this.dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss"); string strQuery = "select t.fs_batchno,t.fs_productno,t.fs_materialno,to_char(t.fd_starttime,'yyyy-MM-dd hh24:mi:ss') as fd_starttime" + " from dt_productweightmain t where t.fs_uploadflag='1' and t.fs_materialno is null " + "and (t.fd_starttime between to_date('" + strBeginTime + "','yyyy-MM-dd hh24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd hh24:mi:ss')) order by t.fd_starttime desc"; string strTmpTable, strTmpField, strTmpOrder; this.dataSet1.Tables[0].Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { strQuery }; ccp.SourceDataTable = dataSet1.Tables[0]; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); }
private void DoAdd() { if (DoCheck()) { string p_Printer = tbPrinter.Text.Trim(); string p_Describe = tbDescribe.Text.Trim(); int p_PaperNum = Convert.ToInt32(tbPaperNum.Text.Trim()); int p_InkNum = Convert.ToInt32(tbInkNum.Text.Trim()); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.PrinterBaseInfo"; ccp.MethodName = "add"; ccp.ServerParams = new object[] { p_Printer, p_Describe, p_PaperNum, p_InkNum }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.DoClear(); this.DoQuery(); } }
/// <summary> /// 装载所有磅房信息 /// </summary> /// <param name="dtBF"></param> /// <param name="PointType"></param> public void QueryBFData(string PointType) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.QueryPointInfo"; ccp.MethodName = "QueryBFData"; ccp.ServerParams = new object[] { PointType }; DataTable dtBF = new DataTable(); ccp.SourceDataTable = dtBF; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dtBF.Rows.Count > 0) { this.cbJLD.DataSource = dtBF; this.cbJLD.DisplayMember = "FS_POINTNAME"; this.cbJLD.ValueMember = "FS_POINTCODE"; this.cbJLD.AutoCompleteMode = AutoCompleteMode.SuggestAppend; this.cbJLD.AutoCompleteSource = AutoCompleteSource.ListItems; } }
private void Change() { if (this.tbBf.Text == "" || strPointCode == "") { MessageBox.Show("请双击选择需要换纸的数据记录行!"); return; } if (DialogResult.Yes == MessageBox.Show("是否为 "+tbBf.Text+" 换纸", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { string strUpdateSql = "UPDATE BT_POINT T SET T.FN_USEDPRINTPAPER='0' where t.FS_POINTCODE='" + strPointCode + "'"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteNonQuery"; ccp.ServerParams = new object[] { strUpdateSql }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); } }
public string getTotalWeight(string strStoveNo) { string strSql = "select sum(FN_NETWEIGHT) totalWeight from DT_STEELWEIGHTDETAILROLL where FS_STOVENO='" + strStoveNo + "'"; DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { strSql }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); string strTotalWeight = string.Empty; if (dt.Rows.Count > 0) { strTotalWeight = dt.Rows[0]["totalWeight"].ToString(); } return strTotalWeight; }
private void ChangeShift_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); ArrayList list = new ArrayList(); list.Add(_args); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.dbComm.DBComm"; ccp.MethodName = "query"; ccp.ServerParams = new object[] { "BILLETINFO_22.SELECT", list}; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { tbName.Items.Add(dt.Rows[i]["USERID"].ToString(),dt.Rows[i]["USERNAME"].ToString()); } } }
private void btnTemplateOk1_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); string strSql1 = @"select FS_FH,FS_SETTLEMENTNAME from IT_MRP_SETTLEMENT where FS_FH = '" + this.strCurrentMrpCode + "'"; string strSql2 = ""; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp.MethodName = "ExcuteQuery"; ccp.ServerParams = new object[] { strSql1 }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == 0) { if (dt.Rows.Count > 0) { strSql2 = @"update IT_MRP_SETTLEMENT set FS_SETTLEMENTNAME='" + this.ugcpFS_SETTLEMENTNAME1.Text + "' where FS_FH = '" + this.strCurrentMrpCode + "'"; ; } else { strSql2 = @"Insert into IT_MRP_SETTLEMENT (FS_FH,FS_SETTLEMENTNAME) values ('" + this.strCurrentMrpCode + "','" + this.ugcpFS_SETTLEMENTNAME1.Text + "')"; } CoreClientParam ccp1 = new CoreClientParam(); ccp1.ServerName = "ygjzjl.basedatamanage.OtherBaseInfo"; ccp1.MethodName = "ExcuteNonQuery"; ccp1.ServerParams = new object[] { strSql2 }; ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal); if (ccp1.ReturnCode == 0) { MessageBox.Show("更新成功!"); } else { MessageBox.Show("更新失败!"); return; } } // This code was automatically generated by the RowEditTemplate Wizard // // Close the template and save any pending changes. this.ultraGridRowEditTemplate2.Close(true); }
/// <summary> /// 获取计量点信息 /// </summary> /// <param name="pointCode">计量点编号</param> /// <returns>计量点实体类</returns> public BT_POINT GetPoint(string pointCode) { BT_POINT point = null; DataTable dt = new DataTable(); ArrayList param = new ArrayList(); param.Add(pointCode); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.dbComm.DBComm"; ccp.MethodName = "query"; ccp.ServerParams = new object[] { "WEIGHPOINT_01.SELECT", param }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; point = ConvertDataRowToPointObject(dr); } return point; }
private DataTable GetWeightStd() { DataTable dt = new DataTable(); try { string sql = @"SELECT T.FN_ID,T.FS_SPEC,T.FN_LENGTH,T.FN_WEIGHT,T.FN_BILLETCOUNT,T.FS_BUNDLEWEIGHT ,T.FS_BUNDLEMINWWEIGHT,T.FS_BUNDLEMAXWWEIGHT,T.FS_MINDIFFERENTRATE,T.FS_MAXDIFFERENTRATE FROM BT_BCTHEORYWEIGHTINFO T"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.bar.StoreageWeight_BC"; ccp.MethodName = "QueryTableData"; ccp.ServerParams = new object[] { sql }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (Exception e) { } return dt; }
private void RenewWeightData() { if (MessageBox.Show("是否确定恢复采集的称重记录?", "玉钢MCMS", MessageBoxButtons.YesNo) == DialogResult.Yes) { ArrayList list = new ArrayList(); foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in ultraGrid1.Rows) { if (Convert.ToBoolean(ugr.Cells["CHK"].Value)) { list.Add(ugr.Cells["FS_WEIGHTNO"].Value.ToString()); } } CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.dynTrack.WeightMatch"; ccp.MethodName = "RenewFirstData"; ccp.ServerParams = new object[] { list, UserInfo.GetUserID() }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); this.QueryWeightData(); } }