protected void lbRemoveFilterOutstanding_Click(object sender, EventArgs e)
{
if (ViewState["Ocode_igd"] != null)
{
ViewState["Ocode_igd"] = null;
}
if (ViewState["Obrand_name"] != null)
{
ViewState["Obrand_name"] = null;
}
if (ViewState["Osize_title"] != null)
{
ViewState["Osize_title"] = null;
}
if (ViewState["Ocolor_name"] != null)
{
ViewState["Ocolor_name"] = null;
}
if (ViewState["Ocode_igd"] != null)
{
ViewState["Ocode_igd"] = null;
}
if (ViewState["Oprovider_name"] != null)
{
ViewState["Oprovider_name"] = null;
}
if (ViewState["Oporz_title"] != null)
{
ViewState["Oporz_title"] = null;
}
if (ViewState["Ochele_title"] != null)
{
ViewState["Ochele_title"] = null;
}
if (ViewState["Oplan_title"] != null)
{
ViewState["Oplan_title"] = null;
}
GoodsClass objOutstanding = new GoodsClass();
List <GoodsClass> lstPricingClass = new List <GoodsClass>();
if (ViewState["Gstate"].ToString().Equals("1"))
{
lstPricingClass = objOutstanding.GetGoodsClass();
}
else
{
lstPricingClass = objOutstanding.GetNullGoodsClass();
}
grdViewOutstanding.DataSource = lstPricingClass;
grdViewOutstanding.DataBind();
ViewState["lstOutstandingOrders"] = lstPricingClass;
}
protected void btn_null_Click(object sender, EventArgs e)
{
ViewState["Gstate"] = "2";
GoodsClass objPricingClass = new GoodsClass();
List <GoodsClass> lstGoodsClass = new List <GoodsClass>();
lstGoodsClass = objPricingClass.GetNullGoodsClass();
grdViewOutstanding.DataSource = lstGoodsClass;
grdViewOutstanding.DataBind();
ViewState["lstOutstandingOrders"] = lstGoodsClass;
upnlOutstanding.Update();
}
public List <GoodsClass> GetGoodsClass()
{
List <GoodsClass> lstGoodsClass = new List <GoodsClass>();
DataTable dt = new DataTable(); Search obj = new Search(ConfigurationManager.ConnectionStrings["FarsheBoom"].ConnectionString);
Common cur = new Common();
dt = obj.Get_Data("SELECT srl, code_igd, brand_name, size_title, u_buy, color_name, porz_title, chele_title, plan_title, widht, lenght, provider_code, provider_name, selection, sold, buy_price, area, color_srl2,title_igd FROM dbo.Provider_Goods order by code_igd");
if (dt.Rows.Count > 0)
{
foreach (DataRow Woak in dt.Rows)
{
GoodsClass pc = new GoodsClass();
pc.srl = Woak["srl"].ToString();
pc.code_igd = Woak["code_igd"].ToString();
pc.brand_name = Woak["brand_name"].ToString();
pc.size_title = Woak["size_title"].ToString();
pc.u_buy = Woak["u_buy"].ToString();
pc.color_name = Woak["color_name"].ToString();
pc.porz_title = Woak["porz_title"].ToString();
pc.chele_title = Woak["chele_title"].ToString();
pc.plan_title = Woak["plan_title"].ToString();
pc.widht = Woak["widht"].ToString();
pc.lenght = Woak["lenght"].ToString();
pc.provider_code = Woak["provider_code"].ToString();
pc.provider_name = Woak["provider_name"].ToString();
pc.selection = Woak["selection"].ToString();
pc.sold = Woak["sold"].ToString();
pc.buy_price = Woak["buy_price"].ToString();
pc.margin_color = color(Woak["color_srl2"].ToString());
pc.area = Woak["area"].ToString();
pc.title_igd = Woak["title_igd"].ToString();
if (Woak["title_igd"].ToString().Length > 1)
{
pc.has_pic = "دارد";
}
else
{
pc.has_pic = "ندارد";
}
lstGoodsClass.Add(pc);
}
}
return(lstGoodsClass);
}
protected void btn_add_Click(object sender, EventArgs e)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
string txt = txt_enter_codes.Text.Replace("\r\n", "");
IEnumerable <string> here = Enumerable.Range(0, txt.Length / 6).Select(i => txt.Substring(i * 6, 6));
var ss = string.Join(",", here.ToArray());
Common obo = new Common();
DataTable dt = new DataTable(); Search obj = new Search(strConnString);
dt = obj.Get_Data(string.Format("SELECT srl,code_igd, provider_code, brand_name, size_title, carpet_title, porz_title, chele_title, lenght, widht, ROUND(lenght * widht / 10000, 2) AS area, color_srl2, plan_title, color_name, buy_price, ROUND(buy_price / NULLIF(ROUND(lenght * widht / 10000, 1), 0),0) AS u_buy,title_igd FROM dbo.Project_Goods_View Where header_srl={0} And code_igd Not In ({2}) order by {1}", lst_project.SelectedValue, lst_sort.SelectedValue, ss));
if (dt.Rows.Count > 0)
{
txt_count.Text = dt.Rows.Count.ToString();
DataSet1.CallBackDataTable Temp = new DataSet1.CallBackDataTable();
List <GoodsClass> lstGoodsClass = new List <GoodsClass>();
foreach (DataRow Woak in dt.Rows)
{
DataRow row = Temp.NewRow();
row["code_igd"] = Woak["code_igd"];
row["brand_name"] = Woak["brand_name"];
row["size_title"] = Woak["size_title"];
row["carpet_title"] = Woak["carpet_title"];
row["porz_title"] = Woak["porz_title"];
row["chele_title"] = Woak["chele_title"];
row["lenght"] = Woak["lenght"];
row["widht"] = Woak["widht"];
row["area"] = Woak["area"];
row["margin_color"] = color(Woak["color_srl2"].ToString());
row["plan_title"] = Woak["plan_title"];
row["color_name"] = Woak["color_name"];
row["provider_code"] = Woak["provider_code"];
obo.str = Woak["buy_price"].ToString();
row["buy_price"] = obo.str;
obo.str = Woak["u_buy"].ToString();
row["u_buy"] = obo.str;
Temp.Rows.Add(row);
GoodsClass pc = new GoodsClass();
pc.srl = Woak["srl"].ToString();
pc.code_igd = Woak["code_igd"].ToString();
pc.brand_name = Woak["brand_name"].ToString();
pc.size_title = Woak["size_title"].ToString();
pc.color_name = Woak["color_name"].ToString();
pc.porz_title = Woak["porz_title"].ToString();
pc.chele_title = Woak["chele_title"].ToString();
pc.plan_title = Woak["plan_title"].ToString();
pc.widht = Woak["widht"].ToString();
pc.lenght = Woak["lenght"].ToString();
pc.provider_code = Woak["provider_code"].ToString();
pc.provider_name = "";
pc.selection = string.Empty;
pc.sold = string.Empty;
pc.buy_price = Woak["buy_price"].ToString();
pc.margin_color = color(Woak["color_srl2"].ToString());
pc.area = Woak["area"].ToString();
pc.title_igd = Woak["title_igd"].ToString();
lstGoodsClass.Add(pc);
}
Session["ThrowList"] = lstGoodsClass;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/MainCallBack.rdlc");
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportDataSource datasource = new ReportDataSource("DataSet1", (DataTable)Temp);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
string imagePath = new Uri(Server.MapPath("~/images/logo.png")).AbsoluteUri;
ReportParameter parameter = new ReportParameter("ImagePath", imagePath);
ReportParameter parameter_Date = new ReportParameter("Date", new Common().persian_date());
ReportParameter parameter_Title = new ReportParameter("Title", "فرش های غایب");
string provider_name = string.Empty;
provider_name = "تمام تامین کننده ها";
ReportParameter ProviderName = new ReportParameter("ProviderName", provider_name);
ReportParameter ProjectName = new ReportParameter("ProjectName", lst_project.SelectedItem.Text);
ReportViewer1.LocalReport.SetParameters(parameter);
ReportViewer1.LocalReport.SetParameters(parameter_Date);
ReportViewer1.LocalReport.SetParameters(ProviderName);
ReportViewer1.LocalReport.SetParameters(ProjectName);
ReportViewer1.LocalReport.SetParameters(parameter_Title);
ReportViewer1.LocalReport.Refresh();
}
}
protected void btn_report_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Common obo = new Common();
DataTable dt = new DataTable(); Search obj = new Search
(strConnString);
if (chk_all.Checked)
{
dt = obj.Get_Data(string.Format("SELECT srl,code_igd, provider_code, brand_name, size_title, carpet_title, porz_title, chele_title, lenght, widht, ROUND(lenght * widht / 10000, 2) AS area, color_srl2, plan_title, color_name, buy_price, ROUND(buy_price / NULLIF(ROUND(lenght * widht / 10000, 1), 0),0) AS u_buy,title_igd FROM dbo.Project_Goods_View Where header_srl={0} order by {1}", lst_project.SelectedValue, lst_sort.SelectedValue));
}
else
{
dt = obj.Get_Data(string.Format("SELECT srl,code_igd, provider_code, brand_name, size_title, carpet_title, porz_title, chele_title, lenght, widht, ROUND(lenght * widht / 10000, 2) AS area, color_srl2, plan_title, color_name, buy_price, ROUND(buy_price / NULLIF(ROUND(lenght * widht / 10000, 1), 0),0) AS u_buy,title_igd FROM dbo.Project_Goods_View Where header_srl={0} And provider_srl={1} order by {2}", lst_project.SelectedValue, lst_provider.SelectedValue, lst_sort.SelectedValue));
}
if (dt.Rows.Count > 0)
{
txt_count.Text = dt.Rows.Count.ToString();
DataSet1.CallBackDataTable Temp = new DataSet1.CallBackDataTable();
List <GoodsClass> lstGoodsClass = new List <GoodsClass>();
foreach (DataRow Woak in dt.Rows)
{
DataRow row = Temp.NewRow();
row["code_igd"] = Woak["code_igd"];
row["brand_name"] = Woak["brand_name"];
row["size_title"] = Woak["size_title"];
row["carpet_title"] = Woak["carpet_title"];
row["porz_title"] = Woak["porz_title"];
row["chele_title"] = Woak["chele_title"];
row["lenght"] = Woak["lenght"];
row["widht"] = Woak["widht"];
row["area"] = Woak["area"];
row["margin_color"] = color(Woak["color_srl2"].ToString());
row["plan_title"] = Woak["plan_title"];
row["color_name"] = Woak["color_name"];
row["provider_code"] = Woak["provider_code"];
obo.str = Woak["buy_price"].ToString();
row["buy_price"] = obo.str;
obo.str = Woak["u_buy"].ToString();
row["u_buy"] = obo.str;
Temp.Rows.Add(row);
GoodsClass pc = new GoodsClass();
pc.srl = Woak["srl"].ToString();
pc.code_igd = Woak["code_igd"].ToString();
pc.brand_name = Woak["brand_name"].ToString();
pc.size_title = Woak["size_title"].ToString();
pc.color_name = Woak["color_name"].ToString();
pc.porz_title = Woak["porz_title"].ToString();
pc.chele_title = Woak["chele_title"].ToString();
pc.plan_title = Woak["plan_title"].ToString();
pc.widht = Woak["widht"].ToString();
pc.lenght = Woak["lenght"].ToString();
pc.provider_code = Woak["provider_code"].ToString();
pc.provider_name = lst_provider.SelectedItem.Text;
pc.selection = string.Empty;
pc.sold = string.Empty;
pc.buy_price = Woak["buy_price"].ToString();
pc.margin_color = color(Woak["color_srl2"].ToString());
pc.area = Woak["area"].ToString();
pc.title_igd = Woak["title_igd"].ToString();
lstGoodsClass.Add(pc);
}
Session["ThrowList"] = lstGoodsClass;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/MainCallBack.rdlc");
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportDataSource datasource = new ReportDataSource("DataSet1", (DataTable)Temp);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
string imagePath = new Uri(Server.MapPath("~/images/logo.png")).AbsoluteUri;
ReportParameter parameter = new ReportParameter("ImagePath", imagePath);
ReportParameter parameter_Date = new ReportParameter("Date", new Common().persian_date());
ReportParameter parameter_Title = new ReportParameter("Title", "لیست فراخوان");
string provider_name = string.Empty;
if (chk_all.Checked)
{
provider_name = "تمام تامین کننده ها";
}
else
{
provider_name = lst_provider.SelectedItem.Text;
}
ReportParameter ProviderName = new ReportParameter("ProviderName", provider_name);
ReportParameter ProjectName = new ReportParameter("ProjectName", lst_project.SelectedItem.Text);
ReportViewer1.LocalReport.SetParameters(parameter);
ReportViewer1.LocalReport.SetParameters(parameter_Date);
ReportViewer1.LocalReport.SetParameters(ProviderName);
ReportViewer1.LocalReport.SetParameters(ProjectName);
ReportViewer1.LocalReport.SetParameters(parameter_Title);
ReportViewer1.LocalReport.Refresh();
}
}
