/// <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);
}