/// <summary>
/// 新增领用信息
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool AddNew(Models.ys_ReturnOrder model)
{
AddDicByOrder(model);
foreach (Models.ys_ReturnOrderDetail d in model.Detail)
{
KeyValuePair <SqlParameter[], string> item = StatusChangeSerivce.AddNew("归还", model.ReturnNo, d.AssetsId, model.OperatorId.ToString(), model.OperatorName, model.ReturnUserId.ToString(), model.ReturnUserName);
sqlDic.Add(item.Key, item.Value);
AddDicByOrderDetail(d);
AddDicByUpdateAssets(d.AssetsId);
}
return(Models.SqlHelper.ExecuteTransaction1(sqlDic, false) > 0 ? true :false);
}
/// <summary>
/// 订单信息
/// </summary>
/// <param name="model">明细实体</param>
private void AddDicByOrder(Models.ys_ReturnOrder model)
{
string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_ReturnOrder]
([Id]
,[ReturnNo]
,[ReturnUserId]
,[ReturnDepartmentId]
,[OperatorId]
,[Returnday]
,[Description]
,[IsAudit]
,[IsRemoved]
,[CreateTime])
VALUES(@Id
,@ReturnNo
,@ReturnUserId
,@ReturnDepartmentId
,@OperatorId
,@Returnday
,@Description
,@IsAudit
,@IsRemoved
,@CreateTime)";
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@ReturnNo", model.ReturnNo);
SqlParameter s3 = new SqlParameter("@ReturnUserId", model.ReturnUserId);
SqlParameter s4 = new SqlParameter("@ReturnDepartmentId", model.ReturnDepartmentId);
SqlParameter s6 = new SqlParameter("@OperatorId", model.OperatorId);
SqlParameter s8 = new SqlParameter("@Returnday", model.Returnday);
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, s10, s11, s12, s13 };
sqlDic.Add(cmdPara, sqlText);
}
/// <summary>
/// 新增领用信息
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool AddNew(Models.ys_ReturnOrder model)
{
return(sev.AddNew(model));
}
