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);
}
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));
}
//<ÈÑÑÓí ãí ˜äÏ Çíä ÔãÇÑå ÝǘÊæÑ ÈÑÇí ˜ÇÑÈÑ ãÑÈæØå ãí ÈÇÔÏ >
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));
}
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);
}
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);
}
//<ÝǘÊæÑ ÑÇ ÊÇÆíÏ íÇ áÛæ ãí ˜äÏ>
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);
}
//<ÈÑÑÓí ãí ˜äÏ Çíä ÔãÇÑå ÝǘÊæÑ ÈÑÇí ˜ÇÑÈÑ ãÑÈæØå ãí ÈÇÔÏ >
public bool check_factor(Common.ShopingDatum dm)
{
if (dl.check_factor(dm).Rows.Count > 0)
{
return(true);
}
else
{
return(false);;
}
}
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));
}
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"));
}
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);
}
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);
}
public DataTable select_factor_all_User(Common.ShopingDatum dm)
{
return(dl.select_factor_all_User(dm));
}
public void Factor_Update_Takhfif(Common.ShopingDatum dm)
{
dl.Factor_Update_Takhfif(dm);
}
public void Update_Send_Factor(Common.ShopingDatum dm)
{
dl.Update_Send_Factor(dm);
}
public void Update_Factor_Condition(Common.ShopingDatum dm)
{
dl.Update_Factor_Condition(dm);
}
//<ÝǘÊæÑ ÑÇ ÊÇÆíÏ íÇ áÛæ ãí ˜äÏ>
public void Update_Factor_Agreement(Common.ShopingDatum dm)
{
dl.Update_Factor_Agreement(dm);
}
//<äÔÇä ãí ÏåÏ Çíä ÔãÇÑå ÝǘÊæÑ ÊÇÆíÏ ÔÏ íÇ äÔÏ æ íÇ åäæÒ ÚãáíÇÊí ÇäÌÇã äÔÏå>
public DataTable check_agreement_factor(Common.ShopingDatum dm)
{
return(dl.check_agreement_factor(dm));
}
public DataTable select_factor_sended(Common.ShopingDatum dm, string City, string Country)
{
DataTable dt = dl.select_factor_sended(dm);
return(FilterFactorByCityCountry(dt, City, Country));
}
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);
}
public void Update_Peyment_Factor(Common.ShopingDatum dm)
{
dl.Update_Peyment_Factor(dm);
}
public void Delete(Common.ShopingDatum dm)
{
dl.Delete(dm);
}
public void Insert_Factor_Details(Common.ShopingDatum dm)
{
dl.Insert_Factor_Details(dm);
}
//<ÝǘÊæÑ åÇí ÇÒ ˜ÇÑÈÑ ˜å ÇÑÓÇá ÔÏ ÑÇ äÔÇä ãí ÏåÏ>
public DataTable select_user_factor_send_ok(Common.ShopingDatum dm)
{
return(dl.select_user_factor_send_ok(dm));
}
public DataTable select_factor_one(Common.ShopingDatum dm)
{
return(dl.select_factor_one(dm));
}
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));
}
public decimal Insert_Factor(Common.ShopingDatum dm)
{
return(dl.Insert_Factor(dm));
}
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));
}
public DataTable select_factor_nopeyment(Common.ShopingDatum dm)
{
DataTable res = dl.select_factor_nopeyment(dm);
return(res);
}
