protected void bring() { Common obo = new Common(); List <GoodsClass> lstPricingClass = new List <GoodsClass>(); if (Session["ThrowList"] == null) { return; } lstPricingClass = Session["ThrowList"] as List <GoodsClass>; Session.Remove("ThrowList"); string provider_name = string.Empty; if (lstPricingClass.Count > 0) { DataSet1.CallBackDataTable Temp = new DataSet1.CallBackDataTable(); foreach (GoodsClass Woak in lstPricingClass) { DataRow row = Temp.NewRow(); row["code_igd"] = Woak.code_igd; row["brand_name"] = Woak.brand_name; row["size_title"] = Woak.size_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"] = Woak.margin_color; row["plan_title"] = Woak.plan_title; row["color_name"] = Woak.color_name; row["provider_code"] = Woak.provider_code; obo.str = Woak.buy_price; row["buy_price"] = obo.str; provider_name = Woak.provider_name; row["has_pic"] = Woak.has_pic; Temp.Rows.Add(row); } ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Complete.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 ProviderName = new ReportParameter("ProviderName", provider_name); ReportViewer1.LocalReport.SetParameters(parameter); ReportViewer1.LocalReport.SetParameters(parameter_Date); ReportViewer1.LocalReport.SetParameters(ProviderName); ReportViewer1.LocalReport.Refresh(); } }
protected void btn_report_Click(object sender, System.Web.UI.ImageClickEventArgs e) { DataTable dt = new DataTable(); Search obj = new Search(strConnString); Common obo = new WebApplicationKartable.Common(); dt = obj.Get_Data(string.Format("SELECT 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,discount, discount_amount, sale_price FROM dbo.Project_Goods_View Where header_srl={0}", lst_project.SelectedValue)); if (dt.Rows.Count > 0) { DataSet1.CallBackDataTable Temp = new DataSet1.CallBackDataTable(); foreach (DataRow Woak in dt.Rows) { DataRow row = Temp.NewRow(); row["code_igd"] = Woak["code_igd"]; row["provider_code"] = Woak["provider_code"]; 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["discount"] = Woak["discount"]; obo.str = Woak["discount_amount"].ToString(); row["discount_amount"] = obo.str; obo.str = Woak["sale_price"].ToString(); row["sale_price"] = obo.str; if (!Convert.IsDBNull(row["sale_price"]) && !Convert.IsDBNull(row["discount_amount"])) { double final_price = Convert.ToDouble(row["sale_price"]) - Convert.ToDouble(row["discount_amount"]); obo.str = final_price.ToString(); row["final_price"] = obo.str; } Temp.Rows.Add(row); } ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/SalesMan.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 ProjectName = new ReportParameter("ProjectName", lst_project.SelectedItem.Text); ReportViewer1.LocalReport.SetParameters(parameter); ReportViewer1.LocalReport.SetParameters(parameter_Date); ReportViewer1.LocalReport.SetParameters(ProjectName); ReportViewer1.LocalReport.Refresh(); } }
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 obobo = new Common(); DataTable dt2 = new DataTable(); DataTable dt = new DataTable(); Search obj = new Search(strConnString); if (lst_provider.SelectedIndex == 0) { dt = obj.Get_Data(string.Format("SELECT 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, sale_price FROM dbo.Project_Goods_View Where header_srl={0} order by {1}", lst_project.SelectedValue, lst_sort.SelectedValue)); dt2 = obj.Get_Data(string.Format("Select brand_name,size_title, carpet_title, count(brand_name)cnt from dbo.Project_Goods_View Where header_srl={0} group by brand_name, size_title, carpet_title", lst_project.SelectedValue)); } else { dt = obj.Get_Data(string.Format("SELECT 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, sale_price 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)); dt2 = obj.Get_Data(string.Format("Select brand_name,size_title, carpet_title, count(brand_name)cnt from dbo.Project_Goods_View Where header_srl={0} And provider_srl={1} group by brand_name, size_title, carpet_title", lst_project.SelectedValue, lst_provider.SelectedValue)); } if (dt.Rows.Count > 0) { DataSet1.CallBackDataTable Temp = new DataSet1.CallBackDataTable(); 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"]; obobo.str = Woak["sale_price"].ToString(); row["sale_price"] = obobo.str; obobo.str = Woak["buy_price"].ToString(); row["buy_price"] = obobo.str; Temp.Rows.Add(row); } System.Text.StringBuilder sb = new System.Text.StringBuilder(); if (dt.Rows.Count > 0) { sb.Append(" تعداد "); sb.Append(" "); sb.Append(" ............ "); sb.Append("تخته فرشی مطابق لیست فوق در تاریخ"); sb.Append(" "); sb.Append(obobo.persian_date2()); sb.Append(" "); sb.Append("از طرف جناب آقای"); sb.Append(" "); sb.Append(lst_provider.SelectedItem.Text); sb.Append(" "); sb.Append("تحویل فرش بوم شد."); } DataSet1.groupingDataTable Tmp = new DataSet1.groupingDataTable(); if (dt2.Rows.Count > 0) { foreach (DataRow Woak in dt2.Rows) { DataRow row = Tmp.NewRow(); row["brand_name"] = Woak["brand_name"]; row["size_title"] = Woak["size_title"].ToString(); row["carpet_title"] = Woak["carpet_title"].ToString(); row["cnt"] = Convert.ToInt32(Woak["cnt"]); Tmp.Rows.Add(row); } } ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/CallBackReportCouple.rdlc"); ReportViewer1.LocalReport.EnableExternalImages = true; ReportDataSource datasource = new ReportDataSource("DataSet1", (DataTable)Temp); ReportDataSource datasource2 = new ReportDataSource("DataSet2", (DataTable)Tmp); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(datasource); ReportViewer1.LocalReport.DataSources.Add(datasource2); 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 ProviderName = new ReportParameter("ProviderName", lst_provider.SelectedItem.Text); ReportParameter ProjectName = new ReportParameter("ProjectName", lst_project.SelectedItem.Text); ReportParameter Passage = new ReportParameter("Passage", sb.ToString()); ReportViewer1.LocalReport.SetParameters(parameter); ReportViewer1.LocalReport.SetParameters(parameter_Date); ReportViewer1.LocalReport.SetParameters(ProviderName); ReportViewer1.LocalReport.SetParameters(ProjectName); ReportViewer1.LocalReport.SetParameters(Passage); 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(); } }
protected void btn_report_Click(object sender, System.Web.UI.ImageClickEventArgs e) { string p_date = string.Empty, to_date = string.Empty; Common obo = new Common(); DataTable dt = new DataTable(); Search obj = new Search(strConnString); if (lst_provider.SelectedIndex == 0) { dt = obj.Get_Data(string.Format("SELECT code_igd, provider_code, brand_name, size_title, carpet_title, porz_title, chele_title, lenght, widht, area, color_srl2, plan_title, color_name, buy_price,from_date,to_date,title_igd,down_payment,project_code FROM SoldCarpets Where header_srl={0}", lst_project.SelectedValue)); } else { dt = obj.Get_Data(string.Format("SELECT code_igd, provider_code, brand_name, size_title, carpet_title, porz_title, chele_title, lenght, widht, area, color_srl2, plan_title, color_name, buy_price,from_date,to_date,title_igd,down_payment,project_code FROM SoldCarpets Where header_srl={0} And provider_srl={1}", lst_project.SelectedValue, lst_provider.SelectedValue)); } DataSet1.CallBackDataTable Temp = new DataSet1.CallBackDataTable(); if (dt.Rows.Count > 0) { ViewState["lstOutstandingOrders"] = dt; foreach (DataRow Woak in dt.Rows) { DataRow row = Temp.NewRow(); row["code_igd"] = Woak["code_igd"]; p_date = Woak["from_date"].ToString(); to_date = Woak["to_date"].ToString(); 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; Temp.Rows.Add(row); } } System.Text.StringBuilder sb = new System.Text.StringBuilder(); DataTable dt2 = new DataTable(); dt2 = obj.Get_Data(string.Format("SELECT COUNT(dbo.bas_project_goods.igd_srl) FROM dbo.bas_project_goods INNER JOIN dbo.inv_goods ON dbo.bas_project_goods.igd_srl = dbo.inv_goods.srl Where dbo.bas_project_goods.header_srl={0} AND dbo.inv_goods.provider_srl={1}", lst_project.SelectedValue, lst_provider.SelectedValue)); sb.Append("از تعداد"); sb.Append(" ............ "); //if(dt2.Rows.Count > 0) // sb.Append(dt2.Rows[0][0]); sb.Append(" "); sb.Append("تخته فرشی که از آقای"); sb.Append(" "); sb.Append(lst_provider.SelectedItem.Text); sb.Append(" "); sb.Append("در تاریخ"); sb.Append(" "); sb.Append(obo.persian_date2(p_date)); sb.Append(" "); sb.Append("به فرش بوم تحویل دادند، تعداد"); sb.Append(" "); sb.Append("<b>"); if (dt.Rows.Count > 0) { sb.Append(dt.Rows.Count); } sb.Append("</b>"); sb.Append(" "); sb.Append("تخته به فروش رفته و مابقی به تعداد"); sb.Append(" "); //if (dt2.Rows.Count > 0 && dt.Rows.Count > 0) // sb.Append((Convert.ToInt32(dt2.Rows[0][0]) - dt.Rows.Count)); sb.Append(" ..................... "); sb.Append("تخته به طور صحیح و سالم ،در تاریخ"); sb.Append(" "); sb.Append(obo.persian_date2(to_date)); sb.Append(" "); sb.Append("به ایشان (یا نماینده وی) عودت داده شد. جمع مبلغ فرشهای فروش رفته معادل"); sb.Append(" "); if (dt.Rows.Count > 0) { obo.str = dt.Compute("SUM(buy_price)", "").ToString(); sb.Append(obo.str); } sb.Append(" ریال است "); sb.Append("تعداد "); sb.Append(" "); //sb.Append(dt.Rows[0]["cnt_downpayment"]); sb.Append(" ........... "); sb.Append("تخته فرش به ارزش "); sb.Append(" .............................................. "); if (dt.Rows.Count > 0) { obo.str = dt.Compute("SUM(down_payment)", "").ToString(); sb.Append(obo.str); } sb.Append(" ريال "); sb.Append("به صورت بیعانه ای به فروش رفته که از مبلغ فوق کسر شده و در صورت تسویه خریدار حداکثر ظرف یک ماه تسویه می گردد. باقیمانده طی یک فقره چک بانک .............................. به شماره ................................. به مبلغ ..................................................................... ریال به ایشان (یا نماینده وی) پرداخت می گردد. بنابراین حسابهای فیمابین بابت نمایشگاه"); sb.Append(" "); if (dt.Rows.Count > 0) { sb.Append(dt.Rows[0]["project_code"]); } sb.Append(" "); sb.Append("به طور کامل تسویه شده و طرفین هیچ حقی نسبت به یکدیگر ندارند."); ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Settelment.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 ProviderName = new ReportParameter("ProviderName", lst_provider.SelectedItem.Text); ReportParameter ProjectName = new ReportParameter("ProjectName", lst_project.SelectedItem.Text); ReportParameter Passage = new ReportParameter("Passage", sb.ToString()); ReportViewer1.LocalReport.SetParameters(parameter); ReportViewer1.LocalReport.SetParameters(parameter_Date); ReportViewer1.LocalReport.SetParameters(ProviderName); ReportViewer1.LocalReport.SetParameters(ProjectName); ReportViewer1.LocalReport.SetParameters(Passage); ReportViewer1.LocalReport.Refresh(); }