/// <summary>
/// 更新资产状态
/// </summary>
/// <param name="model"></param>
public void AddDicByUpdateAssets(Models.ys_ScrapOrder model)
{
if (!model.IsAudit)
{
string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_Assets]
SET [StatusId] = @StatusId
,[IsRemoved]=0
WHERE [Id] = @Id";
SqlParameter s1 = new SqlParameter("@Id", model.AssetsId);
SqlParameter s2 = new SqlParameter("@StatusId", model.OldStatusId);
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2 };
dicCmd.Add(cmdPara, sqlText);
}
else
{
string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_Assets]
SET [StatusId] = @StatusId
,[IsRemoved]=1
WHERE [Id] = @Id";
SqlParameter s1 = new SqlParameter("@Id", model.AssetsId);
SqlParameter s2 = new SqlParameter("@StatusId", "BF");
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2 };
dicCmd.Add(cmdPara, sqlText);
}
}
/// <summary>
/// 新增报废记录
/// </summary>
/// <param name="model"></param>
public void AddDicByRepairOrder(Models.ys_ScrapOrder model)
{
#region sqltext
string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_ScrapOrder]
([Id]
,[ScrapNo]
,[AssetsId]
,[OldStatusId]
,[ScrapUserId]
,[ScrapUserName]
,[Scrapday]
,[OperatorId]
,[OperatorName]
,[ScrapDescription]
,[IsAudit]
,[CreateTime]
,[IsRemoved])
VALUES(@Id
,@ScrapNo
,@AssetsId
,@OldStatusId
,@ScrapUserId
,@ScrapUserName
,@Scrapday
,@OperatorId
,@OperatorName
,@ScrapDescription
,@IsAudit
,@CreateTime
,@IsRemoved)";
#endregion
#region sqlParam
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@ScrapNo", model.ScrapNo);
SqlParameter s3 = new SqlParameter("@AssetsId", model.AssetsId);
SqlParameter s4 = new SqlParameter("@OldStatusId", model.OldStatusId);
SqlParameter s5 = new SqlParameter("@ScrapUserId", model.ScrapUserId);
SqlParameter s6 = new SqlParameter("@ScrapUserName", model.ScrapUserName);
SqlParameter s7 = new SqlParameter("@Scrapday", model.Scrapday);
SqlParameter s8 = new SqlParameter("@OperatorId", model.OperatorId);
SqlParameter s9 = new SqlParameter("@OperatorName", model.OperatorName);
SqlParameter s10 = new SqlParameter("@ScrapDescription", model.ScrapDescription);
SqlParameter s11 = new SqlParameter("@IsAudit", model.IsAudit);
SqlParameter s12 = new SqlParameter("@CreateTime", model.CreateTime);
SqlParameter s13 = new SqlParameter("@IsRemoved", model.IsRemoved);
#endregion
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13 };
dicCmd.Add(cmdPara, sqlText);
}
/// <summary>
/// 保存领用单信息
/// </summary>
private void sbtnSave_Click(object sender, EventArgs e)
{
//检查用户输入是否合法、部门、人员、资产信息
if (StaffID.EditValue != null && selectAssets.Count > 0)
{
List <Models.ys_ScrapOrder> list = new List <Models.ys_ScrapOrder>();
foreach (Models.ys_Assets a in selectAssets)
{
var model = new Models.ys_ScrapOrder();
model.ScrapNo = bll.GetNewScrapNo();//生成订单号
model.ScrapUserId = clsPublic.GetObjGUID(StaffID.EditValue);
model.ScrapUserName = StaffID.Text;
model.OperatorId = clsSession._UserId;
model.OperatorName = clsSession._FullName;
model.ScrapDescription = txt_Desc.Text;
model.Scrapday = bfday.DateTime;
model.IsAudit = true;
model.AssetsId = a.Id;
model.IsRemoved = false;
model.OldStatusId = a.StatusId;
model.CreateTime = DateTime.Now;
list.Add(model);
}
//生成新的领用单
if (bll.AddNew(list))
{
clsPublic.ShowMessage("保存成功！", Text);
base.DialogResult = DialogResult.OK;
}
else
{
clsPublic.ShowMessage("保存失败！", Text);
}
}
else
{
clsPublic.ShowMessage("职员、或清理的资产信息不能为空！", Text);
}
}
/// <summary>
/// 修改指定的报废记录
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public void AddDicModifyByRepairOrder(Models.ys_ScrapOrder model)
{
#region sqltext
string sqlText = @"UPDATE [AssetsSys].[dbo].[ys_ScrapOrder]
SET [ScrapNo] = @ScrapNo
,[AssetsId] = @AssetsId
,[OldStatusId] = @OldStatusId
,[ScrapUserId] = @ScrapUserId
,[ScrapUserName] = @ScrapUserName
,[Scrapday] = @Scrapday
,[OperatorId] = @OperatorId
,[OperatorName] = @OperatorName
,[ScrapDescription] = @SrcapDescription
,[IsAudit] = @IsAudit
,[CreateTime] = @CreateTime
,[IsRemoved] = @IsRemoved
WHERE [Id] = @Id";
#endregion
#region sqlParam
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@ScrapNo", model.ScrapNo);
SqlParameter s3 = new SqlParameter("@AssetsId", model.AssetsId);
SqlParameter s4 = new SqlParameter("@OldStatusId", model.OldStatusId);
SqlParameter s5 = new SqlParameter("@ScrapUserId", model.ScrapUserId);
SqlParameter s6 = new SqlParameter("@ScrapUserName", model.ScrapUserName);
SqlParameter s7 = new SqlParameter("@Scrapday", model.Scrapday);
SqlParameter s8 = new SqlParameter("@OperatorId", model.OperatorId);
SqlParameter s9 = new SqlParameter("@OperatorName", model.OperatorName);
SqlParameter s10 = new SqlParameter("@ScrapDescription", model.ScrapDescription);
SqlParameter s11 = new SqlParameter("@IsAudit", model.IsAudit);
SqlParameter s12 = new SqlParameter("@CreateTime", model.CreateTime);
SqlParameter s13 = new SqlParameter("@IsRemoved", model.IsRemoved);
#endregion
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s13 };
dicCmd.Add(cmdPara, sqlText);
}
/// <summary>
/// 修改指定的维修记录
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool Modify(Models.ys_ScrapOrder model)
{
return(sev.Modify(new List <Models.ys_ScrapOrder> {
model
}));
}