/// <summary> /// 窗体控件的数据绑定 /// </summary> private void DataBindFuntion() { string drawingstr = string.Empty; string sqlstr = string.Empty; string responuser = string.Empty; this.DRAWINGNOcomboBox.Items.Clear(); if (this.DRAWINGNOcomboBox.Text.Length != 0) { this.DRAWINGNOcomboBox.Text.Remove(0); } this.querybtn.Enabled = true; this.DRAWINGNOcomboBox.Items.Clear(); if (this.drawingrbn.Checked == true) { sqlstr = "SELECT DRAWING_NO FROM PLM.PROJECT_DRAWING_TAB where drawing_type is null AND Project_Id = (select T.ID from PROJECT_TAB T where T.NAME='" + this.textBox1.Text.ToString() + "') AND DOCTYPE_ID IN (7) AND DOCTYPE_ID != 71 AND LASTFLAG = 'Y' AND NEW_FLAG = 'Y' AND DELETE_FLAG = 'N' ORDER BY DRAWING_ID DESC"; } else if (this.modifyrbn.Checked == true) { sqlstr = "SELECT DRAWING_NO FROM PLM.PROJECT_DRAWING_TAB where drawing_type is null AND Project_Id = (select T.ID from PROJECT_TAB T where T.NAME='" + this.textBox1.Text.ToString() + "') AND DRAWING_NO IN (SELECT DISTINCT S.MODIFYDRAWINGNO FROM SP_SPOOL_TAB S WHERE S.FLAG = 'Y' AND S.MODIFYDRAWINGNO IS NOT NULL) AND DOCTYPE_ID = 71 AND LASTFLAG = 'Y' AND NEW_FLAG = 'Y' AND DELETE_FLAG = 'N' ORDER BY DRAWING_ID DESC"; } FillComboBox.GetFlowStatus(this.DRAWINGNOcomboBox, sqlstr); DataSet ds = new DataSet(); drawingstr = "SELECT distinct PLM.USER_API.CHINESENAME(RESPONSIBLE_USER) FROM PLM.PROJECT_DRAWING_TAB where Project_Id = (select T.ID from PROJECT_TAB T where T.NAME='" + this.textBox1.Text.ToString() + "') AND DOCTYPE_ID IN (7) AND DOCTYPE_ID != 71 AND LASTFLAG = 'Y' AND NEW_FLAG = 'Y' AND DELETE_FLAG = 'N'"; FillComboBox.GetFlowStatus(this.RESPONSIBLEcb, drawingstr); responuser = "******" + this.textBox1.Text.ToString() + "') AND DOCTYPE_ID IN (7) AND DOCTYPE_ID != 71 AND LASTFLAG = 'Y' AND NEW_FLAG = 'Y' AND DELETE_FLAG = 'N' ORDER BY DRAWING_ID DESC"; User.DataBaseConnect(responuser, ds); this.DrawingsDgv.DataSource = ds.Tables[0]; ds.Dispose(); SetStatus(); }
public CableListFrm() { InitializeComponent(); drwtb.Text = ProjectDrawingCableFrm.drawingno; drwentb.Text = ProjectDrawingCableFrm.drawingtitle; drwcntb.Text = ProjectDrawingCableFrm.drawingtitlecn; textBox1.Text = ProjectDrawingCableFrm.duty; DataBind(sql); FillComboBox.GetFlowStatus(fequipcb, devicesql); FillComboBox.GetFlowStatus(tequipcb, devicesql); FillComboBox.GetFlowStatus(cablesizecb, cablesizesql); }