// protected override ControlLibrary.Web.Language.LanguageComponent GetLanguageComponent()
// {
// return this.languageComponent1;
// }
private void InitPageValue()
{
this.txtMinDutyRatoMin.Text = string.Empty;
this.txtMinDutyRatoMax.Text = string.Empty;
this.txtBurstMdFreMin.Text = string.Empty;
this.txtBurstMdFreMax.Text = string.Empty;
this.txtElectricCount.Text = "0";
this.txtGroupCount.Text = "0";
if (_facade == null)
{
_facade = new OQCFacadeFactory(base.DataProvider).CreateOQCFacade();
}
object objMain = _facade.GetOQCFuncTest(this.txtItemCode.Text);
if (objMain == null)
{
return;
}
OQCFuncTest testMain = (OQCFuncTest)objMain;
this.txtMinDutyRatoMin.Text = testMain.MinDutyRatoMin.ToString("##.##");
this.txtMinDutyRatoMax.Text = testMain.MinDutyRatoMax.ToString("##.##");
this.txtBurstMdFreMin.Text = testMain.BurstMdFreMin.ToString("##.##");;
this.txtBurstMdFreMax.Text = testMain.BurstMdFreMax.ToString("##.##");;
this.txtElectricCount.Text = Convert.ToInt32(testMain.ElectricTestCount).ToString();
this.txtGroupCount.Text = Convert.ToInt32(testMain.FuncTestGroupCount).ToString();
itemGroupValue = _facade.QueryOQCFuncTestSpec(this.txtItemCode.Text);
InitGridView();
}
protected override void AddDomainObject(object domainObject)
{
if (_oqcfade == null)
{
_oqcfade = new BenQGuru.eMES.OQC.OQCFacade(base.DataProvider);
}
Object objAQL = _oqcfade.GetAQL((domainObject as Domain.OQC.AQL).AQLSeq, (domainObject as Domain.OQC.AQL).AqlLevel);
if (objAQL != null)
{
WebInfoPublish.Publish(this, "$Error_PK_is_Repeat", this.languageComponent1);
return;
}
int LotSizeMin = int.Parse(this.txtLotSizeMin.Text.Trim());
int LotSizeMax = int.Parse(this.txtLotSizeMax.Text.Trim());
int count = _oqcfade.GetIsRepeatLotSizeMin2MaxForAdd(LotSizeMin, LotSizeMax, FormatHelper.CleanString(this.txtAqlLevel.Text));
if (count > 0)
{
WebInfoPublish.Publish(this, "$BS_Repeat_LotSize", this.languageComponent1);
return;
}
this._oqcfade.AddAQL((Domain.OQC.AQL)domainObject);
}
private object[] LoadDataSource(int inclusive, int exclusive)
{
if (_OQCFacade == null)
{
_OQCFacade = new OQCFacade(this.DataProvider);
}
string rCardStart = string.Empty;
string rCardEnd = string.Empty;
string lotNo = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtLotNoQuery.Text));
string moCode = string.Empty;
string itemCode = string.Empty;
string frozenStatus = FrozenStatus.STATUS_FRONZEN;
int frozenDateStart = FormatHelper.TODateInt(this.txtDateFrom.Text);
int frozenDateEnd = FormatHelper.TODateInt(this.txtDateTo.Text);
int unfrozenDateStart = -1;
int unfrozenDateEnd = -1;
return(this._OQCFacade.QueryFrozen(
rCardStart, rCardEnd,
lotNo, moCode, itemCode,
frozenStatus, frozenDateStart, frozenDateEnd, unfrozenDateStart, unfrozenDateEnd,
inclusive, exclusive));
}
protected override void DeleteDomainObjects(ArrayList domainObjects)
{
if (_facade == null)
{
_facade = new OQCFacadeFactory(base.DataProvider).CreateOQCFacade();
}
this._facade.DeleteOQCCheckList((OQCCheckList[])domainObjects.ToArray(typeof(OQCCheckList)));
}
protected override void UpdateDomainObject(object domainObject)
{
if (_facade == null)
{
_facade = new OQCFacade(base.DataProvider);
}
this._facade.UpdateOQCCheckGroup((OQCCheckGroup)domainObject);
}
protected override void DeleteDomainObjects(ArrayList domainObjects)
{
if (_facade == null)
{
_facade = new OQCFacade(base.DataProvider);
}
this._facade.DeleteOQCCheckGroup((OQCCheckGroup[])domainObjects.ToArray(typeof(OQCCheckGroup)));
}
protected override void UpdateDomainObject(object domainObject)
{
if (_facade == null)
{
_facade = new OQCFacadeFactory(base.DataProvider).CreateOQCFacade();
}
this._facade.UpdateOQCCheckList((OQCCheckList)this.GetEditObject());
}
protected override void DeleteDomainObjects(ArrayList domainObjects)
{
if (_oqcfade == null)
{
_oqcfade = new BenQGuru.eMES.OQC.OQCFacade(base.DataProvider);
}
this._oqcfade.DeleteAQL((Domain.OQC.AQL[])domainObjects.ToArray(typeof(Domain.OQC.AQL)));
}
protected override int GetRowCount()
{
if (_oqcfade == null)
{
_oqcfade = new BenQGuru.eMES.OQC.OQCFacade(base.DataProvider);
}
return(this._oqcfade.GetAqlCountForQuery(this.txtAQLLevelQuery.Text.Trim().ToUpper()));
}
private object GetEditObject(Infragistics.WebUI.UltraWebGrid.UltraGridRow row)
{
if (_OQCFacade == null)
{
_OQCFacade = new OQCFacade(this.DataProvider);
}
return(_OQCFacade.GetFrozen(row.Cells[1].Text, row.Cells[4].Text, int.Parse(row.Cells[5].Text), row.Cells[3].Text, row.Cells[2].Text, int.Parse(row.Cells[10].Text)));
}
private void btnInitGroupCount_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
if (_facade == null)
{
_facade = new OQCFacadeFactory(base.DataProvider).CreateOQCFacade();
}
itemGroupValue = _facade.QueryOQCFuncTestSpec(this.txtItemCode.Text);
InitGridView();
}
protected override object[] LoadDataSource(int inclusive, int exclusive)
{
if (_oqcfade == null)
{
_oqcfade = new BenQGuru.eMES.OQC.OQCFacade(base.DataProvider);
}
return(this._oqcfade.GetAqlForQuery(this.txtAQLLevelQuery.Text.Trim().ToUpper(), inclusive, exclusive));
}
protected override int GetRowCount()
{
if (_facade == null)
{
_facade = new OQCFacadeFactory(base.DataProvider).CreateOQCFacade();
}
return(this._facade.QueryOQCCheckListCount(
FormatHelper.CleanString(this.txtCheckListCodeQuery.Text)));
}
protected void cmdSave_ServerClick(object sender, System.EventArgs e)
{
ArrayList array = this.gridHelper.GetCheckedRows();
if (array == null || array.Count <= 0)
{
return;
}
if (!ValidateInput())
{
return;
}
Frozen frozen = null;
string unfrozenReason = this.txtUnfrozenCauseEdit.Text.Trim();
string userCode = this.GetUserCode();
try
{
((SQLDomainDataProvider)this.DataProvider).PersistBroker.AutoCloseConnection = false;
((SQLDomainDataProvider)this.DataProvider).PersistBroker.OpenConnection();
this.DataProvider.BeginTransaction();
if (_OQCFacade == null)
{
_OQCFacade = new OQCFacade(this.DataProvider);
}
foreach (UltraGridRow row in array)
{
frozen = (Frozen)this.GetEditObject(row);
if (frozen != null)
{
_OQCFacade.UnfreezeRCard(frozen, unfrozenReason, userCode);
}
}
this.DataProvider.CommitTransaction();
this.txtUnfrozenCauseEdit.Text = string.Empty;
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
throw ex;
}
finally
{
((SQLDomainDataProvider)this.DataProvider).PersistBroker.CloseConnection();
((SQLDomainDataProvider)this.DataProvider).PersistBroker.AutoCloseConnection = true;
}
this.gridHelper.RequestData();
}
protected override int GetRowCount()
{
if (_facade == null)
{
_facade = new OQCFacade(base.DataProvider);
}
return(this._facade.QueryOQCCheckGroupCount(
FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtChkGroupQuery.Text))
));
}
protected override object[] LoadDataSource(int inclusive, int exclusive)
{
if (_facade == null)
{
_facade = new OQCFacadeFactory(base.DataProvider).CreateOQCFacade();
}
return(this._facade.QueryOQCCheckList(
FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtCheckListCodeQuery.Text)),
inclusive, exclusive));
}
private object GetEditObject(GridRecord row)
{
if (_OQCFacade == null)
{
_OQCFacade = new OQCFacade(this.DataProvider);
}
object obj = this._OQCFacade.GetOQCLot(row.Items.FindItemByKey("OQCLotNo").Value.ToString(), OQCFacade.Lot_Sequence_Default);
return(obj);
}
protected override object GetEditObject()
{
if (_facade == null)
{
_facade = new OQCFacade(base.DataProvider);
}
OQCCheckGroup checkGroup = this._facade.CreateNewOQCCheckGroup();
checkGroup.CheckGroupCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtChkGroupEdit.Text, 40));
checkGroup.MaintainUser = base.GetUserCode();
return(checkGroup);
}
protected override object GetEditObject(GridRecord row)
{
if (_oqcfade == null)
{
_oqcfade = new OQCFacade(base.DataProvider);
}
object obj = _oqcfade.GetAQL(int.Parse(row.Items.FindItemByKey("AqlSql").Value.ToString()), FormatHelper.CleanString(row.Items.FindItemByKey("AqlLevel").Value.ToString()));
if (obj != null)
{
return(obj);
}
return(null);
}
protected override object GetEditObject()
{
if (_oqcfade == null)
{
_oqcfade = new OQCFacade(base.DataProvider);
}
Domain.OQC.AQL aql = this._oqcfade.CreateNewAQL();
aql.AQLSeq = int.Parse(this.txtAqlSeq.Text.Trim());
aql.AqlLevel = FormatHelper.CleanString(this.txtAqlLevel.Text, 40);
aql.LotSizeMin = int.Parse(this.txtLotSizeMin.Text.Trim());
aql.LotSizeMax = int.Parse(this.txtLotSizeMax.Text.Trim());
aql.SampleSize = int.Parse(this.txtSampleSize.Text.Trim());
aql.RejectSize = int.Parse(this.txtRejectSize.Text.Trim());
aql.MaintainUser = this.GetUserCode();
return(aql);
}
protected override object GetEditObject()
{
if (_facade == null)
{
_facade = new OQCFacadeFactory(base.DataProvider).CreateOQCFacade();
}
OQCCheckList checklist = this._facade.CreateNewOQCCheckList();
checklist.CheckItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtCheckListCodeEdit.Text, 40));
checklist.Description = FormatHelper.CleanString(this.txtCheckItemDesc.Text);
checklist.CheckIemUnit = FormatHelper.CleanString(this.txtUnit.Text);
checklist.CheckValueMax = FormatHelper.CleanString(this.txtCheckValueMax.Text);
checklist.CheckValueMin = FormatHelper.CleanString(this.txtCheckValueMin.Text);
checklist.MaintainUser = this.GetUserCode();
return(checklist);
}
private object[] LoadDataSource(int inclusive, int exclusive)
{
if (_OQCFacade == null)
{
_OQCFacade = new OQCFacade(this.DataProvider);
}
string LotNo = this.txtLotNoQuery.Text.ToString().Trim();
string Stepsequence = this.txtStepsequence.Text.Trim();
Stepsequence = Stepsequence.Replace(",", "','");
string Mmodelcode = this.txtModelcode.Text.Trim();
Mmodelcode = Mmodelcode.Replace(",", "','");
string BigLine = this.txtBIGLine.Text.Trim();
BigLine = BigLine.Replace(",", "','");
int frozenDateStart = FormatHelper.TODateInt(this.txtDateFrom.Text);
int frozenDateEnd = FormatHelper.TODateInt(this.txtDateTo.Text);
object[] objs = this._OQCFacade.QueryFrozenAndMaterial(LotNo, Mmodelcode, Stepsequence, BigLine, frozenDateStart, frozenDateEnd, -1, -1, FrozenStatus.STATUS_FRONZEN, inclusive, exclusive);
if (objs != null && objs.Length > 0)
{
for (int i = 0; i < objs.Length; i++)
{
object[] MoObjs = _OQCFacade.QueryMoCodeINOLot2CardByLotNo(((OQCLOTAndMaterial)objs[i]).LOTNO);
if (MoObjs != null &&
MoObjs.Length > 0)
{
for (int j = 0; j < MoObjs.Length; j++)
{
if (j == 0)
{
((OQCLOTAndMaterial)objs[i]).MoCdoe = ((OQCLot2Card)MoObjs[j]).MOCode;
}
else
{
((OQCLOTAndMaterial)objs[i]).MoCdoe = ((OQCLOTAndMaterial)objs[i]).MoCdoe + ", " + ((OQCLot2Card)MoObjs[j]).MOCode;
}
}
}
}
}
return(objs);
}
protected override void UpdateDomainObject(object domainObject)
{
if (_oqcfade == null)
{
_oqcfade = new OQCFacade(this.DataProvider);
}
int LotSizeMin = int.Parse(this.txtLotSizeMin.Text.Trim());
int LotSizeMax = int.Parse(this.txtLotSizeMax.Text.Trim());
int AqlSeq = int.Parse(this.txtAqlSeq.Text.Trim());
int count = _oqcfade.GetIsRepeatLotSizeMin2MaxForUpdate(LotSizeMin, LotSizeMax, AqlSeq, FormatHelper.CleanString(this.txtAqlLevel.Text));
if (count > 0)
{
WebInfoPublish.Publish(this, "$BS_Repeat_LotSize", this.languageComponent1);
return;
}
this._oqcfade.UpdateAQL((Domain.OQC.AQL) this.GetEditObject());
}
protected override object GetEditObject(GridRecord row)
{
if (_facade == null)
{
_facade = new OQCFacadeFactory(base.DataProvider).CreateOQCFacade();
}
string strCode = string.Empty;
object objCode = row.Items.FindItemByKey("CheckItemCode").Value;
if (objCode != null)
{
strCode = objCode.ToString();
}
object obj = _facade.GetOQCCheckList(strCode);
if (obj != null)
{
return((OQCCheckList)obj);
}
return(null);
}
private int GetRowCount()
{
if (_OQCFacade == null)
{
_OQCFacade = new OQCFacade(this.DataProvider);
}
string LotNo = this.txtLotNoQuery.Text.ToString().Trim();
string Stepsequence = this.txtStepsequence.Text.Trim();
Stepsequence = Stepsequence.Replace(",", "','");
string Mmodelcode = this.txtModelcode.Text.Trim();
Mmodelcode = Mmodelcode.Replace(",", "','");
string BigLine = this.txtBIGLine.Text.Trim();
BigLine = BigLine.Replace(",", "','");
int frozenDateStart = FormatHelper.TODateInt(this.txtDateFrom.Text);
int frozenDateEnd = FormatHelper.TODateInt(this.txtDateTo.Text);
return(this._OQCFacade.QueryFrozenAndMaterialCount(LotNo, Mmodelcode, Stepsequence,
BigLine, frozenDateStart, frozenDateEnd, -1, -1, FrozenStatus.STATUS_FRONZEN));
}
protected void cmdSave_ServerClick(object sender, System.EventArgs e)
{
ArrayList array = this.gridHelper.GetCheckedRows();
if (array == null || array.Count <= 0)
{
return;
}
if (!ValidateInput())
{
return;
}
string unfrozenReason = this.txtUnfrozenCauseEdit.Text.Trim();
string userCode = this.GetUserCode();
try
{
((SQLDomainDataProvider)this.DataProvider).PersistBroker.AutoCloseConnection = false;
((SQLDomainDataProvider)this.DataProvider).PersistBroker.OpenConnection();
this.DataProvider.BeginTransaction();
if (_OQCFacade == null)
{
_OQCFacade = new OQCFacade(this.DataProvider);
}
DBDateTime currentDBDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
foreach (GridRecord row in array)
{
OQCLot OQClot = (OQCLot)this.GetEditObject(row);
if (OQClot != null)
{
//更新Lot
_OQCFacade.UpdateUnFrozenOnLot(((OQCLot)OQClot).LOTNO, unfrozenReason, currentDBDateTime.DBDate,
currentDBDateTime.DBTime, userCode, OQCFacade.Lot_Sequence_Default);
// 更新frozen
_OQCFacade.UnFreezeFrozen(((OQCLot)OQClot).LOTNO, unfrozenReason, currentDBDateTime.DBDate,
currentDBDateTime.DBTime, userCode, OQCFacade.Lot_Sequence_Default);
}
}
this.DataProvider.CommitTransaction();
this.txtUnfrozenCauseEdit.Text = string.Empty;
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
throw ex;
}
finally
{
((SQLDomainDataProvider)this.DataProvider).PersistBroker.CloseConnection();
((SQLDomainDataProvider)this.DataProvider).PersistBroker.AutoCloseConnection = true;
}
this.gridHelper.RequestData();
}
private void QueryEvent(object sender, EventArgs e)
{
//将序列号转换为SourceCode
DataCollectFacade dataCollectfacade = new DataCollectFacade(this.DataProvider);
//对于序列号的输入框，需要进行一下处理
string startRCard = FormatHelper.CleanString(this.txtStartSnQuery.Text.Trim().ToUpper());
string endRCard = FormatHelper.CleanString(this.txtEndSnQuery.Text.Trim().ToUpper());
//转换成SourceCard
string startSourceCard = dataCollectfacade.GetSourceCard(startRCard, string.Empty);
string endSourceCard = dataCollectfacade.GetSourceCard(endRCard, string.Empty);
//end
int OQCBeginDate = FormatHelper.TODateInt(this.txtOQCBeginDate.Text);
int OQCEndDate = FormatHelper.TODateInt(this.txtOQCEndDate.Text);
//int OQCBeginTime = FormatHelper.TOTimeInt(this.txtOQCBeginTime.Text);
//int OQCEndTime = FormatHelper.TOTimeInt(this.txtOQCEndTime.Text);
BenQGuru.eMES.OQC.OQCFacade oqcfacade = new BenQGuru.eMES.OQC.OQCFacade(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
oqcfacade.QueryOQCLot2CardCheck(
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtOQCLotQuery.Text),
FormatHelper.CleanString(startSourceCard),
FormatHelper.CleanString(endSourceCard),
FormatHelper.CleanString(this.txtSSCode.Text),
FormatHelper.CleanString(this.txtBigSSCodeWhere.Text),
FormatHelper.CleanString(this.txtMaterialModelCodeWhere.Text),
FormatHelper.CleanString(this.txtOQCLotTypeQuery.Text),
FormatHelper.CleanString(this.txtReWorkMOQuery.Text),
FormatHelper.CleanString(this.txtProductionTypeQuery.Text),
FormatHelper.CleanString(this.drpCrewCodeQuery.SelectedValue),
FormatHelper.CleanString(this.txtOQCMUserRQuery.Text),
OQCBeginDate, 0,
OQCEndDate, 235959,
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).RowCount =
oqcfacade.QueryOQCLot2CardCheckCount(
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtOQCLotQuery.Text),
FormatHelper.CleanString(startSourceCard),
FormatHelper.CleanString(endSourceCard),
FormatHelper.CleanString(this.txtSSCode.Text),
FormatHelper.CleanString(this.txtBigSSCodeWhere.Text),
FormatHelper.CleanString(this.txtMaterialModelCodeWhere.Text),
FormatHelper.CleanString(this.txtOQCLotTypeQuery.Text),
FormatHelper.CleanString(this.txtReWorkMOQuery.Text),
FormatHelper.CleanString(this.txtProductionTypeQuery.Text),
FormatHelper.CleanString(this.drpCrewCodeQuery.SelectedValue),
FormatHelper.CleanString(this.txtOQCMUserRQuery.Text),
OQCBeginDate, 0,
OQCEndDate, 235959);
}
protected void cmdSave_ServerClick(object sender, EventArgs e)
{
if (CheckData() == false)
{
return;
}
try
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)base.DataProvider).PersistBroker.OpenConnection();
if (_facade == null)
{
_facade = new OQCFacadeFactory(base.DataProvider).CreateOQCFacade();
}
OQCFuncTest test = (OQCFuncTest)_facade.GetOQCFuncTest(this.txtItemCode.Text);
bool bIsNew = false;
if (test == null)
{
bIsNew = true;
test = new OQCFuncTest();
}
test.ItemCode = this.txtItemCode.Text;
test.FuncTestGroupCount = Convert.ToDecimal(this.txtGroupCount.Text);
// test.MinDutyRatoMin = 0;
// test.MinDutyRatoMax = 0;
// test.BurstMdFreMin = 0;
// test.BurstMdFreMax = 0;
test.ElectricTestCount = Convert.ToDecimal(this.txtElectricCount.Text);
test.MaintainUser = this.GetUserCode();
test.MaintainDate = FormatHelper.TODateInt(DateTime.Today);
test.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
if (bIsNew == true)
{
_facade.AddOQCFuncTest(test);
}
else
{
_facade.UpdateOQCFuncTest(test);
}
// string strSql = "DELETE FROM tblOQCFuncTestSpec WHERE ItemCode='" + this.txtItemCode.Text + "'";
// this.DataProvider.CustomExecute(new SQLCondition(strSql));
//
// for (int i = 0; i < this.gridWebGrid.Rows.Count; i++)
// {
// OQCFuncTestSpec spec = new OQCFuncTestSpec();
// spec.ItemCode = this.txtItemCode.Text;
// spec.GroupSequence = i;
// spec.FreMin = Convert.ToDecimal(this.gridWebGrid.Rows[i].Cells.FromKey("FreMin").Value);
// spec.FreMax = Convert.ToDecimal(this.gridWebGrid.Rows[i].Cells.FromKey("FreMax").Value);
// spec.ElectricMin = Convert.ToDecimal(this.gridWebGrid.Rows[i].Cells.FromKey("ElectricMin").Value);
// spec.ElectricMax = Convert.ToDecimal(this.gridWebGrid.Rows[i].Cells.FromKey("ElectricMax").Value);
// spec.MaintainUser = this.GetUserCode();
// spec.MaintainDate = FormatHelper.TODateInt(DateTime.Today);
// spec.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
// _facade.AddOQCFuncTestSpec(spec);
// }
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)base.DataProvider).PersistBroker.CommitTransaction();
}
catch (Exception ex)
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)base.DataProvider).PersistBroker.RollbackTransaction();
throw ex;
}
finally
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)base.DataProvider).PersistBroker.CloseConnection();
}
}
