コード例 #1
0
 public bool UpdateMedicineCompany(MedicineCompany medicineCompany) 
 {
     return du.AddRow(@"update MedicineCompany set CompanyID = " + medicineCompany.CompanyID + ")");
 }
コード例 #2
0
 public bool DeleteMedicineCompany(MedicineCompany medicineCompany)
 {
     return du.DeleteRow(@"update MedicineCompany set DeleteFlag = 1 where CompanyID ='" + medicineCompany.CompanyID + "')");
 }
コード例 #3
0
 public bool AddMedicineCompany(MedicineCompany medicineCompany) 
 {
     return du.AddRow(@"insert into MedicineCompany(CompanyID,CompanyCode ,CompanyName, Address1,Address2,Address3,ContactNumber1,ContactNumber2,ContactPerson,Type,UserID,AddDate,ModifiyDate)
     values(" + medicineCompany.CompanyID + ",'" + medicineCompany.CompanyCode + "', '" + medicineCompany.CompanyName + "', " + medicineCompany.Address1 + ", '" + medicineCompany.Address2 + "', '" + medicineCompany.Address3 + "', '" + medicineCompany.ContactNumber1 + "', '" + medicineCompany.ContactNumber2 + "', '" + medicineCompany.ContactPerson + "', '" + medicineCompany.Type + "', '" + medicineCompany.UserID + "', '" + medicineCompany.AddDate + "', '" + medicineCompany.ModifiyDate + "')");
 }