public override void BeginUpload(UploadEventArgs args)
{
args.UploadItem.SetResumeAction(this.ProcessUpload);
args.BeginUpload();
args.UploadProgressChanged(args.UploadItem.Length/2, new TimeSpan(0, 0, 0, 1));
args.UploadCompleted(null);
}
public void Upload_Failed(object sender, UploadEventArgs e)
{
if (e.CanUpdateItemInGrid == true)
{
e.ConnectorExplorer.ContentExplorer.UpdateUploadItemErrorInGrid(e.UploadItem.UniqueID.ToString(), e.UploadedItem);
}
}
private void uploadService_ProgressChanged(object sender, UploadEventArgs e)
{
Dispatcher.BeginInvoke(() =>
{
e.Upload.UploadInfo.PercentageDone = e.Progress;
});
}
protected ActionResult SaveUploadFile(string path, HttpUploadProcessor processor, bool rename)
{
UploadEventArgs fileArg = null;
if (processor == null)
{
processor = new HttpUploadProcessor();
}
if (processor.IsAjaxUpload(Request))
{
try
{
fileArg = processor.SaveAjaxUploadFile(Request, path, rename);
return(Json(fileArg));
}
catch (Exception e)
{
return(GetJsonErrorMessage(e));
}
}
else
{
try
{
fileArg = processor.SaveFormUploadFile(Request, ICON_UPLOAD_PATH, rename);
}
catch (Exception e)
{
SetErrorMessageToViewBag(e);
}
return(UploadResult(fileArg));
}
}
protected void OnUpload(Object sender, UploadEventArgs e)
{
//do something with e.Files
//output the parameters that were received
e.Response = String.Format("a={0}\nb={1}", e.Form["a"], e.Form["b"]);
}
public string UploadImages(HttpContext context)
{
var eventArgs = new UploadEventArgs <HttpContext>(context);
UploadProcess(this, eventArgs);
return(eventArgs.Results.ToJson());
}
private static void Upload(object sender, UploadEventArgs args)
{
args.SaveFileName = GetSaveFilePath(args.FileName, FileGroup, args.MidFilepath);
//var filePath = GetSaveFilePath(args.FileName, FileGroup, args.MidFilepath);
//if (!string.IsNullOrWhiteSpace(filePath))
// args.UploadImage.Save(filePath);
}
public void UploadFile(ISiteSetting siteSetting, UploadItem uploadItem, IConnectorExplorer connectorExplorer, bool canUpdateItemInGrid, bool saveAsWord, UploadEventHandler UploadSucceeded, UploadEventHandler UploadFailed)
{
IServiceManager serviceManager = ServiceManagerFactory.GetServiceManager(siteSetting.SiteSettingType);
bool isListItemAndAttachment = ConfigurationManager.GetInstance().GetListItemAndAttachmentOption();
IItem item = null;
bool isSuccess = serviceManager.UploadFile(siteSetting, uploadItem, isListItemAndAttachment, out item);
UploadEventArgs e = new UploadEventArgs();
e.UploadItem = uploadItem;
e.UploadedItem = item;
e.CanUpdateItemInGrid = canUpdateItemInGrid;
e.ConnectorExplorer = connectorExplorer;
if (isSuccess == true)
{
UploadSucceeded(null, e);
}
else
{
e.ErrorMessage = Languages.Translate("Upload failed");
UploadFailed(null, e);
}
}
// Called when a new file is uploaded
protected async Task OnChange(InputFileChangeEventArgs e)
{
using var stream = e.File.OpenReadStream();
using var ms = new MemoryStream();
await stream.CopyToAsync(ms);
string content = System.Text.Encoding.UTF8.GetString(ms.ToArray());
var doc = new XmlDocument();
var args = new UploadEventArgs();
try
{
doc.LoadXml(content);
}
catch (XmlException)
{
args.Errors = "Invalid XML data found in uploaded SVG file.";
await Upload.InvokeAsync(args);
return;
}
// Search for the script
StringWriter swScript = new();
foreach (XmlNode node in doc.DocumentElement.GetElementsByTagName("sc:script"))
{
if (node.ChildNodes.Count == 1 && node.ChildNodes[0] is XmlCDataSection cdata)
{
swScript.WriteLine(cdata.Data);
}
else
{
swScript.WriteLine(node.InnerText);
}
}
// Search for the style
StringWriter swStyle = new();
foreach (XmlNode node in doc.DocumentElement.GetElementsByTagName("style"))
{
swStyle.WriteLine(node.InnerText);
}
// Call the event
args.Script = swScript.ToString();
args.Style = swStyle.ToString();
if (args.Script.Length == 0)
{
args.Errors = "No SimpleCircuit script metadata found in uploaded SVG file.";
}
else if (args.Style.Length == 0)
{
args.Warnings = "No styling information found in uploaded SVG file.";
}
await Upload.InvokeAsync(args);
}
public void DoSomeUpload()
{
if (UploadProgress != null)
{
UploadEventArgs e = new UploadEventArgs();
e.BytesSoFar = 123f;
e.TotalToUpload = 100000f;
UploadProgress.Invoke(this, e);
}
}
void _uploader_UploadFinished(object sender, UploadEventArgs e)
{
_locator.LoggerViewModel.AddLog("Upload finished");
RaisePropertyChange("ItemsTotal");
RaisePropertyChange("ItemsUploaded");
foreach (FolderDefinition folder in _locator.Folders)
{
folder.UpdateFileList.Execute(null);
}
}
private static void UploadByDFIS(object sender, UploadEventArgs args)
{
using (var ms = new MemoryStream())
{
args.UploadImage.Save(ms, ImageFormat.Jpeg);
ms.Seek(0, SeekOrigin.Begin);
HttpUploader.UploadFile(ms, args.FileName, UploadURL, FileGroup, args.MidFilepath, "", UserName, UploadMethod.Update);
}
}
public void OnRemove(UploadEventArgs args)
{
foreach (var file in args.Files)
{
var itemDel = lstAttachFile.FirstOrDefault(p => p.AttachFileName == file.Name);
if (itemDel != null)
{
lstAttachFile.Remove(itemDel);
}
}
}
public void ProcessUploadFile(object sender, UploadEventArgs <HttpContext> e)
{
lock (_locker)
{
var db = new AlbumImageController();
var flAlbum = new FileAlbumController();
int albumid = int.Parse(e.HttpContextUpload.Request.QueryString["albumid"].ToString());
//tim va thiet lap thong tin con thieu cho lop V_Base
int portalid = int.Parse(e.HttpContextUpload.Request.QueryString["portalid"].ToString());
var portalInfo = new DotNetNuke.Entities.Portals.PortalController().GetPortal(portalid);
string pathImgThumb = "/" + portalInfo.HomeDirectory + "/" + GB.Album.CommonBase.Constants.FolderImageThum + "/";
e.HttpContextUpload.Response.ContentType = "text/plain";//"application/json";
var r = new System.Collections.Generic.List <ViewDataUploadFilesResult>();
foreach (string file in e.HttpContextUpload.Request.Files)
{
HttpPostedFile hpf = e.HttpContextUpload.Request.Files[file] as HttpPostedFile;
string FileName = string.Empty;
if (HttpContext.Request.Browser.Browser.ToUpper() == "IE")
{
string[] files = hpf.FileName.Split(new char[] { '\\' });
FileName = files[files.Length - 1];
}
else
{
FileName = hpf.FileName;
}
if (hpf.ContentLength == 0)
{
continue;
}
//save file to album
flAlbum.StoreImagesInAlbum(hpf.InputStream, FileName, portalid, 44);
//add Image to DB
db.AddNewImage(albumid, FileName);
r.Add(new ViewDataUploadFilesResult()
{
Thumbnail_url = pathImgThumb + FileName,
Name = FileName,
Length = hpf.ContentLength,
Type = hpf.ContentType
});
}
e.Results = r;
}
}
private void Uploader_UploadFinished(object sender, UploadEventArgs e)
{
if (uploadProgress.IsOpen)
{
uploadProgress.Close();
if (_uploadingTo != null)
{
testTree.Selected = testTree.Selected;
_uploadingTo = null;
}
}
}
private void UpdateUploadStatus(UploadEventArgs e)
{
int itemsUploaded = _uploader.ItemsUploaded + 1;
if (itemsUploaded > _uploader.ItemsTotal)
{
itemsUploaded = _uploader.ItemsTotal;
}
itemsCopied.Text = "Copying file " + itemsUploaded.ToString() + " of " + _uploader.ItemsTotal.ToString();
progressText.Text = "Uploading " + e.Text + "...";
progressBar.Text = Math.Round(e.Progress) + "%";
progressBar.Complete = e.Progress;
CenterText();
}
public override void BeginUpload(UploadEventArgs args)
{
if (args == null)
{
throw new ArgumentNullException("args");
}
try
{
_uploadEventArgs = args;
_uploadEventArgs.UploadItem.SetResumeAction(ProcessUpload);
_uploadStream = args.UploadItem.FileInfo.OpenRead();
_uploadEventArgs.BeginUpload();
}
catch (Exception ex)
{
Exception = new UploadException("Response Callback Exception", ex);
_uploadEventArgs.UploadCompleted(Exception);
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
ClearResult();
try
{
string message = null;
DataTable dt = new DataTable();
if (ExcelHelper.GetImportedDataTable(this.fileImport.PostedFile, Server.MapPath(""), out message, out dt, new Hashtable(), ValidationSchemaFile))
{
UploadEventArgs args = new UploadEventArgs {
ContentTable = dt
};
OnUpload(this, args);
}
else
{
if (!string.IsNullOrEmpty(message))
{
string[] errorMsg = message.Split('&');
AddErrorInfo(errorMsg[0]);
if (errorMsg.Length > 1)
{
string[] errorContent = errorMsg[1].Split('|');
for (int i = 0; i < errorContent.Length; i++)
{
AddErrorInfo(errorContent[i]);
}
}
}
}
}
catch (Exception ex)
{
ClearResult();
AddErrorInfo(ex.Message);
}
finally
{
HideUploadingModal();
}
}
void UCFileUpload1_OnUpload(object sender, EventArgs e)
{
UploadEventArgs ue = e as UploadEventArgs;
DataTable dtAdjustment = ue.ContentTable;
dtAdjustment.Columns["通知单号"].ColumnName = "NotificationNo";
dtAdjustment.Columns["零件号"].ColumnName = "PartNo";
dtAdjustment.Columns["工厂代码"].ColumnName = "PlantNo";
dtAdjustment.Columns["供应商DUNS"].ColumnName = "DUNS";
dtAdjustment.Columns["SAP存储区域代码"].ColumnName = "SLOCID";
dtAdjustment.Columns["Available调整值"].ColumnName = "AvailableAdjust";
dtAdjustment.Columns["QI调整值"].ColumnName = "QIAdjust";
dtAdjustment.Columns["Block调整值"].ColumnName = "BlockAdjust";
//StocktakeNotification notification = Service.GetNotification(new StocktakeNotification { NotificationCode = long.Parse(NotiID) });
//List<View_StocktakeResult> items = Service.GetStocktakeResult(new View_StocktakeResult { NotificationID = notification.NotificationID });
List <string> errorMsg = new List <string>();
//List<View_StocktakeResult> itemList = new List<View_StocktakeResult>();
bool hasError = false;
List <View_StocktakeItem> list = new List <View_StocktakeItem>();
for (int i = 0; i < dtAdjustment.Rows.Count; i++)
{
DataRow row = dtAdjustment.Rows[i];
string partNo = row["PartNo"].ToString();
string plantNo = row["PlantNo"].ToString();
string duns = row["DUNS"].ToString();
string notificationNo = row["NotificationNo"].ToString();
string sloc = row["SLOCID"].ToString();
StoreLocation location = this.StoreLocations.Find(s => string.Equals(s.LogisticsSysSLOC, sloc));
if (location == null)
{
string msg = string.Format("第{0}行存储区域不存在", i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
List <View_StocktakeItem> items = Service.QueryStocktakeItem(
new View_StocktakeItem
{
PartCode = partNo,
PartPlantCode = plantNo,
DUNS = duns,
LogisticsSysSLOC = sloc,
NotificationCode = notificationNo
});
if (items == null || items.Count == 0)
{
string msg = string.Format("第{0}行零件不在盘点通知单中", i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
items[0].AvailableAdjust = (row["AvailableAdjust"] == DBNull.Value) ? 0 : Convert.ToInt32(row["AvailableAdjust"]);
items[0].QIAdjust = (row["QIAdjust"] == DBNull.Value) ? 0 : Convert.ToInt32(row["QIAdjust"]);
items[0].BlockAdjust = (row["BlockAdjust"] == DBNull.Value) ? 0 : Convert.ToInt32(row["BlockAdjust"]);
list.Add(items[0]);
}
}
}
if (!hasError)
{
Service.ImportAdjustment(list);
BindDataControl(gvItems, dtAdjustment);
//show information
this.UCFileUpload1.AddSuccessInfo("上传文件成功", string.Empty, string.Empty);
}
}
void UploadCreated(object sender, UploadEventArgs e)
{
Active.Add(new UploadViewModel(this, e.Upload));
OnLogUpdate(new LogEventArgs(DateTime.Now, String.Format("'{0}' ({1}) added to queue", e.Upload.FileName, UploaderViewModel.SizeFormatter(e.Upload.Size))));
}
void _uploader_UploadProgressChange(object sender, UploadEventArgs e)
{
//_locator.LoggerViewModel.AddLog("Upload progress change");
}
void UCFileUpload1_OnUpload(object sender, EventArgs e)
{
UploadEventArgs ue = e as UploadEventArgs;
DataTable dtSGMStocktakeItem = ue.ContentTable;
dtSGMStocktakeItem.Columns["序号"].ColumnName = "RowNumber";
dtSGMStocktakeItem.Columns["零件号"].ColumnName = "PartNo";
dtSGMStocktakeItem.Columns["工厂"].ColumnName = "Plant";
dtSGMStocktakeItem.Columns["库位"].ColumnName = "Store";
dtSGMStocktakeItem.Columns["线旁"].ColumnName = "Line";
dtSGMStocktakeItem.Columns["加工区"].ColumnName = "Machining";
dtSGMStocktakeItem.Columns["存储区域"].ColumnName = "SLOC";
dtSGMStocktakeItem.Columns["起始CSN"].ColumnName = "StartCSN";
dtSGMStocktakeItem.Columns["终止CSN"].ColumnName = "EndCSN";
dtSGMStocktakeItem.DefaultView.Sort = "PartNo";
dtSGMStocktakeItem = dtSGMStocktakeItem.DefaultView.ToTable();
StocktakeNotification notification = Service.GetNotification(new StocktakeNotification {
NotificationID = long.Parse(NotiID)
});
List <View_StocktakeResult> items = new List <View_StocktakeResult>();
int userID = CurrentUser.UserInfo.UserID;
List <string> errorMsg = new List <string>();
List <View_StocktakeResult> itemList = new List <View_StocktakeResult>();
bool hasError = false;
for (int i = 0; i < dtSGMStocktakeItem.Rows.Count; i++)
{
DataRow row = dtSGMStocktakeItem.Rows[i];
string partNo = row["PartNo"].ToString();
string plantCode = row["Plant"].ToString();
string duns = row["DUNS"].ToString();
string sloc = row["SLOC"].ToString();
StoreLocation location = this.StoreLocations.Find(l => l.LogisticsSysSLOC == sloc);
if (location == null)
{
string msg = string.Format("存储区域【{0}】不存在", sloc);// i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
continue;
}
if (i % 1000 == 0)
{
string startCode = partNo;
int end = i + 999;
if (end >= dtSGMStocktakeItem.Rows.Count)
{
end = dtSGMStocktakeItem.Rows.Count - 1;
}
string endCode = dtSGMStocktakeItem.Rows[end]["PartNo"].ToString();
items = Service.GetStocktakeResultOfScope(new View_StocktakeResult {
NotificationID = notification.NotificationID
}, startCode, endCode);
}
View_StocktakeResult result = null;
if (result == null)
{
result = items.Find(r => r.PartCode == partNo && r.PartPlantCode == plantCode && r.DUNS == duns && r.SGMLocationID != null && r.SGMLocationID == location.LocationID);// && r.SGMItemID != null);
}
if (result == null)
{
result = items.Find(r => r.PartCode == partNo && r.PartPlantCode == plantCode && r.DUNS == duns && r.RepairLocationID != null && r.RepairLocationID == location.LocationID);//&& r.RepairItemID != null);
}
if (result == null)
{
result = items.Find(r => r.PartCode == partNo && r.PartPlantCode == plantCode && r.DUNS == duns && r.CSMTLocationID != null && r.CSMTLocationID == location.LocationID);//&& r.CSMTItemID != null);
}
if (result == null)
{
result = items.Find(r => r.PartCode == partNo && r.PartPlantCode == plantCode && r.DUNS == duns && r.GeneralItemID != null && r.GeneralItemID == location.LocationID);//&& r.CSMTItemID != null);
}
if (result == null)
{
result = items.FirstOrDefault(r => r.PartCode == partNo && r.PartPlantCode == plantCode && r.DUNS == duns && r.RDCLocationID != null && r.RDCLocationID == location.LocationID);//&& r.RDCItemID != null);
}
if (result == null)
{
string msg = string.Format("工厂【{0}】，DUNS【{1}】，存储区域为【{2}】的零件【{3}】不在盘点通知单中", plantCode, duns, sloc, partNo);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
string csmtDUNS = CurrentUser.UserInfo.ConsignmentDUNS;
View_StocktakeResult result1 = null;
result1 = items.Find(r => r.PartCode == partNo && r.PartPlantCode == plantCode && r.DUNS == duns && r.CSMTLocationID != null && r.CSMTLocationID == location.LocationID);
if (string.IsNullOrEmpty(csmtDUNS) && (result1 != null))
{
string msg = string.Format("当前用户无权导入工厂【{0}】，DUNS【{1}】，存储区域为【{2}】的零件【{3}】", plantCode, duns, sloc, partNo);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
if (!string.IsNullOrEmpty(csmtDUNS) && !items.Exists(r => r.PartCode == partNo && r.PartPlantCode == plantCode && r.DUNS == duns && string.Equals(r.CSMTDUNS, csmtDUNS)))
{
string msg = string.Format("当前用户无权导入工厂【{0}】，DUNS【{1}】，存储区域为【{2}】的零件【{3}】", plantCode, duns, sloc, partNo);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
View_StocktakeResult result2 = null;
result2 = items.Find(r => r.PartCode == partNo && r.PartPlantCode == plantCode && r.DUNS == duns && r.SGMLocationID != null && r.SGMLocationID == location.LocationID);
if ((CurrentUser.UserInfo.Workshop == null) && (result2 != null))
{
string msg = string.Format("当前用户无权导入当前车间，工厂【{0}】，DUNS【{1}】，存储区域为【{2}】的零件【{3}】的实盘结果", plantCode, duns, sloc, partNo);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
if (!hasError)
{
decimal?available = SGM.Common.Utility.Utils.GetDecimalDbCell(row["Available"]);
decimal?qi = SGM.Common.Utility.Utils.GetDecimalDbCell(row["QI"]);
decimal?block = SGM.Common.Utility.Utils.GetDecimalDbCell(row["Block"]);
WorkshopStocktakeDetail detail = null;
if (CurrentUser.UserInfo.Workshop != null)
{
detail =
result.WorkshopDetails.FirstOrDefault(d => d.WorkshopCode == CurrentUser.UserInfo.Workshop.WorkshopCode);
}
if (result.SGMItemID != null && result.SGMLocationID == location.LocationID && CurrentUser.UserInfo.Workshop != null && detail != null)
{
for (int j = result.WorkshopDetails.Count - 1; j >= 0; j--)
{
if (result.WorkshopDetails[j].ItemDetailID != detail.ItemDetailID)
{
result.WorkshopDetails.RemoveAt(j);
}
}
detail.SGMFillinBy = userID;
detail.SGMBlock = block;
detail.SGMQI = qi;
detail.Line = SGM.Common.Utility.Utils.GetDecimalDbCell(row["Line"]);
detail.Machining = SGM.Common.Utility.Utils.GetDecimalDbCell(row["Machining"]);
detail.Store = SGM.Common.Utility.Utils.GetDecimalDbCell(row["Store"]);
if (row["StartCSN"] != DBNull.Value && row["StartCSN"] + "" != string.Empty)
{
detail.StartCSN = row["StartCSN"].ToString();
}
if (row["EndCSN"] != DBNull.Value && row["EndCSN"] + "" != string.Empty)
{
detail.EndCSN = row["EndCSN"].ToString();
}
}
else
{
if (result.CSMTItemID != null && result.CSMTLocationID == location.LocationID)
{
result.CSMTFillinBy = userID;
result.CSMTAvailable = available;
result.CSMTBlock = block;
result.CSMTQI = qi;
}
else
{
if (result.RepairItemID != null && result.RepairLocationID == location.LocationID)
{
result.RepairFillinBy = userID;
result.RepairAvailable = available;
result.RepairBlock = block;
result.RepairQI = qi;
}
else
{
if (result.GeneralItemID != null && result.GenerLocationID == location.LocationID)
{
result.GenFillinBy = userID;
result.GeneralAvailable = available;
result.GeneralBlock = block;
result.GeneralQI = qi;
}
else
{
if (result.RDCItemID != DefaultValue.LONG && result.RDCLocationID == location.LocationID)
{
result.RDCFillinBy = userID;
result.RDCAvailable = available;
result.RDCBlock = block;
result.RDCQI = qi;
}
}
}
}
}
//result.SGMBlock = int.Parse(dtSGMStocktakeItem.Rows[i]["Block"].ToString());
itemList.Add(result);
}
}
}
if (!hasError)
{
//List<View_StocktakeResult> tmpList = new List<View_StocktakeResult>();
//string cacheKey = string.Empty;
//while (itemList.Count > 0)
//{
// tmpList.Clear();
// tmpList.AddRange(itemList.Take((itemList.Count < 20) ? itemList.Count : 20));
// itemList.RemoveRange(0, (itemList.Count < 20) ? itemList.Count : 20);
// if (itemList.Count > 0)
// {
// cacheKey = Service.ImportResult(notification, tmpList, cacheKey, false);
// }
// else
// {
// Service.ImportResult(notification, tmpList, cacheKey, true);
// }
// //fill in items
//}
Service.FillStocktakeResult(notification, itemList);
BindDataControl(gvItems, dtSGMStocktakeItem);
//show information
this.UCFileUpload1.AddSuccessInfo("上传文件成功", string.Empty, string.Empty);
}
}
private void Uploader_UploadFinished(object sender, UploadEventArgs e)
{
if (uploadProgress.IsOpen)
{
uploadProgress.Close();
if (_uploadingTo != null)
{
testTree.Selected = testTree.Selected;
_uploadingTo = null;
}
}
}
void UCFileUpload1_OnUpload(object sender, EventArgs e)
{
UploadEventArgs ue = e as UploadEventArgs;
DataTable dtStorelocaiton = ue.ContentTable;
dtStorelocaiton.Columns["序号"].ColumnName = "No";
dtStorelocaiton.Columns["存储区域名称"].ColumnName = "LocationName";
dtStorelocaiton.Columns["区域类型"].ColumnName = "TypeID";
dtStorelocaiton.Columns["Available"].ColumnName = "Available";
dtStorelocaiton.Columns["QI"].ColumnName = "QI";
dtStorelocaiton.Columns["Block"].ColumnName = "Block";
dtStorelocaiton.Columns["物流系统存储区域"].ColumnName = "LogisticsSysSLOC";
bool hasError = false;
List <S_StoreLocation> recordList = new List <S_StoreLocation>();
for (int i = 0; i < dtStorelocaiton.Rows.Count; i++)
{
S_StoreLocation storeloc = new S_StoreLocation();
if (dtStorelocaiton.Rows[i]["LocationName"] != DBNull.Value)
{
storeloc.LocationName = dtStorelocaiton.Rows[i]["LocationName"].ToString();
}
if (dtStorelocaiton.Rows[i]["TypeID"] != DBNull.Value)
{
storeloc.TypeID = Convert.ToInt32(dtStorelocaiton.Rows[i]["TypeID"]);
}
if (dtStorelocaiton.Rows[i]["Available"] != DBNull.Value)
{
storeloc.AvailableIncluded = Convert.ToInt32(dtStorelocaiton.Rows[i]["Available"]);
}
if (dtStorelocaiton.Rows[i]["QI"] != DBNull.Value)
{
storeloc.QIIncluded = Convert.ToInt32(dtStorelocaiton.Rows[i]["QI"]);
}
if (dtStorelocaiton.Rows[i]["Block"] != DBNull.Value)
{
storeloc.BlockIncluded = Convert.ToInt32(dtStorelocaiton.Rows[i]["Block"]);
}
if (dtStorelocaiton.Rows[i]["LogisticsSysSLOC"] != DBNull.Value)
{
storeloc.LogisticsSysSLOC = dtStorelocaiton.Rows[i]["LogisticsSysSLOC"].ToString();
StoreLocation store = this.StoreLocations.SingleOrDefault(s => string.Equals(s.LogisticsSysSLOC, storeloc.LogisticsSysSLOC));
CacheHelper.RemoveCache(Consts.CACHE_KEY_STORE_LOCATION);
if (store != null)
{
string msg = string.Format("第{0}行，该物流系统存储区域已存在", i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
}
if (!recordList.Exists(r => r.LocationName == storeloc.LocationName && r.LogisticsSysSLOC == storeloc.LogisticsSysSLOC))
{
recordList.Add(storeloc);
}
else
{
string msg = string.Format("存储区域名称{0}，物流系统存储区域{1}重复", storeloc.LocationName, storeloc.LogisticsSysSLOC);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
}
if (!hasError)
{
Service.ImportStoreLocation(recordList);
BindDataControl(gvStorelocation, dtStorelocaiton);
this.UCFileUpload1.AddSuccessInfo("上传文件成功", string.Empty, string.Empty);
}
}
private async void uploadService_UploadCompleted(object sender, UploadEventArgs e)
{
App.FeedLastRefreshed = DateTime.MinValue;
var upload = e.Upload;
if (upload.UploadInfo.Exception != null)
{
Dispatcher.BeginInvoke(() =>
{
upload.UploadInfo.IsUploaded = false;
upload.UploadInfo.IsUploading = false;
upload.UploadInfo.Failed = true;
if (upload.UploadInfo.Exception != null)
{
errorMsg.Text = upload.UploadInfo.Exception.Message;
if (upload.UploadInfo.Exception.Message != "Upload stopped")
{
m_numFailed++;
}
}
});
}
else
{
if (upload.UploadInfo.StatusCode == HttpStatusCode.NoContent)
{
Dispatcher.BeginInvoke(async() =>
{
m_wasLocked = false;
countUploaded++;
UpdateTotalStatus();
upload.UploadInfo.PercentageDone = e.Progress;
upload.UploadInfo.IsUploaded = true;
upload.UploadInfo.IsUploading = false;
upload.UploadInfo.Failed = false;
await RemoveUpload(upload);
});
}
else if (upload.UploadInfo.StatusCode == HttpStatusCode.Unauthorized)
{
Dispatcher.BeginInvoke(() =>
{
m_numFailed++;
SetFailed(upload, upload.UploadInfo.StatusCode);
errorMsg.Text = m_numFailed + " Login failed";
upload.UploadInfo.Failed = true;
});
}
else
{
Dispatcher.BeginInvoke(() =>
{
m_numFailed++;
SetFailed(upload, upload.UploadInfo.StatusCode);
errorMsg.Text = m_numFailed + " Upload(s) failed (Code " + (int)upload.UploadInfo.StatusCode + ")";
upload.UploadInfo.Failed = true;
});
}
}
if (!m_ispaused)
{
await ProcessQueue();
}
}
protected void ucFileUpload_Upload(object sender, EventArgs e)
{
List <long> notiList = new List <long>();
foreach (GridViewRow row in gvNotification.Rows)
{
if (gvNotification.DataKeys[row.RowIndex] != null)
{
CheckBox cbSelect = row.FindControl("cbNotiSelect") as CheckBox;
if (cbSelect.Checked)
{
long notiID = (long)gvNotification.DataKeys[row.RowIndex]["NotificationID"];
notiList.Add(notiID);
}
}
}
if (notiList.Count == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "selectNotiMsg", "alert('请选择通知单');", true);
return;
}
UploadEventArgs ue = e as UploadEventArgs;
DataTable dtDetails = ue.ContentTable;
dtDetails.DefaultView.Sort = "零件号";
dtDetails = dtDetails.DefaultView.ToTable();
bool isValid = true;
List <ViewPart> partList = new List <ViewPart>();
//get part by code, plant, duns
for (int i = 0; i < dtDetails.Rows.Count; i++)
{
ViewPart tmpPart = new ViewPart
{
PlantCode = dtDetails.Rows[i]["工厂代码"].ToString(),
DUNS = dtDetails.Rows[i]["供应商DUNS"].ToString(),
PartCode = dtDetails.Rows[i]["零件号"].ToString()
};
if (!partList.Exists(p => p.PartCode == tmpPart.PartCode && p.PlantCode == tmpPart.PlantCode && p.DUNS == tmpPart.DUNS))
{
partList.Add(tmpPart);
}
}
//partList = Service.QueryPartsByKey(partList);
List <View_StocktakeDetails> detailsList = new List <View_StocktakeDetails>();
for (int i = 0; i < dtDetails.Rows.Count; i++)
{
bool hasError = false;
View_StocktakeDetails details = new View_StocktakeDetails
{
PartCode = dtDetails.Rows[i]["零件号"].ToString(),
DUNS = dtDetails.Rows[i]["供应商DUNS"].ToString(),
PartPlantCode = dtDetails.Rows[i]["工厂代码"].ToString(),
UnRecorded = dtDetails.Rows[i]["未入账"] + ""
};
details.Wip = SGM.Common.Utility.Utils.GetDecimalDbCell(dtDetails.Rows[i]["Wip"]);
details.M080 = SGM.Common.Utility.Utils.GetDecimalDbCell(dtDetails.Rows[i]["M080"]);
string msg;
if (i % 5000 == 0)
{
string startCode = details.PartCode;
int end = i + 4999;
if (end >= dtDetails.Rows.Count)
{
end = dtDetails.Rows.Count - 1;
}
string endCode = dtDetails.Rows[end]["零件号"].ToString();
partList = Service.QueryPartCodeScope(null, startCode, endCode);
}
ViewPart part = partList.FirstOrDefault(p => p.PartCode == details.PartCode && p.PlantCode == details.PartPlantCode && p.DUNS == details.DUNS);
if (part == null)//part is invalid
{
msg = string.Format("工厂为【{0}】，供应商为【{1}】的零件【{2}】不存在", details.PartPlantCode, details.DUNS, details.PartCode);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
details.PartID = part.PartID;
}
if (!hasError)
{
if (detailsList.Exists(d => d.PartPlantCode == details.PartPlantCode && d.DUNS == details.DUNS && string.Equals(d.PartCode, details.PartCode)))
{
msg = string.Format("工厂为【{0}】，供应商为【{1}】的零件【{2}】数据重复", details.PartPlantCode, details.DUNS, details.PartCode);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
detailsList.Add(details);
}
}
isValid = isValid && !hasError;
}
if (isValid)
{
Service.ImportAnalyseRef(detailsList, notiList);
BindDataControl(gvResult, detailsList);
//show information
this.UCFileUpload1.AddSuccessInfo("导入成功", string.Empty, string.Empty);
}
}
void UCFileUpload1_OnUpload(object sender, EventArgs e)
{
string noticeNo = txtNoticeNo.Text.Trim();
if (string.IsNullOrEmpty(noticeNo))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "selectNotiMsg", "alert('请选择通知单');", true);
return;
}
UploadEventArgs ue = e as UploadEventArgs;
DataTable dtStorage = ue.ContentTable;
dtStorage.Columns["序号"].ColumnName = "No";
dtStorage.Columns["零件号"].ColumnName = "PartNo";
dtStorage.Columns["工厂代码"].ColumnName = "PlantCode";
dtStorage.Columns["物流系统存储区域"].ColumnName = "StoreLocation";
dtStorage.Columns["系统Available"].ColumnName = "Available";
dtStorage.Columns["系统QI"].ColumnName = "QI";
dtStorage.Columns["系统Block"].ColumnName = "Block";
dtStorage.Columns["单价"].ColumnName = "Price";
bool hasError = false;
List <S_StorageRecord> recordList = new List <S_StorageRecord>();
List <ViewPart> partList = new List <ViewPart>();
List <View_StocktakeDetails> stocktakeDetails = new List <View_StocktakeDetails>();
dtStorage.DefaultView.Sort = "PartNo";
dtStorage = dtStorage.DefaultView.ToTable();
//get part by code, plant
List <StorageRecordView> storageRecords = new List <StorageRecordView>();
for (int i = 0; i < dtStorage.Rows.Count; i++)
{
StorageRecordView record = new StorageRecordView
{
PartCode = dtStorage.Rows[i]["PartNo"].ToString(),
PlantCode = dtStorage.Rows[i]["PlantCode"].ToString(),
SLOC = dtStorage.Rows[i]["StoreLocation"].ToString()
};
if (!storageRecords.Exists(r => r.PartCode == record.PartCode && r.PlantCode == record.PlantCode && r.SLOC == record.SLOC))
{
storageRecords.Add(record);
}
else
{
string msg = string.Format("库存信息零件号{0}，工厂{1}，存储区域{2}重复", record.PartCode, record.PlantCode, record.SLOC);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
}
storageRecords.Clear();
if (!hasError)
{
//partList = Service.QueryPartsByCodePlant(partList);//Key(partList);
for (int i = 0; i < dtStorage.Rows.Count; i++)
{
if (i % 5000 == 0)
{
string startCode = dtStorage.Rows[i]["PartNo"].ToString();
int end = i + 4999;
if (end >= dtStorage.Rows.Count)
{
end = dtStorage.Rows.Count - 1;
}
//View_StocktakeDetails filterStocktakeDetails = new View_StocktakeDetails { NotificationCode = noticeNo };
string endCode = dtStorage.Rows[end]["PartNo"].ToString();
partList = Service.QueryPartCodeScope(null, startCode, endCode);
stocktakeDetails = Service.QueryStocktakeDetailsScope(new View_StocktakeDetails {
NotificationCode = noticeNo
}, startCode, endCode);
}
string sloc = dtStorage.Rows[i]["StoreLocation"].ToString();
StoreLocation storeLocation = this.StoreLocations.FirstOrDefault(l => l.LogisticsSysSLOC == sloc);
if (storeLocation == null) //storeLocation invalid
{
string msg = string.Format("物流系统存储区域【{0}】不存在", sloc); //i + 2,
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
View_StocktakeDetails tmpStocktakeDetails = new View_StocktakeDetails
{
PartCode = dtStorage.Rows[i]["PartNo"].ToString(),
NotificationCode = noticeNo
};
List <View_StocktakeDetails> tmpStocktakeDetailsList = stocktakeDetails.Where(s => s.NotificationCode == tmpStocktakeDetails.NotificationCode && s.PartCode == tmpStocktakeDetails.PartCode).ToList();
//if (tmpStocktakeDetailsList == null || tmpStocktakeDetailsList.Count == 0)
//{
// string msg = string.Format("通知单【{0}】中不存在零件【{1}】", tmpStocktakeDetails.NotificationCode, tmpStocktakeDetails.PartCode);
// UCFileUpload1.AddErrorInfo(msg);
// hasError = true;
//}
ViewPart tmpPart = new ViewPart
{
PlantCode = dtStorage.Rows[i]["PlantCode"].ToString(),
//DUNS = dtStorage.Rows[i]["DUNS"].ToString(),
PartCode = dtStorage.Rows[i]["PartNo"].ToString()
};
//ViewPart part = partList.SingleOrDefault(p => p.PartCode == tmpPart.PartCode && p.PlantCode == tmpPart.PlantCode && p.DUNS == tmpPart.DUNS);
List <ViewPart> tmpPartList = partList.Where(p => p.PartCode == tmpPart.PartCode && p.PlantCode == tmpPart.PlantCode).ToList();
//if (part == null)//part is invalid
if (tmpPartList == null || tmpPartList.Count == 0)
{
//string msg = string.Format("工厂【{0}】中不存在零件【{1}】", tmpPart.PlantCode, tmpPart.PartCode);// i + 2,
//UCFileUpload1.AddErrorInfo(msg);
//hasError = true;
}
else
{
//storeLocation is valid
if (storeLocation != null)
{
foreach (var part in tmpPartList)
{
S_StorageRecord tmpRecord = new S_StorageRecord
{
SLOCID = storeLocation.LocationID,
PartID = part.PartID
};
tmpRecord.Available = SGM.Common.Utility.Utils.GetDecimalDbCell(dtStorage.Rows[i]["Available"]);
tmpRecord.QI = SGM.Common.Utility.Utils.GetDecimalDbCell(dtStorage.Rows[i]["QI"]);
tmpRecord.Block = SGM.Common.Utility.Utils.GetDecimalDbCell(dtStorage.Rows[i]["Block"]);
tmpRecord.Price = SGM.Common.Utility.Utils.GetDecimalDbCell(dtStorage.Rows[i]["Price"]);
if (tmpStocktakeDetailsList == null || tmpStocktakeDetailsList.Count == 0)
{
tmpRecord.DetailsID = 0;
}
else
{
tmpRecord.DetailsID = Convert.ToInt32(tmpStocktakeDetailsList.FirstOrDefault().DetailsID);
recordList.Add(tmpRecord);
}
}
}
}
}
}
if (!hasError)
{
//fill in items
Service.ImportStorage(recordList);
BindDataControl(gvStoreage, dtStorage);
//show information
this.UCFileUpload1.AddSuccessInfo("上传文件成功", string.Empty, string.Empty);
}
}
private void OnUploadAssembly(UploadEventArgs e)
{
SetText(string.Format("Assembly {0} saved on server recieved from {1}", e.AssemblyName, e.FromClientId), MessageType.Success);
}
private static void SomeClass_UploadProgress(object sender, UploadEventArgs e)
{
string s = string.Format("sending file data {0:0.000}%", (e.BytesSoFar * 100.0f) / e.TotalToUpload);
Console.WriteLine(s);
}
public abstract void BeginUpload(UploadEventArgs args);
public void Upload_Success(object sender, UploadEventArgs e)
{
}
void UCFileUpload1_OnUpload(object sender, EventArgs e)
{
UploadEventArgs ue = e as UploadEventArgs;
DataTable dtPartConsignment = ue.ContentTable;
dtPartConsignment.Columns["序号"].ColumnName = "RowNumber";
dtPartConsignment.Columns["工厂"].ColumnName = "PlantCode";
dtPartConsignment.Columns["外协零件号"].ColumnName = "PartCode";
dtPartConsignment.Columns["供应商DUNS"].ColumnName = "DUNS";
dtPartConsignment.Columns["外协供应商DUNS"].ColumnName = "CDUNS";
dtPartConsignment.Columns["外协供应商名称"].ColumnName = "SupplierName";
dtPartConsignment.Columns["电话"].ColumnName = "Telephone";
dtPartConsignment.Columns["传真"].ColumnName = "Fax";
bool hasError = false;
List <View_ConsignmentPart> partlist = new List <View_ConsignmentPart>();
for (int i = 0; i < dtPartConsignment.Rows.Count; i++)
{
View_ConsignmentPart partCRecord = new View_ConsignmentPart();
Supplier supplier = this.Suppliers.SingleOrDefault(s => string.Equals(s.DUNS, dtPartConsignment.Rows[i]["CDUNS"].ToString().Trim()));
if (supplier == null)
{
string msg = string.Format("第{0}行，该外协供应商DUNS不存在", i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
partCRecord.ConsignmentSupplier = supplier.SupplierID;
}
Part part = new Part();
List <ViewPart> list = new List <ViewPart>();
part.PartCode = dtPartConsignment.Rows[i]["PartCode"].ToString();
part.Plant = new Plant();
part.Plant.PlantCode = dtPartConsignment.Rows[i]["PlantCode"] + "";
part.Supplier = new Supplier();
part.Supplier.DUNS = dtPartConsignment.Rows[i]["DUNS"] + "";
list = this.Service.QueryParts(part);
if (list.Count <= 0)
{
string msg = string.Format("第{0}行，该零件不存在", i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
partCRecord.PartID = list[0].PartID;
partCRecord.PartCode = dtPartConsignment.Rows[i]["PartCode"].ToString();
partCRecord.DUNS = dtPartConsignment.Rows[i]["DUNS"].ToString();
partlist.Add(partCRecord);
}
}
if (!hasError)
{
Service.ImportConsignmentRecord(partlist);
BindDataControl(gvConsignmentPartRecord, dtPartConsignment);
this.UCFileUpload1.AddSuccessInfo("上传文件成功", string.Empty, string.Empty);
}
}
protected void ucFileUpload_Upload(object sender, EventArgs e)
{
UploadEventArgs ue = e as UploadEventArgs;
DataTable dtDetails = ue.ContentTable;
dtDetails.DefaultView.Sort = "零件号";
dtDetails = dtDetails.DefaultView.ToTable();
bool isValid = true;
List <ViewPart> partList = new List <ViewPart>();
//get part by code, plant, duns
//for (int i = 0; i < dtDetails.Rows.Count; i++)
//{
// ViewPart tmpPart = new ViewPart
// {
// PlantCode = dtDetails.Rows[i]["工厂代码"].ToString(),
// DUNS = dtDetails.Rows[i]["供应商DUNS"].ToString(),
// PartCode = dtDetails.Rows[i]["零件号"].ToString()
// };
// if (!partList.Exists(p => string.Equals(p.PartCode , tmpPart.PartCode, StringComparison.OrdinalIgnoreCase) && string.Equals(p.PlantCode ,tmpPart.PlantCode , StringComparison.OrdinalIgnoreCase)&& string.Equals(p.DUNS ,tmpPart.DUNS, StringComparison.OrdinalIgnoreCase)))
// {
// partList.Add(tmpPart);
// }
//}
List <View_StocktakeDetails> detailsList = new List <View_StocktakeDetails>();
for (int i = 0; i < dtDetails.Rows.Count; i++)
{
bool hasError = false;
View_StocktakeDetails details = new View_StocktakeDetails
{
RowNumber = int.Parse(dtDetails.Rows[i]["序号"].ToString()),
PartCode = dtDetails.Rows[i]["零件号"].ToString(),
DUNS = dtDetails.Rows[i]["供应商DUNS"].ToString(),
PartPlantCode = dtDetails.Rows[i]["工厂代码"].ToString(),
TypeName = dtDetails.Rows[i]["申请类别"].ToString(),
PriorityName = dtDetails.Rows[i]["紧急程度"].ToString(),
Description = dtDetails.Rows[i]["备注"].ToString()
};
string msg;
if (i % 5000 == 0)
{
string startCode = details.PartCode;
int end = i + 4999;
if (end >= dtDetails.Rows.Count)
{
end = dtDetails.Rows.Count - 1;
}
string endCode = dtDetails.Rows[end]["零件号"].ToString();
partList = Service.QueryPartCodeScope(null, startCode, endCode);
}
ViewPart part = partList.FirstOrDefault(p => string.Equals(p.PartCode, details.PartCode, StringComparison.OrdinalIgnoreCase) && string.Equals(p.PlantCode, details.PartPlantCode, StringComparison.OrdinalIgnoreCase) && string.Equals(p.DUNS, details.DUNS, StringComparison.OrdinalIgnoreCase));
if (part == null)//part is invalid
{
msg = string.Format("第{0}行，该零件不存在", i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
details.PartID = part.PartID;
}
StocktakePriority priority = Priorities.FirstOrDefault(p => string.Equals(p.PriorityName, details.PriorityName, StringComparison.OrdinalIgnoreCase));
if (priority == null)
{
msg = string.Format("第{0}行，紧急程度信息非法", i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
details.Priority = priority.PriorityID;
}
StocktakeType type = StocktakeTypes.FirstOrDefault(t => string.Equals(t.TypeName, details.TypeName, StringComparison.OrdinalIgnoreCase));
if (type == null)
{
msg = string.Format("第{0}行，申请类别信息非法", i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
details.StocktakeType = type.TypeID;
}
if (!hasError)
{
if (detailsList.Exists(d => string.Equals(d.TypeName, details.TypeName, StringComparison.OrdinalIgnoreCase) && string.Equals(d.PriorityName, details.PriorityName, StringComparison.OrdinalIgnoreCase) && string.Equals(d.PartPlantCode, details.PartPlantCode, StringComparison.OrdinalIgnoreCase) && string.Equals(d.DUNS, details.DUNS, StringComparison.OrdinalIgnoreCase) && string.Equals(d.PartCode, details.PartCode, StringComparison.OrdinalIgnoreCase)))
{
msg = string.Format("第{0}行，数据重复", i + 2);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
}
else
{
detailsList.Add(details);
}
}
isValid = isValid && !hasError;
}
if (isValid)
{
NewStocktakeRequest newRequest = new NewStocktakeRequest
{
IsStatic = (rblIsStatic.SelectedIndex == 1),
RequestBy = CurrentUser.UserInfo.UserID,
IsCycleCount = false,
Details = (from d in detailsList
select new NewStocktakeDetails
{
PartID = d.PartID.ToString(),
StocktakePriority = d.Priority.Value,
StocktakeTypeID = d.StocktakeType.Value,
Description = d.Description
}).ToList()
};
int currentDynAmount = 0;
int currentStAmount = 0;
foreach (var item in UserGroups)
{
currentDynAmount += item.CurrentDynamicStocktake ?? 0;
currentStAmount += item.CurrentStaticStocktake ?? 0;
}
int maxUserCount;
int currentCount;
int maxCount;
if (!newRequest.IsStatic)
{
BizParams param = BizParamsList.Find(p => p.ParamKey == "MaxDynamic");
maxCount = int.Parse(param.ParamValue);
maxUserCount = CurrentUser.UserInfo.UserGroup.MaxDynamicStocktake ?? 0;
currentCount = CurrentUser.UserInfo.UserGroup.CurrentDynamicStocktake.Value;
int dynOverflowAmount = currentCount + newRequest.Details.Count - maxUserCount;
if (dynOverflowAmount > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "maxOverflow", "alert('超过当前用户组动态盘点上限" + dynOverflowAmount + "个')", true);
return;
}
dynOverflowAmount = currentDynAmount + newRequest.Details.Count - maxCount;
if (dynOverflowAmount > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "maxOverflow", "alert('超过动态盘点总数上限" + dynOverflowAmount + "个')", true);
return;
}
}
if (newRequest.IsStatic)
{
BizParams param = BizParamsList.Find(p => p.ParamKey == "MaxStatic");
maxCount = int.Parse(param.ParamValue);
maxUserCount = CurrentUser.UserInfo.UserGroup.MaxStaticStocktake.Value;
currentCount = CurrentUser.UserInfo.UserGroup.CurrentStaticStocktake.Value;
int stOverflowAmount = currentCount + newRequest.Details.Count - maxUserCount;
if (stOverflowAmount > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "maxOverflow", "alert('超过当前用户组静态盘点上限" + stOverflowAmount + "个')", true);
return;
}
stOverflowAmount = currentStAmount + newRequest.Details.Count - maxCount;
if (stOverflowAmount > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "maxOverflow", "alert('超过静态盘点总数上限" + stOverflowAmount + "个')", true);
return;
}
}
//fill in items
StocktakeRequest request = Service.RequestStocktake(newRequest);
BindDataControl(gvResult, detailsList);
CurrentUser.RefreshUserProfile();
CacheHelper.RemoveCache(Consts.CACHE_KEY_USER_GROUPS);
//show information
this.UCFileUpload1.AddSuccessInfo("盘点申请成功，申请单号" + request.RequestNumber, string.Empty, string.Empty);
}
}
private void UpdateUploadStatus(UploadEventArgs e)
{
int itemsUploaded = _uploader.ItemsUploaded + 1;
if (itemsUploaded > _uploader.ItemsTotal)
{
itemsUploaded = _uploader.ItemsTotal;
}
itemsCopied.Text = "Copying file " + itemsUploaded.ToString() + " of " + _uploader.ItemsTotal.ToString();
progressText.Text = "Uploading " + e.Text + "...";
progressBar.Text = Math.Round(e.Progress) + "%";
progressBar.Complete = e.Progress;
CenterText();
}
void _uploader_UploadedItem(object sender, UploadEventArgs e)
{
_locator.LoggerViewModel.AddLog("Upload new file");
RaisePropertyChange("ItemsTotal");
RaisePropertyChange("ItemsUploaded");
}
private void Uploader_UploadProgressChange(object sender, UploadEventArgs e)
{
UpdateUploadStatus(e);
}
void UCFileUpload1_OnUpload(object sender, EventArgs e)
{
UploadEventArgs ue = e as UploadEventArgs;
DataTable dtPart = ue.ContentTable;
dtPart.Columns["序号"].ColumnName = "RowNumber";
dtPart.Columns["零件号"].ColumnName = "PartCode";
dtPart.Columns["零件名称"].ColumnName = "PartChineseName";
dtPart.Columns["工位"].ColumnName = "WorkLocation";
dtPart.Columns["库位"].ColumnName = "Dloc";
dtPart.Columns["循环盘点级别"].ColumnName = "LevelName";
dtPart.Columns["已循环盘点次数"].ColumnName = "CycleCountTimes";
dtPart.Columns["车型"].ColumnName = "Specs";
dtPart.Columns["FollowUp"].ColumnName = "Followup";
dtPart.Columns["工厂"].ColumnName = "PlantCode";
dtPart.Columns["车间"].ColumnName = "Workshops";
dtPart.Columns["工段"].ColumnName = "Segments";
dtPart.Columns["物料类别"].ColumnName = "CategoryName";
dtPart.Columns["物料状态"].ColumnName = "StatusName";
dtPart.Columns["DUNS"].ColumnName = "DUNS";
dtPart.Columns.Add("UserName", typeof(string));
dtPart.DefaultView.Sort = "PartCode";
dtPart = dtPart.DefaultView.ToTable();
bool hasError = false;
List <ViewPart> partList = new List <ViewPart>();
List <ViewPart> list = new List <ViewPart>();
for (int i = 0; i < dtPart.Rows.Count; i++)
{
DataRow row = dtPart.Rows[i];
bool rowError = false;
ViewPart part = new ViewPart();
if (!BatchUpdate)
{
Plant plant = this.Plants.SingleOrDefault(p => string.Equals(p.PlantCode, dtPart.Rows[i]["PlantCode"].ToString(), StringComparison.OrdinalIgnoreCase));
CycleCountLevel cycleClevel = this.CycleCountLevels.SingleOrDefault(c => c.LevelName == dtPart.Rows[i]["LevelName"].ToString());
PartStatus partstatus = this.PartStatus.SingleOrDefault(p => p.StatusName == dtPart.Rows[i]["StatusName"].ToString());
Supplier supplier = this.Suppliers.SingleOrDefault(s => string.Equals(s.DUNS, dtPart.Rows[i]["DUNS"].ToString()));
part.PartCode = dtPart.Rows[i]["PartCode"].ToString();
if (supplier == null)
{
string msg = string.Format("零件【{0}】的供应商DUNS【{1}】不存在", part.PartCode, dtPart.Rows[i]["DUNS"] + "");
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
rowError = true;
}
else
{
part.SupplierID = supplier.SupplierID;
}
if (plant == null)
{
string msg = string.Format("零件【{0}】的工厂【{1}】不存在", part.PartCode, dtPart.Rows[i]["PlantCode"] + "");
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
rowError = true;
}
else
{
part.PlantID = plant.PlantID;
}
if (cycleClevel == null)
{
string msg = string.Format("零件【{0}】的循环盘点级别【{1}】不存在", part.PartCode, dtPart.Rows[i]["LevelName"] + "");
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
rowError = true;
}
else
{
part.CycleCountLevel = cycleClevel.LevelID;
}
if (dtPart.Rows[i]["CategoryName"] != DBNull.Value && !string.IsNullOrEmpty(dtPart.Rows[i]["CategoryName"].ToString().Trim()))
{
PartCategory partcategory = this.PartCategorys.SingleOrDefault(p => string.Equals(p.CategoryName, dtPart.Rows[i]["CategoryName"].ToString(), StringComparison.OrdinalIgnoreCase));
if (partcategory == null)
{
string msg = string.Format("零件【{0}】的物料类别【{1}】不存在", part.PartCode, dtPart.Rows[i]["CategoryName"] + "");
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
rowError = true;
}
else
{
part.CategoryID = partcategory.CategoryID;
}
}
if (partstatus == null)
{
string msg = string.Format("零件【{0}】的物料状态【{1}】不存在", part.PartCode, dtPart.Rows[i]["StatusName"] + "");
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
rowError = true;
}
else
{
part.PartStatus = partstatus.StatusID;
}
part.PartChineseName = dtPart.Rows[i]["PartChineseName"].ToString();
part.WorkLocation = dtPart.Rows[i]["WorkLocation"].ToString();
part.Dloc = dtPart.Rows[i]["Dloc"].ToString();
part.Specs = dtPart.Rows[i]["Specs"].ToString();
part.FollowUp = dtPart.Rows[i]["Followup"].ToString();
part.Workshops = dtPart.Rows[i]["Workshops"].ToString();
part.Segments = dtPart.Rows[i]["Segments"].ToString();
if (!string.IsNullOrEmpty(dtPart.Rows[i]["CycleCountTimes"].ToString()))
{
part.CycleCountTimes = short.Parse(dtPart.Rows[i]["CycleCountTimes"].ToString());
}
part.UpdateBy = CurrentUser.UserInfo.UserID;
dtPart.Rows[i]["UserName"] = CurrentUser.UserInfo.UserName;
}
else
{
string plantCode = row["PlantCode"] + "";
string partCode = row["PartCode"] + "";
string duns = row["DUNS"] + "";
//ViewPart tmpPart = new ViewPart { PlantCode = plantCode, PartCode = partCode, DUNS = duns };
if (i % 1000 == 0)
{
string startCode = partCode;
int end = i + 999;
if (end >= dtPart.Rows.Count)
{
end = dtPart.Rows.Count - 1;
}
string endCode = dtPart.Rows[end]["PartCode"].ToString();
list = Service.QueryPartsOfScope(startCode, endCode);
}
//List<ViewPart> list = new List<ViewPart> { tmpPart };
//list = Service.QueryPartsByKey(list);
part = list.Find(p => p.PartCode == partCode && p.PlantCode == plantCode && p.DUNS == duns);
if (part == null)//(list == null || list.Count == 0)
{
string msg = string.Format("工厂为【{0}】，供应商为【{1}】的零件【{2}】不存在", plantCode, duns, partCode);
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
rowError = true;
}
else
{
//part = list[0];
part.UpdateBy = CurrentUser.UserInfo.UserID;
switch (rblFields.SelectedIndex)
{
case 0:
part.FollowUp = row["Followup"].ToString();
break;
case 1:
part.Specs = row["Specs"].ToString();
break;
case 2:
part.Segments = row["Segments"].ToString();
part.WorkLocation = row["WorkLocation"].ToString();
if (row["CategoryName"] != DBNull.Value && !string.IsNullOrEmpty(row["CategoryName"].ToString().Trim()))
{
PartCategory partcategory = this.PartCategorys.SingleOrDefault(p => string.Equals(p.CategoryName, row["CategoryName"].ToString(), StringComparison.OrdinalIgnoreCase));
if (partcategory == null)
{
string msg = string.Format("零件【{0}】的物料类别【{1}】不存在", part.PartCode, row["CategoryName"] + "");
UCFileUpload1.AddErrorInfo(msg);
hasError = true;
rowError = true;
}
else
{
part.CategoryID = partcategory.CategoryID;
}
}
else
{
part.CategoryID = null;
}
break;
default:
break;
}
}
}
if (!rowError)
{
partList.Add(part);
}
}
if (!hasError)
{
Service.ImportPart(partList);
BindDataControl(gvParts, dtPart);
this.UCFileUpload1.AddSuccessInfo("上传文件成功", string.Empty, string.Empty);
}
}
static void img_UploadProgress(object sender, UploadEventArgs e)
{
Console.WriteLine("{1} - {0,5:N}", e.PercentComplete * 100, e.FileName);
}
public string UploadImages(HttpContext context)
{
var eventArgs = new UploadEventArgs<HttpContext>(context);
UploadProcess(this,eventArgs);
return eventArgs.Results.ToJson();
}
private void Uploader_UploadProgressChange(object sender, UploadEventArgs e)
{
UpdateUploadStatus(e);
}
/// <summary>
/// Upload complete
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void uploadComplete(object sender, Responses.UploadDone e)
{
if (UploadComplete != null)
{
CoPilot.Interfaces.UploadDone upload = new CoPilot.Interfaces.UploadDone();
upload.DeleteUrl = e.DeleteUrl;
upload.DownloadUrl = e.DownloadUrl;
upload.FileId = e.FileId;
upload.Status = e.Status;
UploadEventArgs args = new UploadEventArgs();
args.UploadDone = upload;
UploadComplete.Invoke(this, args);
}
}
