public RecordsRequiredModel DataRowToModel(DataRow row) { RecordsRequiredModel recordsRequiredModel = new RecordsRequiredModel(); if (row != null) { if ((row["ID"] != null) && (row["ID"].ToString() != "")) { recordsRequiredModel.ID = int.Parse(row["ID"].ToString()); } if (row["BTable"] != null) { recordsRequiredModel.BTable = row["BTable"].ToString(); } if (row["Name"] != null) { recordsRequiredModel.Name = row["Name"].ToString(); } if (row["Comment"] != null) { recordsRequiredModel.Comment = row["Comment"].ToString(); } if ((row["IsRequired"] != null) && (row["IsRequired"].ToString() != "")) { recordsRequiredModel.IsRequired = new decimal?(decimal.Parse(row["IsRequired"].ToString())); } recordsRequiredModel.RcdState = RecordsStateModel.Unchanged; } return(recordsRequiredModel); }
public bool Update(RecordsRequiredModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update RecordsRequired set "); builder.Append("BTable=@BTable,"); builder.Append("Name=@Name,"); builder.Append("Comment=@Comment,"); builder.Append("IsRequired=@IsRequired "); builder.Append(" where ID=@ID"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@BTable", MySqlDbType.String), new MySqlParameter("@Name", MySqlDbType.String), new MySqlParameter("@Comment", MySqlDbType.String), new MySqlParameter("@IsRequired", MySqlDbType.Int32), new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.BTable; cmdParms[1].Value = model.Name; cmdParms[2].Value = model.Comment; cmdParms[3].Value = model.IsRequired; cmdParms[4].Value = model.ID; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public int Add(RecordsRequiredModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into RecordsRequired("); builder.Append("BTable,Name,Comment,IsRequired)"); builder.Append(" values ("); builder.Append("@BTable,@Name,@Comment,@IsRequired)"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@BTable", MySqlDbType.String), new MySqlParameter("@Name", MySqlDbType.String), new MySqlParameter("@Comment", MySqlDbType.String), new MySqlParameter("@IsRequired", MySqlDbType.Int32) }; cmdParms[0].Value = model.BTable; cmdParms[1].Value = model.Name; cmdParms[2].Value = model.Comment; cmdParms[3].Value = model.IsRequired; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public List <RecordsRequiredModel> DataTableToList(DataTable dt) { List <RecordsRequiredModel> list = new List <RecordsRequiredModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { RecordsRequiredModel item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public int Add(RecordsRequiredModel model) { return(this.dal.Add(model)); }
public bool Update(RecordsRequiredModel model) { return(this.dal.Update(model)); }