public void loadData() { //LFProdArea //string sql = "select * from cbase_all_code where CODE_GROUP='"+maintype+"'"; try { // string sql = "select * from cbase_all_code where CODE_GROUP='LFProdArea'"; string sql = "select * from cbase_all_code where CODE_GROUP='" + maintype + "'"; ds = new AppSvrHMI.L3DataSet(); ds.SourceType = AppSvrHMI.L3DataSetSourceType.SQL; ds.SourceMethod = sql; ds.L3DataAdapter = this.Adapter; ds.LoadData(); if (ds.Tables[0].Rows.Count > 0) { cbYuanyin.DataSource = ds; // cbYuanyin.DataMember = "L3DataTable"; cbYuanyin.DisplayMember = "L3DataTable.Code_Des"; } // cbYuanyin.DataSource = ds; //// cbYuanyin.DataMember = "L3DataTable"; // cbYuanyin.DisplayMember = "L3DataTable.Code_Des"; // MessageBox.Show(ds.Tables[0].Rows.Count.ToString()); } catch { return; } }
public DialogResult showDialogForSteel(AppSvrIF.Session session, AppSvrHMI.L3DataSet ds) { // lblOldSteelGrade.Text = oldSteel; lblOldSteelGrade.Text = ds.Tables[0].Rows[0]["SteelGradeIndex"].ToString(); //钢种记号 lblSteelGrade.Text = ds.Tables[0].Rows[0]["SteelGrade"].ToString(); //钢种 lblSteelGroup.Text = ds.Tables[0].Rows[0]["Grade_Group_Code"].ToString(); //钢组 lblNC1.Text = ds.Tables[0].Rows[0]["NC_ZYX1"].ToString(); //NC1 lblNC2.Text = ds.Tables[0].Rows[0]["NC_ZYX2"].ToString(); //NC2 lblProtel.Text = ds.Tables[0].Rows[0]["Protocol"].ToString(); //协议 if (ds.Tables[0].Rows[0]["Use_Flag"].ToString() == "1") { lblUseFlag.Text = "禁用"; //制造标准 } else if (ds.Tables[0].Rows[0]["Use_Flag"].ToString() == "0") { lblUseFlag.Text = "在用"; } else { lblUseFlag.Text = "未定义"; } Adapter.Session = session; return(ShowDialog()); }
private void AlloyAndAreaLFMapFrm_Load(object sender, EventArgs e) { tdsBOF = (AppSvrHMI.L3DataSet)(dsBOF.Clone()); tdsLFOne = (AppSvrHMI.L3DataSet)(dsLFOne.Clone()); tdsLFTwo = (AppSvrHMI.L3DataSet)(dsLFTwo.Clone()); tdsGroundPublic = (AppSvrHMI.L3DataSet)(dsGroundPublic.Clone()); tdsGroundLF1 = (AppSvrHMI.L3DataSet)(dsGroundLF1.Clone()); tdsGroundLF2 = (AppSvrHMI.L3DataSet)(dsGroundLF2.Clone()); tdsWireLF1 = (AppSvrHMI.L3DataSet)(dsWireLF1.Clone()); tdsWireLF2 = (AppSvrHMI.L3DataSet)(dsWireLF2.Clone()); tdsBOF = dsBOF; tdsLFOne = dsLFOne; tdsLFTwo = dsLFTwo; tdsGroundPublic = dsGroundPublic; tdsGroundLF1 = dsGroundLF1; tdsGroundLF2 = dsGroundLF2; tdsWireLF1 = dsWireLF1; tdsWireLF2 = dsWireLF2; //AppSvrHMI.L3DataSet d = null; dsA = (AppSvrHMI.L3DataSet)tdsBOF.Copy(); dsB = (AppSvrHMI.L3DataSet)tdsLFOne.Copy(); dsC = (AppSvrHMI.L3DataSet)tdsLFTwo.Copy(); dsD = (AppSvrHMI.L3DataSet)tdsGroundPublic.Copy(); //e = (AppSvrHMI.L3DataSet)tdsGroundLF1.Copy(); dsE = (AppSvrHMI.L3DataSet)tdsGroundLF1.Copy(); dsF = (AppSvrHMI.L3DataSet)tdsGroundLF2.Copy(); dsG = (AppSvrHMI.L3DataSet)tdsWireLF1.Copy(); dsH = (AppSvrHMI.L3DataSet)tdsWireLF2.Copy(); }
private float fGross = 0;//缓存毛重 public DialogResult ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsSend) { try { if (dsSend == null || dsSend.Tables[0].Rows.Count != 1) { return(DialogResult.None); } dsMain.Tables[0].Rows.Clear(); DataRow newrow = dsMain.Tables[0].NewRow(); newrow["MaterialID"] = dsSend.Tables[0].Rows[0]["MaterialID"].ToString(); newrow["BFID"] = dsSend.Tables[0].Rows[0]["BFID"].ToString(); newrow["TAP_No"] = dsSend.Tables[0].Rows[0]["TAP_No"].ToString(); newrow["TPC_No"] = dsSend.Tables[0].Rows[0]["TPC_No"].ToString(); newrow["Weight"] = dsSend.Tables[0].Rows[0]["Net_Weight"].ToString(); newrow["WeightMode"] = 2; dsMain.Tables[0].Rows.Add(newrow); try { fGross = float.Parse(dsSend.Tables[0].Rows[0]["Gross_Weight"].ToString()); } catch { fGross = 0; } Adapter.Session = session; return(ShowDialog()); } catch { return(DialogResult.None); } }
public DialogResult ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsSend) { try { if (dsSend == null || dsSend.Tables[0].Rows.Count != 1) { return(DialogResult.None); } dsM.Tables[0].Rows.Clear(); dsM.Tables[0].ImportRow(dsSend.Tables[0].Rows[0]); //DataRow newrow = dsM.Tables[0].NewRow(); //newrow["MaterialID"] = dsSend.Tables[0].Rows[0]["MaterialID"].ToString(); //newrow["BFID"] = dsSend.Tables[0].Rows[0]["BFID"].ToString(); //newrow["TAP_No"] = dsSend.Tables[0].Rows[0]["TAP_No"].ToString(); //newrow["TPC_No"] = dsSend.Tables[0].Rows[0]["TPC_No"].ToString(); //newrow["Net_Weight"] = 0; //dsM.Tables[0].Rows.Add(newrow); Adapter.Session = session; return(ShowDialog()); } catch { return(DialogResult.None); } }
public DialogResult ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; dsDiv.Tables[0].Clear(); dsDiv.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); return(ShowDialog()); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { dsBulkInStoreConfirm.Tables[0].Clear(); dsBulkInStoreConfirm.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); cmdCodeArea.Parameters[0].ConstantValue = dsData.Tables[0].Rows[0]["Bulk_CODE"].ToString(); Adapter.Session = session; this.ShowDialog(); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; dsPlan.Tables[0].Clear(); dsPlan.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); this.ShowDialog(); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { dsAlloyToBulk.Tables[0].Clear(); dsAlloyToBulk.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); txtOldAmount.Text = dsData.Tables[0].Rows[0]["AMOUNT"].ToString(); Adapter.Session = session; this.ShowDialog(); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData, string Unit) { Adapter.Session = session; txtTAPNo.Text = dsData.Tables[0].Rows[0]["TAP_No"].ToString(); txtTPCNo.Text = dsData.Tables[0].Rows[0]["TPC_No"].ToString(); IorII = Unit; this.ShowDialog(); }
public DialogResult ShowDialogEx(int nPosition, AppSvrHMI.L3DataSet dsData) { bsPlan.DataSource = dsData; bsPlan.DataMember = dsData.Tables[0].TableName; bsPlan.Position = nPosition; return(ShowDialog()); }
public DialogResult ShowDialogEx(AppSvrIF.Session session, int nPosition, ref AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; bsMain.DataSource = dsData; bsMain.DataMember = dsData.Tables[0].TableName; bsMain.Position = nPosition; return(ShowDialog()); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData, string UnitID) { Adapter.Session = session; txtTAPNo.Text = dsData.Tables[0].Rows[0]["TAP_No"].ToString(); txtTPCNo.Text = dsData.Tables[0].Rows[0]["TPC_No"].ToString(); dsIronsInfo.SourceCondition = "MaterialID = '" + dsData.Tables[0].Rows[0]["MaterialID"].ToString() + "'"; IorII = UnitID; this.ShowDialog(); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; dsBalance.Tables[0].Clear(); dsBalance.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); dsBalance.Tables[0].Rows[0]["OldAmount"] = dsData.Tables[0].Rows[0]["AMOUNT"]; dsBalance.Tables[0].Rows[0]["StoreAreaID"] = dsData.Tables[0].Rows[0]["POSITION"]; this.ShowDialog(); }
//数据加载 private void CCMMarkScrapFrm_Load(object sender, EventArgs e) { cmbCasterID.Items.Clear(); dsSend = (AppSvrHMI.L3DataSet)dsHeatData.Clone(); for (int i = 0; i < dsCasterID.Tables[0].Rows.Count; i++) { cmbCasterID.Items.Add(dsCasterID.Tables[0].Rows[i]["Code"]); } }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; dsTapping.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); dsTapping.AcceptChanges(); bsTapping.Position = 0; lbSteelGradeIndex.Text = dsData.Tables[0].Rows[0]["SteelGradeIndex"].ToString(); this.ShowDialog(); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; dsSpileChange.Tables[0].Clear(); for (int i = 0; i < dsData.Tables[0].Rows.Count; i++) { dsSpileChange.Tables[0].ImportRow(dsData.Tables[0].Rows[i]); } this.ShowDialog(); }
public DialogResult ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; dsInStore.Tables[0].Clear(); for (int i = 0; i < dsData.Tables[0].Rows.Count; i++) { dsInStore.Tables[0].ImportRow(dsData.Tables[0].Rows[i]); } return(ShowDialog()); }
private void CCMMakeProductFrm_Load(object sender, EventArgs e) { //[20090102Liao] cmbCasterID.Items.Clear(); for (int i = 0; i < dsCasterID.Tables[0].Rows.Count; i++) { cmbCasterID.Items.Add(dsCasterID.Tables[0].Rows[i][0].ToString()); } cmbCasterID.SelectedIndex = 0; dsSend = (AppSvrHMI.L3DataSet)dsHeatData.Clone(); }
public DialogResult ShowDialogEx(int nPosition, string strSort, ref AppSvrHMI.L3DataSet dsData) { bsDesStdMainten.DataSource = null; bsDesStdMainten.DataSource = dsData; bsDesStdMainten.DataMember = dsData.Tables[0].TableName; ((System.Data.DataRowView)(bsDesStdMainten.Current)).DataView.Sort = strSort; bsDesStdMainten.Position = nPosition; return(ShowDialog()); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; Adapter.RefreshDataBindings(); dsRollBack.Tables[0].Clear(); dsRollBack.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); dsRollBack.Tables[0].Rows[0]["OldAmount"] = dsData.Tables[0].Rows[0]["AMOUNT"]; dsRollBack.Tables[0].Rows[0]["AMOUNT"] = 0; this.ShowDialog(); }
public DialogResult ShowDialogEx(AppSvrIF.Session session, ref AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; bsPlan.DataSource = null; bsPlan.DataSource = dsData; bsPlan.DataMember = dsData.Tables[0].TableName; bsPlan.MoveFirst(); return(ShowDialog()); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; dsWriteTime.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); dsWriteTime.AcceptChanges(); bsData.Position = 0; //bsData.DataSource = dsData; //bsData.DataMember = dsData.Tables[0].TableName; this.ShowDialog(); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { dsAlloyInStoreConfirm.Tables[0].Clear(); dsAlloyInStoreConfirm.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); txtOldAmount.Text = dsData.Tables[0].Rows[0]["AMOUNT"].ToString(); //cmdCodeArea.Parameters[0].ConstantValue = dsData.Tables[0].Rows[0]["ALLOY_CODE"].ToString(); cmdPossition.Parameters[0].ConstantValue = dsData.Tables[0].Rows[0]["ALLOY_CODE"].ToString(); Adapter.Session = session; //dsCodeArea.L3DataAdapter = Adapter; dsPossition.L3DataAdapter = Adapter; this.ShowDialog(); }
//上位 private void btnOnPosition_Click(object sender, EventArgs e) { string strbtnName = ((ToolStripMenuItem)sender).Name; AppSvrHMI.L3DataSet dsSend = SetDSOnPositon(strbtnName); if (dsSend != null) { cmdOnPosition.Parameters[0].SourceObject = dsSend; cmdOnPosition.Parameters[0].SourceProperty = "L3DataTable"; cmdOnPosition.Execute(); } }
private int iAddCount2 = 0; //拨入钢坯支数2 public DialogResult ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData, string UnitID) { //if (UnitID == CommDataMag.CommonData.CCM_UNIT_05ID) //{ // dMax = 100; //} Adapter.Session = session; Adapter.set_URIParameters("CCMID", UnitID); Adapter.RefreshDataBindings(); dsHeatData.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); return(ShowDialog()); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; l3cmdpCodeArea.ConstantValue = dsData.Tables[0].Rows[0]["Bulk_CODE"].ToString(); dsCodeArea.L3DataAdapter = Adapter; dsCodeArea.L3DataAdapter = null; dsChange.Tables[0].Clear(); dsChange.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); dsChange.Tables[0].Rows[0]["OldAmount"] = dsData.Tables[0].Rows[0]["AMOUNT"]; this.ShowDialog(); }
public void ShowDialogEx(AppSvrIF.Session session, AppSvrHMI.L3DataSet dsData) { Adapter.Session = session; l3cmdpTraget.ConstantValue = dsData.Tables[0].Rows[0]["ALLOY_CODE"].ToString(); dsTraget.L3DataAdapter = Adapter; Adapter.RefreshDataBindings(); dsTraget.LoadData(); dsChange.Tables[0].Clear(); dsChange.Tables[0].ImportRow(dsData.Tables[0].Rows[0]); dsChange.Tables[0].Rows[0]["OldAmount"] = dsData.Tables[0].Rows[0]["AMOUNT"]; this.ShowDialog(); }
//控件加载 private void TundishBaseMagFrmOT_Load(object sender, EventArgs e) { //锁定排序 CommDataMag.CommonMethed.SetdvColumnSortNotSortable(dvTundish); dsCold = (AppSvrHMI.L3DataSet)dsTundish.Clone(); //永久层打结开始 cmdInnerTieStart.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_OFFLINE + "'"; //永久层打结束 cmdInnerTieEnd.Parameters[0].SourceFilter = "CheckFlag =1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_INNER_BUILD + "' and Flag = 0"; //永久层烘烤开始 cmdInnerFireStart.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_INNER_BUILD + "' and Flag = 1"; //永久层烘烤结束 cmdInnerFireEnd.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_INNER_FIRE + "' and Flag = 0"; //上件开始 cmdInstallStart.Parameters[0].SourceFilter = "( CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_OFFLINE + "') or ( CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_INNER_FIRE + "' and Flag = 1 )"; //上件结束 cmdInstallEnd.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_ISTALL + "' and Flag = 0"; //工作层修砌开始 cmdWorkBuildStart.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_ISTALL + "' and Flag = 1"; //工作层修砌结束 cmdWorkBuildEnd.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_WORK_DAUB + "' and Flag = 0"; //工作层烘烤开始 cmdWorkFireStart.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_WORK_DAUB + "' and Flag = 1"; //工作层烘烤结束 cmdWorkFireEnd.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_WORK_FIRE + "' and Flag = 0"; //工作层确认冷备 cmdConfirmCold.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_WORK_FIRE + "' and Flag = 1"; //热备烘烤开始 cmdOnFireStart.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_COLD + "' and Flag = 1"; //热备烘烤结束 cmdOnFireEnd.Parameters[0].SourceFilter = "CheckFlag = 1 and Status = '" + CommDataMag.CommonData.CTUNDISH_STATUS_HOT_FIRE + "' and Flag = 0"; //中包异常下线 cmdOffLineException.Parameters[0].SourceFilter = "CheckFlag = 1 and Status < '" + CommDataMag.CommonData.CTUNDISH_STATUS_USE + "'"; }
private void AlloyAndAreaMapFrm_Load(object sender, EventArgs e) { tdsFire = (AppSvrHMI.L3DataSet)(dsFire.Clone()); tdsGround = (AppSvrHMI.L3DataSet)(dsGround.Clone()); tdsWire = (AppSvrHMI.L3DataSet)(dsWire.Clone()); tdsFire = dsFire; tdsGround = dsGround; tdsWire = dsWire; //AppSvrHMI.L3DataSet d = null; a = (AppSvrHMI.L3DataSet)tdsFire.Copy(); b = (AppSvrHMI.L3DataSet)tdsGround.Copy(); c = (AppSvrHMI.L3DataSet)tdsWire.Copy(); }