internal void LoadPartDescriptionInformation()
{
if (string.IsNullOrEmpty(this.PartNumber))
{
return;
}
IDbConnection cnn = DatabaceFactory.GetPISConnection();
IDbCommand cmd = null;
IDbDataParameter dp = null;
DbDataAdapter da = null;
cmd = DatabaceFactory.CreateCommand(this.GetPartDescriptionSQL(), DatabaseType.SQLServer, cnn);
dp = cmd.CreateParameter();
dp.ParameterName = "PN";
dp.Value = this.PartNumber;
cmd.Parameters.Add(dp);
da = DatabaceFactory.CreateAdapter(cmd, DatabaseType.SQLServer);
DataSet DsModel = new DataSet();
da.Fill(DsModel);
this.WriteToAttributePartDescription(DsModel.Tables[0]);
}
/// <summary>
/// Load only model master information
/// </summary>
/// <param name="modelname"></param>
internal void LoadModelPublish()
{
if (string.IsNullOrEmpty(this.Model_Name))
{
return;
}
IDbConnection cnn = DatabaceFactory.GetPISConnection();
IDbCommand cmd = null;
IDbDataParameter dp = null;
DbDataAdapter da = null;
cmd = DatabaceFactory.CreateCommand(this.GetPublishSQL(), DatabaseType.SQLServer, cnn);
dp = cmd.CreateParameter();
dp.ParameterName = "model_name";
dp.Value = this.Model_Name;
cmd.Parameters.Add(dp);
da = DatabaceFactory.CreateAdapter(cmd, DatabaseType.SQLServer);
DataSet DsModel = new DataSet();
da.Fill(DsModel);
this.WriteToAttributePublish(DsModel.Tables[0]);
}
internal void LoadPartDetail()
{
//希望能增加外部傳入參數的方式來指定連線字串
IDbConnection cnn = DatabaceFactory.GetPISConnection();
StringBuilder sql = new StringBuilder();
IDbCommand cmd = DatabaceFactory.CreateCommand(sql.ToString(), DatabaseType.SQLServer, cnn);
IDbDataParameter dp = cmd.CreateParameter();
dp.ParameterName = "PN";
dp.Value = this.PartNumber;
cmd.Parameters.Add(dp);
//Get Specs and Descriptions
sql.Clear();
sql.Append(this.GetPartSpecsSQL());
sql.Append(" ; ");
sql.Append(this.GetPartDescriptionSQL());
cmd.CommandText = sql.ToString();
DbDataAdapter da = DatabaceFactory.CreateAdapter(cmd, DatabaseType.SQLServer);
DataSet dsPart = new DataSet();
da.Fill(dsPart);
//======================Product Spec==========================================
this.WriteToAttributePartSpecs(dsPart.Tables[0]);
//======================Product Description==========================================
this.WriteToAttributePartDescription(dsPart.Tables[1]);
}
public static bool LogQuote2Order(string OrderID, string QuoteID, ref string Msg)
{
if (string.IsNullOrEmpty(OrderID) || string.IsNullOrEmpty(QuoteID))
{
return(false);
}
StringBuilder sql = new StringBuilder();
sql.Append(" select top 1 ORDER_ID, ORDER_NO,PO_NO,CREATED_DATE,CREATED_BY ");
sql.Append(" from ORDER_MASTER where ORDER_ID =@ORDER_ID ");
IDbDataParameter dp = null;
IDbConnection connMY = DatabaceFactory.CreateConnection(ConfigurationManager.ConnectionStrings["MY"].ConnectionString, DatabaseType.SQLServer);
IDbCommand cmd = DatabaceFactory.CreateCommand(sql.ToString(), DatabaseType.SQLServer, connMY);
dp = cmd.CreateParameter();
dp.ParameterName = "ORDER_ID";
dp.Value = OrderID;
cmd.Parameters.Add(dp);
DbDataAdapter da = DatabaceFactory.CreateAdapter(cmd, DatabaseType.SQLServer);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
sql.Clear();
sql.Append(" INSERT INTO [QUOTE_TO_ORDER_LOG] ([QUOTEID] ,[SO_NO],[PO_NO] ,[ORDER_DATE] ,[ORDER_BY]) ");
sql.Append(" VALUES ( @QUOTEID ,@SO_NO,@PO_NO ,@ORDER_DATE ,@ORDER_BY) ");
IDbConnection connEQ = DatabaceFactory.CreateConnection(ConfigurationManager.ConnectionStrings["EQ"].ConnectionString, DatabaseType.SQLServer);
cmd = DatabaceFactory.CreateCommand(sql.ToString(), DatabaseType.SQLServer, connEQ);
dp = cmd.CreateParameter(); dp.ParameterName = "QUOTEID"; dp.Value = QuoteID; cmd.Parameters.Add(dp);
dp = cmd.CreateParameter(); dp.ParameterName = "SO_NO"; dp.Value = dt.Rows[0]["ORDER_NO"] ?? ""; cmd.Parameters.Add(dp);
dp = cmd.CreateParameter(); dp.ParameterName = "PO_NO"; dp.Value = dt.Rows[0]["PO_NO"] ?? ""; cmd.Parameters.Add(dp);
dp = cmd.CreateParameter(); dp.ParameterName = "ORDER_DATE"; dp.Value = dt.Rows[0]["CREATED_DATE"] ?? ""; cmd.Parameters.Add(dp);
dp = cmd.CreateParameter(); dp.ParameterName = "ORDER_BY"; dp.Value = dt.Rows[0]["CREATED_BY"] ?? ""; cmd.Parameters.Add(dp);
int retInt = -1;
connEQ.Open();
try
{
retInt = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Msg = ex.ToString();
}
finally
{
connEQ.Close();
connMY.Close();
}
if (retInt > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
///
/// </summary>
/// <param name="category_id"></param>
/// <param name="model_id"></param>
/// <returns></returns>
internal string GetModelNameByCategory_ModelID(string category_id, string model_id)
{
if (string.IsNullOrEmpty(model_id))
{
return("");
}
StringBuilder sql = new StringBuilder();
sql.Append(" Select m.model_name,m.model_id ");
sql.Append(" From Category_Model c inner join Model m on c.model_name=m.model_name ");
sql.Append(" Where c.category_id=@category_id ");
sql.Append(" And m.model_id=@model_id ");
IDbConnection cnn = DatabaceFactory.GetPISConnection();
IDbCommand cmd = null; IDbDataParameter dp = null; DbDataAdapter da = null;
cmd = DatabaceFactory.CreateCommand(sql.ToString(), DatabaseType.SQLServer, cnn);
dp = cmd.CreateParameter();
dp.ParameterName = "category_id";
dp.Value = category_id;
cmd.Parameters.Add(dp);
dp = cmd.CreateParameter();
dp.ParameterName = "model_id";
dp.Value = model_id;
cmd.Parameters.Add(dp);
da = DatabaceFactory.CreateAdapter(cmd, DatabaseType.SQLServer);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
return((string)dt.Rows[0]["model_name"]);
}
return("");
}
internal void LoadModels(bool IsCompleteMode = false)
{
IDbConnection cnn = DatabaceFactory.GetPISConnection();
StringBuilder sql = new StringBuilder();
//優化這一段，如果已查過一次model資訊，在model建構子中就不用再查一次model資訊
sql.Append(this.GetPartModelByPISSQL());
//sql.AppendLine(string.Format(" Select distinct m.Model_name, mp.part_no as PART_NO, m.MODEL_ID "));
//sql.AppendLine(string.Format(" From model m "));
//sql.AppendLine(string.Format(" left join Category_Model cm on cm.Model_name=m.Model_name "));
//sql.AppendLine(string.Format(" left join CATALOG_CATEGORY cc on cc.Category_id=cm.Category_id "));
//sql.AppendLine(string.Format(" left join Model_Publish mpu on mpu.model_name =m.model_name and mpu.Site_ID ='ACL' "));
//sql.AppendLine(string.Format(" left join model_product mp on m.model_name=mp.Model_name and mp.relation='product' and mp.PART_NO = @PN "));
//sql.AppendLine(string.Format(" left join product on product.part_no=mp.Part_no "));
//sql.AppendLine(string.Format(" Where cc.CATALOGID IN ('{0}', '{1}') ", new string[] { "1-2JKBQD", "1-2MLAX2" }));
//sql.AppendLine(string.Format(" And mpu.Active_FLG ='Y'"));
//sql.AppendLine(string.Format(" And mp.STATUS<>'deleted' "));
//sql.AppendLine(string.Format(" AND (PRODUCT.PART_NO =@PN or m.Model_name= substring(@PN,0, charindex('-',@PN,charindex('-',@PN)+1)) "));
//sql.AppendLine(string.Format(" or m.MODEL_NAME =@PN "));
//sql.AppendLine(string.Format(" ) "));
//sql.AppendLine(string.Format(" Order by m.Model_name DESC "));
IDbCommand cmd = DatabaceFactory.CreateCommand(sql.ToString(), DatabaseType.SQLServer, cnn);
IDbDataParameter dp = cmd.CreateParameter();
dp.ParameterName = "PN";
dp.Value = this.PartNumber;
cmd.Parameters.Add(dp);
DbDataAdapter da = DatabaceFactory.CreateAdapter(cmd, DatabaseType.SQLServer);
DataTable dt = new DataTable("Model");
da.Fill(dt);
if (dt == null || dt.Rows.Count == 0)
{
//If part is not hooked to model in PIS, then get model and part relationship from SAP(PRODUCT_LOGISTICS_NEW)
sql.Clear();
sql.Append(this.GetPartModelBySAPSQL());
//sql.AppendLine(string.Format(" Select distinct top 1 m.Model_name,ISNULL(mp.part_no,pln.PART_NO) as PART_NO ,m.MODEL_ID "));
//sql.AppendLine(string.Format(" from dbo.model m "));
//sql.AppendLine(string.Format(" left join dbo.Category_Model cm on cm.Model_name=m.Model_name "));
//sql.AppendLine(string.Format(" left join dbo.CATALOG_CATEGORY cc on cc.Category_id=cm.Category_id "));
//sql.AppendLine(string.Format(" left join Model_Publish mpu on mpu.model_name =m.model_name and mpu.Site_ID ='ACL' "));
//sql.AppendLine(string.Format(" left join PRODUCT_LOGISTICS_NEW pln on pln.MODEL_NO =m.MODEL_NAME "));
//sql.AppendLine(string.Format(" and pln.PART_NO = @PN "));
//sql.AppendLine(string.Format(" left join model_product mp on m.model_name=mp.Model_name and mp.relation='product' and mp.PART_NO = @PN "));
//sql.AppendLine(string.Format(" left join product on product.part_no=mp.Part_no "));
//sql.AppendLine(string.Format(" Where cc.CATALOGID IN ('{0}', '{1}') ", new string[] { "1-2JKBQD", "1-2MLAX2" }));
//sql.AppendLine(string.Format(" And mp.STATUS<>'deleted' "));
//sql.AppendLine(string.Format(" AND (PRODUCT.PART_NO =@PN or m.Model_name= substring(@PN,0, charindex('-',@PN,charindex('-',@PN)+1)) "));
//sql.AppendLine(string.Format(" or pln.PART_NO =@PN or m.MODEL_NAME =@PN "));
//sql.AppendLine(string.Format(" ) "));
//sql.AppendLine(string.Format(" order by m.Model_name DESC "));
cmd.CommandText = sql.ToString();
dt = new DataTable("Model");
da.Fill(dt);
}
foreach (DataRow _row in dt.Rows)
{
Model _model = new Model((string)_row["Model_name"]);
if (IsCompleteMode)
{
_model.LoadCompleteModelInformation();
}
else
{
_model.LoadBasicModelInformation();
}
this._Models.Add(_model);
}
}
public void getOfficeGroupByEripIdOrg(string AccountRowId, string EripId, string org, out string officecode, out string groupcode, ref string Msg)
{
officecode = string.Empty; groupcode = string.Empty; EripId = EripId.Trim().ToUpper();
DataTable dt = new DataTable();
IDbConnection connMY = DatabaceFactory.CreateConnection(ConfigurationManager.ConnectionStrings["MY"].ConnectionString, DatabaseType.SQLServer);
IDbConnection connEQ = DatabaceFactory.CreateConnection(ConfigurationManager.ConnectionStrings["EQ"].ConnectionString, DatabaseType.SQLServer);
if (!string.IsNullOrEmpty(EripId))
{
string sql = string.Format("SELECT top 1 isnull(SalesOffice,'') as OfficeCode, isnull(SalesGroup,'') as GroupCode from sap_dimcompany where org_ID='{0}' AND company_id='{1}'", org, EripId);
IDbCommand cmd = DatabaceFactory.CreateCommand(sql, DatabaseType.SQLServer, connMY);
DbDataAdapter da = DatabaceFactory.CreateAdapter(cmd, DatabaseType.SQLServer);
connMY.Open();
da.Fill(dt);
if (dt != null && dt.Rows.Count == 1)
{
if (!string.IsNullOrEmpty(dt.Rows[0]["OfficeCode"].ToString()))
{
officecode = dt.Rows[0]["OfficeCode"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["GroupCode"].ToString()))
{
groupcode = dt.Rows[0]["GroupCode"].ToString();
}
}
connMY.Close();
}
if (string.IsNullOrEmpty(officecode) || string.IsNullOrEmpty(groupcode))
{
StringBuilder sb = new StringBuilder();
sb.Append(" SELECT TOP 1 a.ROW_ID, ISNULL(b.ATTRIB_05, N'') AS ERP_ID, a.NAME AS ACCOUNT_NAME, ");
sb.Append(" a.CUST_STAT_CD AS ACCOUNT_STATUS, ISNULL(a.MAIN_FAX_PH_NUM, N'') AS FAX_NUM, ");
sb.Append(" ISNULL(a.MAIN_PH_NUM, N'') AS PHONE_NUM, ISNULL(a.OU_TYPE_CD, N'') AS OU_TYPE_CD, ISNULL(a.URL, N'') ");
sb.Append(" AS URL, ISNULL(b.ATTRIB_34, N'') AS BusinessGroup, ISNULL(a.OU_TYPE_CD, N'') AS ACCOUNT_TYPE, ");
sb.Append(" ISNULL(c.NAME, N'') AS RBU, ISNULL");
sb.Append(" ((SELECT EMAIL_ADDR");
sb.Append(" FROM S_CONTACT");
sb.Append(" WHERE (ROW_ID IN");
sb.Append(" (SELECT PR_EMP_ID");
sb.Append(" FROM S_POSTN");
sb.Append(" WHERE (ROW_ID IN");
sb.Append(" (SELECT PR_POSTN_ID");
sb.Append(" FROM S_ORG_EXT");
sb.Append(" WHERE (ROW_ID = a.ROW_ID)))))), N'') AS PRIMARY_SALES_EMAIL, ");
sb.Append(" a.PAR_OU_ID AS PARENT_ROW_ID, ISNULL(b.ATTRIB_09, N'N') AS MAJORACCOUNT_FLAG, ISNULL(a.CMPT_FLG, ");
sb.Append(" N'N') AS COMPETITOR_FLAG, ISNULL(a.PRTNR_FLG, N'N') AS PARTNER_FLAG, ISNULL(d.COUNTRY, N'') ");
sb.Append(" AS COUNTRY, ISNULL(d.CITY, N'') AS CITY, ISNULL(d.ADDR, N'') AS ADDRESS, ISNULL(d.STATE, N'') AS STATE, ");
sb.Append(" ISNULL(d.ZIPCODE, N'') AS ZIPCODE, ISNULL(d.PROVINCE, N'') AS PROVINCE, ISNULL");
sb.Append(" ((SELECT TOP (1) NAME");
sb.Append(" FROM S_INDUST");
sb.Append(" WHERE (ROW_ID = a.X_ANNIE_PR_INDUST_ID)), N'N/A') AS BAA, b.CREATED, ");
sb.Append(" b.LAST_UPD AS LAST_UPDATED, ISNULL");
sb.Append(" ((SELECT TOP (1) e.NAME");
sb.Append(" FROM S_PARTY AS e INNER JOIN");
sb.Append(" S_POSTN AS f ON e.ROW_ID = f.OU_ID");
sb.Append(" WHERE (f.ROW_ID IN");
sb.Append(" (SELECT PR_POSTN_ID");
sb.Append(" FROM S_ORG_EXT AS S_ORG_EXT_2");
sb.Append(" WHERE (ROW_ID = a.ROW_ID)))), N'') AS PriOwnerDivision, ");
sb.Append(" a.PR_POSTN_ID AS PriOwnerRowId, ISNULL");
sb.Append(" ((SELECT TOP (1) NAME");
sb.Append(" FROM S_POSTN AS f");
sb.Append(" WHERE (ROW_ID IN");
sb.Append(" (SELECT PR_POSTN_ID");
sb.Append(" FROM S_ORG_EXT AS S_ORG_EXT_1");
sb.Append(" WHERE (ROW_ID = a.ROW_ID)))), N'') AS PriOwnerPosition, CAST('' AS nvarchar(10)) ");
sb.Append(" AS LOCATION, CAST('' AS nvarchar(10)) AS ACCOUNT_TEAM, ISNULL(d.ADDR_LINE_2, N'') AS ADDRESS2, ");
sb.Append(" ISNULL(b.ATTRIB_36, N'') AS ACCOUNT_CC_GRADE, ISNULL(a.BASE_CURCY_CD, N'') AS CURRENCY");
sb.Append(" FROM S_ORG_EXT AS a LEFT OUTER JOIN");
sb.Append(" S_ORG_EXT_X AS b ON a.ROW_ID = b.ROW_ID LEFT OUTER JOIN");
sb.Append(" S_PARTY AS c ON a.BU_ID = c.ROW_ID LEFT OUTER JOIN");
sb.Append(" S_ADDR_ORG AS d ON a.PR_ADDR_ID = d.ROW_ID");
sb.Append(" WHERE (a.ROW_ID = @RID)");
IDbDataParameter dp = null;
IDbConnection connCRM = DatabaceFactory.CreateConnection(ConfigurationManager.ConnectionStrings["CRM"].ConnectionString, DatabaseType.SQLServer);
IDbCommand cmd = DatabaceFactory.CreateCommand(sb.ToString(), DatabaseType.SQLServer, connCRM);
dp = cmd.CreateParameter(); dp.ParameterName = "RID"; dp.Value = AccountRowId; cmd.Parameters.Add(dp);
connCRM.Open();
DbDataAdapter da = DatabaceFactory.CreateAdapter(cmd, DatabaseType.SQLServer);
dt.Clear();
da.Fill(dt);
if (dt != null && dt.Rows.Count == 1)
{
//'JJ 2014/2/13：Company_id如果空白時需要Office和Sales Group因為gpblock_logic這個table需要知道office和sales Group才能知道要appove給誰
//'由Sales的Emal去SIEBEL_POSITION的PRIMARY_POSITION_NAME查出字串如：AFR/Embedded/AOnline-eSales-SEU-Agnes_Iglesias，PRIMARY_POSITION_NAME 鎖定Embedded或iA
//'再由字串split(1)分出來Sales Group是EC Aonline(Embedded是EC Aonline、iA是iA Aonline)
//'由SIEBEL_POSITION join SIEBEL_CONTACT，再由SIEBEL_CONTACT的OrgID就能知道office
//'如果查不到就由317(EC Aonline)的[email protected]和[email protected]來appove
string UserEmail = HttpContext.Current.User.Identity.Name;
string sql = string.Format("SELECT TOP 1 a.PRIMARY_POSITION_NAME + ',' + b.OrgID FROM SIEBEL_POSITION a left join SIEBEL_CONTACT b on a.CONTACT_ID = b.ROW_ID WHERE a.EMAIL_ADDR =@UserEmail and(a.PRIMARY_POSITION_NAME like '%Embedded%' or a.PRIMARY_POSITION_NAME like '%iA%')");
cmd = DatabaceFactory.CreateCommand(sql, DatabaseType.SQLServer, connMY);
dp = cmd.CreateParameter(); dp.ParameterName = "UserEmail"; dp.Value = UserEmail; cmd.Parameters.Add(dp);
connMY.Open();
object retObj = null;
try
{
retObj = cmd.ExecuteScalar();
}
catch (Exception ex)
{ Msg += ex.ToString(); }
finally
{
connMY.Close();
}
//例：ABN/iA/AOnline-Manager-NEU-Wenyu_Lai,AUK
if ((retObj != null) && !string.IsNullOrEmpty(retObj.ToString()))
{
string sOffice = retObj.ToString().Split(new char[] { ',' })[1];
//例：AUK
string sGroup = retObj.ToString().Split(new char[] { ',' })[0].Split(new char[] { '/' })[1];
//例：iA
//轉換Sales Group Name
if (sGroup == "Embedded")
{
sGroup = "EC Aonline";
}
else if (sGroup == "iA")
{
sGroup = "iA Aonline";
}
//找出office code
sql = "SELECT TOP 1 OFFICE_CODE from gpblock_logic where OFFICE_NAME=@sOffice and active=1 AND TYPE='GP' and group_name=@sGroup";
cmd = DatabaceFactory.CreateCommand(sql, DatabaseType.SQLServer, connEQ);
dp = cmd.CreateParameter(); dp.ParameterName = "sOffice"; dp.Value = sOffice; cmd.Parameters.Add(dp);
IDbDataParameter dpgroup = cmd.CreateParameter(); dpgroup.ParameterName = "sGroup"; dpgroup.Value = sGroup; cmd.Parameters.Add(dpgroup);
connEQ.Open();
retObj = null;
try
{
retObj = cmd.ExecuteScalar();
}
catch (Exception ex)
{ Msg += ex.ToString(); }
finally
{
connEQ.Close();
}
if ((retObj != null) && !string.IsNullOrEmpty(retObj.ToString()))
{
officecode = retObj.ToString();
//找出Group code
sql = "SELECT TOP 1 GROUP_CODE from gpblock_logic where OFFICE_NAME=@sOffice and active=1 AND TYPE='GP' and group_name=@sGroup";
cmd = DatabaceFactory.CreateCommand(sql, DatabaseType.SQLServer, connEQ);
dp = cmd.CreateParameter(); dp.ParameterName = "sOffice"; dp.Value = sOffice; cmd.Parameters.Add(dp);
dpgroup = cmd.CreateParameter(); dpgroup.ParameterName = "sGroup"; dpgroup.Value = sGroup; cmd.Parameters.Add(dpgroup);
connEQ.Open();
retObj = null;
try
{
retObj = cmd.ExecuteScalar();
}
catch (Exception ex)
{ Msg += ex.ToString(); }
finally
{
connEQ.Close();
}
///////
if ((retObj != null) && !string.IsNullOrEmpty(retObj.ToString()))
{
groupcode = retObj.ToString();
}
else
{
groupcode = "317";
//找不到就都帶317 (EC Aonline)
}
}
else
{
//都沒有就由Account RBU去查office code，而group code就固定是317 (EC Aonline)
object R = new object();
sql = "SELECT TOP 1 OFFICE_CODE from gpblock_logic where OFFICE_NAME=@OFFICE_NAME and active=1 AND TYPE='GP' and group_name='317'";
cmd = DatabaceFactory.CreateCommand(sql, DatabaseType.SQLServer, connEQ);
dp = cmd.CreateParameter(); dp.ParameterName = "OFFICE_NAME"; dp.Value = dt.Rows[0]["RBU"]; cmd.Parameters.Add(dp);
connEQ.Open();
try
{
R = cmd.ExecuteScalar();
}
catch (Exception ex)
{ }
finally
{
connEQ.Close();
}
if ((R != null) && !string.IsNullOrEmpty(R.ToString()))
{
officecode = R.ToString();
groupcode = "317"; //找不到就都帶317 (EC Aonline)
}
}
}
}
connCRM.Close();
}
//JJ 2014/2/25 都找不到預設就帶ADL
if (string.IsNullOrEmpty(officecode))
{
officecode = "3000";
}
//JJ 2014/2/25 都找不到預設就帶EC Aonline
if (string.IsNullOrEmpty(groupcode))
{
groupcode = "317";
}
}
/// <summary>
/// Load complete model information
/// </summary>
/// <param name="modelname"></param>
internal void LoadCompleteModelInformation()
{
if (string.IsNullOrEmpty(this.Model_Name))
{
return;
}
IDbConnection cnn = DatabaceFactory.GetPISConnection();
IDbCommand cmd = null;
IDbDataParameter dp = null;
DbDataAdapter da = null;
StringBuilder sql = new StringBuilder();
//Frank 其它語系待處理
sql.Clear();
sql.AppendLine(this.GetModelSQL());
//Model in different Langs
sql.AppendLine(";");
sql.AppendLine(this.GetModel_LangSQL());
//Model literatures
sql.AppendLine(";");
sql.AppendLine(this.GetLiteraturesSQL());
//Model Features
sql.AppendLine(";");
sql.AppendLine(this.GetFeaturesSQL());
//Model Specs
sql.AppendLine(";");
sql.AppendLine(this.GetModelSpecsSQL());
cmd = DatabaceFactory.CreateCommand(sql.ToString(), DatabaseType.SQLServer, cnn);
dp = cmd.CreateParameter();
dp.ParameterName = "model_name";
dp.Value = this.Model_Name;
cmd.Parameters.Add(dp);
da = DatabaceFactory.CreateAdapter(cmd, DatabaseType.SQLServer);
DataSet DsModel = new DataSet();
da.Fill(DsModel);
//=====================Model=========================================
if (DsModel.Tables[0] != null)
{
this.WriteToAttributeModel(DsModel.Tables[0]);
}
//=====================Model_Langs=========================================
//Frank 其它語系待處理
if (DsModel.Tables[1] != null)
{
this.WriteToAttributeModel_Lang(DsModel.Tables[1]);
}
//=====================Literatures=====================================
if (DsModel.Tables[2] != null)
{
this.WriteToAttributeLiteratures(DsModel.Tables[2]);
}
//======================Features==========================================
if (DsModel.Tables[3] != null)
{
this.WriteToAttributeFeatures(DsModel.Tables[3]);
}
//======================Features==========================================
if (DsModel.Tables[4] != null)
{
this.WriteToAttributeModelSpecs(DsModel.Tables[4]);
}
}
