private void Form4_Load(object sender, EventArgs e) { this.BackColor = System.Drawing.SystemColors.ControlLightLight; // Button1.Visible = false; //Button2.Visible = False DataGridView1.Refresh(); DataGridView1.AllowUserToAddRows = false; //可以不显示最后一行空 DataGridView1.ReadOnly = true; //不允许用户更改数据 // DataGridView1.ReadOnly = false; DataGridView1.RowsDefaultCellStyle.BackColor = Color.White; //.AntiqueWhite; DataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.AliceBlue; DataGridView1.DataSource = ds.Tables[0]; // DataGridView1.AutoSizeColumnsMode=DataGridViewAutoSizeColumnsMode.ColumnHeader; // DataGridView1.AutoSizeColumnsMode=DataGridViewAutoSizeColumnsMode.AllCells; // for (int i=0;i<DataGridView1.Columns.Count;i++) // { // DataGridView1.Columns[i].Width = 92; // } // DataGridView1.DataSource = ds;//.Tables[1]; // DataGridView1.DataBindings(); Type dgvType = DataGridView1.GetType(); System.Reflection.PropertyInfo pi = null; pi = dgvType.GetProperty("DoubleBuffered", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic); //pi.SetValue(dgvType, setting, Nothing) pi.SetValue(DataGridView1, true, null); this.WindowState = FormWindowState.Maximized; }
private void RetrieveDialogType_Load(object sender, EventArgs e) { SM = new StudyMover.StudyMover(); dtpDateFrom.CustomFormat = "dd/MM/yyyy"; dtpDateTo.CustomFormat = "dd/MM/yyyy"; dtpDateFrom.Value = DateTime.Now.Date; dtpDateTo.Value = DateTime.Now.Date; TeleRadPush.modMain.Retreived = false; DataGridView1.Refresh(); this.Cursor = Cursors.WaitCursor; this.PatientStudyViewTableAdapter.Fill(this.PatientStudyView.PatientStudyView); //Me.StudyViewTableAdapter.Fill(Me.DicomServerDBDataSet1.StudyView) //OptionsBox = New OptionsBoxType //If UType = 2 Then // os = New frmOS //Else // sp = New frmSP //End If //NotesReports_Images(); this.Cursor = Cursors.Default; WoN_WoR = Color.White; WN_WoR = Color.LightPink; WN_WR = Color.PowderBlue; GridDesign(); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { DataTable dt1 = controllerObj.GetInfoOfAProjectTeamByNumber(comboBox1.SelectedValue.ToString()); DataGridView1.DataSource = dt1; DataGridView1.Refresh(); }
public void mark(TextBox sender, TextBox tb) { int count = 0; try { string[] words = tb.Text.Split(','); for (int i = 0; i < (DataGridView1.RowCount - 1); i++) { if (DataGridView1.Rows[i].Cells[columnSelect].Value is object) { foreach (string wor in words) { if (DataGridView1.Rows[i].Cells[columnSelect].Value.ToString().IndexOf(wor) >= 0) { DataGridView1.Rows[i].Cells[columnSelect].Style.BackColor = sender.BackColor; count += 1; continue; } } } } sender.Text = string.Format("{0}", count); DataGridView1.Refresh(); } catch (Exception) { // dummy } }
private void comboBox1_SelectedIndexChanged_1(object sender, EventArgs e) { DataTable dt1 = controllerObj.GetAllInfoOfInternshipByName(comboBox1.SelectedValue.ToString()); DataGridView1.DataSource = dt1; DataGridView1.Refresh(); }
public int GridDesign() { int lb2 = 0; int lb3 = 0; int lb4 = 0; lb2 = 0; lb3 = 0; lb4 = 0; label2.Text = "Without Notes && Reports"; label3.Text = "Notes without Reports"; label4.Text = "With Notes && Reports"; DataGridViewCellStyle m_SelectedStyle = default(DataGridViewCellStyle); DataGridView1.RowHeadersDefaultCellStyle.SelectionBackColor = Color.DarkGray; DataGridView1.DefaultCellStyle.SelectionBackColor = Color.DarkGray; DataGridView1.RowHeadersDefaultCellStyle.SelectionForeColor = Color.White; DataGridView1.DefaultCellStyle.SelectionForeColor = Color.White; for (i = 0; i <= DataGridView1.RowCount - 1; i++) { if (DataGridView1.Rows[i].Cells[13].Value == DBNull.Value || DataGridView1.Rows[i].Cells[14].Value == DBNull.Value) { return(0); } ; if (Convert.ToBoolean(DataGridView1.Rows[i].Cells[13].Value) == false & Convert.ToBoolean(DataGridView1.Rows[i].Cells[14].Value) == false) { m_SelectedStyle = new DataGridViewCellStyle(); m_SelectedStyle.BackColor = WoN_WoR; DataGridView1.Rows[i].DefaultCellStyle = m_SelectedStyle; lb2 = lb2 + 1; } if (Convert.ToBoolean(DataGridView1.Rows[i].Cells[13].Value) == true & Convert.ToBoolean(DataGridView1.Rows[i].Cells[14].Value) == false) { m_SelectedStyle = new DataGridViewCellStyle(); m_SelectedStyle.BackColor = WN_WoR; DataGridView1.Rows[i].DefaultCellStyle = m_SelectedStyle; lb3 = lb3 + 1; } if (Convert.ToBoolean(DataGridView1.Rows[i].Cells[13].Value) == true & Convert.ToBoolean(DataGridView1.Rows[i].Cells[14].Value) == true) { m_SelectedStyle = new DataGridViewCellStyle(); m_SelectedStyle.BackColor = WN_WR; DataGridView1.Rows[i].DefaultCellStyle = m_SelectedStyle; lb4 = lb4 + 1; } } label2.Text = label2.Text + ": " + lb2 + " Records"; label3.Text = label3.Text + ": " + lb3 + " Records"; label4.Text = label4.Text + ": " + lb4 + " Records"; DataGridView1.Refresh(); return(1); }
public void btnupdate_Click(System.Object sender, System.EventArgs e) { con.Open(); sql = "UPDATE tblinfo SET account_no=\'" + txtAcctNo.Text + "\',pin_code=\'" + txtPincode.Text + "\',Firstname=\'" + txtfnme.Text + "\',Lastname=\'" + txtlnme.Text + "\',Address=\'" + txtaddr.Text + "\',Contact_no=\'" + txtcontact.Text + "\',Gender=\'" + cbGender.Text + "\'where Firstname=\'" + lblhide.Text + "\'"; cmd.CommandText = sql; cmd.Connection = con; cmd.ExecuteNonQuery(); cmd.Dispose(); MessageBox.Show("success"); con.Close(); DataGridView1.Refresh(); }
private void btnSearch_Click(object sender, EventArgs e) { string strSQL = ""; string varCode = ""; string varName = ""; string varPhys = ""; if (txtPatientID.Text.Length > 0) { varCode = "%" + txtPatientID.Text + "%"; } if (txtFirstName.Text.Length > 0) { varName = "%" + txtFirstName.Text + "%"; } if (txtReferringMD.Text.Length > 0) { varPhys = "%" + txtReferringMD.Text + "%"; } if (chkSearchDate.Checked) { strSQL = "SELECT * FROM PatientStudyView WHERE (PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "') and convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' order by StudyDate desc"; } else { strSQL = "SELECT * FROM PatientStudyView WHERE PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "' order by StudyDate desc"; } if (string.IsNullOrEmpty(varCode) && string.IsNullOrEmpty(varName) && string.IsNullOrEmpty(varPhys) && chkSearchDate.Checked) { strSQL = "SELECT * FROM PatientStudyView WHERE convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' order by StudyDate desc"; } CN1.OpenConnection(); CMD1 = new System.Data.Odbc.OdbcCommand(strSQL, CN1.DBConnection); //Dim dtst As New DataSet DicomServerDBDataSet1.PatientStudyViewDataTable table = new DicomServerDBDataSet1.PatientStudyViewDataTable(); System.Data.Odbc.OdbcDataAdapter adptr = new System.Data.Odbc.OdbcDataAdapter(); adptr.SelectCommand = CMD1; adptr.Fill(table); DataGridView1.Refresh(); DataGridView1.DataSource = null; DataGridView1.DataSource = table; this.Cursor = Cursors.Default; GridDesign(); CMD1.Dispose(); CN1.closeconnection(); }
void filldata() { Myconnection obj = new Myconnection(); obj.con.Open(); obj.qry = "select * from achievements order by employee"; obj.cmd = new SqlCommand(obj.qry, obj.con); obj.dr = obj.cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(obj.dr); DataGridView1.AutoGenerateColumns = true; DataGridView1.DataSource = dt; DataGridView1.Refresh(); obj.con.Close(); }
private void txtsearch_TextChanged(object sender, EventArgs e) { Myconnection obj = new Myconnection(); obj.con.Open(); obj.qry = "select employee, forward,title,date,approval from achievements where employee like '%'+ '" + txtsearch.Text + "' + '%'"; obj.cmd = new SqlCommand(obj.qry, obj.con); obj.dr = obj.cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(obj.dr); DataGridView1.AutoGenerateColumns = true; DataGridView1.DataSource = dt; DataGridView1.Refresh(); obj.con.Close(); }
private void btnRefresh_Click(object sender, EventArgs e) { DataGridView1.Refresh(); PatientStudyView.Clear(); this.PatientStudyViewTableAdapter.Fill(this.PatientStudyView.PatientStudyView); DataGridView1.DataSource = null; DataGridView1.DataSource = PatientStudyViewBindingSource; this.Cursor = Cursors.Default; GridDesign(); txtFirstName.Text = ""; txtPatientID.Text = ""; txtReferringMD.Text = ""; dtpDateFrom.Value = DateTime.Now.Date; dtpDateTo.Value = DateTime.Now.Date; chkSearchDate.Checked = false; }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox1.SelectedItem.ToString() == "Courses not graded yet") { object O = controllerObj.GetStudentUsernameFromName(YourName_Label.Text.ToString()); DataTable dt = controllerObj.GetCoursesOfAStudentByUsername(O.ToString()); DataGridView1.DataSource = dt; DataGridView1.Refresh(); } else if (comboBox1.SelectedItem.ToString() == "Courses graded") { object O = controllerObj.GetStudentUsernameFromName(YourName_Label.Text.ToString()); DataTable dt = controllerObj.GetCoursesWithGradesOfAStudentByUsername(O.ToString()); DataGridView1.DataSource = dt; DataGridView1.Refresh(); } }
private void btnYesterday_Click(object sender, EventArgs e) { CN1.OpenConnection(); CMD1 = new System.Data.Odbc.OdbcCommand("select * from PatientStudyView where datepart(dd,StudyDate)=" + DateTime.Now.AddDays(-1).Day.ToString() + " and datepart(MM,StudyDate)=" + DateTime.Now.AddDays(-1).Month.ToString() + " and datepart(yy,StudyDate)=" + DateTime.Now.AddDays(-1).Year.ToString() + "", CN1.DBConnection); //Dim dtst As New DataSet DicomServerDBDataSet1.PatientStudyViewDataTable table = new DicomServerDBDataSet1.PatientStudyViewDataTable(); System.Data.Odbc.OdbcDataAdapter adptr = new System.Data.Odbc.OdbcDataAdapter(); adptr.SelectCommand = CMD1; adptr.Fill(table); DataGridView1.Refresh(); DataGridView1.DataSource = null; DataGridView1.DataSource = table; this.Cursor = Cursors.Default; GridDesign(); CMD1.Dispose(); CN1.closeconnection(); }
private void RetrieveDialogType_Load(object sender, EventArgs e) { dtpDateFrom.CustomFormat = "dd/MM/yyyy"; dtpDateTo.CustomFormat = "dd/MM/yyyy"; dtpDateFrom.Value = DateTime.Now.Date; dtpDateTo.Value = DateTime.Now.Date; TeleRadReport.modMain.Retreived = false; this.Cursor = Cursors.WaitCursor; this.PatientStudyViewTableAdapter.Fill(this.PatientStudyView.PatientStudyView); //this.DataGridView1.DataSource = this.PatientStudyViewTableAdapter; DataGridView1.Refresh(); this.Cursor = Cursors.Default; WoN_WoR = Color.White; WN_WoR = Color.LightPink; WN_WR = Color.PowderBlue; GridDesign(); }
public void btnupdate_Click(System.Object sender, System.EventArgs e) { //con.Open(); ////Dim ad As New OleDb.OleDbDataAdapter("select * from book", con) //sql = "UPDATE tblinfo SET account_no=\'" + txtAcctNo.Text + "\',pin_code=\'" + txtPincode.Text + "\',Firstname=\'" + txtfnme.Text + "\',Lastname=\'" + txtlnme.Text + "\',Address=\'" + txtaddr.Text + "\',Contact_no=\'" + txtcontact.Text + "\',Gender=\'" + cbGender.Text + "\'where Firstname=\'" + lblhide.Text + "\'"; //cmd.CommandText = sql; //cmd.Connection = con; //cmd.ExecuteNonQuery(); //cmd.Dispose(); MessageBox.Show("success"); //con.Close(); //Button5_Click(sender, e) DataTable dt = DataClass.Data(); DataRow[] HRow = dt.Select("account_no = '" + txtAcctNo.Text + "' AND pin = '" + txtPincode.Text + "' "); DataGridView1.DataSource = dt; DataGridView1.Refresh(); }
private void DisplayMTData_Load(object sender, EventArgs e) { string FName = "./Graphics/MeridianTransitData.csv"; string tablename = "Export2"; var SR = new System.IO.StreamReader(FName); string allData = SR.ReadToEnd(); var rows = allData.Split(Conversions.ToChar(Constants.vbCrLf)); // ("\r".ToCharArray()) int incr1 = 0; foreach (string r in rows) { if (incr1 > 0) { var items = r.Split(','); if ((items[0] ?? "") != Constants.vbLf) { var DT = Convert.ToDateTime(items[2]); items[0] = CnvtToDeg(items[0].ToString()); items[1] = CnvtToDeg(items[1].ToString()); items[3] = CnvtTime(items[3].ToString()); items[4] = CnvtEQT(items[4].ToString()); items[5] = CnvtDec(items[5].ToString()); // items(6) = CnvtHo(items(6).ToString) DataSet2.Tables[tablename].Rows.Add(items); } } incr1 += 1; } // DataGridView1.DataSource = DataSet2.Tables(0).DefaultView DataGridView1.Refresh(); SR.Close(); SR.Dispose(); Refresh(); // DisplayAnalema() return; }
public void UpdateDataGrid() { DataGridView1.DataSource = Database.Tickets.ToList(); DataGridView1.Refresh(); }
private void btnYesterday_Click(object sender, EventArgs e) { string sqlQuery = ""; if (chkAll.Checked) { sqlQuery = "select * from PatientStudyView where datepart(dd,StudyDate)=" + DateTime.Now.AddDays(-1).Day.ToString() + " and datepart(MM,StudyDate)=" + DateTime.Now.AddDays(-1).Month.ToString() + " and datepart(yy,StudyDate)=" + DateTime.Now.AddDays(-1).Year.ToString() + ""; } else { string Mod = ""; bool MoreThanOne = false; if (chkCR.Checked) { Mod = "Modality='CR'"; MoreThanOne = true; } if (chkCT.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='CT'"; } else { Mod = "Modality='CT'"; } MoreThanOne = true; } if (chkDX.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='DX'"; } else { Mod = "Modality='DX'"; } MoreThanOne = true; } if (chkES.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='ES'"; } else { Mod = "Modality='ES'"; } MoreThanOne = true; } if (chkMG.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='MG'"; } else { Mod = "Modality='MG'"; } MoreThanOne = true; } if (chkMR.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='MR'"; } else { Mod = "Modality='MR'"; } MoreThanOne = true; } if (chkNM.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='NM'"; } else { Mod = "Modality='NM'"; } MoreThanOne = true; } if (chkOT.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='OT'"; } else { Mod = "Modality='OT'"; } MoreThanOne = true; } if (chkPT.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='PT'"; } else { Mod = "Modality='PT'"; } MoreThanOne = true; } if (chkRF.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='RF'"; } else { Mod = "Modality='RF'"; } MoreThanOne = true; } if (chkRT.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='RT'"; } else { Mod = "Modality='RT'"; } MoreThanOne = true; } if (chkSC.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='SC'"; } else { Mod = "Modality='SC'"; } MoreThanOne = true; } if (chkUS.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='US'"; } else { Mod = "Modality='US'"; } MoreThanOne = true; } if (chkXA.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='XA'"; } else { Mod = "Modality='XA'"; } MoreThanOne = true; } sqlQuery = "select * from PatientStudyView where datepart(dd,StudyDate)=" + DateTime.Now.AddDays(-1).Day.ToString() + " and datepart(MM,StudyDate)=" + DateTime.Now.AddDays(-1).Month.ToString() + " and datepart(yy,StudyDate)=" + DateTime.Now.AddDays(-1).Year.ToString() + " AND (" + Mod + ")"; } CN1.OpenConnection(); CMD1 = new System.Data.Odbc.OdbcCommand(sqlQuery, CN1.DBConnection); //Dim dtst As New DataSet DicomServerDBDataSet1.PatientStudyViewDataTable table = new DicomServerDBDataSet1.PatientStudyViewDataTable(); System.Data.Odbc.OdbcDataAdapter adptr = new System.Data.Odbc.OdbcDataAdapter(); adptr.SelectCommand = CMD1; adptr.Fill(table); DataGridView1.Refresh(); DataGridView1.DataSource = null; DataGridView1.DataSource = table; this.Cursor = Cursors.Default; GridDesign(); CMD1.Dispose(); CN1.closeconnection(); }
private void btnSearch_Click(object sender, EventArgs e) { if (txtPatientID.Text.Length <= 0 && txtFirstName.Text.Length <= 0 && txtReferringMD.Text.Length <= 0 && chkSearchDate.Checked == false) { return; } string strSQL = ""; string varCode = ""; string varName = ""; string varPhys = ""; if (txtPatientID.Text.Length > 0) { varCode = "%" + txtPatientID.Text + "%"; } if (txtFirstName.Text.Length > 0) { varName = "%" + txtFirstName.Text + "%"; } if (txtReferringMD.Text.Length > 0) { varPhys = "%" + txtReferringMD.Text + "%"; } if (chkAll.Checked) { if (chkSearchDate.Checked) { strSQL = "SELECT * FROM PatientStudyView WHERE (PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "') and convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' order by StudyDate desc"; } else { strSQL = "SELECT * FROM PatientStudyView WHERE PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "' order by StudyDate desc"; } if (string.IsNullOrEmpty(varCode) && string.IsNullOrEmpty(varName) && string.IsNullOrEmpty(varPhys) && chkSearchDate.Checked) { strSQL = "SELECT * FROM PatientStudyView WHERE convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' order by StudyDate desc"; } } else { string Mod = ""; bool MoreThanOne = false; if (chkCR.Checked) { Mod = "Modality='CR'"; MoreThanOne = true; } if (chkCT.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='CT'"; } else { Mod = "Modality='CT'"; } MoreThanOne = true; } if (chkDX.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='DX'"; } else { Mod = "Modality='DX'"; } MoreThanOne = true; } if (chkES.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='ES'"; } else { Mod = "Modality='ES'"; } MoreThanOne = true; } if (chkMG.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='MG'"; } else { Mod = "Modality='MG'"; } MoreThanOne = true; } if (chkMR.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='MR'"; } else { Mod = "Modality='MR'"; } MoreThanOne = true; } if (chkNM.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='NM'"; } else { Mod = "Modality='NM'"; } MoreThanOne = true; } if (chkOT.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='OT'"; } else { Mod = "Modality='OT'"; } MoreThanOne = true; } if (chkPT.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='PT'"; } else { Mod = "Modality='PT'"; } MoreThanOne = true; } if (chkRF.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='RF'"; } else { Mod = "Modality='RF'"; } MoreThanOne = true; } if (chkRT.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='RT'"; } else { Mod = "Modality='RT'"; } MoreThanOne = true; } if (chkSC.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='SC'"; } else { Mod = "Modality='SC'"; } MoreThanOne = true; } if (chkUS.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='US'"; } else { Mod = "Modality='US'"; } MoreThanOne = true; } if (chkXA.Checked) { if (MoreThanOne) { Mod = Mod + " OR Modality='XA'"; } else { Mod = "Modality='XA'"; } MoreThanOne = true; } if (chkSearchDate.Checked) { strSQL = "SELECT * FROM PatientStudyView WHERE (PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "') and convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' AND (" + Mod + ") order by StudyDate desc"; } else { strSQL = "SELECT * FROM PatientStudyView WHERE PatientID LIKE '" + varCode + "' OR PatientName_DICOM LIKE '" + varName + "' or ReferringPhysician_DICOM like '" + varPhys + "' AND (" + Mod + ") order by StudyDate desc"; } if (varCode.Length <= 0 && varName.Length <= 0 && varPhys.Length <= 0 && chkSearchDate.Checked) { strSQL = "SELECT * FROM PatientStudyView WHERE convert(date,StudyDate) BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd") + "' and '" + dtpDateTo.Value.ToString("yyyy-MM-dd") + "' AND (" + Mod + ") order by StudyDate desc"; } } CN1.OpenConnection(); CMD1 = new System.Data.Odbc.OdbcCommand(strSQL, CN1.DBConnection); //Dim dtst As New DataSet DicomServerDBDataSet1.PatientStudyViewDataTable table = new DicomServerDBDataSet1.PatientStudyViewDataTable(); System.Data.Odbc.OdbcDataAdapter adptr = new System.Data.Odbc.OdbcDataAdapter(); adptr.SelectCommand = CMD1; adptr.Fill(table); DataGridView1.Refresh(); DataGridView1.DataSource = null; DataGridView1.DataSource = table; this.Cursor = Cursors.Default; GridDesign(); CMD1.Dispose(); CN1.closeconnection(); }
public FrmClimateFeature(Framework.Entity.Chapter chapter, object type) { InitializeComponent(); @class = type; System.Collections.ArrayList templateList = contentService.GetContentTemplateByTitle(chapter.Title); foreach (Framework.Entity.Template template in templateList) { Framework.Class.ComboItem item = new Framework.Class.ComboItem(); item.Text = template.Title; item.Value = template; CbxType.Items.Add(item); } CbxType.SelectedIndex = 0; { DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn colChoice = new DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn(); colChoice.HeaderText = "选择城市"; colChoice.Width = 50; DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn colCity = new DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn(); colCity.HeaderText = "城市"; colCity.Width = 120; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colYearAvgTemp = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colYearAvgTemp.HeaderText = "年平均气温"; colYearAvgTemp.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colColdestMonth = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colColdestMonth.HeaderText = "最冷月份"; colColdestMonth.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colColdAvgTemp = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colColdAvgTemp.HeaderText = "冷月平均气温"; colColdAvgTemp.Width = 120; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colHottestMonth = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colHottestMonth.HeaderText = "最热月份"; colHottestMonth.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colHotAvgTemp = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colHotAvgTemp.HeaderText = "热月平均气温"; colHotAvgTemp.Width = 120; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colAvgMonthPrecipitation = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colAvgMonthPrecipitation.HeaderText = "月平均降水量"; colAvgMonthPrecipitation.Width = 120; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colSummerPrecipitationAccounts = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colSummerPrecipitationAccounts.HeaderText = "夏季降水量占全年比例"; colSummerPrecipitationAccounts.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colWinterConstruction = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colWinterConstruction.HeaderText = "冬期施工日期"; colWinterConstruction.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colRainConstruction = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colRainConstruction.HeaderText = "雨期施工日期"; colRainConstruction.Width = 100; DataGridView1.Columns.Add(colChoice); DataGridView1.Columns.Add(colCity); DataGridView1.Columns.Add(colYearAvgTemp); DataGridView1.Columns.Add(colColdestMonth); DataGridView1.Columns.Add(colColdAvgTemp); DataGridView1.Columns.Add(colHottestMonth); DataGridView1.Columns.Add(colHotAvgTemp); DataGridView1.Columns.Add(colAvgMonthPrecipitation); DataGridView1.Columns.Add(colSummerPrecipitationAccounts); DataGridView1.Columns.Add(colWinterConstruction); DataGridView1.Columns.Add(colRainConstruction); DataGridView1.Rows.Add(); object[] strCity = new object[] { "北京", "天津", "上海", "广州" }; string[] strYearAvgTemp = new string[] { "1℃", "2℃", "3℃", "4℃" }; string[] strColdestMonth = new string[] { "1月", "2月", "3月", "4月" }; string[] strColdAvgTemp = new string[] { "1℃", "2℃", "3℃", "4℃" }; string[] strHottestMonth = new string[] { "1月", "2月", "3月", "4月" }; string[] strHotAvgTemp = new string[] { "1℃", "2℃", "3℃", "4℃" }; string[] strAvgMonthPrecipitation = new string[] { "10ml", "20ml", "30ml", "40ml" }; string[] strSummerPrecipitationAccounts = new string[] { "10%", "20%", "30%", "40%" }; string[] strWinterConstruction = new string[] { "1月", "2月", "3月", "4月" }; string[] strRainConstruction = new string[] { "1月", "2月", "3月", "4月" }; for (int i = 0; i < strCity.Length; i++) { DevComponents.DotNetBar.ButtonItem btnItem = new DevComponents.DotNetBar.ButtonItem(); btnItem.Text = (string)strCity[i]; btnItem.Click += new System.EventHandler(delegate(object sender, System.EventArgs args) { DataGridView1.SelectedRows[0].Cells[1].Value = btnItem.Text; for (int j = 0; j < strCity.Length; j++) { if (btnItem.Text == strCity[j].ToString()) { DataGridView1.Rows[0].Cells[2].Value = strYearAvgTemp[j]; DataGridView1.Rows[0].Cells[3].Value = strColdestMonth[j]; DataGridView1.Rows[0].Cells[4].Value = strColdAvgTemp[j]; DataGridView1.Rows[0].Cells[5].Value = strHottestMonth[j]; DataGridView1.Rows[0].Cells[6].Value = strHotAvgTemp[j]; DataGridView1.Rows[0].Cells[7].Value = strAvgMonthPrecipitation[j]; DataGridView1.Rows[0].Cells[8].Value = strSummerPrecipitationAccounts[j]; DataGridView1.Rows[0].Cells[9].Value = strWinterConstruction[j]; DataGridView1.Rows[0].Cells[10].Value = strRainConstruction[j]; break; } } DataGridView1.Refresh(); }); colChoice.SubItems.Add(btnItem); } } }
private void SearchBtn_Click(object sender, EventArgs e) { String SelectString = String.Empty; SqlCommand Command = new SqlCommand(); SqlConnection Connection = new SqlConnection("Server=HRASQL\\HRASQL;Database=HRA;Integrated Security=SSPI"); SqlDataAdapter Adapter = new SqlDataAdapter(); DataTable DT = new DataTable(); Int32 Count = 0; String WildCardParam = String.Empty; SelectString = "Select count(*) from mdnurdat where "; if (LastNameTxt.Text != "") { SelectString += "Last_Name like @param1"; //SelectString += "Last_Name like '" + LastNameTxt.Text + "%'"; } if (LastNameTxt.Text != " " && FirstNameTxt.Text != " ") { SelectString += " and "; } if (FirstNameTxt.Text != " ") { SelectString += "First_Name like @param2"; //SelectString += "First_Name like '" + FirstNameTxt.Text + "%'"; } Command.CommandText = SelectString; Command.Connection = Connection; Command.CommandType = CommandType.Text; Command.CommandTimeout = 300; WildCardParam = String.Format("{0}%", LastNameTxt.Text); Command.Parameters.AddWithValue("@param1", WildCardParam); WildCardParam = String.Format("{0}%", FirstNameTxt.Text); Command.Parameters.AddWithValue("@param2", WildCardParam); try { Connection.Open(); Count = (Int32)Command.ExecuteScalar(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { Connection.Close(); } if (Count != 0) { SelectString = SelectString.Replace("count(*)", "Nurse_Id, First_Name, Last_Name, '1' + Phone as Phone"); Command.CommandText = SelectString; Adapter.SelectCommand = Command; try { Connection.Open(); Adapter.Fill(DT); DataGridView1.DataSource = DT; DataGridView1.Refresh(); }catch (Exception ex) { Console.WriteLine(ex.Message); } finally { Connection.Close(); } } else { MessageBox.Show("No Attendant Found."); } }
private void Button2_Click(object sender, EventArgs e) { DataGridView1.Refresh(); }
private void btnOpenCSV_Click(object sender, EventArgs e) { System.IO.StreamReader myStream = null; var openFileDialog1 = new OpenFileDialog(); if ((DataSet1.DataSetName ?? "") == (tablename ?? "")) { DataSet1.Dispose(); DataSet1 = new DataSet(); DataGridView1.DataSource = Constants.vbNull; } DataSet1.Tables.Add(tablename); DataSet1.DataSetName = tablename; DataGridView1.DataSource = DataSet1; openFileDialog1.InitialDirectory = "./"; openFileDialog1.Filter = "txt files (*.txt)|*.txt|csv files (*.csv)|*.csv"; openFileDialog1.Title = "Open CSV Text File"; openFileDialog1.FilterIndex = 2; openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { if (string.IsNullOrEmpty(openFileDialog1.FileName)) { return; } ReadError = false; FileLoading = true; int ReadNum = 0; try { myStream = new System.IO.StreamReader(openFileDialog1.FileName); if (myStream is object) { SLOpenFName = openFileDialog1.FileName; lblOpenFN.Visible = true; txtOpenFN.Visible = true; txtOpenFN.Text = SLOpenFName; string allData = myStream.ReadToEnd(); var rows = allData.Split(Conversions.ToChar(Environment.NewLine)); // ("\r".ToCharArray()) int incr1 = 0; foreach (string r1 in rows) { string r = r1; r = r.Trim(Convert.ToChar(Environment.NewLine)).Trim(); if (ReadNum == 0) { r = r.Trim(Convert.ToChar(Environment.NewLine)).Trim(); var items = r.Split(','); for (int ctr = 0, loopTo = Information.UBound(items); ctr <= loopTo; ctr++) { DataSet1.Tables[tablename].Columns.Add(items[ctr]); } } else { r = r.Trim(Convert.ToChar(Environment.NewLine)).Trim(); var items1 = r.Split(','); if (!string.IsNullOrEmpty(items1[0]) & items1[0] != null) { DataSet1.Tables[tablename].Rows.Add(items1); } } ReadNum += 1; incr1 += 1; } myStream.Close(); btnSaveFile.Visible = true; btnExit.Visible = true; } myStream.Dispose(); DataGridView1.DataSource = DataSet1.Tables[0].DefaultView; DataGridView1.Refresh(); FileLoading = false; Refresh(); } catch (Exception Ex) { ErrorMsgBox("Cannot read file from disk. Original error: " + Ex.Message); } finally { // Check this again, since we need to make sure we didn't throw an exception on open. if (myStream is object) { myStream.Close(); } } } else { btnSaveFile.Visible = false; btnExit.Visible = false; } }
public FrmConcreteProject(Framework.Entity.Chapter chapter, object type) { InitializeComponent(); @class = type; System.Collections.ArrayList templateList = contentService.GetContentTemplateByTitle(chapter.Title); foreach (Framework.Entity.Template template in templateList) { Framework.Class.ComboItem item = new Framework.Class.ComboItem(); item.Text = template.Title; item.Value = template; CbxType.Items.Add(item); } CbxType.SelectedIndex = 0; { #region /*劳动力准备*/ DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn colChoice = new DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn(); colChoice.HeaderText = "选择工种"; colChoice.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn colName = new DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn(); colName.HeaderText = "工种名称"; colName.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewIntegerInputColumn colNumber = new DevComponents.DotNetBar.Controls.DataGridViewIntegerInputColumn(); colNumber.HeaderText = "每班人数"; colNumber.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colRemarks = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colRemarks.HeaderText = "备注"; colRemarks.Width = 309; object[,] machines = new object[, ] { { "班组长", "有较强施工组织能力,熟悉混凝土施工方法。" }, { "振捣手", "有振捣经验,持证上岗。" }, { "抹面", "必须是瓦工出身,有抹面经验,持证上岗。" }, { "接管", "有接管经验,操作熟练。" }, { "普工", "能够吃苦,不怕脏,听从指挥" } }; for (int i = 0; i < 5; i++) { DevComponents.DotNetBar.ButtonItem btnItem = new DevComponents.DotNetBar.ButtonItem(); btnItem.Text = (string)machines[i, 0]; btnItem.Click += new System.EventHandler(delegate(object sender, System.EventArgs args) { DataGridView1.SelectedRows[0].Cells[1].Value = btnItem.Text; switch (btnItem.Text) { case "班组长": DataGridView1.SelectedRows[0].Cells[3].Value = (string)machines[0, 1]; break; case "振捣手": DataGridView1.SelectedRows[0].Cells[3].Value = (string)machines[1, 1]; break; case "抹面": DataGridView1.SelectedRows[0].Cells[3].Value = (string)machines[2, 1]; break; case "接管": DataGridView1.SelectedRows[0].Cells[3].Value = (string)machines[3, 1]; break; case "普工": DataGridView1.SelectedRows[0].Cells[3].Value = (string)machines[4, 1]; break; } DataGridView1.Refresh(); }); colChoice.SubItems.Add(btnItem); } DataGridView1.Columns.Add(colChoice); DataGridView1.Columns.Add(colName); DataGridView1.Columns.Add(colNumber); DataGridView1.Columns.Add(colRemarks); #endregion } { #region/*机具准备 */ DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn colChoice = new DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn(); colChoice.HeaderText = "选择机械"; colChoice.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn colName = new DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn(); colName.HeaderText = "机械名称"; colName.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewIntegerInputColumn colNumber = new DevComponents.DotNetBar.Controls.DataGridViewIntegerInputColumn(); colNumber.HeaderText = "数量"; colNumber.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewIntegerInputColumn colPower = new DevComponents.DotNetBar.Controls.DataGridViewIntegerInputColumn(); colPower.HeaderText = "功率(KW)"; colPower.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colRemarks = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colRemarks.HeaderText = "备注"; colRemarks.Width = 209; object[] machines2 = new object[] { "混凝土泵车", "环保型振动棒", "BL12布料杆", "架子车", "木抹", "铁抹刮杠", "线绳", "钢卷尺", "棕刷" }; for (int i = 0; i < 9; i++) { DevComponents.DotNetBar.ButtonItem btnItem = new DevComponents.DotNetBar.ButtonItem(); btnItem.Text = (string)machines2[i]; btnItem.Click += new System.EventHandler(delegate(object sender, System.EventArgs args) { DataGridView2.SelectedRows[0].Cells[1].Value = btnItem.Text; DataGridView2.Refresh(); }); colChoice.SubItems.Add(btnItem); } DataGridView2.Columns.Add(colChoice); DataGridView2.Columns.Add(colName); DataGridView2.Columns.Add(colNumber); DataGridView2.Columns.Add(colPower); DataGridView2.Columns.Add(colRemarks); #endregion } { #region/*混凝土原材料要求 */ DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn colChoice = new DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn(); colChoice.HeaderText = "选择原材料"; colChoice.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn colName = new DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn(); colName.HeaderText = "原材料名称"; colName.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn colRemarks = new DevComponents.DotNetBar.Controls.DataGridViewTextBoxDropDownColumn(); colRemarks.HeaderText = "备注"; colRemarks.Width = 409; object[,] machines3 = new object[, ] { { "砂", "选用中粗砂,平均粒径不大于0.5mm,含泥量≤1%,对砂子的含石量、含水量在商砼生产厂家搅拌站进行现场取样实测,保证混凝土严格按照施工配合比施工。" }, { "石子", "选用砾石,要求含泥量≤1%,泥块含量≤0.5%,压碎指标值≤10,最大粒径与管径之比在1:3~1:4之间。" }, { "水泥", "采用普通硅酸盐水泥,水泥进场后立即取样送试,安定性合格后方可使用。" }, { "泵送剂", "进场泵送剂应具有出厂合格证及产品技术资料,并符合相应国家标准的要求,超过有效期或受潮的泵送剂不得使用。" }, { "粉煤灰", "选用Ⅱ级干排灰,进场材料必须出具出厂合格证" }, { "膨胀剂", "选用MEA,使混凝土得以补偿收缩,减少混凝土的收缩应力增强砼的防水能力。进场材料必须出具出厂合格证及厂家资质证书" }, { "水", "市政供水管网洁净自来水" } }; for (int i = 0; i < 7; i++) { DevComponents.DotNetBar.ButtonItem btnItem = new DevComponents.DotNetBar.ButtonItem(); btnItem.Text = (string)machines3[i, 0]; btnItem.Click += new System.EventHandler(delegate(object sender, System.EventArgs args) { DataGridView3.SelectedRows[0].Cells[1].Value = btnItem.Text; switch (btnItem.Text) { case "砂": DataGridView3.SelectedRows[0].Cells[2].Value = (string)machines3[0, 1]; break; case "石子": DataGridView3.SelectedRows[0].Cells[2].Value = (string)machines3[1, 1]; break; case "水泥": DataGridView3.SelectedRows[0].Cells[2].Value = (string)machines3[2, 1]; break; case "泵送剂": DataGridView3.SelectedRows[0].Cells[2].Value = (string)machines3[3, 1]; break; case "粉煤灰": DataGridView3.SelectedRows[0].Cells[2].Value = (string)machines3[4, 1]; break; case "膨胀剂": DataGridView3.SelectedRows[0].Cells[2].Value = (string)machines3[5, 1]; break; case "水": DataGridView3.SelectedRows[0].Cells[2].Value = (string)machines3[6, 1]; break; } DataGridView3.Refresh(); }); colChoice.SubItems.Add(btnItem); } DataGridView3.Columns.Add(colChoice); DataGridView3.Columns.Add(colName); DataGridView3.Columns.Add(colRemarks); #endregion } }
public FrmConstructPrepare(Framework.Entity.Chapter chapter, object type) { InitializeComponent(); @class = type; templateList = contentService.GetContentTemplateByTitle(chapter.Title); foreach (Framework.Entity.Template template in templateList) { if (template.Title == "脚手架工程") { tempInsertText = template; } } { #region/*机械准备*/ object[,] machines = new object[, ] { { "架子扳手", "架子工搭设和拆除架子用" }, { "力矩扳手", "检查架子扣件拧紧力度是否达到要求" }, { "倒链", "调整架子水平弯曲度" }, }; for (int i = 0; i < 3; i++) { DevComponents.DotNetBar.ButtonItem btnItem = new DevComponents.DotNetBar.ButtonItem(); btnItem.Text = (string)machines[i, 0]; btnItem.Click += new System.EventHandler(delegate(object sender, System.EventArgs args) { DataGridView1.SelectedRows[0].Cells[1].Value = btnItem.Text; switch (btnItem.Text) { case "架子扳手": DataGridView1.SelectedRows[0].Cells[3].Value = (string)machines[0, 1]; break; case "力矩扳手": DataGridView1.SelectedRows[0].Cells[3].Value = (string)machines[1, 1]; break; case "倒链": DataGridView1.SelectedRows[0].Cells[3].Value = (string)machines[2, 1]; break; } DataGridView1.Refresh(); }); colChoice.SubItems.Add(btnItem); } #endregion } { #region /*材料准备*/ DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn colChoice = new DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn(); colChoice.HeaderText = "选择脚手架"; colChoice.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn colName = new DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn(); colName.HeaderText = "脚手架名称"; colName.Width = 150; DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn colType = new DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn(); colType.HeaderText = "所需材料"; colType.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewMaskedTextBoxAdvColumn colFunction = new DevComponents.DotNetBar.Controls.DataGridViewMaskedTextBoxAdvColumn(); colFunction.HeaderText = "材料说明"; colFunction.Width = 250; object[,] machines = new object[, ] { { "钢管落地脚手架_内脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "钢管落地脚手架_外脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "钢管落地脚手架_物料提升架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "腕扣式钢管脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "门式钢管脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "门式脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "扣件式钢管脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "附墙升降脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "整体提升脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "整体提升外脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, { "钢管扣件满堂脚手架", new string[] { "钢管&Φ48 × 3.5", "扣件&配套", "连墙件&二步三跨,扣件连接", "脚手扳&木脚手板", "安全网&密目安全网" } }, }; for (int i = 0; i < 11; i++) { DevComponents.DotNetBar.ButtonItem btnItem = new DevComponents.DotNetBar.ButtonItem(); btnItem.Text = (string)machines[i, 0]; string[] types = (string[])machines[i, 1]; for (int j = 0; j < types.Length; j++) { DevComponents.DotNetBar.ButtonItem btnChildItem = new DevComponents.DotNetBar.ButtonItem(); string[] info = types[j].ToString().Split('&'); btnChildItem.Text = info[0]; btnChildItem.Click += new System.EventHandler(delegate(object sender, System.EventArgs args) { DevComponents.DotNetBar.ButtonItem item = sender as DevComponents.DotNetBar.ButtonItem; DataGridView2.SelectedRows[0].Cells[1].Value = item.Parent.Text; DataGridView2.SelectedRows[0].Cells[2].Value = info[0]; DataGridView2.SelectedRows[0].Cells[3].Value = info[1]; DataGridView2.Refresh(); }); btnItem.SubItems.Add(btnChildItem); } colChoice.SubItems.Add(btnItem); } DataGridView2.Columns.Add(colChoice); DataGridView2.Columns.Add(colName); DataGridView2.Columns.Add(colType); DataGridView2.Columns.Add(colFunction); #endregion } { #region /*劳动力需求*/ DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn colChoice = new DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn(); colChoice.HeaderText = "选择工种"; colChoice.Width = 100; DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn colName = new DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn(); colName.HeaderText = "工种名称"; colName.Width = 250; DevComponents.DotNetBar.Controls.DataGridViewIntegerInputColumn colNumber = new DevComponents.DotNetBar.Controls.DataGridViewIntegerInputColumn(); colNumber.HeaderText = "每班人数"; colNumber.Width = 250; object[] labor = new object[] { "技术管理", "安全监督", "质量检查", "测量放线", "架子工" }; for (int i = 0; i < 5; i++) { DevComponents.DotNetBar.ButtonItem btnItem = new DevComponents.DotNetBar.ButtonItem(); btnItem.Text = (string)labor[i]; btnItem.Click += new System.EventHandler(delegate(object sender, System.EventArgs args) { DataGridView3.SelectedRows[0].Cells[1].Value = btnItem.Text; DataGridView3.Refresh(); }); colChoice.SubItems.Add(btnItem); } DataGridView3.Columns.Add(colChoice); DataGridView3.Columns.Add(colName); DataGridView3.Columns.Add(colNumber); #endregion } { #region/*脚手架施工方案*/ //DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn colChoice = new DevComponents.DotNetBar.Controls.DataGridViewButtonXColumn(); //colChoice.HeaderText = "选择脚手架施工方案"; //colChoice.Width = 200; //DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn colName = new DevComponents.DotNetBar.Controls.DataGridViewLabelXColumn(); //colName.HeaderText = "脚手架施工方案"; //colName.Width = 400; //object[,] machines = new object[,]{ // {"腕扣式钢管脚手架",new string[] {"内脚手架","物料提升架","外脚手架"}}, // {"复合水泥发泡保温板",new string[]{}}, // }; //for (int i = 0; i < 2; i++) //{ // DevComponents.DotNetBar.ButtonItem btnItem = new DevComponents.DotNetBar.ButtonItem(); // btnItem.Text = (string)machines[i, 0]; // string[] types = (string[])machines[0, 1]; // btnItem.Click += new System.EventHandler(delegate(object sender, System.EventArgs args) // { // if (int i = 0) // { // for (int j = 0; j < types.Length; j++) // { // DevComponents.DotNetBar.ButtonItem btnChildItem = new DevComponents.DotNetBar.ButtonItem(); // //btnChildItem.Text = types[j].ToString(); // //btnChildItem.Click += new System.EventHandler(delegate(object sender, System.EventArgs args) // //{ // // DevComponents.DotNetBar.ButtonItem item = sender as DevComponents.DotNetBar.ButtonItem; // DataGridView2.SelectedRows[0].Cells[1].Value = types[j].ToString(); // //DataGridView2.SelectedRows[0].Cells[2].Value = info[0]; // //DataGridView2.SelectedRows[0].Cells[3].Value = info[1]; // //DataGridView2.Refresh(); // //}); // btnItem.SubItems.Add(btnChildItem); // } // } // else // { // DataGridView4.SelectedRows[0].Cells[1].Value = btnItem.Text; // DataGridView4.Refresh(); // } // }); // colChoice.SubItems.Add(btnItem); //} //DataGridView4.Columns.Add(colChoice); //DataGridView4.Columns.Add(colName); #endregion } }