public bool Update(VaccinationOtherProgramModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update INOCULATION_OTHERPROGRAM set "); builder.Append("Name=@Name,"); builder.Append("ProvinceID=@ProvinceID,"); builder.Append("CityID=@CityID,"); builder.Append("DistrictID=@DistrictID,"); builder.Append("TownID=@TownID,"); builder.Append("VillageID=@VillageID,"); builder.Append("Times=@Times"); builder.Append(" where ID=@ID"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@Name", MySqlDbType.String, 30), new MySqlParameter("@ProvinceID", MySqlDbType.Decimal), new MySqlParameter("@CityID", MySqlDbType.Decimal), new MySqlParameter("@DistrictID", MySqlDbType.Decimal), new MySqlParameter("@TownID", MySqlDbType.Decimal), new MySqlParameter("@VillageID", MySqlDbType.Decimal), new MySqlParameter("@Times", MySqlDbType.Decimal), new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.Name; cmdParms[1].Value = model.ProvinceID; cmdParms[2].Value = model.CityID; cmdParms[3].Value = model.DistrictID; cmdParms[4].Value = model.TownID; cmdParms[5].Value = model.VillageID; cmdParms[6].Value = model.Times; cmdParms[7].Value = model.ID; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public int Add(VaccinationOtherProgramModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into INOCULATION_OTHERPROGRAM("); builder.Append("Name,ProvinceID,CityID,DistrictID,TownID,VillageID,Times)"); builder.Append(" values ("); builder.Append("@Name,@ProvinceID,@CityID,@DistrictID,@TownID,@VillageID,@Times)"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@Name", MySqlDbType.String, 30), new MySqlParameter("@ProvinceID", MySqlDbType.Decimal), new MySqlParameter("@CityID", MySqlDbType.Decimal), new MySqlParameter("@DistrictID", MySqlDbType.Decimal), new MySqlParameter("@TownID", MySqlDbType.Decimal), new MySqlParameter("@VillageID", MySqlDbType.Decimal), new MySqlParameter("@Times", MySqlDbType.Decimal) }; cmdParms[0].Value = model.Name; cmdParms[1].Value = model.ProvinceID; cmdParms[2].Value = model.CityID; cmdParms[3].Value = model.DistrictID; cmdParms[4].Value = model.TownID; cmdParms[5].Value = model.VillageID; cmdParms[6].Value = model.Times; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public List <VaccinationOtherProgramModel> DataTableToList(DataTable dt) { List <VaccinationOtherProgramModel> list = new List <VaccinationOtherProgramModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { VaccinationOtherProgramModel item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public VaccinationOtherProgramModel DataRowToModel(DataRow row) { VaccinationOtherProgramModel inoculation_otherprogram = new VaccinationOtherProgramModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { inoculation_otherprogram.ID = int.Parse(row["ID"].ToString()); } if ((row["Name"] != null) && (row["Name"] != DBNull.Value)) { inoculation_otherprogram.Name = row["Name"].ToString(); } if (((row["ProvinceID"] != null) && (row["ProvinceID"] != DBNull.Value)) && (row["ProvinceID"].ToString() != "")) { inoculation_otherprogram.ProvinceID = decimal.Parse(row["ProvinceID"].ToString()); } if (((row["CityID"] != null) && (row["CityID"] != DBNull.Value)) && (row["CityID"].ToString() != "")) { inoculation_otherprogram.CityID = new decimal?(decimal.Parse(row["CityID"].ToString())); } if (((row["DistrictID"] != null) && (row["DistrictID"] != DBNull.Value)) && (row["DistrictID"].ToString() != "")) { inoculation_otherprogram.DistrictID = new decimal?(decimal.Parse(row["DistrictID"].ToString())); } if (((row["TownID"] != null) && (row["TownID"] != DBNull.Value)) && (row["TownID"].ToString() != "")) { inoculation_otherprogram.TownID = new decimal?(decimal.Parse(row["TownID"].ToString())); } if (((row["VillageID"] != null) && (row["VillageID"] != DBNull.Value)) && (row["VillageID"].ToString() != "")) { inoculation_otherprogram.VillageID = new decimal?(decimal.Parse(row["VillageID"].ToString())); } if (((row["Times"] != null) && (row["Times"] != DBNull.Value)) && (row["Times"].ToString() != "")) { inoculation_otherprogram.Times = new decimal?(decimal.Parse(row["Times"].ToString())); } } return(inoculation_otherprogram); }
public int Add(VaccinationOtherProgramModel model) { return(this.dal.Add(model)); }
public bool Update(VaccinationOtherProgramModel model) { return(this.dal.Update(model)); }