public static T_CheckupCorp AddT_CheckupCorp(T_CheckupCorp t_CheckupCorp) { string sql = "INSERT T_CheckupCorps (id, corp_addr, leading_official, contacts, contact_numbers, remarks, status)" + "VALUES (@id, @corp_addr, @leading_official, @contacts, @contact_numbers, @remarks, @status)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@id", DBHelper.GetValueByWhetherNull(t_CheckupCorp.id)), new SqlParameter("@corp_addr", DBHelper.GetValueByWhetherNull(t_CheckupCorp.corp_addr)), new SqlParameter("@leading_official", DBHelper.GetValueByWhetherNull(t_CheckupCorp.leading_official)), new SqlParameter("@contacts", DBHelper.GetValueByWhetherNull(t_CheckupCorp.contacts)), new SqlParameter("@contact_numbers", DBHelper.GetValueByWhetherNull(t_CheckupCorp.contact_numbers)), new SqlParameter("@remarks", DBHelper.GetValueByWhetherNull(t_CheckupCorp.remarks)), new SqlParameter("@status", DBHelper.GetValueByWhetherNull(t_CheckupCorp.status)) }; int newId = DBHelper.GetScalar(sql, para); return(GetT_CheckupCorpByCorp_name(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static T_CheckupCorp GetT_CheckupCorpByCorp_name(string corp_name) { string sql = "SELECT * FROM T_CheckupCorps WHERE Corp_name = @Corp_name"; try { SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@Corp_name", corp_name)); if (reader.Read()) { T_CheckupCorp t_CheckupCorp = new T_CheckupCorp(); try{ t_CheckupCorp.Id = (int)reader["id"]; }catch {} try{ t_CheckupCorp.Corp_name = (string)reader["corp_name"]; }catch {} try{ t_CheckupCorp.Corp_addr = (string)reader["corp_addr"]; }catch {} try{ t_CheckupCorp.Leading_official = (string)reader["leading_official"]; }catch {} try{ t_CheckupCorp.Contacts = (string)reader["contacts"]; }catch {} try{ t_CheckupCorp.Contact_numbers = (string)reader["contact_numbers"]; }catch {} try{ t_CheckupCorp.Remarks = (string)reader["remarks"]; }catch {} try{ t_CheckupCorp.Status = (bool)reader["status"]; }catch {} reader.Close(); return(t_CheckupCorp); } else { reader.Close(); return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
private static IList <T_CheckupCorp> GetT_CheckupCorpsBySql(string sql, params SqlParameter[] values) { List <T_CheckupCorp> list = new List <T_CheckupCorp>(); try { DataTable table = DBHelper.GetDataSet(sql, values); foreach (DataRow row in table.Rows) { T_CheckupCorp t_CheckupCorp = new T_CheckupCorp(); try{ t_CheckupCorp.Id = (int)row["id"]; }catch {} try{ t_CheckupCorp.Corp_name = (string)row["corp_name"]; }catch {} try{ t_CheckupCorp.Corp_addr = (string)row["corp_addr"]; }catch {} try{ t_CheckupCorp.Leading_official = (string)row["leading_official"]; }catch {} try{ t_CheckupCorp.Contacts = (string)row["contacts"]; }catch {} try{ t_CheckupCorp.Contact_numbers = (string)row["contact_numbers"]; }catch {} try{ t_CheckupCorp.Remarks = (string)row["remarks"]; }catch {} try{ t_CheckupCorp.Status = (bool)row["status"]; }catch {} list.Add(t_CheckupCorp); } return(list); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static void ModifyT_CheckupCorp(T_CheckupCorp t_CheckupCorp) { string sql = "UPDATE T_CheckupCorps " + "SET " + "id = @id, " + "corp_addr = @corp_addr, " + "leading_official = @leading_official, " + "contacts = @contacts, " + "contact_numbers = @contact_numbers, " + "remarks = @remarks, " + "status = @status " + "WHERE corp_name = @corp_name"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@corp_name", t_CheckupCorp.corp_name), new SqlParameter("@id", DBHelper.GetValueByWhetherNull(t_CheckupCorp.id)), new SqlParameter("@corp_addr", DBHelper.GetValueByWhetherNull(t_CheckupCorp.corp_addr)), new SqlParameter("@leading_official", DBHelper.GetValueByWhetherNull(t_CheckupCorp.leading_official)), new SqlParameter("@contacts", DBHelper.GetValueByWhetherNull(t_CheckupCorp.contacts)), new SqlParameter("@contact_numbers", DBHelper.GetValueByWhetherNull(t_CheckupCorp.contact_numbers)), new SqlParameter("@remarks", DBHelper.GetValueByWhetherNull(t_CheckupCorp.remarks)), new SqlParameter("@status", DBHelper.GetValueByWhetherNull(t_CheckupCorp.status)) }; DBHelper.ExecuteCommand(sql, para); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static void ModifyT_CheckupCorp(T_CheckupCorp t_CheckupCorp) { T_CheckupCorpService.ModifyT_CheckupCorp(t_CheckupCorp); }
public static void DeleteT_CheckupCorp(T_CheckupCorp t_CheckupCorp) { T_CheckupCorpService.DeleteT_CheckupCorp(t_CheckupCorp); }
public static T_CheckupCorp AddT_CheckupCorp(T_CheckupCorp t_CheckupCorp) { return(T_CheckupCorpService.AddT_CheckupCorp(t_CheckupCorp)); }
public static void DeleteT_CheckupCorp(T_CheckupCorp t_CheckupCorp) { DeleteT_CheckupCorpByCorp_name(t_CheckupCorp.Corp_name); }
public static void DeleteT_CheckupCorp(T_CheckupCorp t_CheckupCorp) { DeleteT_CheckupCorpById(t_CheckupCorp.Id); }