public void InitialRptForm(Models.ys_CheckOrder model) { #region 获取数据 BLL.CheckOrderManager manager = new BLL.CheckOrderManager(); System.Data.DataTable dt = manager.GetAllTable(model.Id); this.DataSource = dt; #endregion #region 订单信息 this.IsAudit.Checked = model.IsAudit; IsAudit.Text = IsAudit.Checked == true ? "已审核" : "未审核"; labCheckday.Text = model.Checkday.ToString(); labCheckNo.Text = model.CheckNo; labDescription.Text = model.Description; labOperator.Text = model.OperatorName; labPrintTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); #endregion #region 订单明细 txtName.DataBindings.Add("Text", null, "Name"); txtBarcode.DataBindings.Add("Text", null, "Barcode"); txtModel.DataBindings.Add("Text", null, "Model"); txtCategory.DataBindings.Add("Text", null, "CategoryName"); txtStatus.DataBindings.Add("Text", null, "StatusName"); txtIsCheck.DataBindings.Add("Text", null, "IsSelect"); txtIsCheckTime.DataBindings.Add("Text", null, "IsCheckTime"); txtCheckUserName.DataBindings.Add("Text", null, "CheckUserName"); #endregion }
/// <summary> /// 盘点单打印 /// </summary> public override void Print() { if (gvData.FocusedRowHandle >= 0) { var CheckNo = gvData.GetFocusedRowCellValue("CheckNo").ToString(); Models.ys_CheckOrder model = allList.FirstOrDefault(a => a.CheckNo == CheckNo); DevReport.rptCheckOrder rpt = new DevReport.rptCheckOrder(model); rpt.ShowPreview(); } }
/// <summary> /// 新增方法 /// </summary> public override void AddNew() { model = new Models.ys_CheckOrder(); this.txtCheckNo.Text = "新单号"; model.Id = Guid.Empty; Checkday.EditValue = DateTime.Now; txtDescription.Text = ""; cIsAudit.Checked = false; Checkday.ReadOnly = false; }
/// <summary> /// 盘点单审核 /// </summary> /// <param name="model">盘点单实体</param> /// <returns></returns> public bool UnApprove(Models.ys_CheckOrder model) { UnAddDicByOrder(model); foreach (Models.ys_CheckOrderDeail d in model.Details) { KeyValuePair <SqlParameter[], string> item = StatusChangeSerivce.AddNew("盘点反审", model.CheckNo, d.AssetsId, model.OperatorId.ToString(), model.OperatorName, model.OperatorId.ToString(), model.OperatorName); UnsqlDic.Add(item.Key, item.Value); UnAddDicByUpdateAssets(d); } return(Models.SqlHelper.ExecuteTransaction1(UnsqlDic, false) > 0 ? true : false); }
/// <summary> /// 是否有存在未审核的盘点单 /// </summary> /// <returns></returns> public bool IsExistsUnAuditCheckNo() { Models.ys_CheckOrder model = sev.GetAllList().FirstOrDefault(a => a.IsRemoved == false && a.IsAudit == false); if (model != null) { return(true); } else { return(false); } }
/// <summary> /// 新增盘点单 /// </summary> /// <param name="model">盘点单实体</param> /// <returns></returns> public bool AddNew(Models.ys_CheckOrder model) { Dictionary <string, SqlParameter[]> dic = new Dictionary <string, SqlParameter[]>(); #region 订单 string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_CheckOrder] ([Id] ,[CheckNo] ,[Checkday] ,[Description] ,[OperatorId] ,[OperatorName] ,[IsAudit] ,[IsRemoved] ,[CreateTime]) VALUES (@Id ,@CheckNo ,@Checkday ,@Description ,@OperatorId ,@OperatorName ,@IsAudit ,@IsRemoved ,@CreateTime)"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@CheckNo", model.CheckNo); SqlParameter s3 = new SqlParameter("@Description", model.Description); SqlParameter s4 = new SqlParameter("@OperatorId", model.OperatorId); SqlParameter s6 = new SqlParameter("@OperatorName", model.OperatorName); SqlParameter s8 = new SqlParameter("@IsAudit", model.IsAudit); SqlParameter s9 = new SqlParameter("@CreateTime", model.CreateTime); SqlParameter s10 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter s11 = new SqlParameter("@Checkday", model.Checkday); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s6, s8, s9, s10, s11 }; #endregion #region 明细 string sqlText1 = @"INSERT INTO ys_CheckOrderDetail(CheckId,AssetsId,OldStatusId) SELECT @checkId,Id,StatusId FROM ys_Assets WHERE IsRemoved=0"; SqlParameter s0 = new SqlParameter("@checkId", model.Id); SqlParameter[] cmdPara1 = new SqlParameter[] { s0 }; #endregion dic.Add(sqlText, cmdPara); dic.Add(sqlText1, cmdPara1); return(Models.SqlHelper.ExecuteTransaction(dic) > 0 ? true : false); }
/// <summary> /// 盘点审核 /// </summary> public override void Approve() { if (gvData.FocusedRowHandle >= 0) { Guid Id = (Guid)gvData.GetFocusedRowCellValue("Id"); model = allList.FirstOrDefault(a => a.Id == Id); if (model != null) { if (model.IsAudit) { MessageBox.Show("盘点单已审核不能更改"); return; } AssetsCheckApproveForm sub = new AssetsCheckApproveForm(model); sub.ShowDialog(); } } }
/// <summary> /// 选择行改变事件 /// </summary> private void gvData_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { if (e.RowHandle >= 0) { Guid Id = (Guid)gvData.GetFocusedRowCellValue("Id"); model = allList.FirstOrDefault(a => a.Id == Id); if (model != null) { txtCheckNo.Text = model.CheckNo; Checkday.EditValue = model.Checkday; txtOperatorName.Text = model.OperatorName; txtDescription.Text = model.Description; cIsAudit.Checked = model.IsAudit; Checkday.ReadOnly = true; } } }
/// <summary> /// 修改盘点单 /// </summary> /// <param name="checkId">单号Id</param> public AssetsCheckEditForm(Guid checkId) : this() { model = manager.GetOneByCheckId(checkId); if (model != null) { txtCheckNo.Text = model.CheckNo; Checkday.EditValue = model.Checkday; txtOperatorName.Text = model.OperatorName; txtDescription.Text = model.Description; cIsAudit.Checked = model.IsAudit; gcData.DataSource = dtAll = manager.GetAllTable(checkId); if (model.IsAudit) { gvData.OptionsBehavior.Editable = false; } } }
/// <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 Modify(Models.ys_CheckOrder model) { SqlParameter[] Param = new SqlParameter[] { new SqlParameter("@Id", model.Id), new SqlParameter("@Description", model.Description), new SqlParameter("@OperatorId", model.OperatorId), new SqlParameter("@OperatorName", model.OperatorName), new SqlParameter("@IsRemoved", model.IsRemoved), new SqlParameter("@Checkday", model.Checkday) }; return(Models.SqlHelper.ExecuteNoQuery(@"UPDATE [AssetsSys].[dbo].[ys_CheckOrder] SET [Description] = @Description ,[OperatorId] = @OperatorId ,[OperatorName] = @OperatorName ,[IsRemoved] = @IsRemoved ,[Checkday] = @Checkday WHERE [Id] = @Id", Param) > 0 ? true : false); }
// /// <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); // } #endregion /// <summary> /// 订单信息 /// </summary> /// <param name="model">明细实体</param> private void UnAddDicByOrder(Models.ys_CheckOrder model) { string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_CheckOrder] SET [Description] = @Description ,[OperatorId] = @OperatorId ,[OperatorName] = @OperatorName ,[IsAuditday] = @IsAuditday ,[IsAudit] = @IsAudit WHERE [Id] = @Id"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@Description", model.Description); SqlParameter s3 = new SqlParameter("@OperatorId", model.OperatorId); SqlParameter s4 = new SqlParameter("@OperatorName", model.OperatorName); SqlParameter s5 = new SqlParameter("@IsAuditday", "2020-01-01"); SqlParameter s6 = new SqlParameter("@IsAudit", false); SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s5, s6 }; UnsqlDic.Add(cmdPara, sqlText); }
/// <summary> /// 新增盘点单 /// </summary> /// <param name="model">盘点单实体</param> /// <returns></returns> public bool AddNew(Models.ys_CheckOrder model) { return(sev.AddNew(model)); }
public rptCheckOrder(Models.ys_CheckOrder model) { InitializeComponent(); InitialRptForm(model); }
/// <summary> /// 订单修改 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool Modify(Models.ys_CheckOrder model) { return(sev.Modify(model)); }
public AssetsCheckApproveForm(Models.ys_CheckOrder model) { InitializeComponent(); _model = model; Query(); }
/// <summary> /// 盘点单反审核 /// </summary> /// <param name="model">盘点单实体</param> /// <returns></returns> public bool UnApprove(Models.ys_CheckOrder model) { return(sev.Approve(model)); }