/// <summary> /// 创建缩略图 /// </summary> /// <param name="originalPicture">原图地址</param> /// <returns>缩略图地址。生成失败返回null</returns> public ActionResult CreateThumbnail(string originalPicture) { //原图为缩略图直接返回其地址 if (originalPicture.IndexOf("_s") > 0) { return(Json(originalPicture)); } //缩略图地址 string _thumbnail = originalPicture.Insert(originalPicture.LastIndexOf('.'), "_s"); //创建缩略图 if (Core.Picture.CreateThumbnail(Server.MapPath(originalPicture), Server.MapPath(_thumbnail), 160, 120)) { //记录保存在数据库中 attachmentService.Add(new Attachment() { Extension = _thumbnail.Substring(_thumbnail.LastIndexOf('.') + 1), FileParth = "~" + _thumbnail, Inputer = ControllerContext.HttpContext.GetOwinContext().Authentication.User.Identity.Name, Type = AttachmentType.Image, UploadDate = DateTime.Now }); return(Json(_thumbnail)); } return(Json(null)); }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = BottleDetectionService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (stock != null) { ModifiedGrid(); ///////////////////////////////////////////////////////////////////////////// stock.FCode = txtFCode.Text; stock.FName = tbxFCustomer.Text; //-------------------------------------------------- stock.FAddress = txtFAddress.Text.Trim(); stock.FFlag = 1; stock.FDeleteFlag = 0; stock.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim()); stock.FLinkman = txtFLinkman.Text.Trim(); stock.FMemo = txtFMemo.Text.Trim(); stock.FPhone = txtFPhone.Text.Trim(); stock.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; stock.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : ""; var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", stock.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesAmt", parms).Tables[0].Rows[0][0]); stock.FAmount = amt; stock.FDate = txtFDate.SelectedDate; stock.FSalesman = ddlFSalesman.SelectedValue; stock.FArea = ddlFArea.SelectedValue; stock.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim()); stock.FDiscountAmount = string.IsNullOrEmpty(txtFDiscountAmount.Text.Trim()) ? 0 : Convert.ToDecimal(txtFDiscountAmount.Text.Trim()); stock.FReconciliation = txtFReconciliation.Text; stock.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; stock.FLogisticsNumber = txtFLogisticsNumber.Text; stock.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); stock.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); stock.FSubjectCode = ddlSubject.SelectedValue; stock.FSubjectName = ddlSubject.SelectedText; stock.FSKNum = ""; BottleDetectionService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "XS", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "1"); orderParms.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_num", orderParms); txtKeyId.Text = newKeyId; //新增日志 var billStatus = new LHBillStatus { KeyId = newKeyId, FCompanyId = CurrentUser.AccountComId, FActionName = "新增", FDate = DateTime.Now, FDeptId = CurrentUser.AccountOrgId, FOperator = CurrentUser.AccountName, FMemo = String.Format("单据号{0},{1}新增钢瓶检测据。", newKeyId, CurrentUser.AccountName) }; GasHelper.AddBillStatus(billStatus); var bottles = new Dictionary <string, object>(); bottles.Clear(); bottles.Add("@SalesKeyId", newKeyId); bottles.Add("@companyid", CurrentUser.AccountComId); bottles.Add("@date", Convert.ToDateTime(stock.FDate).ToString("yyyy-MM-dd")); SqlService.ExecuteProcedureCommand("proc_SalesReturnBottle", bottles); //收款部分 var parmsAuto = new Dictionary <string, object>(); parmsAuto.Clear(); parmsAuto.Add("@KeyId", newKeyId); parmsAuto.Add("@companyId", CurrentUser.AccountComId); parmsAuto.Add("@FCate", "客户"); parmsAuto.Add("@date", Convert.ToDateTime(stock.FDate).ToString("yyyy-MM-dd")); parmsAuto.Add("@FSKNum", stock.FSKNum); SqlService.ExecuteProcedureCommand("proc_SKOrderAuto", parmsAuto); } if (!string.IsNullOrEmpty(hfdImage.Text)) { var attachment = new LHAttachment(); attachment.FCompanyId = CurrentUser.AccountComId; attachment.FPath = hfdImage.Text; attachment.KeyId = txtKeyId.Text; AttachmentService.Add(attachment); } return(true); } return(false); }
public ResultModel AddInfo([FromBody] AttachmentInfo attachment) { attachment.Create = User.Identity.GetCurrentUser().UserName; attachment.CreateDate = DateTime.Now; return(GenerateResult("", "", bll.Add(attachment))); }
public override JsonResult Process() { byte[] uploadFileBytes = null; string uploadFileName = null; if (UploadConfig.Base64) { uploadFileName = UploadConfig.Base64Filename; uploadFileBytes = Convert.FromBase64String(Request[UploadConfig.UploadFieldName]); } else { var file = Request.Files[UploadConfig.UploadFieldName]; uploadFileName = file.FileName; if (!CheckFileType(uploadFileName)) { Result.State = UploadState.TypeNotAllow; return(WriteResult()); } if (!CheckFileSize(file.ContentLength)) { Result.State = UploadState.SizeLimitExceed; return(WriteResult()); } uploadFileBytes = new byte[file.ContentLength]; try { file.InputStream.Read(uploadFileBytes, 0, file.ContentLength); } catch (Exception) { Result.State = UploadState.NetworkError; return(WriteResult()); } } Result.OriginFileName = uploadFileName; var savePath = PathFormatter.Format(uploadFileName, UploadConfig.PathFormat); var localPath = Server.MapPath(savePath); try { if (!Directory.Exists(Path.GetDirectoryName(localPath))) { Directory.CreateDirectory(Path.GetDirectoryName(localPath)); } File.WriteAllBytes(localPath, uploadFileBytes); Result.Url = savePath; Result.State = UploadState.Success; attachmentService.Add(new Attachment() { OriginName = Result.OriginFileName, Extension = Path.GetExtension(uploadFileName).ToLower(), FileParth = Result.Url, Inputer = Context.GetOwinContext().Authentication.User.Identity.Name, UploadDate = DateTime.Now, Type = FileType }); return(WriteResult()); } catch (Exception e) { Result.State = UploadState.FileAccessError; Result.ErrorMessage = e.Message; return(WriteResult()); } }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = LiquidPlanTaskService.Where(p => p.KeyId == txtKeyId.Text.Trim() && // p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (stock != null) { stock.FCode = txtFCode.Text; stock.FName = tbxFCustomer.Text; //-------------------------------------------------- stock.FAddress = txtFAddress.Text.Trim(); stock.FFlag = 1; stock.FDeleteFlag = 0; stock.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim()); stock.FLinkman = txtFLinkman.Text.Trim(); stock.FMemo = txtFMemo.Text.Trim(); stock.FPhone = txtFPhone.Text.Trim(); stock.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; stock.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : ""; stock.FDate = txtFDate.SelectedDate; stock.FSalesman = ddlFSalesman.SelectedValue; stock.FArea = ddlFArea.SelectedValue; stock.FReconciliation = txtFReconciliation.Text; stock.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; stock.FLogisticsNumber = txtFLogisticsNumber.Text; stock.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); stock.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); stock.FQty = Convert.ToDecimal(txtFQty.Text); stock.FPrice = Convert.ToDecimal(txtFPrice.Text); stock.FAmount = stock.FPrice * stock.FQty; stock.FItemCode = tbxFItemName.SelectedValue; stock.FItemName = tbxFItemName.SelectedText; LiquidPlanTaskService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "CC", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "29"); orderParms.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_num", orderParms); txtKeyId.Text = newKeyId; //新增日志 var billStatus = new LHBillStatus { KeyId = newKeyId, FCompanyId = CurrentUser.AccountComId, FActionName = "新增", FDate = DateTime.Now, FDeptId = CurrentUser.AccountOrgId, FOperator = CurrentUser.AccountName, FMemo = String.Format("单据号{0},{1}新增发货单据。", newKeyId, CurrentUser.AccountName) }; GasHelper.AddBillStatus(billStatus); } if (!string.IsNullOrEmpty(hfdImage.Text)) { var attachment = new LHAttachment(); attachment.FCompanyId = CurrentUser.AccountComId; attachment.FPath = hfdImage.Text; attachment.KeyId = txtKeyId.Text; AttachmentService.Add(attachment); } return(true); } return(false); }
/// <summary> /// 上传附件 /// </summary> /// <returns></returns> public ActionResult Upload() { var _uploadConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~").GetSection("UploadConfig") as EUWeb.Models.Config.UploadConfig; //文件最大限制 int _maxSize = _uploadConfig.MaxSize; //保存路径 string _savePath; //文件路径 string _fileParth = "~/" + _uploadConfig.Path + "/"; //文件名 string _fileName; //扩展名 string _fileExt; //文件类型 string _dirName; //允许上传的类型 Hashtable extTable = new Hashtable(); extTable.Add("image", _uploadConfig.ImageExt); extTable.Add("flash", _uploadConfig.FileExt); extTable.Add("media", _uploadConfig.MediaExt); extTable.Add("file", _uploadConfig.FileExt); //上传的文件 HttpPostedFileBase _postFile = Request.Files["imgFile"]; if (_postFile == null) { return(Json(new { error = '1', message = "请选择文件" })); } _fileName = _postFile.FileName; _fileExt = Path.GetExtension(_fileName).ToLower(); //文件类型 _dirName = Request.QueryString["dir"]; if (string.IsNullOrEmpty(_dirName)) { _dirName = "image"; } if (!extTable.ContainsKey(_dirName)) { return(Json(new { error = 1, message = "目录类型不存在" })); } //文件大小 if (_postFile.InputStream == null || _postFile.InputStream.Length > _maxSize) { return(Json(new { error = 1, message = "文件大小超过限制" })); } //检查扩展名 if (string.IsNullOrEmpty(_fileExt) || Array.IndexOf(((string)extTable[_dirName]).Split(','), _fileExt.Substring(1).ToLower()) == -1) { return(Json(new { error = 1, message = "不允许上传此类型的文件。 \n只允许" + ((String)extTable[_dirName]) + "格式。" })); } _fileParth += _dirName + "/" + DateTime.Now.ToString("yyyy-MM") + "/"; _savePath = Server.MapPath(_fileParth); //检查上传目录 if (!Directory.Exists(_savePath)) { Directory.CreateDirectory(_savePath); } string _newFileName = DateTime.Now.ToString("yyyyMMdd_hhmmss") + _fileExt; _savePath += _newFileName; _fileParth += _newFileName; //保存文件 _postFile.SaveAs(_savePath); //保存数据库记录 Attachment attachment = new Attachment() { Extension = _fileExt.Substring(1), FilePath = _fileParth, Owner = User.Identity.Name, UploadDate = DateTime.Now, Type = _dirName }; attachmentService.Add(attachment); return(Json(new { error = 0, url = Url.Content(_fileParth) })); }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (StockOut != null) { ModifiedGrid(); ///////////////////////////////////////////////////////////////////////////// StockOut.FCode = txtFCode.Text; StockOut.FName = tbxFCustomer.Text; //------------------------------------------------------ StockOut.FAddress = txtFAddress.Text.Trim(); //StockOut.FCompanyId = CurrentUser.AccountComId; StockOut.FDate = txtFDate.SelectedDate; StockOut.FShipper = !ddlFShipper.SelectedValue.Equals("-1") ? ddlFShipper.SelectedText : ""; StockOut.FVehicleNum = !ddlFVehicleNum.SelectedValue.Equals("-1") ? ddlFVehicleNum.SelectedText : ""; StockOut.FFreight = Convert.ToDecimal(txtFFreight.Text.Trim()); StockOut.FLinkman = txtFLinkman.Text.Trim(); StockOut.FMemo = txtFMemo.Text.Trim(); StockOut.FPhone = txtFPhone.Text.Trim(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", StockOut.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_SalesAmt", parms).Tables[0].Rows[0][0]); StockOut.FAmount = amt; StockOut.FSalesman = ddlFSalesman.SelectedValue; StockOut.FArea = ddlFArea.SelectedValue; StockOut.FAmt = string.IsNullOrEmpty(txtFAmt.Text.Trim()) ? 0 : Convert.ToDecimal(txtFAmt.Text.Trim());// StockOut.FDiscountAmount = string.IsNullOrEmpty(txtFDiscountAmount.Text.Trim()) ? 0 : Convert.ToDecimal(txtFDiscountAmount.Text.Trim()); StockOut.FReconciliation = txtFReconciliation.Text; StockOut.FDeliveryMethod = ddlDeliveryMethod.SelectedValue; StockOut.FLogisticsNumber = txtFLogisticsNumber.Text; StockOut.FSupercargo = GasHelper.GetDropDownListArrayString(ddlFSupercargo.SelectedItemArray); StockOut.FDriver = GasHelper.GetDropDownListArrayString(ddlFDriver.SelectedItemArray); StockOut.FSubjectCode = ddlSubject.SelectedValue; StockOut.FSubjectName = ddlSubject.SelectedText; var bottles = new Dictionary <string, object>(); bottles.Clear(); bottles.Add("@SalesKeyId", StockOut.KeyId); bottles.Add("@companyid", CurrentUser.AccountComId); bottles.Add("@date", Convert.ToDateTime(StockOut.FDate).ToString("yyyy-MM-dd")); SqlService.ExecuteProcedureCommand("proc_SalesReturnBottle", bottles); //收款部分 var parmsAuto = new Dictionary <string, object>(); parmsAuto.Clear(); parmsAuto.Add("@KeyId", StockOut.KeyId); parmsAuto.Add("@companyId", CurrentUser.AccountComId); parmsAuto.Add("@FCate", "客户"); parmsAuto.Add("@date", Convert.ToDateTime(StockOut.FDate).ToShortDateString()); parmsAuto.Add("@FSKNum", string.IsNullOrEmpty(StockOut.FSKNum) ? "" : StockOut.FSKNum); SqlService.ExecuteProcedureCommand("proc_SKOrderAuto", parmsAuto); if (!string.IsNullOrEmpty(hfdImage.Text)) { var attachment = new LHAttachment(); attachment.FCompanyId = CurrentUser.AccountComId; attachment.FPath = hfdImage.Text; attachment.KeyId = txtKeyId.Text; AttachmentService.Add(attachment); } //--------------------------------------------------------- //收发类型 StockOut.FT6ReceiveSendType = ddlT6ReceiveSendType.SelectedText; StockOut.FT6ReceiveSendTypeNum = ddlT6ReceiveSendType.SelectedValue; //部门名称 StockOut.FT6Department = ""; //部门代码 StockOut.FT6DepartmentNum = ""; //业务员代码 StockOut.FT6SalesmanNum = ""; //币种 StockOut.FT6Currency = ddlFT6Currency.SelectedValue; //汇率 StockOut.FT6ExchangeRate = Convert.ToDecimal(txtFT6ExchangeRate.Text); //销售类型 StockOut.FT6SaleType = ddlFT6SaleType.SelectedText; StockOut.FT6SaleTypeNum = ddlFT6SaleType.SelectedValue; //T6同步 //StockOut.FT6Status = "未同步"; return(StockOutService.SaveChanges() >= 0); } return(false); }