/// <summary> /// 更新资产信息 /// </summary> /// <param name="assetsId">资产Id</param> public void AddDicByUpdateAssets(Guid assetsId) { Models.ys_BorrowOrderDetail mlast = GetLastOneByAssetsId(assetsId); string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_Assets] SET [DepartmentId] = @DepartmentId ,[UserId] = @UserId ,[StatusId] = @StatusId WHERE [Id] = @Id"; if (mlast != null) { SqlParameter s1 = new SqlParameter("@Id", assetsId); SqlParameter s2 = new SqlParameter("@DepartmentId", mlast.OldDepartmentId); SqlParameter s3 = new SqlParameter("@UserId", mlast.OldUserId); SqlParameter s5 = new SqlParameter("@StatusId", mlast.OldStatusId); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s5 }; sqlDic.Add(cmdPara, sqlText); } else { throw new Exception("没有找到资产ID为:" + assetsId + " 借用记录"); } }
/// <summary> /// 保存领用单信息 /// </summary> private void sbtnSave_Click(object sender, EventArgs e) { //检查用户输入是否合法、部门、人员、资产信息 if (cbUser.EditValue != null && selectList.Count > 0) { model.Id = Guid.NewGuid(); model.BorrowNo = manager.GetNewBorrowNo(); model.BorrowUserId = clsPublic.GetObjGUID(cbUser.EditValue); model.BorrowUserName = cbUser.Text; model.BorrowDepartmentId = userList.FirstOrDefault(a => a.Id == model.BorrowUserId).DepartmentId; model.OperatorId = clsSession._UserId; model.OperatorName = clsSession._FullName; model.Description = tDescription.Text; model.Borrowday = tBorrowday.DateTime; model.Planday = tPlenday.DateTime; model.Detail = new List <Models.ys_BorrowOrderDetail>(); //循环获取资产数据集 foreach (Models.ys_Assets m in selectList) { Models.ys_BorrowOrderDetail d = new Models.ys_BorrowOrderDetail(); d.AssetsId = m.Id; d.BorrowId = model.Id; d.OldDepartmentId = m.DepartmentId; d.OldDepartmentName = m.DepartmentName == null?"":m.DepartmentName; d.OldLocation = m.Location; d.OldStatusId = m.StatusId; d.OldStatusName = m.StatusName; d.OldUserId = m.UserId; d.OldUserName = m.UserName == null ? "" : 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_BorrowOrderDetail model) { string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_BorrowOrderDetail] ([Id] ,[BorrowId] ,[AssetsId] ,[OldUserName] ,[OldUserId] ,[OldDepartmentName] ,[OldDepartmentId] ,[OldLocation] ,[OldStatusId] ,[OldStatusName] ,[CreateTime] ,[IsRemoved]) VALUES (@Id ,@BorrowId ,@AssetsId ,@OldUserName ,@OldUserId ,@OldDepartmentName ,@OldDepartmentId ,@OldLocation ,@OldStatusId ,@OldStatusName ,@CreateTime ,@IsRemoved)"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@BorrowId", model.BorrowId); SqlParameter s3 = new SqlParameter("@AssetsId", model.AssetsId); 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 s12 = new SqlParameter("@OldStatusName", model.OldStatusName); 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, s12, s10, s11 }; sqlDic.Add(cmdPara, sqlText); }