/// <summary> /// 保存领用单信息 /// </summary> private void sbtnSave_Click(object sender, EventArgs e) { //检查用户输入是否合法、部门、人员、资产信息 if (cbUser.EditValue != null && selectList.Count > 0) { model.Id = Guid.NewGuid(); model.RefundNo = manager.GetNewRefundNo(); model.RefundUserId = clsPublic.GetObjGUID(cbUser.EditValue); model.RefundUserName = cbUser.Text; model.OperatorId = clsSession._UserId; model.OperatorName = clsSession._FullName; model.Description = tDescription.Text; model.Refundday = tApplyday.DateTime; model.Detail = new List <Models.ys_RefundOrderDetail>(); //循环获取资产数据集 foreach (Models.ys_Assets m in selectList) { Models.ys_RefundOrderDetail d = new Models.ys_RefundOrderDetail(); d.AssetsId = m.Id; d.RefundId = model.Id; d.OldDepartmentId = m.DepartmentId; d.OldDepartmentName = m.DepartmentName; d.OldLocation = m.Location; d.OldStatusId = m.StatusId; d.OldStatusName = m.StatusName; d.OldUserId = m.UserId; d.OldUserName = m.UserName; d.Id = Guid.NewGuid(); model.Detail.Add(d); } //生成新的领用单 if (manager.AddNew(model)) { clsPublic.ShowMessage("保存成功!", Text); base.DialogResult = DialogResult.OK; } else { clsPublic.ShowMessage("保存失败!", Text); } } else { clsPublic.ShowMessage("申请人员、或退库的资产信息不能为空!", Text); } }
/// <summary> /// 订单明细信息 /// </summary> /// <param name="model">明细实体</param> public void AddDicByOrderDetail(Models.ys_RefundOrderDetail model) { string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_RefundOrderDetail] ([Id] ,[AssetsId] ,[RefundId] ,[OldUserName] ,[OldUserId] ,[OldDepartmentName] ,[OldDepartmentId] ,[OldLocation] ,[OldStatusId] ,[IsRemoved] ,[CreateTime]) VALUES (@Id ,@AssetsId ,@RefundId ,@OldUserName ,@OldUserId ,@OldDepartmentName ,@OldDepartmentId ,@OldLocation ,@OldStatusId ,@IsRemoved ,@CreateTime)"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@AssetsId", model.AssetsId); SqlParameter s3 = new SqlParameter("@RefundId", model.RefundId); SqlParameter s4 = new SqlParameter("@OldUserName", model.OldUserName); SqlParameter s5 = new SqlParameter("@OldUserId", model.OldUserId); SqlParameter s6 = new SqlParameter("@OldDepartmentName", model.OldDepartmentName); SqlParameter s7 = new SqlParameter("@OldDepartmentId", model.OldDepartmentId); SqlParameter s8 = new SqlParameter("@OldLocation", model.OldLocation); SqlParameter s9 = new SqlParameter("@OldStatusId", model.OldStatusId); SqlParameter s10 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter s11 = new SqlParameter("@CreateTime", model.CreateTime); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11 }; sqlDic.Add(cmdPara, sqlText); }