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));
}
