protected override object GetEditObject(Infragistics.WebUI.UltraWebGrid.UltraGridRow row) { if (_Facade == null) { _Facade = new MaterialFacade(base.DataProvider); } object obj = _Facade.GetMaterialReqStd(row.Cells[1].Text.ToString(), int.Parse(row.Cells[4].Text.ToString())); if (obj != null) { return((MaterialReqStd)obj); } return(null); }
protected void cmdImport_ServerClick(object sender, System.EventArgs e) { this._Facade = new MaterialFacade(this.DataProvider); string errorItemCode = string.Empty; string fileName = FileLoadProcess.UploadFile2ServerUploadFolder(this.Page, this.fileInit, null); if (fileName == null) { WebInfoPublish.Publish(this, "$Error_UploadFileIsEmpty", this.languageComponent1); return; } if (!fileName.ToLower().EndsWith(".csv")) { WebInfoPublish.Publish(this, "$Error_UploadFileTypeError", this.languageComponent1); return; } this.ViewState.Add("UploadedFileName", fileName); if (items == null) { items = GetAllItem(); if (items == null) { return; } } if (items == null || items.Length == 0) { return; } int successNum = 0; int failNum = 0; string objValue = string.Empty; string orgID = GlobalVariables.CurrentOrganizations.First().OrganizationID.ToString(); string mUser = GetUserCode(); for (int i = 0; i < items.Length; i++) { string itemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(GetFieldValue(items[i], "ITEMCODE"))); string requestQty = FormatHelper.CleanString(GetFieldValue(items[i], "RequestQTY")); if (string.Compare(GetFieldValue(items[i], "EAttribute1"), "OK", true) == 0 || string.Compare(GetFieldValue(items[i], "EAttribute1"), "Insert", true) == 0) { object obj = _Facade.GetMaterialReqStd(itemCode, int.Parse(orgID)); MaterialReqStd newMaterialReqStd = new MaterialReqStd(); if (string.Compare(GetFieldValue(items[i], "EAttribute1"), "Insert", true) == 0) { newMaterialReqStd.ItemCode = itemCode; newMaterialReqStd.OrganizationID = int.Parse(orgID); newMaterialReqStd.RequestQTY = int.Parse(requestQty); newMaterialReqStd.MaintainUser = mUser; _Facade.AddMaterialReqStd(newMaterialReqStd); } else { MaterialReqStd objMaterialReqStd = obj as MaterialReqStd; objValue = requestQty.ToString(); if (objValue != string.Empty) { objMaterialReqStd.RequestQTY = int.Parse(objValue); } objMaterialReqStd.MaintainUser = mUser; if (string.Compare(GetFieldValue(items[i], "EAttribute1"), "OK", true) == 0) { _Facade.UpdateMaterialReqStd(objMaterialReqStd); } } successNum++; } else { failNum++; errorItemCode += GetFieldValue(items[i], "ITEMCODE").ToString() + "\\n";; } } errorItemCode = "\\n导入失败的料号:\\n" + errorItemCode; string strMessage = "导入完成: 成功" + successNum + "笔, 失败" + failNum + "笔\\n" + errorItemCode; string alertInfo = string.Format("<script language=javascript>alert('{0}');</script>", strMessage); if (!this.IsClientScriptBlockRegistered("ImportAlert")) { this.RegisterClientScriptBlock("ImportAlert", alertInfo); } items = null; }
private void ValidateItems() { if (items == null || items.Length == 0) { return; } CultureInfo culture = new System.Globalization.CultureInfo("en-US"); for (int i = 0; i < items.Length; i++) { string result = string.Empty; object item = items[i]; this._ItemFacade = new ItemFacade(this.DataProvider); string itemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(GetFieldValue(items[i], "ITEMCODE"))); Int32 orgID = GlobalVariables.CurrentOrganizations.First().OrganizationID; object obj = _ItemFacade.GetMaterial(itemCode, orgID); if (obj == null) { result = "物料代码不存在"; } else { this._Facade = new MaterialFacade(this.DataProvider); object objExit = _Facade.GetMaterialReqStd(itemCode, orgID); if (objExit == null) { result = "Insert"; } } string requestQty = GetFieldValue(items[i], "RequestQTY"); if (requestQty != string.Empty) { try { int numRequestQty = int.Parse(requestQty); } catch { result = string.Format("{0};数量必须是数字", result); } } if (result != string.Empty && result != null) { int j = result.IndexOf(";"); if (j == 0) { result = result.Substring(1, result.Length - 1); } } if (result == string.Empty) { result = "OK"; } SetFieldValue(item, "EAttribute1", result); } }