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();
}
