/// <summary>
/// 新增调拔信息
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool AddNew(Models.ys_AllotOrder model)
{
AddDicByOrder(model);
foreach (Models.ys_AllotOrderDetail d in model.Detail)
{
KeyValuePair <SqlParameter[], string> item = StatusChangeSerivce.AddNew("调拨", model.AllotNo, d.AssetsId, model.OperatorId.ToString(), model.OperatorName, model.AllotUserId.ToString(), model.AllotUserName);
sqlDic.Add(item.Key, item.Value);
AddDicByOrderDetail(d);
AddDicByUpdateAssets(d.AssetsId, model.AllotDepartmentId, model.AllotUserId, model.Location);
}
return(Models.SqlHelper.ExecuteTransaction1(sqlDic, false) > 0 ? true :false);
}
/// <summary>
/// 订单信息
/// </summary>
/// <param name="model">明细实体</param>
private void AddDicByOrder(Models.ys_AllotOrder model)
{
string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_AllotOrder]
([Id]
,[AllotNo]
,[AllotUserId]
,[AllotDepartmentId]
,[OperatorId]
,[Allotday]
,[Location]
,[Description]
,[IsAudit]
,[CreateTime]
,[IsRemoved])
VALUES
(@Id
,@AllotNo
,@AllotUserId
,@AllotDepartmentId
,@OperatorId
,@Allotday
,@Location
,@Description
,@IsAudit
,@CreateTime
,@IsRemoved)";
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@AllotNo", model.AllotNo);
SqlParameter s3 = new SqlParameter("@AllotUserId", model.AllotUserId);
SqlParameter s4 = new SqlParameter("@AllotDepartmentId", model.AllotDepartmentId);
SqlParameter s6 = new SqlParameter("@OperatorId", model.OperatorId);
SqlParameter s8 = new SqlParameter("@Allotday", model.Allotday);
SqlParameter s9 = new SqlParameter("@Location", model.Location);
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_AllotOrder model)
{
return(sev.AddNew(model));
}
