/// <summary>
/// 保存领用单信息
/// </summary>
private void sbtnSave_Click(object sender, EventArgs e)
{
//检查用户输入是否合法、部门、人员、资产信息
if (cbUser.EditValue != null && selectList.Count > 0)
{
model.Id = Guid.NewGuid();
model.RefundNo = manager.GetNewRefundNo();
model.RefundUserId = clsPublic.GetObjGUID(cbUser.EditValue);
model.RefundUserName = cbUser.Text;
model.OperatorId = clsSession._UserId;
model.OperatorName = clsSession._FullName;
model.Description = tDescription.Text;
model.Refundday = tApplyday.DateTime;
model.Detail = new List <Models.ys_RefundOrderDetail>();
//循环获取资产数据集
foreach (Models.ys_Assets m in selectList)
{
Models.ys_RefundOrderDetail d = new Models.ys_RefundOrderDetail();
d.AssetsId = m.Id;
d.RefundId = model.Id;
d.OldDepartmentId = m.DepartmentId;
d.OldDepartmentName = m.DepartmentName;
d.OldLocation = m.Location;
d.OldStatusId = m.StatusId;
d.OldStatusName = m.StatusName;
d.OldUserId = m.UserId;
d.OldUserName = m.UserName;
d.Id = Guid.NewGuid();
model.Detail.Add(d);
}
//生成新的领用单
if (manager.AddNew(model))
{
clsPublic.ShowMessage("保存成功！", Text);
base.DialogResult = DialogResult.OK;
}
else
{
clsPublic.ShowMessage("保存失败！", Text);
}
}
else
{
clsPublic.ShowMessage("申请人员、或退库的资产信息不能为空！", Text);
}
}
/// <summary>
/// 订单明细信息
/// </summary>
/// <param name="model">明细实体</param>
public void AddDicByOrderDetail(Models.ys_RefundOrderDetail model)
{
string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_RefundOrderDetail]
([Id]
,[AssetsId]
,[RefundId]
,[OldUserName]
,[OldUserId]
,[OldDepartmentName]
,[OldDepartmentId]
,[OldLocation]
,[OldStatusId]
,[IsRemoved]
,[CreateTime])
VALUES
(@Id
,@AssetsId
,@RefundId
,@OldUserName
,@OldUserId
,@OldDepartmentName
,@OldDepartmentId
,@OldLocation
,@OldStatusId
,@IsRemoved
,@CreateTime)";
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@AssetsId", model.AssetsId);
SqlParameter s3 = new SqlParameter("@RefundId", model.RefundId);
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 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, s10, s11 };
sqlDic.Add(cmdPara, sqlText);
}
