public static IList <GoodsFlowEntity> QueryWaitingValid(GoodsFlowValidType validType, int formNo, bool isValid, string vendorId, string hospitalId) { var sql = string.Format(@"select top 30 {0} from goods_flow where 1=1 {1} order by barcode", COLUMN_SQL, GetFormNoSql(validType, true)); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_form_no", DbType.Int32, formNo); if (validType == GoodsFlowValidType.Dispatch) { db.AddInParameter(dc, "p_vendor_id", DbType.String, vendorId); } db.AddInParameter(dc, "p_hospital_id", DbType.String, hospitalId); AddValidValue(db, dc, validType, isValid); var list = new List <GoodsFlowEntity>(); using (var reader = db.ExecuteReader(dc)) { while (reader.Read()) { var entity = new GoodsFlowEntity(); entity.Init(reader); list.Add(entity); } } return(list); }
public static GoodsFlowEntity GetByBarcode(GoodsFlowValidType validType, string barcode, string vendorId, string hospitalId) { var sql = string.Format(@"select {0} from goods_flow where 1=1 and barcode=@p_barcode {1}", COLUMN_SQL, GetValidTypeSql(validType)); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); if (validType == GoodsFlowValidType.Dispatch) { db.AddInParameter(dc, "p_vendor_id", DbType.String, vendorId); } db.AddInParameter(dc, "p_hospital_id", DbType.String, hospitalId); db.AddInParameter(dc, "p_barcode", DbType.String, barcode); using (var reader = db.ExecuteReader(dc)) { while (reader.Read()) { var entity = new GoodsFlowEntity(); entity.Init(reader); return(entity); } } return(null); }
public static GoodsFlowEntity GetByBarcode(string barcode) { var sql = string.Format("select {0} from goods_flow where barcode = @p_barcode", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_barcode", DbType.String, barcode); GoodsFlowEntity entity = null; using (var reader = db.ExecuteReader(dc)) { while (reader.Read()) { entity = new GoodsFlowEntity(); entity.Init(reader); break; } } return(entity); }