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