示例#1
0
        // 출고타입별 기본 배송비를 가져온다
        public static List <EstShippingFeeModels> GetCostTableData(
            string est_code
            , string ese_code
            , string nation_code
            , string release_code
            )
        {
            string sql1 = "select "
                          + "SEQNO"
                          + ", EST_CODE"
                          + ", ESE_CODE"
                          + ", NATION_CODE"
                          + ", RELEASE_CODE"
                          + ", WEIGHT"
                          + ", SHIPPING_FEE_NOR"
                          + ", SHIPPING_FEE_STC"
                          + " from est_shipping_fee"
                          + string.Format(" where EST_CODE='{0}'", est_code)
                          + string.Format(" and ESE_CODE='{0}'", ese_code)
                          + string.Format(" and NATION_CODE='{0}'", nation_code)
                          + string.Format(" and RELEASE_CODE='{0}'", release_code)
                          + " order by WEIGHT"
                          + "";

            string    err1 = "";
            DataTable dt1  = DatabaseConnection.GetDataTableMySQL(sql1, out err1);

            if (dt1 == null)
            {
                return(null);
            }



            List <EstShippingFeeModels> SHIPPING_FEE_LIST = new List <EstShippingFeeModels>();

            for (int i = 0; i < dt1.Rows.Count; i++)
            {
                EstShippingFeeModels SHIPPING_FEE = new EstShippingFeeModels();

                SHIPPING_FEE.SEQNO            = GlobalFunction.GetInt(dt1.Rows[i]["SEQNO"].ToString().Trim());                  //	int(10) unsigned	PRI	auto_increment	일련번호 (자동증가)
                SHIPPING_FEE.EST_CODE         = dt1.Rows[i]["EST_CODE"].ToString().Trim();                                      //	varchar(5)			STATION 코드
                SHIPPING_FEE.ESE_CODE         = dt1.Rows[i]["ESE_CODE"].ToString().Trim();                                      //	varchar(8)  SENDER 코드("00000000" : 기본 요율표)
                SHIPPING_FEE.NATION_CODE      = dt1.Rows[i]["NATION_CODE"].ToString().Trim();                                   //	char(2)			국가코드
                SHIPPING_FEE.RELEASE_CODE     = dt1.Rows[i]["RELEASE_CODE"].ToString().Trim();                                  //	varchar(20)			출고타입 코드
                SHIPPING_FEE.WEIGHT           = GlobalFunction.GetDouble(dt1.Rows[i]["WEIGHT"].ToString().Trim(), 3);           //	double			무게(kg : 소수점 3자리)
                SHIPPING_FEE.SHIPPING_FEE_NOR = GlobalFunction.GetDouble(dt1.Rows[i]["SHIPPING_FEE_NOR"].ToString().Trim(), 2); //	double			일반신청 배송비(MAR : 소수점 2자리)
                SHIPPING_FEE.SHIPPING_FEE_STC = GlobalFunction.GetDouble(dt1.Rows[i]["SHIPPING_FEE_STC"].ToString().Trim(), 2); //	double			보관신청 배송비(MAR : 소수점 2자리)

                SHIPPING_FEE_LIST.Add(SHIPPING_FEE);
            }

            return(SHIPPING_FEE_LIST);
        }
示例#2
0
        // 기본요율표를 설정하기 위한 템플릿을 리턴한다
        public static List <EstShippingFeeModels> GetEmptyCostTable(string weight_unit)
        {
            string WEIGHT_UNIT = weight_unit.ToUpper();

            double weight     = 0;
            double add_weight = ((weight_unit == "KG") ? 0.5 : 1);
            double max_weight = ((weight_unit == "KG") ? 30 : 60);

            List <EstShippingFeeModels> SHIPPING_FEE_LIST = new List <EstShippingFeeModels>();

            while (Math.Abs(max_weight - weight) > 0.001)
            {
                weight += add_weight;

                EstShippingFeeModels Fee = new EstShippingFeeModels();
                Fee.WEIGHT           = weight;
                Fee.SHIPPING_FEE_NOR = 0.0;
                Fee.SHIPPING_FEE_STC = 0.0;
                SHIPPING_FEE_LIST.Add(Fee);
            }

            return(SHIPPING_FEE_LIST);
        }