public static List <ProjectTemplete> SearchAllWithClass(string c1, string c2, string c3)
{
try
{
MySqlParameter _class1 = new MySqlParameter("_class1", MySqlDbType.String);
_class1.Value = c1;
MySqlParameter _class2 = new MySqlParameter("_class2", MySqlDbType.String);
_class2.Value = c2;
MySqlParameter _class3 = new MySqlParameter("_class3", MySqlDbType.String);
_class3.Value = c3;
DbManager dm = DbManager.Ins;
MySqlParameter[] pars = new MySqlParameter[] { _class1, _class2, _class3 };
DataTable dt = dm.ExecuteProcQuery("ProjectTemplete_SearchAllWithClass", pars);
List <ProjectTemplete> pts = new List <ProjectTemplete>();
foreach (DataRow dr in dt.Rows)
{
ProjectTemplete pt = new ProjectTemplete();
pt.Id = (int)dr["id"];
pt.Name = (string)dr["name"];
pt.Description = (string)dr["description"];
pts.Add(pt);
}
return(pts);
}
catch (Exception)
{
return(null);
}
}
private static MySqlParameter[] MakeUpdateParameter(ProjectTemplete pt)
{
MySqlParameter _id = new MySqlParameter("_id", MySqlDbType.Int32);
_id.Value = pt.Id;
MySqlParameter _class1 = new MySqlParameter("_class1", MySqlDbType.String);
_class1.Value = pt.Class1;
MySqlParameter _class2 = new MySqlParameter("_class2", MySqlDbType.String);
_class2.Value = pt.Class2;
MySqlParameter _class3 = new MySqlParameter("_class3", MySqlDbType.String);
_class3.Value = pt.Class3;
MySqlParameter _name = new MySqlParameter("_name", MySqlDbType.String);
_name.Value = pt.Name;
MySqlParameter _description = new MySqlParameter("_description", MySqlDbType.String);
_description.Value = pt.Description;
MySqlParameter _raw = new MySqlParameter("_raw", MySqlDbType.Blob);
_raw.Value = pt.Raw;
return(new MySqlParameter[] { _id, _class1, _class2, _class3, _name, _description, _raw });
}
private void bu_add_Click(object sender, EventArgs e)
{
if (cb_class1.Text == "" || cb_class2.Text == "" || cb_class3.Text == "")
{
MessageBox.Show("您必须选择或者输入类别", "错误");
return;
}
ProjectTemplete pt = new ProjectTemplete();
pt.Class1 = cb_class1.Text;
pt.Class2 = cb_class2.Text;
pt.Class3 = cb_class3.Text;
pt.Description = pro.Remark;
pt.Name = pro.Name;
pt.Raw = pro.Serialize();
pt.Id = 0;
bool res = DBProjectTempleteAdapter.Insert(pt);
if (!res)
{
MessageBox.Show("建立新模板错误，请检查您的网络或者联系管理员", "错误");
return;
}
RefreshData();
}
public static bool Update(ProjectTemplete pt)
{
try
{
DbManager dm = DbManager.Ins;
MySqlParameter[] pars = MakeUpdateParameter(pt);
dm.ExecuteProcNonQuery("ProjectTemplete_Update", pars);
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static bool Insert(ProjectTemplete pt)
{
try
{
DbManager dm = DbManager.Ins;
MySqlParameter[] pars = MakeInsertParameter(pt);
DataTable dt = dm.ExecuteProcQuery("ProjectTemplete_Insert", pars);
pt.Id = (int)dt.Rows[0][0];
return(true);
}
catch (Exception e)
{
return(false);
}
}
private void bu_addlocal_Click(object sender, EventArgs e)
{
OpenFileDialog fd = new OpenFileDialog();
fd.CheckFileExists = true;
fd.CheckPathExists = true;
fd.Filter = "PHTC工程文件|*.pht";
if (fd.ShowDialog() == DialogResult.Cancel)
{
return;
}
Project p = Project.FromFile(fd.FileName);
if (p == null)
{
MessageBox.Show("该文件格式不正确", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (cb_class1.Text == "" || cb_class2.Text == "" || cb_class3.Text == "")
{
MessageBox.Show("您必须选择或者输入类别", "错误");
return;
}
ProjectTemplete pt = new ProjectTemplete();
pt.Class1 = cb_class1.Text;
pt.Class2 = cb_class2.Text;
pt.Class3 = cb_class3.Text;
pt.Description = p.Remark;
pt.Name = p.Name;
pt.Raw = p.Serialize();
pt.Id = 0;
bool res = DBProjectTempleteAdapter.Insert(pt);
if (!res)
{
MessageBox.Show("建立新模板错误，请检查您的网络或者联系管理员", "错误");
return;
}
RefreshData();
}
