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