public void SetUp()
{
persistBroker = new OLEDBPersistBroker("Provider=OraOLEDB.Oracle.1;Password=emes;Persist Security Info=True;User ID=emes;Data Source=sqcdemo");
modelFacade = new ModelFacade();
itemFacade = new ItemFacade();
baseModelFacade = new BaseModelFacade();
}
/// <summary>
/// 透过DataConnect生成PersistBroker
/// </summary>
/// <returns></returns>
public IPersistBroker GetPersistBroker(RptViewDataConnect dataConnect)
{
if (dataConnect == null)
{
return(null);
}
IPersistBroker persistBroker = null;
string strPassword = BenQGuru.eMES.Common.Helper.EncryptionHelper.DESDecryption(dataConnect.Password);
if (dataConnect.ServerType == DatabaseType.SQLServer)
{
string strConn = string.Format("Data Source={0};User ID={1};Password={2};Initial Catalog={3};", dataConnect.ServiceName, dataConnect.UserName, strPassword, dataConnect.DefaultDatabase);
SqlPersistBroker sql = new SqlPersistBroker(strConn);
_connection = sql.Connection;
persistBroker = new BenQGuru.eMES.Common.PersistBroker.SqlPersistBroker(strConn);
}
else if (dataConnect.ServerType == DatabaseType.Oracle)
{
string strConn = string.Format("Provider=OraOLEDB.Oracle;Data Source={0};User ID={1};Password={2};Persist Security Info=True;", dataConnect.ServiceName, dataConnect.UserName, strPassword);
OLEDBPersistBroker ole = new OLEDBPersistBroker(strConn);
_connection = ole.Connection;
persistBroker = new BenQGuru.eMES.Common.PersistBroker.OLEDBPersistBroker(strConn);
}
return(persistBroker);
}
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 void TestSMTCopy()
{
persistBroker = new OLEDBPersistBroker("Provider=OraOLEDB.Oracle.1;Password=emes;Persist Security Info=True;User ID=emes;Data Source=sqcdemo");
// clear data
// insert info of MO UT_MOCODE1
string sql = "INSERT INTO TBLSMTRESBOM (MOCODE,ROUTECODE,OPCODE,RESCODE,STATIONCODE,ITEMCODE,OPBOMCODE,OPBOMVER,LOTNO,PCBA,BIOS,VERSION,VENDERITEMCODE,VENDORCODE,DATECODE,FEEDERCODE,MUSER,MDATE,MTIME,EATTRIBUTE1,OBITEMCODE) VALUES ('UT_MOCODE1','UT_ROUTECODE1','UT_OPERATIONCODE1','UT_RESOURCE1','{0}','UT_ITEMCODE1','UT_ROUTECODE1','OPBOMVER1','LOTNO','PCBA','BIOS','VERSION','VENDERITEMCODE','VENDORCODE','DATECODE','FEEDER1','vizo UnitTest',20050509,0,NULL,'P007-10594-03')";
persistBroker.Execute(string.Format(sql, "UT_STATION1"));
persistBroker.Execute(string.Format(sql, "UT_STATION2"));
persistBroker.Execute(string.Format(sql, "UT_STATION3"));
// copy from UT_MOCODE1 to UT_MOCODE2
BenQGuru.eMES.SMT.SMTFacade facade = new BenQGuru.eMES.SMT.SMTFacade();
facade.CopySMTResourceBOM("UT_MOCODE1", "UT_MOCODE2", "UT_ROUTECODE1", "UT_OPERATIONCODE1", "UT_RESOURCE1");
// check smtbom count of UT_MOCODE2
int cnt1 = facade.QuerySMTResourceBOMCount(string.Empty, "UT_MOCODE1", string.Empty, string.Empty, string.Empty, string.Empty);
int cnt2 = facade.QuerySMTResourceBOMCount(string.Empty, "UT_MOCODE2", string.Empty, string.Empty, string.Empty, string.Empty);
// clear data
sql = "delete from tblsmtresbom where mocode like 'UT_%'";
persistBroker.Execute(sql);
Console.WriteLine("cnt1={0} , cnt2={1}", cnt1, cnt2);
Assert.AreEqual(cnt1, cnt2);
Assert.AreEqual(3, cnt1);
}
public void SetUp()
{
persistBroker = new OLEDBPersistBroker("Provider=OraOLEDB.Oracle.1;Password=emes;Persist Security Info=True;User ID=emes;Data Source=sqcdemo");
dataCollectFacade = new DataCollectFacade();
}
public void SetUp()
{
broker = new OLEDBPersistBroker("Provider=OraOLEDB.Oracle.1;Password=emes;Persist Security Info=True;User ID=emes;Data Source=sqcdemo");
facade = new ShiftModelFacade();
}
public void SetUp()
{
persistBroker = new OLEDBPersistBroker("Provider=OraOLEDB.Oracle.1;Password=emes;Persist Security Info=True;User ID=emes;Data Source=sqcdemo");
dataCollect = new ActionOnLineHelper(DataProvider);
}
