protected override void DeleteDomainObjects(ArrayList domainObjects)
{
if (_esoppicsFacade == null)
{
_esoppicsFacade = new EsopPicsFacade(base.DataProvider);
}
this._esoppicsFacade.DeleteEsoppics((Esoppics[])domainObjects.ToArray(typeof(Esoppics)));
string filaPath = "";
if (_facade == null)
{
_facade = new SystemSettingFacade(this.DataProvider);
}
//object parameter = _facade.GetParameter("PICUPLOADPATH", "ESOPPICDIRPATHGROUP");
//if (parameter != null)
//{
//服务器目录路径
filaPath = System.AppDomain.CurrentDomain.BaseDirectory
+ "ESFileUpload";//((Domain.BaseSetting.Parameter)parameter).ParameterAlias;
//}
DirectoryInfo dir = new DirectoryInfo(filaPath);
foreach (FileInfo file in dir.GetFiles())
{
foreach (Esoppics pic in domainObjects)
{
if (file.Name == pic.Picfullname + ".jpg")
{
file.Delete();
}
}
}
}
//获取入库类型空值时Value
/// <summary>
/// 获取入库类型空值时Value
/// </summary>
/// <returns></returns>
private string GetDrpStorageInTypeEmptyValue()
{
if (_SystemSettingFacade == null)
{
_SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
}
string result = string.Empty;
ArrayList valueList = new ArrayList();
object[] parameters = _SystemSettingFacade.GetParametersByParameterGroup("ININVTYPE");
if (parameters != null && parameters.Length > 0)
{
foreach (Domain.BaseSetting.Parameter parameter in parameters)
{
if (parameter.ParameterAlias == InInvType.PD)
{
continue;
}
valueList.Add(string.Format("'{0}'", parameter.ParameterAlias));
}
}
if (valueList.Count > 0)
{
result = string.Join(",", valueList.ToArray(typeof(string)) as string[]);
}
return(result);
}
protected override void InitWebGrid()
{
base.InitWebGrid();
this.gridHelper.AddColumn("IQCCCOUNT", "创建IQC个数", null);
this.gridHelper.AddColumn("QCCOUNT", "QC检验个数", null);
this.gridHelper.AddColumn("SQECOUNT", "SQE判定个数", null);
this.gridHelper.AddColumn("AVERQCTIME", "平均QC检验时间", null);
this.gridHelper.AddColumn("AVERSQETIME", "平均SQE判定时间", null);
this.gridHelper.AddColumn("AVERIQCTIME", "平均IQC执行时间", null);
this.gridHelper.AddColumn("QTY", "来料总数", null);
this.gridHelper.AddColumn("SAMPLECOUNT", "样本总数", null);
this.gridHelper.AddColumn("NGQTY", "缺陷品总数", null);
this.gridHelper.AddColumn("RETURNQTY", "退换货数量", null);
this.gridHelper.AddColumn("REFORMQTY", "现场整改数量", null);
this.gridHelper.AddColumn("GIVEQTY", "让步接收数量", null);
this.gridHelper.AddColumn("ACCEPTQTY", "特采放行数量", null);
SystemSettingFacade _SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
object[] objs = _SystemSettingFacade.GetErrorGroupcode();
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
this.gridHelper.AddColumn(ecg.ErrorCodeGroup, ecg.ErrorCodeGroupDescription, null);
}
}
//多语言
this.gridHelper.ApplyLanguage(this.languageComponent1);
}
private void ddlMOTypeWhere_Load(object sender, System.EventArgs e)
{
SystemSettingFacade sysFacade = new SystemSettingFacade(this._DataProvider);
object[] moTypeList = sysFacade.GetParametersByParameterGroup("MOTYPE");
ddlMOTypeWhere.Items.Clear();
ddlMOTypeWhere.Items.Add(new ListItem("", ""));
if (moTypeList != null)
{
foreach (BenQGuru.eMES.Domain.BaseSetting.Parameter param in moTypeList)
{
string showText = _LanguageComponent.GetString(param.ParameterValue.Trim().ToUpper());
bool found = false;
foreach (ListItem item in ddlMOTypeWhere.Items)
{
if (item.Text.Trim().ToUpper() == showText)
{
item.Value += "," + param.ParameterCode;
found = true;
break;
}
}
if (!found)
{
ddlMOTypeWhere.Items.Add(new ListItem(showText, param.ParameterCode));
}
}
}
}
protected override object GetEditObject(UltraGridRow row)
{
string userGroupCode = this.txtUserGroupCodeQuery.Text.Trim();
if (facade == null)
{
facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
UserGroup2Module relation = facade.CreateNewUserGroup2Module();
relation.UserGroupCode = userGroupCode;
relation.ModuleCode = row.Cells[2].Text;
if (securityFacade == null)
{
securityFacade = new SystemSettingFacadeFactory(base.DataProvider).CreateSecurityFacade();
}
relation.ViewValue = securityFacade.SpellViewValueFromRights(new bool[] {
row.Cells.FromKey("Export").Text == "true",
row.Cells.FromKey("Read").Text == "true",
row.Cells.FromKey("Write").Text == "true",
row.Cells.FromKey("Delete").Text == "true"
});
relation.MaintainUser = this.GetUserCode();
return(relation);
}
//初始入库类型下拉框
/// <summary>
/// 初始化入库类型下拉框
/// </summary>
private void InitStorageInTypeList()
{
if (_SystemSettingFacade == null)
{
_SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
}
if (isVendor)
{
this.drpStorageInTypeQuery.Items.Add(new ListItem("PO入库", "POR"));
this.drpStorageInTypeQuery.SelectedIndex = 0;
}
else
{
object[] parameters = _SystemSettingFacade.GetParametersByParameterGroup("INVINTYPE");
this.drpStorageInTypeQuery.Items.Add(new ListItem("", ""));
foreach (Domain.BaseSetting.Parameter parameter in parameters)
{
if (parameter.ParameterAlias != "PGIR" && parameter.ParameterAlias != "SCTR")
{
this.drpStorageInTypeQuery.Items.Add(new ListItem(parameter.ParameterDescription, parameter.ParameterAlias));
}
}
this.drpStorageInTypeQuery.SelectedIndex = 0;
}
}
private string CheckBigLine()
{
string returnValue = string.Empty;
SystemSettingFacade systemSettingFacade = new SystemSettingFacade(this.DataProvider);
object[] bigLineList = systemSettingFacade.GetAllBIGSSCODE();
string[] textBigList = this.txtBigLineList.Text.ToUpper().Trim().Split(',');
for (int i = 0; i < textBigList.Length; i++)
{
for (int j = 0; j < bigLineList.Length; j++)
{
if (((Parameter)bigLineList[j]).ParameterAlias.Trim().ToUpper() == textBigList[i].Trim().ToUpper())
{
break;
}
if (j == bigLineList.Length - 1)
{
returnValue += textBigList[i].Trim().ToUpper() + ",";
}
}
}
if (returnValue.Length > 0)
{
returnValue = returnValue.Substring(0, returnValue.Length - 1);
}
return(returnValue);
}
protected override object GetEditObject()
{
if (facade == null)
{
facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
UserGroup2Module relation = facade.CreateNewUserGroup2Module();
relation.ModuleCode = this.txtModuleCodeEdit.Text;
relation.UserGroupCode = this.txtUserGroupCodeQuery.Text;
if (securityFacade == null)
{
securityFacade = new SystemSettingFacadeFactory(base.DataProvider).CreateSecurityFacade();
}
relation.ViewValue = securityFacade.SpellViewValueFromRights(new bool[] {
this.chbRight.Items[0].Selected,
this.chbRight.Items[1].Selected,
this.chbRight.Items[2].Selected,
this.chbRight.Items[3].Selected
});
relation.MaintainUser = this.GetUserCode();
return(relation);
}
private object[] GetParamerters()
{
//BenQGuru.eMES.Common.Domain.IDomainDataProvider _domainDataProvider = BenQGuru.eMES.Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider();
BenQGuru.eMES.BaseSetting.SystemSettingFacade systemFacade = new SystemSettingFacade(_dataProvider);
object[] returnobjs = systemFacade.GetParametersByParameterGroup(_paramGroupCode);
return(returnobjs);
}
protected void cmdUploadError_ServerClick(object sender, System.EventArgs e)
{
SystemSettingFacade facade = new SystemSettingFacade(base.DataProvider);
SystemError systemError = facade.CreateNewSystemError();
systemError.SystemErrorCode = Guid.NewGuid().ToString();
systemError.ErrorMessage = FormatHelper.CleanString(this.GetRequestParam("msg"), 100);
systemError.InnerErrorMessage = FormatHelper.CleanString(this.GetRequestParam("innermsg"), 100);
systemError.TriggerModuleCode = SessionHelper.Current(this.Session).ModuleCode;
systemError.SendUser = this.GetUserCode();
if (systemError.SendUser == null || systemError.SendUser == string.Empty)
{
systemError.SendUser = "******";
}
systemError.SendDate = FormatHelper.TODateInt(DateTime.Now);
systemError.SendTime = FormatHelper.TOTimeInt(DateTime.Now);
systemError.IsResolved = FormatHelper.BooleanToString(false);
systemError.MaintainUser = this.GetUserCode();
if (systemError.MaintainUser == null || systemError.MaintainUser == string.Empty)
{
systemError.MaintainUser = "******";
}
facade.AddSystemError(systemError);
string scriptString = "<script language=JavaScript>window.name+='[back]';window.parent.history.back(-1);</script>";
if (!this.IsClientScriptBlockRegistered("clientScript"))
{
this.RegisterClientScriptBlock("clientScript", scriptString);
}
}
public static void UploadError(string msg, string innserMsg)
{
SQLDomainDataProvider provider = BenQGuru.eMES.Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider() as SQLDomainDataProvider;
SystemSettingFacade facade = new SystemSettingFacade(provider);
SystemError systemError = facade.CreateNewSystemError();
systemError.SystemErrorCode = Guid.NewGuid().ToString();
systemError.ErrorMessage = FormatHelper.CleanString(msg, 100);
systemError.InnerErrorMessage = FormatHelper.CleanString(innserMsg, 100);
systemError.TriggerModuleCode = SessionHelper.Current(HttpContext.Current.Session).ModuleCode;
systemError.SendUser = SessionHelper.Current(HttpContext.Current.Session).UserCode;
if (systemError.SendUser == null || systemError.SendUser == string.Empty)
{
systemError.SendUser = "******";
}
systemError.SendDate = FormatHelper.TODateInt(DateTime.Now);
systemError.SendTime = FormatHelper.TOTimeInt(DateTime.Now);
systemError.IsResolved = FormatHelper.BooleanToString(false);
systemError.MaintainUser = SessionHelper.Current(HttpContext.Current.Session).UserCode;
if (systemError.MaintainUser == null || systemError.MaintainUser == string.Empty)
{
systemError.MaintainUser = "******";
}
facade.AddSystemError(systemError);
provider.PersistBroker.CloseConnection();
}
private void InitStorageList()
{
//InventoryFacade facade = new InventoryFacade(base.DataProvider);
//object[] objStorage = facade.GetAllStorage();
//drpStorageQuery.Items.Clear();
//drpStorageQuery.Items.Add(new ListItem("", ""));
//if (objStorage != null && objStorage.Length > 0)
//{
// foreach (Storage storage in objStorage)
// {
// this.drpStorageQuery.Items.Add(new ListItem(
// storage.StorageCode + "-" + storage.StorageName, storage.StorageCode)
// );
// }
//}
//this.drpStorageQuery.SelectedIndex = 0;
SystemSettingFacade systemSettingFacade = new SystemSettingFacade(this.DataProvider);
UserFacade userFacade = new UserFacade(this.DataProvider);
string[] usergroupList = userFacade.GetUserGroupCodeofUser(GetUserCode());//+TOSTORAGE
this.drpStorageQuery.Items.Add(new ListItem("", ""));
object[] parameters = systemSettingFacade.GetDistinctParaInParameterGroup(usergroupList);
if (parameters != null)
{
foreach (Domain.BaseSetting.Parameter parameter in parameters)
{
drpStorageQuery.Items.Add(new ListItem(parameter.ParameterCode + "-" + parameter.ParameterDescription, parameter.ParameterCode));
}
}
this.drpStorageQuery.SelectedIndex = 0;
}
/// <summary>
/// 由编辑区的输入获得DomainObject
/// </summary>
/// <returns></returns>
protected override object GetEditObject()
{
// this.ValidateInput();
if (_facade == null)
{
_facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
Module module = this._facade.CreateNewModule();
module.ModuleSequence = System.Decimal.Parse(this.txtModuleSequenceEdit.Text);
module.ModuleCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtModuleCodeEdit.Text, 40));
module.ModuleVersion = FormatHelper.CleanString(this.txtModuleVersionEdit.Text, 40);
module.ModuleType = this.drpModuleTypeEdit.SelectedValue;
module.ModuleStatus = this.drpModuleStatusEdit.SelectedValue;
module.ModuleHelpFileName = FormatHelper.CleanString(this.txtHelpFileNameEdit.Text, 100);
module.IsSystem = this.drpIsSystemEdit.SelectedValue;
module.IsActive = this.drpIsActiveEdit.SelectedValue;
module.ModuleDescription = FormatHelper.CleanString(this.txtModuleDescEdit.Text, 100);
module.FormUrl = FormatHelper.CleanString(this.txtFormUrlEdit.Text, 100);
module.ParentModuleCode = this.drpParentModuleCodeEdit.SelectedValue;
module.IsRestrain = this.drpIsRestrain.SelectedValue;
module.MaintainUser = this.GetUserCode();
return(module);
}
protected override int GetRowCount()
{
if (_OQCFacade == null)
{
_OQCFacade = new OQCFacade(base.DataProvider);
}
SystemSettingFacade systemSettingFacade = new SystemSettingFacade(this.DataProvider);
UserFacade userFacade = new UserFacade(this.DataProvider);
string[] usergroupList = userFacade.GetUserGroupCodeofUser1(GetUserCode());
return(this._OQCFacade.QueryOQC2Count(
usergroupList,
FormatHelper.CleanString(this.txtCarInvNoQuery.Text),
FormatHelper.CleanString(this.txtPickNo.Text),
FormatHelper.CleanString(this.txtOQCNoQuery.Text),
FormatHelper.CleanString(this.drpOQCStatusQuery.SelectedValue),
FormatHelper.TODateInt(this.txtAppBDateQuery.Text),
FormatHelper.TODateInt(this.txtAppEDateQuery.Text),
FormatHelper.CleanString(this.txtCartonNoQurey.Text),
FormatHelper.CleanString(this.txtSNQuery.Text),
string.Empty,
string.Empty,
string.Empty,
string.Empty, string.Empty
));
}
public void SetUp()
{
broker = new OLEDBPersistBroker("Provider=OraOLEDB.Oracle.1;Password=emes;Persist Security Info=True;User ID=emes;Data Source=sqcdemo");
facade = new SystemSettingFacade();
helper = new FacadeHelper(this.facade.DataProvider);
module.ModuleCode = "segment";
module.ModuleType = "page";
module.ModuleStatus = "1";
module.ModuleSequence = 1;
module.MaintainUser = "******";
module.MaintainDate = 20050311;
module.MaintainTime = 115311;
module.IsSystem = "1";
module.IsActive = "1";
module.FormUrl = "FSegmentMP.aspx";
relation.ModuleCode = "segment";
relation.UserGroupCode = "admin";
this.helper.DeleteDomainObject(relation);
relation.MaintainUser = "******";
relation.MaintainDate = 20050311;
relation.MaintainTime = 115311;
relation.ViewValue = "1111";
this.helper.DeleteDomainObject(relation);
this.helper.DeleteDomainObject(module);
}
//获取配送实时状态
public string GetDisToLineStatus(DisToLineQuery disToLine)//ALERTDISER
{
SystemSettingFacade systemSettingFacade = new SystemSettingFacade(DataProvider);
string strNormal = systemSettingFacade.GetParameterAlias("ALERTMATERIALDISGROUP", "ALERTDISNORMAL");
int normal = 0;
if (!string.IsNullOrEmpty(strNormal))
{
normal = Convert.ToInt32(strNormal);
}
string strDisER = systemSettingFacade.GetParameterAlias("ALERTMATERIALDISGROUP", "ALERTDISER");
int disER = 0;
if (!string.IsNullOrEmpty(strDisER))
{
disER = Convert.ToInt32(strDisER);
}
//状态根据剩余生产时间换算（小于cycleTime为缺料中、小于紧急预警时间为紧急配料、小于正常预警时间为待配送）
if (disToLine.lefttime < disToLine.CycleTime)
{
return("ShortDis");
}
if (disToLine.lefttime <= disER)
{
return("ERDis");
}
if (disToLine.lefttime <= normal)
{
return("WaitDis");
}
return("Normal");
}
protected override int GetRowCount()
{
if (facade == null)
{
facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
return(facade.GetModuleWithViewValueVisibilityCount(this.GetQueryParameterModuleParent()));
}
protected override void DeleteDomainObjects(ArrayList domainObjects)
{
if (facade == null)
{
facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
facade.DeleteUserGroup2Module((UserGroup2Module[])domainObjects.ToArray(typeof(UserGroup2Module)));
}
protected override void DeleteDomainObjects(ArrayList domainObjects)
{
if (_facade == null)
{
_facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
this._facade.DeleteModule((Module[])domainObjects.ToArray(typeof(Module)));
}
protected override object[] LoadDataSource(int inclusive, int exclusive)
{
if (_facade == null)
{
_facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
return(this._facade.GetSubModulesByModuleCode(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtModuleCodeQuery.Text)), inclusive, exclusive));
}
protected override void UpdateDomainObject(object domainObject)
{
if (facade == null)
{
facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
this.facade.UpdateUserGroup2Module((UserGroup2Module)domainObject);
}
protected override void AddDomainObject(object domainObject)
{
if (_facade == null)
{
_facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
this._facade.AddModule((Module)domainObject);
}
private ITreeObjectNode LoadModuleTreeToApplication()
{
if (_facade == null)
{
_facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
return(this._facade.BuildModuleTree());
}
protected override int GetRowCount()
{
if (_facade == null)
{
_facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
return(this._facade.GetSubModulesByModuleCodeCount(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtModuleCodeQuery.Text))));
}
protected override void AddDomainObject(ArrayList domainObject)
{
if (facade == null)
{
facade = new SystemSettingFacadeFactory(base.DataProvider).CreateSystemSettingFacade();
}
facade.AddUserGroup2FunctionGroup((UserGroup2FunctionGroup[])domainObject.ToArray(typeof(UserGroup2FunctionGroup)));
}
public IMenu[] Build()
{
this.GetUnVisibilityMenu(ApplicationService.Current().DataProvider);
SystemSettingFacade facade = new SystemSettingFacade(ApplicationService.Current().DataProvider);
bool bIsAdmin = false;
string strUserCode = ApplicationService.Current().UserCode;
if (strUserCode.ToUpper() == "ADMIN")
{
bIsAdmin = true;
}
else
{
for (int i = 0; ApplicationService.Current().LoginInfo.UserGroups != null && i < ApplicationService.Current().LoginInfo.UserGroups.Length; i++)
{
if (((UserGroup)ApplicationService.Current().LoginInfo.UserGroups[i]).UserGroupType == "ADMIN")
{
bIsAdmin = true;
break;
}
}
}
if (bIsAdmin == true)
{
strUserCode = string.Empty;
}
ITreeObjectNode rootNode = facade.BuildMenuTreePDA(strUserCode);
TreeObjectNodeSet set = rootNode.GetSubLevelChildrenNodes();
ArrayList listMenu = new ArrayList();
foreach (MenuTreeNode node in set)
{
if (node.MenuWithUrl.MenuType.ToUpper() == MenuType.MenuType_PDA.ToUpper())
{
if (this.menuHT != null && this.menuHT.Contains(node.MenuWithUrl.ModuleCode))
{
continue;
}
if (this.htUnVisibilityMenu != null && this.htUnVisibilityMenu.Contains(node.MenuWithUrl.MenuCode))
{
continue;
}
listMenu.Add(BuildUltraMenuItem(node));
}
}
if (listMenu.Count > 0)
{
MenuCommand[] menuList = new MenuCommand[listMenu.Count];
listMenu.CopyTo(menuList);
return(menuList);
}
return(null);
}
protected override void UpdateDomainObject(object domainObject)
{
this.CheckParentModule(this.drpParentModuleCodeEdit.SelectedValue);
if (_facade == null)
{
_facade = new SystemSettingFacadeFactory(base.DataProvider).Create();
}
this._facade.UpdateModule((Module)domainObject);
}
public static void Build(PageNavigator pageNavigator, string moduleCode, string url, Hashtable urls, ControlLibrary.Web.Language.LanguageComponent languageComponent, IDomainDataProvider _domainDataProvider, BasePage page)
{
if (pageNavigator == null)
{
return;
}
pageNavigator.Clear();
pageNavigator.AddRootPageNavigator("MES", "");
//BenQGuru.eMES.Common.Domain.IDomainDataProvider _domainDataProvider = BenQGuru.eMES.Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider();
SystemSettingFacade facade = new SystemSettingFacade(_domainDataProvider); // new SystemSettingFacadeFactory().Create();
ITreeObjectNode moduleTree = facade.BuildModuleTree();
ITreeObjectNode currNode = ((ITreeObjectNode)moduleTree).GetTreeObjectNodeByID(moduleCode);
if (currNode == null)
{
ExceptionManager.Raise(typeof(Module), "$Error_Module_Not_Exist", string.Format("[$ModuleCode={0}]", moduleCode));
}
TreeObjectNodeSet set = currNode.GetChainFromRoot();
//foreach ( ModuleTreeNode node in set )
for (int i = 0; i < set.Count; i++)
{
ModuleTreeNode node = (set[i] as ModuleTreeNode);
if (node.ID != string.Empty)
{
languageComponent.Language = Web.Helper.SessionHelper.Current(page.Session).Language;
string name = languageComponent.GetString(Module_Prefix + node.Module.ModuleCode);
if (name == string.Empty)
{
name = node.Module.ModuleCode;
}
if (i < set.Count - 1)
{
string key = pageNavigator.Request.ApplicationPath.TrimEnd('/', '\\') + "/" + node.Module.FormUrl;
if (urls.Contains(key.ToUpper()))
{
pageNavigator.AddPageNavigator(name, urls[key.ToUpper()].ToString());
}
else
{
pageNavigator.AddPageNavigator(name, node.Module.FormUrl);
}
}
else
{
pageNavigator.AddPageNavigator(name, url);
}
}
}
}
protected override DataRow GetGridRow(object obj)
{
if (facade == null)
{
facade = new WarehouseFacade(base.DataProvider);
}
DataRow row = this.DtSource.NewRow();
IQCSUMMARY s = (IQCSUMMARY)obj;
row["IQCCCOUNT"] = s.IQCCCOUNT;
row["QCCOUNT"] = s.QCCOUNT;
row["SQECOUNT"] = s.SQECOUNT;
row["AVERQCTIME"] = facade.QCAverPeriod(txtStorageCodeQuery.Text, drpStorageInTypeQuery.SelectedValue, txtVendorCodeQuery.Text, FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text));
row["AVERSQETIME"] = facade.SQEAverPeriod(txtStorageCodeQuery.Text, drpStorageInTypeQuery.SelectedValue, txtVendorCodeQuery.Text, FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text));
row["AVERIQCTIME"] = facade.IQCAverPeriod(txtStorageCodeQuery.Text, drpStorageInTypeQuery.SelectedValue, txtVendorCodeQuery.Text, FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text));
row["QTY"] = s.QTY;
row["SAMPLECOUNT"] = s.SAMPLECOUNT;
row["NGQTY"] = s.NGQTY;
row["RETURNQTY"] = s.RETURNQTY;
row["REFORMQTY"] = s.REFORMQTY;
row["GIVEQTY"] = s.GIVEQTY;
row["ACCEPTQTY"] = s.ACCEPTQTY;
SystemSettingFacade _SystemSettingFacade = new SystemSettingFacade(base.DataProvider);
object[] objs = _SystemSettingFacade.GetErrorGroupcode();
if (objs != null && objs.Length > 0)
{
foreach (ErrorCodeGroupA ecg in objs)
{
IQCSUMMARY[] summary = facade.EGGroupQty(ecg.ErrorCodeGroup,
txtStorageCodeQuery.Text, drpStorageInTypeQuery.SelectedValue, txtVendorCodeQuery.Text,
FormatHelper.TODateInt(dateInDateFromQuery.Text),
FormatHelper.TODateInt(dateInDateToQuery.Text));
int sum = 0;
foreach (IQCSUMMARY o in summary)
{
sum += o.NGQTY;
}
row[ecg.ErrorCodeGroup] = sum;
}
}
return(row);
}
protected void Page_Load(object sender, System.EventArgs e)
{
_SystemSettingFacade = new SystemSettingFacade(this.DataProvider);
if (!this.IsPostBack)
{
// 初始化页面语言
this.InitPageLanguage(this.languageComponent1, false);
}
}
