示例#1
0
 public void Update_Factor_Condition(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[2];
     prms[0] = new SqlParameter("@id", dm.Id_Factor);
     prms[1] = new SqlParameter("@factor_condition", dm.Factor_Condition);
     sh.ExecuteNonQuery("shop_factor_condition_update", prms);
 }
示例#2
0
 public DataTable select_user_factor_ok(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[2];
     prms[0] = new SqlParameter("@id_user", dm.Id_User);
     prms[1] = new SqlParameter("@factor_agreement", "True");
     return(sh.ExecuteDataSet("shop_factor_user_select_ok", prms));
 }
示例#3
0
 //<ÈÑÑÓí ãí ˜äÏ Çíä ÔãÇÑå ÝǘÊæÑ ÈÑÇí ˜ÇÑÈÑ ãÑÈæØå ãí ÈÇÔÏ >
 public DataTable check_factor(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[3];
     prms[0] = new SqlParameter("@id", dm.Id_Factor);
     prms[1] = new SqlParameter("@id_user", dm.Id_User);
     prms[2] = new SqlParameter("@factor_code", dm.Factor_Code);
     return(sh.ExecuteDataSet("shop_factor_check", prms));
 }
示例#4
0
 public void Update_Send_Factor(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[3];
     prms[0] = new SqlParameter("@id", dm.Id_Factor);
     prms[1] = new SqlParameter("@Date_Send", dm.Date_Send);
     prms[2] = new SqlParameter("@Send_Product", dm.Send_Product);
     sh.ExecuteNonQuery("shop_factor_Send_update", prms);
 }
示例#5
0
 public void Insert_Factor_Details(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[3];
     prms[0] = new SqlParameter("@id_product", dm.Id_Product);
     prms[1] = new SqlParameter("@id_factor", dm.Id_Factor);
     prms[2] = new SqlParameter("@product_count", dm.Count);
     sh.ExecuteNonQuery("shop_details_insert", prms);
 }
示例#6
0
 //<ÝǘÊæÑ ÑÇ ÊÇÆíÏ íÇ áÛæ ãí ˜äÏ>
 public void Update_Factor_Agreement(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[4];
     prms[0] = new SqlParameter("@id", dm.Id_Factor);
     prms[1] = new SqlParameter("@factor_agreement", dm.Factor_Agreement);
     prms[2] = new SqlParameter("@date_agreement_factor", dm.Date_Agreement_Factor);
     prms[3] = new SqlParameter("@factor_condition", dm.Factor_Condition);
     sh.ExecuteNonQuery("shop_factor_agreement_update", prms);
 }
示例#7
0
 //<ÈÑÑÓí ãí ˜äÏ Çíä ÔãÇÑå ÝǘÊæÑ ÈÑÇí ˜ÇÑÈÑ ãÑÈæØå ãí ÈÇÔÏ >
 public bool check_factor(Common.ShopingDatum dm)
 {
     if (dl.check_factor(dm).Rows.Count > 0)
     {
         return(true);
     }
     else
     {
         return(false);;
     }
 }
示例#8
0
 public DataTable select_factor_sended(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[4];
     dm.Register_Date = '%' + dm.Register_Date + '%';
     dm.Factor_Code   = '%' + dm.Factor_Code + '%';
     dm.Bank_Name     = '%' + dm.Bank_Name + '%';
     prms[0]          = new SqlParameter("@date_register", dm.Register_Date);
     prms[1]          = new SqlParameter("@Id_User", dm.Id_User);
     prms[2]          = new SqlParameter("@Factor_Code", dm.Factor_Code);
     prms[3]          = new SqlParameter("@id", dm.Bank_Name);
     return(sh.ExecuteDataSet("shop_factor_select_sended", prms));
 }
示例#9
0
 public decimal Insert_Factor(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[8];
     prms[0] = new SqlParameter("@id_user", dm.Id_User);
     prms[1] = new SqlParameter("@date_register", dm.Register_Date);
     prms[2] = new SqlParameter("@sum_price", dm.Sum_Price);
     prms[3] = new SqlParameter("@factor_code", dm.Factor_Code);
     prms[4] = new SqlParameter("@factor_condition", dm.Factor_Condition);
     prms[5] = new SqlParameter("@send_price", dm.Send_Price);
     prms[6] = new SqlParameter("@customer_name", dm.Customer_Name);
     prms[7] = new SqlParameter("@Tasx", dm.Tasx);
     return(sh.ExecuteNonQueryIdentity("shop_factor_insert", prms, "id_factor"));
 }
示例#10
0
        public void Factor_Update_Takhfif(Common.ShopingDatum dm)
        {
            SqlParameter[] prms = new SqlParameter[6];

            prms[0] = new SqlParameter("@id", dm.Id_Factor);
            prms[1] = new SqlParameter("@Tasx", dm.Tasx);
            prms[2] = new SqlParameter("@Sum_Price", dm.Sum_Price);
            prms[3] = new SqlParameter("@Discount", dm.Discount);
            prms[4] = new SqlParameter("@Send_Price", dm.Send_Price);
            prms[5] = new SqlParameter("@description", dm.Description);

            sh.ExecuteNonQuery("shop_factor_Update_Takhfif", prms);
        }
示例#11
0
 public void Update_Peyment_Factor(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[12];
     prms[0]  = new SqlParameter("@id", dm.Id_Factor);
     prms[1]  = new SqlParameter("@peyment_code", dm.Peyment_Code);
     prms[2]  = new SqlParameter("@bank_name", dm.Bank_Name);
     prms[3]  = new SqlParameter("@bank_code", dm.Bank_Code);
     prms[4]  = new SqlParameter("@peyment_date", dm.Peyment_Date);
     prms[5]  = new SqlParameter("@peyment_kind", dm.Peyment_Kind);
     prms[6]  = new SqlParameter("@peyment_price", dm.Peyment_Price);
     prms[7]  = new SqlParameter("@customer_name", dm.Customer_Name);
     prms[8]  = new SqlParameter("@customer_tell", dm.Customer_Tell);
     prms[9]  = new SqlParameter("@customer_time_recive", dm.Customer_Time_Recive);
     prms[10] = new SqlParameter("@customer_address", dm.Customer_Address);
     prms[11] = new SqlParameter("@description", dm.Description);
     sh.ExecuteNonQuery("shop_factor_peyment_update", prms);
 }
示例#12
0
 public DataTable select_factor_all_User(Common.ShopingDatum dm)
 {
     return(dl.select_factor_all_User(dm));
 }
示例#13
0
 public void Factor_Update_Takhfif(Common.ShopingDatum dm)
 {
     dl.Factor_Update_Takhfif(dm);
 }
示例#14
0
 public void Update_Send_Factor(Common.ShopingDatum dm)
 {
     dl.Update_Send_Factor(dm);
 }
示例#15
0
 public void Update_Factor_Condition(Common.ShopingDatum dm)
 {
     dl.Update_Factor_Condition(dm);
 }
示例#16
0
 //<ÝǘÊæÑ ÑÇ ÊÇÆíÏ íÇ áÛæ ãí ˜äÏ>
 public void Update_Factor_Agreement(Common.ShopingDatum dm)
 {
     dl.Update_Factor_Agreement(dm);
 }
示例#17
0
 //<äÔÇä ãí ÏåÏ Çíä ÔãÇÑå ÝǘÊæÑ ÊÇÆíÏ ÔÏ íÇ äÔÏ æ íÇ åäæÒ ÚãáíÇÊí ÇäÌÇã äÔÏå>
 public DataTable check_agreement_factor(Common.ShopingDatum dm)
 {
     return(dl.check_agreement_factor(dm));
 }
示例#18
0
        public DataTable select_factor_sended(Common.ShopingDatum dm, string City, string Country)
        {
            DataTable dt = dl.select_factor_sended(dm);

            return(FilterFactorByCityCountry(dt, City, Country));
        }
示例#19
0
 public void Delete(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[1];
     prms[0] = new SqlParameter("@Id_Factor", dm.Id_Factor);
     sh.ExecuteNonQuery("shop_factor_Delete", prms);
 }
示例#20
0
 public void Update_Peyment_Factor(Common.ShopingDatum dm)
 {
     dl.Update_Peyment_Factor(dm);
 }
示例#21
0
 public void Delete(Common.ShopingDatum dm)
 {
     dl.Delete(dm);
 }
示例#22
0
 public void Insert_Factor_Details(Common.ShopingDatum dm)
 {
     dl.Insert_Factor_Details(dm);
 }
示例#23
0
 //<ÝǘÊæÑ åÇí ÇÒ ˜ÇÑÈÑ ˜å ÇÑÓÇá ÔÏ ÑÇ äÔÇä ãí ÏåÏ>
 public DataTable select_user_factor_send_ok(Common.ShopingDatum dm)
 {
     return(dl.select_user_factor_send_ok(dm));
 }
示例#24
0
 public DataTable select_factor_one(Common.ShopingDatum dm)
 {
     return(dl.select_factor_one(dm));
 }
示例#25
0
 public DataTable select_user_factor(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[1];
     prms[0] = new SqlParameter("@id_user", dm.Id_User);
     return(sh.ExecuteDataSet("shop_factor_user_select", prms));
 }
示例#26
0
 public decimal Insert_Factor(Common.ShopingDatum dm)
 {
     return(dl.Insert_Factor(dm));
 }
示例#27
0
 public DataTable select_factor_one(Common.ShopingDatum dm)
 {
     SqlParameter[] prms = new SqlParameter[1];
     prms[0] = new SqlParameter("@id", dm.Id_Factor);
     return(sh.ExecuteDataSet("shop_factor_select_one", prms));
 }
示例#28
0
        public DataTable select_factor_nopeyment(Common.ShopingDatum dm)
        {
            DataTable res = dl.select_factor_nopeyment(dm);

            return(res);
        }