/// <summary>
/// 添加其他入库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public override int AddOtherOutOfStorage(OtherOutOfStorage model)
{
int sysNo = 0;
using (var context = Context.UseTransaction(true))
{
try
{
sysNo = Context.Insert("OtherOutOfStorage", model).AutoMap(x => x.SysNo, x => x.ListData).ExecuteReturnLastId <int>("SysNo");
if (sysNo > 0)
{
foreach (var item in model.ListData)
{
item.OtherOutOfStorageCode = sysNo;
Context.Insert("OtherOutOfStorageDetailed", item).AutoMap(x => x.SysNo, x => x.CollectWarehouseCode, x => x.ZhangCount).ExecuteReturnLastId <int>("SysNo");
}
}
context.Commit();
}
catch (Exception e)
{
if (sysNo > 0)
{
Context.Delete("OtherOutOfStorage").Where("SysNo", sysNo).Execute();
}
//回滚
sysNo = 0;
context.Rollback();
}
}
return(sysNo);
}
public ActionResult EditOtherOutOfStorage(int?id, int?PageType = (int)Hyt.Model.InventorySheet.OtherOutOfStorageTypeEnum.其他入库)
{
OtherOutOfStorage model = new OtherOutOfStorage();
if (id != null)
{
model = Hyt.BLL.InventorySheet.WhInventoryBo.Instance.GetOtherOutOfStorageModel((int)id);
}
ViewBag.PageType = PageType;
ViewBag.AdminName = CurrentUser.Base.UserName;
ViewBag.AdminSysNo = CurrentUser.Base.SysNo;
return(View(model));
}
/// <summary>
/// 根据id获取其他出入库明细
/// </summary>
/// <returns></returns>
public override OtherOutOfStorage GetOtherOutOfStorageModel(int sysNo)
{
var model = new OtherOutOfStorage();
model = Context.Select <OtherOutOfStorage>("*").From("OtherOutOfStorage").Where("SysNo=@SysNo").Parameter("SysNo", sysNo).QuerySingle();
if (model == null)
{
return(null);
}
else
{
model.ListData = Context.Select <OtherOutOfStorageDetailed>("SysNo,ProductSysNo,ProductCode,BarCode,ProductName,Count,UnitPrice,Price,Remarks,CollectWarehouseSysNo,CollectWarehouseName").From("OtherOutOfStorageDetailed")
.Where("OtherOutOfStorageCode=@OtherOutOfStorageCode")
.Parameter("OtherOutOfStorageCode", sysNo)
.QueryMany();
return(model);
}
}
public ActionResult AddOtherOutOfStorage(OtherOutOfStorage model, string ProductSysNo, string ProductCode, string BarCode, string ProductName, string Count, string UnitPrice, string Price, string Remarks, string CollectWarehouseSysNo, string CollectWarehouseName, int?PageType)
{
Result <object> result = new Result <object>();
#region 其他出入库信息
model.Type = PageType == (int)OtherOutOfStorageTypeEnum.其他入库 ? (int)OtherOutOfStorageTypeEnum.其他入库 : (int)OtherOutOfStorageTypeEnum.其他出库;
model.AddTime = DateTime.Now;
model.Status = (int)OtherOutOfStorageStatusEnum.审核中;
#endregion
#region 其他出入库商品明细
model.ListData = new List <OtherOutOfStorageDetailed>();
for (int i = 0; i < ProductSysNo.Trim(',').Split(',').Length; i++)
{
OtherOutOfStorageDetailed product = new OtherOutOfStorageDetailed();
product.ProductSysNo = Convert.ToInt32(ProductSysNo.Trim(',').Split(',')[i]);
product.ProductCode = ProductCode.Trim(',').Split(',')[i];
product.BarCode = BarCode.Trim(',').Split(',')[i];
product.ProductName = ProductName.Trim(',').Split(',')[i];
product.Count = Convert.ToDecimal(Count.Trim(',').Split(',')[i]);
product.UnitPrice = Convert.ToDecimal(UnitPrice.Trim(',').Split(',')[i]);
product.Price = Convert.ToDecimal(Price.Trim(',').Split(',')[i]);
product.Remarks = Remarks.Trim('^').Split('^')[i];
product.CollectWarehouseSysNo = Convert.ToInt32(CollectWarehouseSysNo.Trim(',').Split(',')[i]);
product.CollectWarehouseName = CollectWarehouseName.Trim(',').Split(',')[i];
model.ListData.Add(product);
}
#endregion
if (Hyt.BLL.InventorySheet.WhInventoryBo.Instance.AddOtherOutOfStorage(model) > 0)
{
result.Status = true;
result.Message = "成功!";
return(Json(result));
}
else
{
result.Status = false;
result.Message = "错误,提交失败!";
return(Json(result));
}
}
/// <summary>
/// 其他出入库更新库存
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public override bool UpdateOtherOutPdProductStock(OtherOutOfStorage model)
{
int sysNo = 0;
using (var context = Context.UseTransaction(true))
{
try
{
string sqlstr = @"update OtherOutOfStorage set Status=@Status,ToexamineName=@ToexamineName,ToexamineSysNo=@ToexamineSysNo where sysNo=@sysNo ";
sysNo = Context.Sql(sqlstr).Parameter("Status", model.Status)
.Parameter("sysNo", model.SysNo)
.Parameter("ToexamineName", model.ToexamineName)
.Parameter("ToexamineSysNo", model.ToexamineSysNo)
.Execute();
string set = "StockQuantity-=@StockQuantity";
if (model.Type == (int)OtherOutOfStorageTypeEnum.其他入库)
{
set = "StockQuantity+=@StockQuantity";
}
foreach (var item in model.ListData)
{
sqlstr = @"update PdProductStock set " + set + " where sysno =(select sysNo from PdProductStock where pdproductSysno=@pdproductSysno and WarehouseSysNo=@WarehouseSysNo )";
sysNo = Context.Sql(sqlstr)
.Parameter("StockQuantity", item.Count)
.Parameter("pdproductSysno", item.ProductSysNo)
.Parameter("WarehouseSysNo", item.CollectWarehouseSysNo)
.Execute();
}
context.Commit();
}
catch (Exception e)
{
//回滚
sysNo = 0;
context.Rollback();
}
}
return(sysNo > 0);
}
/// <summary> /// 其他出入库更新库存 /// </summary> /// <param name="model"></param> /// <returns></returns> public abstract bool UpdateOtherOutPdProductStock(OtherOutOfStorage model);
/// <summary> /// 添加其他入库 /// </summary> /// <param name="model"></param> /// <returns></returns> public abstract int AddOtherOutOfStorage(OtherOutOfStorage model);
/// <summary>
/// 其他出入库更新库存
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateOtherOutPdProductStock(OtherOutOfStorage model)
{
return(IWhInventoryDao.Instance.UpdateOtherOutPdProductStock(model));
}
/// <summary>
/// 添加其他入库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddOtherOutOfStorage(OtherOutOfStorage model)
{
return(IWhInventoryDao.Instance.AddOtherOutOfStorage(model));
}
