public static RawMateEntity DataRowToEntity(DataRow row) { if (row == null) return null; var result = new RawMateEntity() { RawMateId = (int)(row["RawMateId"]), RawMateNo = (string)(row["RawMateNo"]), RawMateName = (string)(row["RawMateName"]), Spec = (string)(row["Spec"]), MinStore = (decimal)(row["MinStore"]), MaxStore = (decimal)(row["MaxStore"]), Unit = (string)(row["Unit"]), IsRemind = (bool)(row["IsRemind"]), QtyMode = (short)(row["QtyMode"]), preprice1 = (decimal)(row["preprice1"]), preprice2 = (decimal)(row["preprice2"]), preprice3 = (decimal)(row["preprice3"]), recprice = (decimal)(row["recprice"]), Remark1 = (string)(row["Remark1"]), Remark2 = (string)(row["Remark2"]), Remark3 = (string)(row["Remark3"]), Remark4 = (string)(row["Remark4"]), PId = (int)(row["PId"]), Level_Path = (string)(row["Level_Path"]), Level_Num = (int)(row["Level_Num"]), Level_Total = (int)(row["Level_Total"]), Level_Deep = (int)(row["Level_Deep"]), CreateId = (string)(row["CreateId"]), CreateDate = (DateTime)(row["CreateDate"]), LastModifyId = (string)(row["LastModifyId"]), LastModifyDate = (DateTime)(row["LastModifyDate"]), }; return result; }
public static RawMateEntity[] DataTableToEntitys(DataTable dt) { if (dt == null) return null; var results = new RawMateEntity[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { results[i] = DataRowToEntity(dt.Rows[i]); } return results; }
public int CreateRawMate(RawMateEntity entity) { int entityid = 0; base.UseTran((tran) => { var cmd = GetCreateRawMateCommand(this.Database, entity); base.Database.ExecuteNonQuery(cmd, tran); entityid = (int)base.Database.GetParameterValue(cmd, "RawMateId"); }); return entityid; }
public void UpdateRawMate(RawMateEntity entity) { base.UseTran((tran) => { var cmd = GetUpdateRawMateCommand(this.Database, entity); base.Database.ExecuteNonQuery(cmd, tran); }); }
public static DbCommand GetUpdateRawMateCommand(Database database, RawMateEntity entity) { DbCommand cmd = database.GetStoredProcCommand("P_UpdateRawMate"); #region 参数赋值 database.AddInParameter(cmd, "RawMateId", DbType.Int32, entity.RawMateId); database.AddInParameter(cmd, "RawMateNo", DbType.String, entity.RawMateNo); database.AddInParameter(cmd, "RawMateName", DbType.String, entity.RawMateName); database.AddInParameter(cmd, "Spec", DbType.String, entity.Spec); database.AddInParameter(cmd, "MinStore", DbType.Decimal, entity.MinStore); database.AddInParameter(cmd, "MaxStore", DbType.Decimal, entity.MaxStore); database.AddInParameter(cmd, "Unit", DbType.String, entity.Unit); database.AddInParameter(cmd, "IsRemind", DbType.Boolean, entity.IsRemind); database.AddInParameter(cmd, "QtyMode", DbType.Int16, entity.QtyMode); database.AddInParameter(cmd, "preprice1", DbType.Decimal, entity.preprice1); database.AddInParameter(cmd, "preprice2", DbType.Decimal, entity.preprice2); database.AddInParameter(cmd, "preprice3", DbType.Decimal, entity.preprice3); database.AddInParameter(cmd, "recprice", DbType.Decimal, entity.recprice); database.AddInParameter(cmd, "Remark1", DbType.String, entity.Remark1); database.AddInParameter(cmd, "Remark2", DbType.String, entity.Remark2); database.AddInParameter(cmd, "Remark3", DbType.String, entity.Remark3); database.AddInParameter(cmd, "Remark4", DbType.String, entity.Remark4); database.AddInParameter(cmd, "LastModifyId", DbType.String, entity.LastModifyId); #endregion return cmd; }