/// <summary>
/// 保存领用单信息
/// </summary>
private void sbtnSave_Click(object sender, EventArgs e)
{
//检查用户输入是否合法、部门、人员、资产信息
if (cbUser.EditValue != null && selectList.Count > 0)
{
model.Id = Guid.NewGuid();
model.ReturnNo = manager.GetNewRefundNo();
model.ReturnUserId = clsPublic.GetObjGUID(cbUser.EditValue);
model.ReturnUserName = cbUser.Text;
model.OperatorName = clsSession._FullName;
model.OperatorId = clsSession._UserId;
model.Description = tDescription.Text;
model.Returnday = tApplyday.DateTime;
model.Detail = new List <Models.ys_ReturnOrderDetail>();
//循环获取资产数据集
foreach (Models.ys_Assets m in selectList)
{
Models.ys_ReturnOrderDetail d = new Models.ys_ReturnOrderDetail();
d.AssetsId = m.Id;
d.ReturnId = model.Id;
d.OldDepartmentId = m.DepartmentId;
d.OldDepartmentName = m.DepartmentName;
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_ReturnOrderDetail model)
{
string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_ReturnOrderDetail]
([Id]
,[ReturnId]
,[AssetsId]
,[OldUserId]
,[OldUserName]
,[OldDepartmentId]
,[OldDepartmentName]
,[OldStatusName]
,[OldStatusId]
,[IsRemoved]
,[CreateTime])
VALUES(@Id
,@ReturnId
,@AssetsId
,@OldUserId
,@OldUserName
,@OldDepartmentId
,@OldDepartmentName
,@OldStatusName
,@OldStatusId
,@IsRemoved
,@CreateTime)";
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@ReturnId", model.ReturnId);
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 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, s9, s12, s10, s11 };
sqlDic.Add(cmdPara, sqlText);
}
