private static String GetIntoLibSQL() { IList intolibs = IntoLibData.GetAllIntoLibRecs(); StringBuilder sbResult = new StringBuilder(); foreach (object o in intolibs) { IntoLib il = o as IntoLib; StringBuilder sb = new StringBuilder(); sb.Append("insert into intolib (User,InputTime,PumpName,PumpType,DrawType,FileName,Version,ProductNo) values "); sb.Append("('" + il.User + "'"); sb.Append(",'" + il.InputTime.ToString() + "'"); sb.Append(",'" + il.PumpName + "'"); sb.Append(",'" + il.PumpType + "'"); sb.Append(",'" + il.DrawType + "'"); sb.Append(",'" + il.FileName + "'"); sb.Append("," + il.Version); sb.Append(",'" + il.ProductNo + "'"); sb.Append(");"); string queryText = sb.ToString(); sbResult.Append(Environment.NewLine); sbResult.Append(queryText); sbResult.Append(Environment.NewLine); } return(sbResult.ToString());; }
private void IntoLibRec_Load(object sender, System.EventArgs e) { IList listUser = UserData.GetAllUsers(); foreach (object o in listUser) { _User u = (_User)o; comboBox1.Items.Add(u.Name); } comboBox1.SelectedIndex = 0; IList PumpNames = IntoLibData.GetIntoLibPumpNames(); foreach (object o1 in PumpNames) { comboBox2.Items.Add(o1.ToString()); } comboBox2.SelectedIndex = 0; IList PumpClass = PumpTypeData.getPumpTypeName(); foreach (object o2 in PumpClass) { comboBox3.Items.Add(o2.ToString()); } comboBox3.SelectedIndex = 0; }
private void button1_Click(object sender, System.EventArgs e) { if (tabControl1.SelectedTab == tabPage1) { if (textBox1.Text == "") { MessageBox.Show(this, "信息输入不完整!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } IList list1 = IntoLibData.GetIntoLibByFileName(textBox1.Text); FillList(list1); } if (tabControl1.SelectedTab == tabPage2) { IList list1 = IntoLibData.GetIntoLibByUser(comboBox1.Text); FillList(list1); } if (tabControl1.SelectedTab == tabPage3) { IList list1 = IntoLibData.GetIntoLibByPumpType(comboBox3.Text); FillList(list1); } if (tabControl1.SelectedTab == tabPage4) { IList list1 = IntoLibData.GetIntoLibByPumpName(comboBox2.Text); FillList(list1); } LogFindResult(); }
private void button2_Click(object sender, System.EventArgs e) { IList list = IntoLibData.GetAllIntoLibRecs(); FillList(list); LogFindResult(); }
private void LoadPumpNames() { IList pumpNameList = IntoLibData.GetIntoLibPumpNames(); foreach (Object o in pumpNameList) { cmbPumpName.Items.Add(o.ToString()); } }
private void OutLib_Load(object sender, System.EventArgs e) { IList userList = UserData.GetAllUsers(); foreach (object o in userList) { _User u = (_User)o; comboBox1.Items.Add(u.Name); } comboBox1.SelectedIndex = 0; IList DrawTypes = DrawTypeData.LoadFileType(); foreach (object a in DrawTypes) { FileType ft = (FileType)a; comboBox2.Items.Add(ft.Type); } comboBox2.SelectedIndex = 0; IList PumpNames = IntoLibData.GetIntoLibPumpNames(); foreach (object pn in PumpNames) { comboBox3.Items.Add(pn.ToString()); } comboBox3.SelectedIndex = 0; IList TypeNames = PumpTypeData.getPumpTypeName(); foreach (object tn in TypeNames) { comboBox4.Items.Add(tn.ToString()); } comboBox4.SelectedIndex = 0; }