public bool update_by_index() { try { SqlHealper sh = new SqlHealper(); sh.ExecuteCMD("update tbl_P set P_ID = '" + this.ID + "',P_Name = '" + this.Name + "',P_Sex = '" + this.Sex + "',P_Birthday = '" + this.Birthday.ToShortDateString() + "',P_Jobday = '" + this.Jobday.ToShortDateString() + "',P_Education = '" + this.Education + "',P_Department = '" + this.Department + "',P_Duty = '" + this.Duty + "',P_Jobtype = '" + this.Jobtype + "' where P_index = " + this.index.ToString()); } catch { return(false); } return(true); }
public bool add() { try { SqlHealper sh = new SqlHealper(); sh.ExecuteCMD( "insert into tbl_U( U_ID, U_Name, U_Pwd, U_Role, U_Limit)" + "values" + "('" + this.ID + "','" + this.Name + "','" + this.Pwd + "'," + this.Role.ToString() + "," + this.Limit.ToString() + ")" ); } catch { return(false); } return(true); }
public bool add() { try { SqlHealper sh = new SqlHealper(); sh.ExecuteCMD( "insert into tbl_M" + "(M_ID, M_Classify, M_MakePrice, M_SellPrice, M_Unit, M_Memo)" + "values" + "('" + this.ID + "','" + this.Classify + "','" + this.MakePrice + "','" + this.SellPrice + "','" + this.Unit + "','" + this.Memo + "')" ); } catch { return(false); } return(true); }
static void Main(string[] args) { string user = "", passwd = "", domain = "", database = ""; XmlReader.Read(ref domain, ref user, ref passwd, ref database); Console.WriteLine("user = "******"passwd = " + passwd); Console.WriteLine("domain = " + domain); SqlHealper sh = new SqlHealper(); sh.ExecuteCMD("update tbl_P set P_Jobtype='管理' where P_ID='test1'"); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form1()); Console.ReadLine(); }
public bool add() { try { SqlHealper sh = new SqlHealper(); sh.ExecuteCMD( "INSERT INTO tbl_P(" + "P_ID , P_Name , P_Sex , P_Birthday , P_Jobday , P_Education , P_Department , P_Duty , P_Jobtype " + ")values(" + "'" + this.ID + "','" + this.Name + "','" + this.Sex + "','" + this.Birthday.ToShortDateString() + "','" + this.Jobday.ToShortDateString() + "','" + this.Education + "','" + this.Department + "','" + this.Duty + "','" + this.Jobtype + "'" + ")" ); } catch { return(false); } return(true); }
public bool update_by_index() { try { SqlHealper sh = new SqlHealper(); sh.ExecuteCMD( "update tbl_U " + "set U_ID = '" + this.ID + "'," + "U_Name = '" + this.Name + "'," + "U_pwd = '" + this.Pwd + "'," + "U_role = '" + this.Role + "'," + "U_Limit = '" + this.Limit + "'" + " where U_index = " + this.index.ToString() ); } catch { return(false); } return(true); }
public bool update_by_index() { try { SqlHealper sh = new SqlHealper(); sh.ExecuteCMD( "update tbl_M " + "set M_ID = '" + this.ID + "'," + "M_Classify = '" + this.Classify + "'," + "M_MakePrice = '" + this.MakePrice + "'," + "M_SellPrice = '" + this.SellPrice + "'," + "M_Unit = '" + this.Unit + "'," + "M_Memo = '" + this.Memo + "' " + "where M_index = " + this.index ); } catch { return(false); } return(true); }
public void delete_by_index() { SqlHealper sh = new SqlHealper(); sh.ExecuteCMD("delete tbl_P where P_index = " + this.index.ToString()); }
public static void delete_by_index(string index) { SqlHealper sh = new SqlHealper(); sh.ExecuteCMD("delete tbl_U where U_index = " + index.ToString()); }