/// <summary>
/// 新增领用信息
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool AddNew(Models.ys_BorrowOrder model)
{
AddDicByOrder(model);
foreach (Models.ys_BorrowOrderDetail d in model.Detail)
{
KeyValuePair <SqlParameter[], string> item = StatusChangeSerivce.AddNew("借用", model.BorrowNo, d.AssetsId, model.OperatorId.ToString(), model.OperatorName, model.BorrowUserId.ToString(), model.BorrowUserName);
sqlDic.Add(item.Key, item.Value);
AddDicByOrderDetail(d);
AddDicByUpdateAssets(d.AssetsId, model.BorrowDepartmentId, model.BorrowUserId, "JY");
}
return(Models.SqlHelper.ExecuteTransaction1(sqlDic, false) > 0 ? true :false);
}
/// <summary>
/// 订单信息
/// </summary>
/// <param name="model">明细实体</param>
private void AddDicByOrder(Models.ys_BorrowOrder model)
{
string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_BorrowOrder]
([Id]
,[BorrowNo]
,[BorrowUserId]
,[BorrowDepartmentId]
,[OperatorId]
,[Borrowday]
,[Planday]
,[Description]
,[IsAudit]
,[CreateTime]
,[IsRemoved])
VALUES
(@Id
,@BorrowNo
,@BorrowUserId
,@BorrowDepartmentId
,@OperatorId
,@Borrowday
,@Planday
,@Description
,@IsAudit
,@CreateTime
,@IsRemoved)";
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@BorrowNo", model.BorrowNo);
SqlParameter s3 = new SqlParameter("@BorrowUserId", model.BorrowUserId);
SqlParameter s4 = new SqlParameter("@BorrowDepartmentId", model.BorrowDepartmentId);
SqlParameter s6 = new SqlParameter("@OperatorId", model.OperatorId);
SqlParameter s8 = new SqlParameter("@Borrowday", model.Borrowday);
SqlParameter s9 = new SqlParameter("@Planday", model.Planday);
SqlParameter s10 = new SqlParameter("@Description", model.Description);
SqlParameter s11 = new SqlParameter("@IsAudit", model.IsAudit);
SqlParameter s12 = new SqlParameter("@CreateTime", model.CreateTime);
SqlParameter s13 = new SqlParameter("@IsRemoved", model.IsRemoved);
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4, s6, s8, s9, s10, s11, s12, s13 };
sqlDic.Add(cmdPara, sqlText);
}
/// <summary>
/// 新增领用信息
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool AddNew(Models.ys_BorrowOrder model)
{
return(sev.AddNew(model));
}
