/// <summary>
/// 根据料号、客户别获取料号对应站别
/// </summary>
/// <param name="cust_No"></param>
/// <param name="key_Part_No"></param>
/// <returns></returns>
public DataSet Get_C_KEYPARTS_MODE_T(string cust_No, string key_Part_No)
{
DataSet ds = new DataSet();
string strSql = string.Format(@"SELECT A.KEY_PART_NO,A.PART_MODE FROM SFIS1.C_KEYPARTS_MODE_T A WHERE A.CUST_NO=:CUST_NO AND A.KEY_PART_NO=:KEY_PART_NO");
DBParameter dbParameter = new DBParameter();
dbParameter.Clear();
dbParameter.Add(":CUST_NO", OracleDbType.Varchar2, cust_No);
dbParameter.Add(":KEY_PART_NO", OracleDbType.Varchar2, key_Part_No);
try
{
ds = dbHander.ExecuteAsDataSet(strSql, dbParameter.GetParameters());
}
catch (Exception ex)
{
this.logHandler.Error(MethodBase.GetCurrentMethod().Name, "Call Get_C_KEYPARTS_MODE_T Fail: " + ex.Message);
}
return ds;
}
public static DataSet GetCatalogPricingRule(Int32 catalogPriceRuleID, AspxCommonInfo aspxCommonObj)
{
OracleHandler sqlHandler = new OracleHandler();
List <KeyValuePair <string, object> > paramList = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
paramList.Add(new KeyValuePair <string, object>("CatalogPriceRuleID", catalogPriceRuleID));
DataSet ds = sqlHandler.ExecuteAsDataSet("usp_Aspx_GetPricingRuleInfoByID", paramList);
return(ds);
}
public DataSet GetStoreSettingsByPortal(int storeID, int portalID, string cultureName)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("StoreID", storeID));
parameterCollection.Add(new KeyValuePair <string, object>("PortalID", portalID));
parameterCollection.Add(new KeyValuePair <string, object>("CultureName", cultureName));
DataSet ds = new DataSet();
OracleHandler sagesql = new OracleHandler();
ds = sagesql.ExecuteAsDataSet("usp_Aspx_GetStoreSettingForCac", parameterCollection);
return(ds);
}
catch (Exception e)
{
throw e;
}
}
public static List <SubscriptionInfo> NotificationUsersGetAll(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
OracleHandler sqLH = new OracleHandler();
DataSet ds = sqLH.ExecuteAsDataSet("usp_Aspx_NotificationUsersGetAll", parameterCollection);
List <SubscriptionInfo> SubscriptionDetails = new List <SubscriptionInfo>();
if (ds.Tables.Count > 0)
{
SubscriptionDetails = DataSourceHelper.FillCollection <SubscriptionInfo>(ds.Tables[0]);
}
return(SubscriptionDetails);
}
catch (Exception e)
{
throw e;
}
}