public HttpResponseMessage SaveBasItemCategoryForm(t_item_category obj) { using (TransactionScope transaction = new TransactionScope()) { DBHelper <t_item_category> dbhelp = new DBHelper <t_item_category>(); DateTime dt = DateTime.Now; //事务 var result = 0; var ItemCategory = db.t_item_category.Where(w => w.Code == obj.Code && w.CorpID == userInfo.CorpID); try { if (obj.ItemCategoryID == 0) { string Code = ""; result = AutoIncrement.AutoIncrementResult("ItemCategory", out Code); obj.CreateTime = dt; obj.CreateUser = (int)userInfo.UserID; obj.UPdateTime = dt; obj.UpdateUser = (int)userInfo.UserID; obj.CorpID = userInfo.CorpID; obj.Code = Code; if (ItemCategory.ToList().Count() > 0) { throw new Exception("编码重复!"); } } else { obj.UPdateTime = dt; obj.UpdateUser = (int)userInfo.UserID; if (ItemCategory.ToList().Count() > 1) { throw new Exception("编码重复!"); } } result = result + (obj.ItemCategoryID == 0 ? dbhelp.Add(obj) : dbhelp.Update(obj)); //提交事务 transaction.Complete(); return(Json(true, "保存成功!")); } catch (Exception ex) { return(Json(false, "保存失败!" + ex.Message)); } } }
private dynamic SaveForm(t_purchaseOrder obj) { using (TransactionScope transaction = new TransactionScope()) { DateTime dt = DateTime.Now; t_purchase_order objItem = new t_purchase_order() { POID = obj.POID, PostDate = obj.PostDate, PurchaserID = obj.PurchaserID, Remark = obj.Remark, Status = obj.Status, SupplierID = obj.SupplierID, TruckID = obj.TruckID, UpdateTime = obj.UpdateTime, UpdateUserID = obj.UpdateUserID, BillDate = obj.BillDate, BillType = obj.BillType, Code = obj.Code, ConfirmTime = obj.ConfirmTime, ConfirmUserID = obj.ConfirmUserID, CorpID = obj.CorpID, CreateTime = obj.CreateTime, CreateUserID = obj.CreateUserID, DriverID = obj.DriverID, IsStockFinished = obj.IsStockFinished }; DBHelper <t_purchase_order> dbhelp_purOrder = new DBHelper <t_purchase_order>(); //事务 var result = 0; var Item = db.t_purchase_order.Where(w => w.Code == objItem.Code && w.CorpID == userInfo.CorpID); try { if (objItem.POID == 0) { string Code = objItem.Code; if (Code == "" || Code == null) { result = AutoIncrement.AutoIncrementResult("PurchaseOrder", out Code); } objItem.CreateTime = dt; objItem.BillDate = dt; objItem.CreateUserID = (int)userInfo.UserID; objItem.CorpID = userInfo.CorpID; objItem.Code = Code; objItem.Status = 1; if (Item.ToList().Count() > 0) { throw new Exception("账号重复!"); } result = result + dbhelp_purOrder.Add(objItem); } else { objItem.CorpID = userInfo.CorpID; objItem.UpdateTime = dt; objItem.UpdateUserID = (int)userInfo.UserID; if (Item.ToList().Count() > 1) { throw new Exception("账号重复!"); } result = result + dbhelp_purOrder.Update(objItem); } //删除并保存明细 DBHelper <t_purchase_order_detail> dbhelp_purOderDetail = new DBHelper <t_purchase_order_detail>(); List <int> ItemList = new List <int>(); List <int> UomList = new List <int>(); List <t_itemprice> itempriceList = new List <t_itemprice>(); foreach (var item in obj.OrderDetail) { item.CorpID = userInfo.CorpID; item.POID = objItem.POID; item.UpdateTime = dt; item.UpdateUserID = (int)userInfo.UserID; ItemList.Add(item.ItemID); UomList.Add(item.UomID); itempriceList.Add(new t_itemprice { CorpID = userInfo.CorpID, SuppCustID = objItem.SupplierID, ItemID = item.ItemID, UomID = item.UomID, LastPrice = item.UnitAmount, UpdateTime = dt, TargetType = 1 }); } //删除明细 result = result + dbhelp_purOderDetail.RemoveList(w => w.POID == objItem.POID); //添加明细 result = result + dbhelp_purOderDetail.AddList(obj.OrderDetail); //删除最后价格 DBHelper <t_itemprice> dbhelp_itemprice = new DBHelper <t_itemprice>(); result = result + dbhelp_itemprice.RemoveList(w => w.TargetType == 1 && w.CorpID == userInfo.CorpID && ItemList.Contains(w.ItemID) && UomList.Contains(w.UomID) && w.SuppCustID == objItem.SupplierID); //添加最后价格 result = result + dbhelp_itemprice.AddList(itempriceList.ToArray()); //提交事务 transaction.Complete(); return(new { result = true, message = "保存成功!", data = new { POID = objItem.POID } }); } catch (Exception ex) { throw new DomainException("保存失败!"); } } }
public HttpResponseMessage SaveBasSupplierForm(t_supplier obj) { using (TransactionScope transaction = new TransactionScope()) { DBHelper <t_supplier> dbhelp = new DBHelper <t_supplier>(); DateTime dt = DateTime.Now; //事务 var result = 0; var Supplier = db.t_supplier.Where(w => w.Code == obj.Code && w.CorpID == userInfo.CorpID); try { if (obj.SupplierID == 0) { string Code = ""; result = AutoIncrement.AutoIncrementResult("Supplier", out Code); obj.CreateTime = dt; obj.CreateUserID = (int)userInfo.UserID; obj.UpdateTime = dt; obj.UpdateUserID = (int)userInfo.UserID; obj.CorpID = userInfo.CorpID; obj.Code = Code; if (Supplier.ToList().Count() > 0) { throw new Exception("编码重复!"); } else { if (obj.IsValid == 0)//判断是否修改关闭状态,如果是需要写关闭人 { obj.CloseTime = dt; obj.CloseUserID = (int)userInfo.UserID; } } } else { obj.UpdateTime = dt; obj.UpdateUserID = (int)userInfo.UserID; if (Supplier.ToList().Count() > 1) { throw new Exception("编码重复!"); } else { if (obj.IsValid == 0 && Supplier.Select(s => s.IsValid).FirstOrDefault() != 0)//判断是否修改关闭状态,如果是需要写关闭人 { obj.CloseTime = dt; obj.UpdateUserID = (int)userInfo.UserID; } if (obj.IsValid != 0 && Supplier.Select(s => s.IsValid).FirstOrDefault() == 0)//如果再次打开清空时间和操作员 { obj.CloseTime = null; obj.UpdateUserID = null; } } } result = result + (obj.SupplierID == 0 ? dbhelp.Add(obj) : dbhelp.Update(obj)); //提交事务 transaction.Complete(); return(Json(true, "保存成功!")); } catch (Exception ex) { return(Json(false, "保存失败!" + ex.Message)); } } }
public HttpResponseMessage SaveBasCustomerForm(t_customer obj) { using (TransactionScope transaction = new TransactionScope()) { DBHelper <t_customer> dbhelp = new DBHelper <t_customer>(); DateTime dt = DateTime.Now; //事务 var result = 0; var Customer = db.t_customer.Where(w => w.Code == obj.Code && w.CorpID == userInfo.CorpID); try { string base64Data = obj.Photo; if (obj.CustID == 0) { string Code = obj.Code; if (Code == "" || Code == null) { result = AutoIncrement.AutoIncrementResult("Customer", out Code); } obj.Photo = ""; obj.CreateTime = dt; obj.CreateUserID = (int)userInfo.UserID; obj.CorpID = userInfo.CorpID; obj.Code = Code; if (Customer.ToList().Count() > 0) { throw new Exception("账号重复!"); } result = result + dbhelp.Add(obj); } else { obj.Photo = ""; obj.UpdateTime = dt; obj.UpdateUserID = (int)userInfo.UserID; if (Customer.ToList().Count() > 1) { throw new Exception("账号重复!"); } result = result + dbhelp.Update(obj); } //保存图片并修改数据库图片名称 try { //获取文件储存路径 string suffix = base64Data.Split(new char[] { ';' })[0].Substring(base64Data.IndexOf('/') + 1); //获取后缀名 string newFileName = "CUST_" + obj.CustID.ToString("000000000") + "." + suffix; string strPath = HttpContext.Current.Server.MapPath("~/" + UploadImgPath + "/" + newFileName); //获取当前项目所在目录 //获取图片并保存 BaseToImg.Base64ToImg(base64Data.Split(',')[1]).Save(strPath); obj.Photo = newFileName; } catch { obj.Photo = base64Data; } List <string> fileds = new List <string>(); fileds.Add("Photo"); result = result + dbhelp.UpdateEntityFields(obj, fileds); //提交事务 transaction.Complete(); return(Json(true, "保存成功!")); } catch (Exception ex) { return(Json(false, "保存失败!" + ex.Message)); } } }
public HttpResponseMessage SaveBasWarehouseForm(t_warehouse_user obj) { using (TransactionScope transaction = new TransactionScope()) { DBHelper <t_warehouse> dbhelp = new DBHelper <t_warehouse>(); DateTime dt = DateTime.Now; //事务 var result = 0; var WareHouse = db.t_warehouse.Where(w => w.Code == obj.Code && w.CorpID == userInfo.CorpID); try { if (obj.WarehouseID == 0) { string Code = ""; result = AutoIncrement.AutoIncrementResult("Warehouse", out Code); obj.CreateTime = dt; obj.CreateUserID = (int)userInfo.UserID; obj.UpdateTime = dt; obj.UpdateUserID = (int)userInfo.UserID; obj.CorpID = userInfo.CorpID; obj.Code = Code; if (WareHouse.ToList().Count() > 0) { throw new Exception("编码重复!"); } else { if (obj.IsValid == 0)//判断是否修改关闭状态,如果是需要写关闭人 { obj.CloseTime = dt; obj.CloseUser = (int)userInfo.UserID; } } } else { obj.UpdateTime = dt; obj.UpdateUserID = (int)userInfo.UserID; if (WareHouse.ToList().Count() > 1) { throw new Exception("编码重复!"); } else { if (obj.IsValid == 0 && WareHouse.Select(s => s.IsValid).FirstOrDefault() != 0)//判断是否修改关闭状态,如果是需要写关闭人 { obj.CloseTime = dt; obj.CloseUser = (int)userInfo.UserID; } if (obj.IsValid != 0 && WareHouse.Select(s => s.IsValid).FirstOrDefault() == 0)//如果再次打开清空时间和操作员 { obj.CloseTime = null; obj.CloseUser = null; } } } t_warehouse tw = new t_warehouse() { WarehouseID = obj.WarehouseID, Code = obj.Code, Address = obj.Address, CorpID = obj.CorpID, Name = obj.Name, IsValid = obj.IsValid, Phone = obj.Phone, Tel = obj.Tel, IsBin = obj.IsBin, IsRequireReceive = obj.IsRequireReceive, IsRequireShipment = obj.IsRequireShipment, Contact = obj.Contact, CreateTime = obj.CreateTime, CreateUserID = obj.CreateUserID, UpdateTime = obj.UpdateTime, UpdateUserID = obj.UpdateUserID, CloseTime = obj.CloseTime, CloseUser = obj.CloseUser }; result = result + (obj.WarehouseID == 0 ? dbhelp.Add(tw) : dbhelp.Update(tw)); //删除并新增仓库对应用户 foreach (var item in obj.userData) { item.WarehouseID = (int)tw.WarehouseID; } result = result + new DBHelper <t_user_warehouse>().RemoveList(w => w.WarehouseID == tw.WarehouseID); result = result + new DBHelper <t_user_warehouse>().AddList(obj.userData); //提交事务 transaction.Complete(); return(Json(true, "保存成功!")); } catch (Exception ex) { return(Json(false, "保存失败!" + ex.Message)); } } }
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)); } } }