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
}
}
