/// <summary> /// 新增领用信息 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool AddNew(Models.ys_BorrowOrder model) { AddDicByOrder(model); foreach (Models.ys_BorrowOrderDetail d in model.Detail) { KeyValuePair <SqlParameter[], string> item = StatusChangeSerivce.AddNew("借用", model.BorrowNo, d.AssetsId, model.OperatorId.ToString(), model.OperatorName, model.BorrowUserId.ToString(), model.BorrowUserName); sqlDic.Add(item.Key, item.Value); AddDicByOrderDetail(d); AddDicByUpdateAssets(d.AssetsId, model.BorrowDepartmentId, model.BorrowUserId, "JY"); } return(Models.SqlHelper.ExecuteTransaction1(sqlDic, false) > 0 ? true :false); }
/// <summary> /// 订单信息 /// </summary> /// <param name="model">明细实体</param> private void AddDicByOrder(Models.ys_BorrowOrder model) { string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_BorrowOrder] ([Id] ,[BorrowNo] ,[BorrowUserId] ,[BorrowDepartmentId] ,[OperatorId] ,[Borrowday] ,[Planday] ,[Description] ,[IsAudit] ,[CreateTime] ,[IsRemoved]) VALUES (@Id ,@BorrowNo ,@BorrowUserId ,@BorrowDepartmentId ,@OperatorId ,@Borrowday ,@Planday ,@Description ,@IsAudit ,@CreateTime ,@IsRemoved)"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@BorrowNo", model.BorrowNo); SqlParameter s3 = new SqlParameter("@BorrowUserId", model.BorrowUserId); SqlParameter s4 = new SqlParameter("@BorrowDepartmentId", model.BorrowDepartmentId); SqlParameter s6 = new SqlParameter("@OperatorId", model.OperatorId); SqlParameter s8 = new SqlParameter("@Borrowday", model.Borrowday); SqlParameter s9 = new SqlParameter("@Planday", model.Planday); SqlParameter s10 = new SqlParameter("@Description", model.Description); SqlParameter s11 = new SqlParameter("@IsAudit", model.IsAudit); SqlParameter s12 = new SqlParameter("@CreateTime", model.CreateTime); SqlParameter s13 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s6, s8, s9, s10, s11, s12, s13 }; sqlDic.Add(cmdPara, sqlText); }
/// <summary> /// 新增领用信息 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool AddNew(Models.ys_BorrowOrder model) { return(sev.AddNew(model)); }