public FacadeFactory()
{
if (_domainDataProvider == null)
{
_domainDataProvider = DomainDataProviderManager.DomainDataProvider();
}
}
private void _helper_DomainObjectToGridRow(object sender, EventArgs e)
{
BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null;
try
{
provider = base.DataProvider;
BenQGuru.eMES.Material.InventoryFacade facade = new InventoryFacade(provider);
if ((e as DomainObjectToGridRowEventArgs).DomainObject != null)
{
BenQGuru.eMES.Domain.Material.InvShip obj = (e as DomainObjectToGridRowEventArgs).DomainObject as BenQGuru.eMES.Domain.Material.InvShip;
if (obj != null)
{
/*int sum = facade.QueryInvShipWebSum(obj.ShipNo,
* obj.ShipSeq,
* this.txtPartner.Text.Trim(),
* this.dateInDateFromQuery.Text,
* this.dateInDateToQuery.Text,
* this.txtModel.Text.Trim(),
* this.txtItemCode.Text.Trim(),
* this.txtRCardFrom.Text.Trim(),
* this.txtRCardTo.Text,
* this.txtPrintDateFrom.Text,
* this.txtPrintDateTo.Text
* );*/
(e as DomainObjectToGridRowEventArgs).GridRow =
new UltraGridRow(new object[] {
obj.ShipNo,
obj.ShipSeq,
obj.ShipType,
obj.PartnerCode,
obj.PartnerDesc,
obj.ModelCode,
obj.ItemCode,
obj.ItemDesc,
GetReceiveStausName(obj.ShipStatus),
FormatHelper.ToDateString(obj.ShipDate),
obj.PlanQty,
obj.ActQty,
obj.ShipDesc,
string.Empty
}
);
}
}
}
finally
{
if (provider != null)
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection();
}
}
}
public object CheckUpdate()
{
BenQGuru.eMES.Common.Domain.IDomainDataProvider _dataProvider =
BenQGuru.eMES.Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider();
try
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)_dataProvider).PersistBroker.AutoCloseConnection = false;
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)_dataProvider).PersistBroker.OpenConnection();
//object objUpdater = null;
//Laws Lu,2005/08/22,新增 版本更新
object objUpdater = Web.Helper.FormatHelper.GetCsVersion(_dataProvider);
string strVersion = UserControl.FileLog.GetLocalCSVersion(UserControl.FileLog.VersionFileName);
int iErrorCount = 0;
if (objUpdater != null)
{
iErrorCount = Web.Helper.FormatHelper.GetUpdateErrorCount(_dataProvider, ((BenQGuru.eMES.Web.Helper.Updater)objUpdater).CSVersion);
}
//Laws Lu,2006/08/14 修改 如果更新有错误也不允许继续操作
if ((objUpdater != null &&
strVersion != ((BenQGuru.eMES.Web.Helper.Updater)objUpdater).CSVersion.Trim()) ||
(objUpdater != null && iErrorCount != 0 &&
strVersion == ((BenQGuru.eMES.Web.Helper.Updater)objUpdater).CSVersion.Trim()))
{
return(objUpdater);
// bResult = true;
// Updater upd = (BenQGuru.eMES.Web.Helper.Updater)objUpdater;
//
// AutoUpdate(upd.Location.Trim(),upd.LoginUser,upd.LoginPassword);
}
}
catch (Exception ex)
{
Common.Log.Error(ex.Message);
}
finally
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)_dataProvider).PersistBroker.CloseConnection();
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)_dataProvider).PersistBroker.AutoCloseConnection = true;
}
return(null);
}
public RouteDataPreparationHelper(BenQGuru.eMES.Common.Domain.IDomainDataProvider dataProvider, DropDownList model, DropDownList item, DropDownList mo, DropDownList op)
{
this._model = model;
this._item = item;
this._mo = mo;
this._op = op;
FacadeFactory fFac = new FacadeFactory(dataProvider);
this._modelFacade = fFac.CreateModelFacade();
this._moFacade = fFac.CreateMOFacade();
this._itemFacade = fFac.CreateItemFacade();
if (this._model != null)
{
this._model.SelectedIndexChanged += new EventHandler(_model_SelectedIndexChanged);
this._model.AutoPostBack = true;
this._modelBuilder = new DropDownListBuilder(this._model);
this._modelBuilder.HandleGetObjectList += new GetObjectListDelegate(this._getModelList);
}
if (this._item != null)
{
this._item.SelectedIndexChanged += new EventHandler(_item_SelectedIndexChanged);
this._item.AutoPostBack = true;
this._itemBuilder = new DropDownListBuilder(this._item);
this._itemBuilder.HandleGetObjectList += new GetObjectListDelegate(this._getItemList);
}
if (this._mo != null)
{
this._moBuilder = new DropDownListBuilder(this._mo);
this._moBuilder.HandleGetObjectList += new GetObjectListDelegate(this._getMOList);
}
if (this._op != null)
{
this._opBuilder = new DropDownListBuilder(this._op);
this._opBuilder.HandleGetObjectList += new GetObjectListDelegate(this._getOperationList);
}
}
public PhysicalLayoutDataPreparationHelper(BenQGuru.eMES.Common.Domain.IDomainDataProvider dataProvider, DropDownList segment, DropDownList stepSequence, DropDownList resource, DropDownList shift)
{
this._segment = segment;
this._stepSequence = stepSequence;
this._resource = resource;
this._shift = shift;
this._facade = new FacadeFactory(dataProvider).CreateBaseModelFacade();
this._shiftfacade = new FacadeFactory(dataProvider).CreateShiftModelFacade();
if (this._segment != null)
{
this._segment.SelectedIndexChanged += new EventHandler(_segment_SelectedIndexChanged);
this._segment.AutoPostBack = true;
this._segmentBuilder = new DropDownListBuilder(this._segment);
this._segmentBuilder.HandleGetObjectList += new GetObjectListDelegate(this._getSegmentList);
}
if (this._stepSequence != null)
{
this._stepSequence.SelectedIndexChanged += new EventHandler(_stepSequence_SelectedIndexChanged);
this._stepSequence.AutoPostBack = true;
this._stepSequenceBuilder = new DropDownListBuilder(this._stepSequence);
this._stepSequenceBuilder.HandleGetObjectList += new GetObjectListDelegate(this._getStepSequenceList);
}
if (this._resource != null)
{
this._resourceBuilder = new DropDownListBuilder(this._resource);
this._resourceBuilder.HandleGetObjectList += new GetObjectListDelegate(this._getResourceList);
}
if (this._shift != null)
{
this._shiftBuilder = new DropDownListBuilder(this._shift);
this._shiftBuilder.HandleGetObjectList += new GetObjectListDelegate(this._getShiftList);
}
}
public SMTFacadeFactory(BenQGuru.eMES.Common.Domain.IDomainDataProvider domainDataProvider)
{
this._domainDataProvider = domainDataProvider;
}
public MailHelper(BenQGuru.eMES.Common.Domain.IDomainDataProvider domainDataProvider, string fromuserMail)
{
this._domainDataProvider = domainDataProvider;
fromUserMail = fromuserMail;
}
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
try
{
_provider = BenQGuru.eMES.Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider();
_query = new BenQGuru.eMES.WebQuery.QuerySPC(this._provider);
_itemfacade = new ItemFacade(this._provider);
GetParam();
#region 返回基本资料部分
if (_fromTime == null || _fromTime == string.Empty)//第一次查询,不是刷新
{
/*产品别
* 品名
* 日期 (YYYY-MM-DD)
* 资源列表 (以逗号分割，资源代码里的逗号用空格代替)
* 测试项
* USL,LSL,UCL,LCL,是否自动产生
*/
ModelFacade modelfacade = new FacadeFactory(_provider).CreateModelFacade();
Model model = (Model)modelfacade.GetModelByItemCode(_itemCode);
this.Writeln(model != null ? model.ModelCode : "");
Item item = (Item)_itemfacade.GetItem(_itemCode, GlobalVariables.CurrentOrganizations.First().OrganizationID);
this.Writeln(item != null ? item.ItemName : "");
//this.Writeln(_dateFrom);
WriteDateList();
WriteResList();
this.Writeln(this._testName);
string strtest = string.Empty;
strtest = itemSpec.USL.ToString() + ","
+ itemSpec.LSL.ToString() + ","
+ itemSpec.UCL.ToString() + ","
+ itemSpec.LCL.ToString() + ","
+ itemSpec.AutoCL + ","
+ itemSpec.LimitUpOnly + ","
+ itemSpec.LimitLowOnly;
this.Writeln(strtest);
}
else //刷新
{
WriteDateList();
//资源列表
WriteResList();
}
#endregion
#region 测试数据部分
//总数 (以下记录数的总和)
//HHMMSS数值,工作站 (时间和数值间没有空格)
//从SQL Server中查询数据
if (_query == null)
{
_query = new BenQGuru.eMES.WebQuery.QuerySPC(this._provider);
}
BenQGuru.eMES.SPCDataCenter.DataHandler dataHandler = new BenQGuru.eMES.SPCDataCenter.DataHandler(this._provider);
int iFromTime = 0;
if (this._fromTime != null && this._fromTime != string.Empty)
{
iFromTime = int.Parse(this._fromTime);
}
string[][] spcData = dataHandler.QuerySPCData(this._itemCode, this._testName, int.Parse(this._groupSeq), this._resourceCode, FormatHelper.TODateInt(this._dateFrom), FormatHelper.TODateInt(this._dateTo), _testResult, iFromTime);
if ((_fromTime == null || _fromTime == string.Empty) && spcData.Length < 10)
{
ExceptionManager.Raise(this.GetType(), "$SPC_SamplePoint_Too_Little");
}
// 记录数
this.Writeln(spcData.Length);
for (int i = 0; i < spcData.Length; i++)
{
string strLine = string.Empty;
strLine = this._dateList.IndexOf(spcData[i][1]) + "," + FormatHelper.ToTimeString(int.Parse(spcData[i][2])).Replace(":", "") + spcData[i][3];
if (this._resList.Count > 1)
{
strLine += "," + this._resList.IndexOf(spcData[i][0]);
}
this.Writeln(strLine);
}
#endregion
Response.End();
if (!IsPostBack)
{
// 初始化页面语言
//this.InitPageLanguage(this.languageComponent1, false);
}
}
catch (System.Threading.ThreadAbortException)
{
}
catch (System.Exception ex)
{
Response.Clear();
string msg = MessageCenter.ParserMessage(ex.Message, this.languageComponent1);
if (ex.InnerException != null)
{
msg = msg + " " + ex.InnerException.Message;
}
msg = msg.Replace("\r", "");
msg = msg.Replace("\n", "");
Response.Write(msg);
try
{
Response.End();
}
catch (System.Threading.ThreadAbortException)
{
}
}
}
finally //关闭数据库连接
{
if (_query != null && this._query.SPCBroker != null)
{
this._query.SPCBroker.CloseConnection();
}
if (_provider != null)
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)_provider).PersistBroker.CloseConnection();
}
}
}
private void _helper_DomainObjectToExportRow(object sender, EventArgs e)
{
if (!this.chbExpDetail.Checked)
{
#region 导出二级界面
BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null;
try
{
provider = base.DataProvider;
BenQGuru.eMES.Material.InventoryFacade facade = new InventoryFacade(provider);
if ((e as DomainObjectToExportRowEventArgs).DomainObject != null)
{
BenQGuru.eMES.Domain.Material.InvReceive obj = (e as DomainObjectToExportRowEventArgs).DomainObject as BenQGuru.eMES.Domain.Material.InvReceive;
/*int sum = facade.QueryInvReceiveWebSum(obj.RecNo,
* obj.RecSeq,
* this.drpStatus.SelectedValue,
* this.dateInDateFromQuery.Text,
* this.dateInDateToQuery.Text,
* this.txtModel.Text.Trim(),
* this.txtItemCode.Text.Trim(),
* this.txtRCardFrom.Text.Trim(),
* this.txtRCardTo.Text);*/
(e as DomainObjectToExportRowEventArgs).ExportRow =
new string[] {
obj.RecNo,
obj.RecType,
obj.ModelCode,
obj.ItemCode,
obj.ItemDesc,
GetReceiveStausName(obj.RecStatus),
obj.PlanQty.ToString(),
obj.ActQty.ToString(),
obj.Description,
string.Empty
};
}
}
finally
{
if (provider != null)
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection();
}
}
#endregion
}
else
{
#region 导出二级界面
BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null;
try
{
provider = base.DataProvider;
BenQGuru.eMES.Material.InventoryFacade facade = new InventoryFacade(provider);
if ((e as DomainObjectToExportRowEventArgs).DomainObject != null)
{
BenQGuru.eMES.Domain.Material.ReceiveRCard obj = (e as DomainObjectToExportRowEventArgs).DomainObject as BenQGuru.eMES.Domain.Material.ReceiveRCard;
(e as DomainObjectToExportRowEventArgs).ExportRow =
new string[] {
obj.RecNo,
obj.RecType,
obj.ModelCode,
obj.ItemCode,
obj.ItemDesc,
GetReceiveStausName(obj.RecStatus),
obj.ActQty.ToString(),
obj.Description,
obj.RunningCard,
RCardStatus.GetName(obj.RCardStatus),
obj.ReceiveUser,
FormatHelper.ToDateString(obj.ReceiveDate),
obj.CartonCode
};
}
}
finally
{
if (provider != null)
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection();
}
}
#endregion
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
if (this.chbExpDetail.Checked && this.hidAction.Value == "exp")
{
#region 导出二级界面
PageCheckManager manager = new PageCheckManager();
manager.Add(new DateRangeCheck(this.lblInDateQuery, this.dateInDateFromQuery.Text, this.dateInDateToQuery.Text, false));
if (!manager.Check())
{
WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1);
return;
}
BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null;
try
{
provider = base.DataProvider;
BenQGuru.eMES.Material.InventoryFacade facade = new InventoryFacade(provider);
object[] dataSource = facade.QueryRecRCardWeb(
this.txtCartonNo.Text.Trim().ToUpper(),
this.txtReceivQuery.Text.Trim(),
this.drpStatus.SelectedValue,
this.dateInDateFromQuery.Text,
this.dateInDateToQuery.Text,
this.txtModel.Text.Trim(),
this.txtItemCode.Text.Trim(),
this.txtRCardFrom.Text.Trim(),
this.txtRCardTo.Text,
this.drpRecType.SelectedValue,
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).GridDataSource = dataSource;
}
finally
{
if (provider != null)
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection();
}
}
#endregion
}
else
{
#region 导出二级界面
PageCheckManager manager = new PageCheckManager();
manager.Add(new DateRangeCheck(this.lblInDateQuery, this.dateInDateFromQuery.Text, this.dateInDateToQuery.Text, false));
if (!manager.Check())
{
WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1);
return;
}
BenQGuru.eMES.Common.Domain.IDomainDataProvider provider = null;
try
{
provider = base.DataProvider;
BenQGuru.eMES.Material.InventoryFacade facade = new InventoryFacade(provider);
object[] dataSource = facade.QueryInvReceiveWeb(
this.txtCartonNo.Text.Trim().ToUpper(),
this.txtReceivQuery.Text.Trim(),
this.drpStatus.SelectedValue,
this.dateInDateFromQuery.Text,
this.dateInDateToQuery.Text,
this.txtModel.Text.Trim(),
this.txtItemCode.Text.Trim(),
this.txtRCardFrom.Text.Trim(),
this.txtRCardTo.Text,
this.drpRecType.SelectedValue,
this.txtConditionMo.Text,
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).GridDataSource = dataSource;
(e as WebQueryEventArgs).RowCount =
facade.QueryInvReceiveWebCount(
this.txtCartonNo.Text.Trim().ToUpper(),
this.txtReceivQuery.Text.Trim(),
this.drpStatus.SelectedValue,
this.dateInDateFromQuery.Text,
this.dateInDateToQuery.Text,
this.txtModel.Text.Trim(),
this.txtItemCode.Text.Trim(),
this.txtRCardFrom.Text.Trim(),
this.txtRCardTo.Text,
this.drpRecType.SelectedValue,
this.txtConditionMo.Text);
}
finally
{
if (provider != null)
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)provider).PersistBroker.CloseConnection();
}
}
#endregion
}
}
public FacadeFactory(BenQGuru.eMES.Common.Domain.IDomainDataProvider dataProvider)
{
_dataProvider = dataProvider;
}
