public HttpResponseMessage DeleteBasItemRow(t_item obj)
{
var result = new DBHelper <t_item>().Remove(obj);
return(Json(true, result == 1 ? "删除成功！" : "删除失败"));
}
public HttpResponseMessage FindBasItemForm(t_item obj)
{
long ItemID = obj.ItemID;
var UOMList = db.t_bas_unitofmeasure.Where(w => (w.CorpID == userInfo.CorpID || w.CorpID == 0) && w.IsValid != 0).Select(s => new
{
label = s.Name,
value = s.UnitID
});
var ItemGroupIDList = db.t_item_group.Where(w => w.IsValid != 0 && (w.CorpID == userInfo.CorpID || w.CorpID == 0)).Select(s => new
{
label = s.Name,
value = s.ItemGroupID
});
var ItemCategoryIDList = db.t_item_category.Where(w => w.IsValid != 0 && (w.CorpID == userInfo.CorpID || w.CorpID == 0)).Select(s => new
{
label = s.Name,
value = s.ItemCategoryID
});
var WarehouseIDList = db.t_warehouse.Where(w => w.IsValid != 0 && w.CorpID == userInfo.CorpID).
Join(db.t_user_warehouse.Where(w => w.IsValid != 0 && w.CorpID == userInfo.CorpID && w.UserID == userInfo.UserID), a => a.WarehouseID, b => b.WarehouseID, (a, b) => new
{
label = a.Name,
value = a.WarehouseID
});
string NullValue = null;
if (ItemID == 0)
{
var list = new
{
CorpID = userInfo.CorpID,
Code = NullValue,
ItemID = 0,
ItemGroupID = NullValue,
ItemGroupIDList = ItemGroupIDList,
ItemCategoryID = NullValue,
ItemCategoryIDList = ItemCategoryIDList,
Photo = new
{
IsTitle = NullValue,
PicID = NullValue,
Type = NullValue,
IsValid = 1,
Picture = NullValue
},
Name = NullValue,
HelperCode = NullValue,
Barcode = NullValue,
BaseUOM = NullValue,
UOMList = UOMList,
CrossWeigth = NullValue,
Height = NullValue,
IsBatch = 0,
IsForSale = 1,
IsZeroValue = 0,
LastCost = NullValue,
Length = NullValue,
Period = NullValue,
PurchasePrice = NullValue,
PurchaseUOM = NullValue,
SalesPrice = NullValue,
SalesUOM = NullValue,
SaveInventory = NullValue,
ShortName = NullValue,
Size = NullValue,
IsValid = 1,
WarehouseID = NullValue,
WarehouseIDList = WarehouseIDList,
Width = NullValue,
CloseTime = NullValue,
CloseUserID = NullValue,
CreateTime = NullValue,
CreateUserID = NullValue,
UpdateTime = NullValue,
UpdateUserID = NullValue,
UOM = new object[] { }
};
return(Json(true, "", list));
}
else
{
var UOM = db.t_item_uom.Where(w => w.ItemID == obj.ItemID && w.CorpID == userInfo.CorpID).Select(s1 => new { s1.ItemID, s1.UomID, s1.IsValid, s1.RateQty, s1.UomType, s1.PurchasePrice, s1.SalesPrice, s1.IsPurchaseUOM, s1.IsSalesUOM }).OrderByDescending(o => o.UomType);
var list = db.t_item.Where(w => w.ItemID == ItemID && w.CorpID == userInfo.CorpID).Select(s => new
{
s.CorpID,
s.Code,
s.ItemID,
s.ItemGroupID,
ItemGroupIDList = ItemGroupIDList,
s.ItemCategoryID,
ItemCategoryIDList = ItemCategoryIDList,
Photo = db.t_item_picture.Where(w => w.CorpID == userInfo.CorpID && w.ItemID == s.ItemID).Select(s1 => new
{
s1.IsTitle,
s1.PicID,
s1.Type,
s1.IsValid,
s1.Picture
}).FirstOrDefault(),
s.Name,
s.HelperCode,
s.Barcode,
s.BaseUOM,
UOMList = UOMList,
s.CrossWeigth,
s.Height,
s.IsBatch,
s.IsForSale,
s.IsZeroValue,
s.LastCost,
s.Length,
s.Period,
s.PurchasePrice,
s.PurchaseUOM,
s.SalesPrice,
s.SalesUOM,
s.SaveInventory,
s.ShortName,
s.Size,
s.IsValid,
s.WarehouseID,
WarehouseIDList = WarehouseIDList,
s.Width,
s.CloseTime,
s.CloseUserID,
s.CreateTime,
s.CreateUserID,
s.UpdateTime,
s.UpdateUserID,
UOM = UOM
}).FirstOrDefault();
return(Json(true, "", list));
}
}
public HttpResponseMessage SaveBasItemForm(t_item_photo_uom obj)
{
using (TransactionScope transaction = new TransactionScope())
{
DateTime dt = DateTime.Now;
t_item objItem = new t_item()
{
CorpID = userInfo.CorpID,
Code = obj.Code,
ItemID = obj.ItemID,
ItemGroupID = obj.ItemGroupID,
ItemCategoryID = obj.ItemCategoryID,
Name = obj.Name,
HelperCode = obj.HelperCode,
Barcode = obj.Barcode,
BaseUOM = obj.BaseUOM,
CrossWeigth = obj.CrossWeigth,
Height = obj.Height,
IsBatch = obj.IsBatch,
IsForSale = obj.IsForSale,
IsZeroValue = obj.IsZeroValue,
LastCost = obj.LastCost,
Length = obj.Length,
Period = obj.Period,
PurchasePrice = obj.PurchasePrice,
PurchaseUOM = obj.PurchaseUOM,
SalesPrice = obj.SalesPrice,
SalesUOM = obj.SalesUOM,
SaveInventory = obj.SaveInventory,
ShortName = obj.ShortName,
Size = obj.Size,
IsValid = obj.IsValid,
WarehouseID = obj.WarehouseID,
Width = obj.Width,
CloseTime = obj.CloseTime,
CloseUserID = obj.CloseUserID,
CreateTime = obj.CreateTime,
CreateUserID = obj.CreateUserID,
UpdateTime = obj.UpdateTime,
UpdateUserID = obj.UpdateUserID
};
DBHelper <t_item> dbhelp_item = new DBHelper <t_item>();
//事务
var result = 0;
var Item = db.t_item.Where(w => w.Code == objItem.Code && w.CorpID == userInfo.CorpID);
try
{
if (objItem.ItemID == 0)
{
string Code = objItem.Code;
if (Code == "" || Code == null)
{
result = AutoIncrement.AutoIncrementResult("Item", out Code);
}
objItem.CreateTime = dt;
objItem.CreateUserID = (int)userInfo.UserID;
objItem.CorpID = userInfo.CorpID;
objItem.Code = Code;
if (Item.ToList().Count() > 0)
{
throw new Exception("账号重复！");
}
result = result + dbhelp_item.Add(objItem);
}
else
{
objItem.UpdateTime = dt;
objItem.UpdateUserID = (int)userInfo.UserID;
if (Item.ToList().Count() > 1)
{
throw new Exception("账号重复！");
}
result = result + dbhelp_item.Update(objItem);
}
//保存图片并修改数据库图片名称
t_item_picture objItemPicture = new t_item_picture()
{
PicID = obj.Photo.PicID,
CorpID = userInfo.CorpID,
ItemID = (int)objItem.ItemID,
Picture = obj.Photo.Picture,
Type = obj.Photo.Type,
IsTitle = obj.Photo.IsTitle,
IsValid = obj.Photo.IsValid,
CreateTime = dt,
CreateUserID = (int)userInfo.UserID,
};
DBHelper <t_item_picture> dbhelp_picture = new DBHelper <t_item_picture>();
string base64Data = obj.Photo.Picture;
try
{
//获取文件储存路径
string suffix = base64Data.Split(new char[] { ';' })[0].Substring(base64Data.IndexOf('/') + 1); //获取后缀名
string newFileName = "M_" + obj.ItemID.ToString("000000000") + "." + suffix;
string strPath = HttpContext.Current.Server.MapPath("~/" + UploadImgPath + "/" + newFileName); //获取当前项目所在目录
//获取图片并保存
BaseToImg.Base64ToImg(base64Data.Split(',')[1]).Save(strPath);
objItemPicture.Picture = newFileName;
}
catch
{
objItemPicture.Picture = base64Data;
}
//删除并保存图片
result = result + dbhelp_picture.RemoveList(w => w.ItemID == objItem.ItemID && w.Type == 0);
result = result + dbhelp_picture.Add(objItemPicture);
//删除并保存单位
DBHelper <t_item_uom> dbhelp_item_uom = new DBHelper <t_item_uom>();
foreach (var item in obj.Uom)
{
item.CorpID = userInfo.CorpID;
item.ItemID = (int)objItem.ItemID;
item.CreateTime = dt;
item.CreateUserID = (int)userInfo.UserID;
item.UpdateTime = dt;
item.UpdateUserID = (int)userInfo.UserID;
}
result = result + dbhelp_item_uom.RemoveList(w => w.ItemID == objItem.ItemID);
result = result + dbhelp_item_uom.AddList(obj.Uom);
//提交事务
transaction.Complete();
return(Json(true, "保存成功！"));
}
catch (Exception ex)
{
return(Json(false, "保存失败！" + ex.Message));
}
}
}
