/// <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;
 }
Exemplo n.º 2
0
        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;
     }
 }