/// <summary>
/// 盘点单审核
/// </summary>
/// <param name="model">盘点单实体</param>
/// <returns></returns>
public bool UnApprove(Models.ys_CheckOrder model)
{
UnAddDicByOrder(model);
foreach (Models.ys_CheckOrderDeail d in model.Details)
{
KeyValuePair <SqlParameter[], string> item = StatusChangeSerivce.AddNew("盘点反审", model.CheckNo, d.AssetsId, model.OperatorId.ToString(), model.OperatorName, model.OperatorId.ToString(), model.OperatorName);
UnsqlDic.Add(item.Key, item.Value);
UnAddDicByUpdateAssets(d);
}
return(Models.SqlHelper.ExecuteTransaction1(UnsqlDic, false) > 0 ? true : false);
}
/// <summary>
/// 新增维修记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddNew(IList <Models.ys_RepairOrder> listModel)
{
foreach (Models.ys_RepairOrder r in listModel)
{
KeyValuePair <SqlParameter[], string> item = StatusChangeSerivce.AddNew("维修", r.RepairNo, r.AssetsId, r.OperatorId.ToString(), r.OperatorName, r.RepairUserId.ToString(), r.RepairUserName);
dicCmd.Add(item.Key, item.Value);
AddDicByRepairOrder(r);
AddDicByUpdateAssets(r);
}
return(Models.SqlHelper.ExecuteTransaction1(dicCmd) > 0 ? true : false);
}
/// <summary>
/// 新增退库信息
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool AddNew(Models.ys_RefundOrder model)
{
AddDicByOrder(model);
foreach (Models.ys_RefundOrderDetail d in model.Detail)
{
KeyValuePair <SqlParameter[], string> item = StatusChangeSerivce.AddNew("退库", model.RefundNo, d.AssetsId, model.OperatorId.ToString(), model.OperatorName, model.RefundUserId.ToString(), model.RefundUserName);
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>
/// <returns></returns>
public bool AddNew(Models.ys_Assets model)
{
Dictionary<SqlParameter[], string> sqlDic = new Dictionary<SqlParameter[], string>();
string sqlText = @"INSERT INTO [AssetsSys].[dbo].[ys_Assets]
([Id]
,[Barcode]
,[Name]
,[Model]
,[CompanyId]
,[CategoryId]
,[DepartmentId]
,[UserId]
,[Buyday]
,[Location]
,[StockId]
,[Price]
,[Description]
,[CreateTime]
,[XmlInf]
,[StatusId]
,[IsRemoved])
VALUES
(@Id
,@Barcode
,@Name
,@Model
,@CompanyId
,@CategoryId
,@DepartmentId
,@UserId
,@Buyday
,@Location
,@StockId
,@Price
,@Description
,@CreateTime
,@XmlInf
,@StatusId
,@IsRemoved)";
SqlParameter s1 = new SqlParameter("@Id", model.Id);
SqlParameter s2 = new SqlParameter("@Barcode", model.Barcode);
SqlParameter s3 = new SqlParameter("@Name", model.Name);
SqlParameter s4 = new SqlParameter("@Model", model.Model);
SqlParameter s5 = new SqlParameter("@CategoryId", model.CategoryId);
SqlParameter s6 = new SqlParameter("@CompanyId", model.CompanyId);
SqlParameter s7 = new SqlParameter("@DepartmentId", model.DepartmentId);
SqlParameter s8 = new SqlParameter("@UserId", model.UserId);
SqlParameter s9 = new SqlParameter("@Buyday", model.Buyday);
SqlParameter s10 = new SqlParameter("@Location", model.Location);
SqlParameter s16 = new SqlParameter("@StockId", model.StockId);
SqlParameter s17 = new SqlParameter("@Price", model.Price);
SqlParameter s11 = new SqlParameter("@Description", model.Description);
SqlParameter s12= new SqlParameter("@CreateTime", model.CreateTime);
SqlParameter s13 = new SqlParameter("@XmlInf", model.XmlInf);
SqlParameter s14 = new SqlParameter("@StatusId", model.StatusId);
SqlParameter s15 = new SqlParameter("@IsRemoved", model.IsRemoved);
SqlParameter[] cmdPara = new SqlParameter[] { s1, s2, s3, s4,s5, s6, s7, s8,s9,s10,s11,s12,s13,s14,s15,s16,s17};
KeyValuePair<SqlParameter[], string> item = StatusChangeSerivce.AddNew("登记", "LK"+DateTime.Now.ToString("yyyyMMdd"), model.Id,model.OperatorId.ToString(),model.OperatorName);
sqlDic.Add(item.Key, item.Value);
sqlDic.Add(cmdPara, sqlText);
return Models.SqlHelper.ExecuteTransaction1(sqlDic,false) > 0 ? true : false;
}