public RecordsVillageModel DataRowToModel(DataRow row) { RecordsVillageModel archive_village = new RecordsVillageModel(); if (row != null) { archive_village.ID = row["ID"].ToString(); if ((row["Code"] != null) && (row["Code"] != DBNull.Value)) { archive_village.Code = row["Code"].ToString(); } if ((row["Name"] != null) && (row["Name"] != DBNull.Value)) { archive_village.Name = row["Name"].ToString(); } if ((row["TownID"] != null) && (row["TownID"] != DBNull.Value)) { archive_village.TownID = int.Parse(row["TownID"].ToString()); } if (row["IsDelete"] != null) { object obj1 = row["IsDelete"]; } } return(archive_village); }
public bool Update(RecordsVillageModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ARCHIVE_VILLAGE set "); builder.Append("ID=@ID,"); builder.Append("Code=@Code,"); builder.Append("Name=@Name,"); builder.Append("TownID=@TownID,"); builder.Append("IsDelete=@IsDelete"); builder.Append(" where "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@ID", MySqlDbType.Int32, 4), new MySqlParameter("@Code", MySqlDbType.String), new MySqlParameter("@Name", MySqlDbType.String), new MySqlParameter("@TownID", MySqlDbType.Int32, 4), new MySqlParameter("@IsDelete", MySqlDbType.Int32, 4) }; cmdParms[0].Value = model.ID; cmdParms[1].Value = model.Code; cmdParms[2].Value = model.Name; cmdParms[3].Value = model.TownID; cmdParms[4].Value = model.IsDelete; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <RecordsVillageModel> DataTableToList(DataTable dt) { List <RecordsVillageModel> list = new List <RecordsVillageModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { RecordsVillageModel item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add(RecordsVillageModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ARCHIVE_VILLAGE("); builder.Append("ID,Code,Name,TownID,IsDelete)"); builder.Append(" values ("); builder.Append("@ID,@Code,@Name,@TownID,@IsDelete)"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@ID", MySqlDbType.Int32, 4), new MySqlParameter("@Code", MySqlDbType.String), new MySqlParameter("@Name", MySqlDbType.String), new MySqlParameter("@TownID", MySqlDbType.Int32, 4), new MySqlParameter("@IsDelete", MySqlDbType.Int32, 4) }; cmdParms[0].Value = model.ID; cmdParms[1].Value = model.Code; cmdParms[2].Value = model.Name; cmdParms[3].Value = model.TownID; cmdParms[4].Value = model.IsDelete; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Update(RecordsVillageModel model) { return(this.dal.Update(model)); }
public bool Add(RecordsVillageModel model) { return(this.dal.Add(model)); }