public HttpResponseMessage SaveBasCompanyForm(t_bas_company obj) { using (TransactionScope transaction = new TransactionScope()) { DBHelper <t_bas_company> dbhelp = new DBHelper <t_bas_company>(); DateTime dt = DateTime.Now; //事务 var result = 0; try { string base64Data = obj.TradeMark; obj.TradeMark = "";//先置空 obj.UpdateTime = dt; obj.UpdateUserID = (int)userInfo.UserID; result = dbhelp.Update(obj); //保存图片并修改数据库图片名称 try { //获取文件储存路径 string suffix = base64Data.Split(new char[] { ';' })[0].Substring(base64Data.IndexOf('/') + 1); //获取后缀名 string newFileName = "COMPANY_" + userInfo.CorpID.ToString("000000000") + "." + suffix; string strPath = HttpContext.Current.Server.MapPath("~/" + UploadImgPath + "/" + newFileName); //获取当前项目所在目录 //获取图片并保存 BaseToImg.Base64ToImg(base64Data.Split(',')[1]).Save(strPath); obj.TradeMark = newFileName; } catch { obj.TradeMark = base64Data; } List <string> fileds = new List <string>(); fileds.Add("TradeMark"); result = result + dbhelp.UpdateEntityFields(obj, fileds); //提交事务 transaction.Complete(); return(Json(true, "保存成功!")); } catch (Exception ex) { return(Json(false, "保存失败!" + ex.Message)); } } }
public HttpResponseMessage SaveBasUserForm(t_bas_user obj) { using (TransactionScope transaction = new TransactionScope()) { DBHelper <t_bas_user> dbhelp = new DBHelper <t_bas_user>(); DateTime dt = DateTime.Now; //事务 var result = 0; try { string base64Data = obj.Photo; if (obj.UserID == 0) { obj.Photo = ""; obj.CreateTime = dt; obj.CreateUserID = (int)userInfo.UserID; obj.CorpID = userInfo.CorpID; if (db.t_bas_user.Where(w => w.Code == obj.Code).ToList().Count() > 0) { throw new Exception("账号重复!"); } result = result + dbhelp.Add(obj); } else { obj.Photo = ""; obj.UpdateTime = dt; obj.UpdateUserID = (int)userInfo.UserID; if (db.t_bas_user.Where(w => w.Code == obj.Code).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 = "USER_" + obj.UserID.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 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)); } } }