/// <summary> /// 新增盘点机明细 /// </summary> /// <param name="model">资产明细</param> /// <returns></returns> public bool AddNewDetail(Models.ys_CheckOrderDeail model) { string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_CheckOrderDetail] ([Id] ,[CheckId] ,[AssetsId] ,[OldStatusId] ,[CreateTime] ,[IsRemoved]) VALUES (@Id ,@CheckId ,@AssetsId ,@OldStatusId ,@CreateTime ,@IsRemoved)"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@CheckId", model.CheckId); SqlParameter s3 = new SqlParameter("@AssetsId", model.AssetsId); SqlParameter s4 = new SqlParameter("@OldStatusId", model.OldStatusId); SqlParameter s5 = new SqlParameter("@CreateTime", model.CreateTime); SqlParameter s6 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s5, s6 }; return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdPara) > 0 ? true : false); }
/// <summary> /// 盘点审核 /// </summary> private void btnApprove_Click(object sender, System.EventArgs e) { _model.OperatorId = clsSession._UserId; _model.IsAuditday = DateTime.Now; _model.IsAudit = true; _model.OperatorName = clsSession._FullName; string msg = string.Format("本次盘点资产{0}件,已盘{1}件,盘差{2}件 --- 是否审核?", dtAll.Rows.Count, dtAll.Select("IsSelect=true").Length, dtAll.Select("IsSelect=false").Length); if (clsPublic.GetMessageBoxYesNoResult(msg, Text)) { List <Models.ys_CheckOrderDeail> list = new List <Models.ys_CheckOrderDeail>(); DataTable Dt = dtAll.Copy(); Dt.DefaultView.RowFilter = "IsSelect=False"; DataTable newdt = Dt.DefaultView.ToTable(); foreach (DataRow r in newdt.Rows) { Models.ys_CheckOrderDeail d = new Models.ys_CheckOrderDeail(); d.AssetsId = (System.Guid)r["AssetsId"]; d.CheckId = (System.Guid)r["CheckId"]; list.Add(d); } _model.Details = list; if (manager.Approve(_model)) { MessageBox.Show("成功"); dtAll.AcceptChanges(); base.DialogResult = DialogResult.OK; } else { MessageBox.Show("失败"); } } }
/// <summary> /// 删除盘点单明细 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool DeleteDetail(Models.ys_CheckOrderDeail model) { string sqlText = @"DELETE FROM [AssetsSys].[dbo].[ys_CheckOrderDetail] WHERE [CheckId]=@CheckId and [AssetsId]=@AssetsId "; SqlParameter s1 = new SqlParameter("@CheckId", model.CheckId); SqlParameter s2 = new SqlParameter("@AssetsId", model.AssetsId); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2 }; return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdPara) > 0 ? true : false); }
/// <summary> /// 更新资产信息 /// </summary> /// <param name="assetsId">资产Id</param> private void UnAddDicByUpdateAssets(Models.ys_CheckOrderDeail model) { string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_Assets] SET [StatusId] = @StatusId,[IsRemoved]=@IsRemoved WHERE [Id] = @Id"; SqlParameter s1 = new SqlParameter("@Id", model.AssetsId); SqlParameter s2 = new SqlParameter("@StatusId", model.OldStatusId); SqlParameter s3 = new SqlParameter("@IsRemoved", false); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3 }; UnsqlDic.Add(cmdPara, sqlText); }
/// <summary> /// 盘点反审核 /// </summary> public override void UnApprove() { if (gvData.FocusedRowHandle >= 0) { Guid Id = (Guid)gvData.GetFocusedRowCellValue("Id"); Models.ys_CheckOrder _model = allList.FirstOrDefault(a => a.Id == Id); if (_model != null) { if (!model.IsAudit) { MessageBox.Show("盘点单未审核不能反审核"); return; } DataTable Dt = manager.GetAllTable(_model.Id); _model.OperatorId = clsSession._UserId; _model.OperatorName = clsSession._FullName; string msg = string.Format("本次盘点资产{0}件,已盘{1}件,盘差{2}件 --- 是否反审核?", Dt.Rows.Count, Dt.Select("IsSelect=true").Length, Dt.Select("IsSelect=false").Length); if (clsPublic.GetMessageBoxYesNoResult(msg, Text)) { List <Models.ys_CheckOrderDeail> list = new List <Models.ys_CheckOrderDeail>(); Dt.DefaultView.RowFilter = "IsSelect=False"; DataTable newdt = Dt.DefaultView.ToTable(); foreach (DataRow r in newdt.Rows) { Models.ys_CheckOrderDeail d = new Models.ys_CheckOrderDeail(); d.AssetsId = (System.Guid)r["AssetsId"]; d.OldStatusId = r["OldStatusId"].ToString(); d.CheckId = (System.Guid)r["CheckId"]; list.Add(d); } _model.Details = list; if (manager.UnApprove(_model)) { MessageBox.Show("成功"); } else { MessageBox.Show("失败"); } } } } }
/// <summary> /// 删除盘点单明细 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool DeleteDetail(Models.ys_CheckOrderDeail model) { return(sev.DeleteDetail(model)); }
/// <summary> /// 新增盘点机明细 /// </summary> /// <param name="model">资产明细</param> /// <returns></returns> public bool AddNewDetail(Models.ys_CheckOrderDeail model) { return(sev.AddNewDetail(model)); }