/// <summary>
/// 保存领用单信息
/// </summary>
private void sbtnSave_Click(object sender, EventArgs e)
{
//检查用户输入是否合法、部门、人员、资产信息
if ((cbtlDepartment.EditValue != null || cbUser.EditValue != null) && selectList.Count > 0)
{
model.Id = Guid.NewGuid();
model.AllotNo = manager.GetNewAllotNo();
model.Location = tlocation.Text;
model.AllotUserId = clsPublic.GetObjGUID(cbUser.EditValue);
model.AllotUserName = cbUser.Text;
if (cbtlDepartment.EditValue == null)
{
model.AllotDepartmentId = clsPublic.GetObjGUID(cbUser.Properties.View.GetFocusedRowCellValue("DepartmentId"));
}
else
{
model.AllotDepartmentId = clsPublic.GetObjGUID(cbtlDepartment.EditValue);
}
model.OperatorId = clsSession._UserId;
model.OperatorName = clsSession._FullName;
model.Description = tDescription.Text;
model.Allotday = tApplyday.DateTime;
model.Detail = new List <Models.ys_AllotOrderDetail>();
//循环获取资产数据集
foreach (Models.ys_Assets m in selectList)
{
Models.ys_AllotOrderDetail d = new Models.ys_AllotOrderDetail();
d.AssetsId = m.Id;
d.AllotId = model.Id;
d.OldDepartmentId = m.DepartmentId;
d.OldDepartmentName = m.DepartmentName;
d.OldUserId = m.UserId;
d.OldUserName = m.UserName;
d.OldLocation = m.Location;
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_AllotOrderDetail model)
{
string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_AllotOrderDetail]
([Id]
,[AllotId]
,[AssetsId]
,[OldUserName]
,[OldUserId]
,[OldDepartmentName]
,[OldDepartmentId]
,[OldLocation]
,[CreateTime]
,[IsRemoved])
VALUES
(@Id
,@AllotId
,@AssetsId
,@OldUserName
,@OldUserId
,@OldDepartmentName
,@OldDepartmentId
,@OldLocation
,@CreateTime
,@IsRemoved)";
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@AllotId", model.AllotId);
SqlParameter s3 = new SqlParameter("@AssetsId", model.AssetsId);
SqlParameter s4 = new SqlParameter("@OldUserName", model.OldUserName == null?"":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("@IsRemoved", model.IsRemoved);
SqlParameter s10 = new SqlParameter("@CreateTime", model.CreateTime);
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s5, s6, s7, s8, s9, s10 };
sqlDic.Add(cmdPara, sqlText);
}
