/// <summary> /// 更新采购单 /// </summary> /// <param name="category"></param> /// <returns></returns> public int UpdateProductBill(ProductBillInfo productBill, bool changebody, SqlTransaction trans) { string sql = @"UPDATE [ProductBillHead] SET [BuyNO] = @BuyNO ,[BatchNO] = @BatchNO ,[BuyDate] = @BuyDate ,[SupplyID] = @SupplyID ,[IsReview] = @IsReview ,[ReviewUser] = @ReviewUser ,[WareHouseID] = @WareHouseID ,[Detail] = @Detail ,[Define1] = @Define1 ,[Define2] = @Define2 ,[Define3] = @Define3 ,[UpdateDateTime] = @UpdateDateTime ,[UpdateUser] = @UpdateUser WHERE id=@id"; SqlParameter[] spvalues = DBTool.GetSqlPm(productBill); int res = SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sql, spvalues); if (changebody) { DeleteDetail(productBill.id, trans); foreach (ProductBillBody ckb in productBill.BillDetail) { InsertDetail(ckb, trans); } } return(res); }
public virtual OperationResult Create(ProductBillInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { ProductBill entity = new ProductBill(); DESwap.ProductBillDTE(info, entity); ProductBillRpt.Insert(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
/// <summary> /// 增加采购单 /// </summary> /// <param name="changeStock"></param> /// <param name="conn"></param> /// <returns></returns> public int InsertProductBill(ProductBillInfo productBill, SqlTransaction trans) { Guid g = Guid.NewGuid(); productBill.id = g; string sql = @"INSERT INTO [ProductBillHead] ([id] ,[BuyNO] ,[BatchNO] ,[BuyDate] ,[SupplyID] ,[IsReview] ,[ReviewUser] ,[WareHouseID] ,[Detail] ,[Define1] ,[Define2] ,[Define3] ,[InsertDateTime] ,[InsertUser]) VALUES (@id ,@BuyNO ,@BatchNO ,@BuyDate ,@SupplyID ,@IsReview ,@ReviewUser ,@WareHouseID ,@Detail ,@Define1 ,@Define2 ,@Define3 ,@InsertDateTime ,@InsertUser)"; SqlParameter[] spvalues = DBTool.GetSqlPm(productBill); int res = SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sql, spvalues); foreach (ProductBillBody ckb in productBill.BillDetail) { ckb.HeadId = g; InsertDetail(ckb, trans); } return(res); }
public int InsertProductBill(ProductBillInfo productBill) { SqlConnection conn; int count = 0; using (conn = SqlHelper.CreateConntion()) { conn.Open(); SqlTransaction trans = conn.BeginTransaction(); try { count = DAL.InsertProductBill(productBill, trans); trans.Commit(); } catch (Exception) { trans.Rollback(); } conn.Close(); } return(count); }
public static void ProductBillETD(ProductBill entity, ProductBillInfo info) { info.Id = entity.Id; info._IdIsDirty = 0; info.BillType = entity.BillType; info._BillTypeIsDirty = 0; info.BillClassId = entity.BillClassId; info._BillClassIdIsDirty = 0; info.BillClassName = entity.BillClassName; info._BillClassNameIsDirty = 0; info.RefId = entity.RefId; info._RefIdIsDirty = 0; info.RefType = entity.RefType; info._RefTypeIsDirty = 0; info.RefNO = entity.RefNO; info._RefNOIsDirty = 0; info.WareHouseId = entity.WareHouseId; info._WareHouseIdIsDirty = 0; info.BillNO = entity.BillNO; info._BillNOIsDirty = 0; info.FormDate = entity.FormDate; info._FormDateIsDirty = 0; info.NeedCompanyId = entity.NeedCompanyId; info._NeedCompanyIdIsDirty = 0; info.NeedCompanyName = entity.NeedCompanyName; info._NeedCompanyNameIsDirty = 0; info.NeedDepartmentId = entity.NeedDepartmentId; info._NeedDepartmentIdIsDirty = 0; info.NeedDepartmentName = entity.NeedDepartmentName; info._NeedDepartmentNameIsDirty = 0; info.NeedStationId = entity.NeedStationId; info._NeedStationIdIsDirty = 0; info.NeedStationName = entity.NeedStationName; info._NeedStationNameIsDirty = 0; info.NeedStaffId = entity.NeedStaffId; info._NeedStaffIdIsDirty = 0; info.NeedStaffName = entity.NeedStaffName; info._NeedStaffNameIsDirty = 0; info.HandleStationId = entity.HandleStationId; info._HandleStationIdIsDirty = 0; info.HandleStationName = entity.HandleStationName; info._HandleStationNameIsDirty = 0; info.HandleStaffId = entity.HandleStaffId; info._HandleStaffIdIsDirty = 0; info.HandleStaffName = entity.HandleStaffName; info._HandleStaffNameIsDirty = 0; info.Status = entity.Status; info._StatusIsDirty = 0; info.Note = entity.Note; info._NoteIsDirty = 0; info.SYS_OrderSeq = entity.SYS_OrderSeq; info._SYS_OrderSeqIsDirty = 0; info.SYS_IsValid = entity.SYS_IsValid; info._SYS_IsValidIsDirty = 0; info.SYS_IsDeleted = entity.SYS_IsDeleted; info._SYS_IsDeletedIsDirty = 0; info.SYS_Remark = entity.SYS_Remark; info._SYS_RemarkIsDirty = 0; info.SYS_StaffId = entity.SYS_StaffId; info._SYS_StaffIdIsDirty = 0; info.SYS_StationId = entity.SYS_StationId; info._SYS_StationIdIsDirty = 0; info.SYS_DepartmentId = entity.SYS_DepartmentId; info._SYS_DepartmentIdIsDirty = 0; info.SYS_CompanyId = entity.SYS_CompanyId; info._SYS_CompanyIdIsDirty = 0; info.SYS_AppId = entity.SYS_AppId; info._SYS_AppIdIsDirty = 0; info.SYS_CreateTime = entity.SYS_CreateTime; info._SYS_CreateTimeIsDirty = 0; info.SYS_ModifyTime = entity.SYS_ModifyTime; info._SYS_ModifyTimeIsDirty = 0; info.SYS_DeleteTime = entity.SYS_DeleteTime; info._SYS_DeleteTimeIsDirty = 0; }
public virtual List<ProductBillInfo> ListAllByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection) { List<ProductBill> list = null; using (var DbContext = new MRPDbContext()) { var query = from i in DbContext.ProductBill select i; #region 条件 foreach (string key in searchCondtionCollection) { string condition = searchCondtionCollection[key]; switch (key.ToLower()) { case "isvalid": int value = Convert.ToInt32(condition); query = query.Where(x => x.SYS_IsValid.Equals(value)); break; default: break; } } #endregion #region 排序 foreach (string sort in sortCollection) { string direct = string.Empty; switch (sort.ToLower()) { case "createtime": if (direct.ToLower().Equals("asc")) { query = query.OrderBy(x => new { x.SYS_CreateTime }); } else { query = query.OrderByDescending(x => new { x.SYS_CreateTime }); } break; default: query = query.OrderByDescending(x => new { x.SYS_OrderSeq }); break; } } list = query.ToList(); } #endregion #region linq to entity List<ProductBillInfo> ilist = new List<ProductBillInfo>(); list.ForEach(x => { ProductBillInfo info = new ProductBillInfo(); DESwap.ProductBillETD(x, info); ilist.Add(info); }); #endregion return ilist;; }
public virtual ProductBillInfo Load(string key) { ProductBillInfo info = new ProductBillInfo(); using (var DbContext = new MRPDbContext()) { ProductBill entity = ProductBillRpt.Get(DbContext, key); DESwap.ProductBillETD(entity,info); } return info; }