public static StockEntity[] DataTableToEntitys(DataTable dt) { if (dt == null) return null; var results = new StockEntity[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { results[i] = DataRowToEntity(dt.Rows[i]); } return results; }
public static DbCommand GetCreateStockCommand(Database database, StockEntity entity) { DbCommand cmd = database.GetStoredProcCommand("P_CreateStock"); database.AddOutParameter(cmd, "StockId", DbType.Int32, 4); #region 参数赋值 database.AddInParameter(cmd, "StockNo", DbType.String, entity.StockNo); database.AddInParameter(cmd, "StockName", DbType.String, entity.StockName); database.AddInParameter(cmd, "CreateId", DbType.String, entity.CreateId); database.AddInParameter(cmd, "Remark", DbType.String, entity.Remark); #endregion return cmd; }
public static StockEntity DataRowToEntity(DataRow row) { if (row == null) return null; var result = new StockEntity() { StockId = (int)(row["StockId"]), StockNo = (string)(row["StockNo"]), StockName = (string)(row["StockName"]), CreateId = (string)(row["CreateId"]), CreateDate = (DateTime)(row["CreateDate"]), LastModifyId = (string)(row["LastModifyId"]), LastModifyDate = (DateTime)(row["LastModifyDate"]), Remark = (string)(row["Remark"]), }; return result; }
public static DbCommand GetUpdateEntityCommand(Database database, StockEntity entity) { DbCommand cmd = database.GetStoredProcCommand("P_UpdateStock"); #region 参数赋值 database.AddInParameter(cmd, "StockId", DbType.Int32, entity.StockId); database.AddInParameter(cmd, "StockNo", DbType.String, entity.StockNo); database.AddInParameter(cmd, "StockName", DbType.String, entity.StockName); database.AddInParameter(cmd, "LastModifyId", DbType.String, entity.LastModifyId); database.AddInParameter(cmd, "Remark", DbType.String, entity.Remark); #endregion return cmd; }
public void UpdateStock(StockEntity entity) { base.UseTran((tran) => { var cmd = GetUpdateEntityCommand(this.Database, entity); base.Database.ExecuteNonQuery(cmd, tran); }); }
public int CreateStock(StockEntity entity) { int entityid = 0; base.UseTran((tran) => { var cmd = GetCreateStockCommand(this.Database, entity); base.Database.ExecuteNonQuery(cmd, tran); entityid = (int)base.Database.GetParameterValue(cmd, "StockId"); }); return entityid; }