private void Fill()
{
OneRecord aco = new OneRecord();
OneRecordDatum dmo = new OneRecordDatum();
DataTable dt;
dmo.Type = "AddressPrint";
dt = aco.SelectOne(dmo);
if (dt.Rows.Count > 0)
{
Label1.Text = dt.Rows[0]["text"].ToString();
}
BLL.user blu = new user();
Shoping ac = new Shoping();
ShopingDatum dm = new ShopingDatum();
string company, post_code;
dm.Id_Factor = decimal.Parse(Request.QueryString["Id_Factor"].ToString());
DataTable dt2 = ac.select_factor_one(dm);
DataTable dtuser = blu.select_one_user(new userDatum()
{
Id = int.Parse(dt2.Rows[0]["id_user"].ToString())
});
company = dtuser.Rows[0]["company"].ToString();
post_code = dtuser.Rows[0]["post_code"].ToString();
Label1.Text = Label1.Text.Replace("NameUser", dt2.Rows[0]["customer_name"].ToString());
Label1.Text = Label1.Text.Replace("TellphoneUser", dt2.Rows[0]["customer_tell"].ToString());
Label1.Text = Label1.Text.Replace("AddressUser", string.Format(" {0} <br/> کد پستی {1} <br/> نام شرکت {2}", dt2.Rows[0]["customer_address"].ToString(), company, post_code));
}
//<اطلاعات فاکتور را نمايش مي دهد>
void fill_factor()
{
Shoping ac = new Shoping();
ShopingDatum dm = new ShopingDatum();
DataSet ds = new DataSet();
decimal Sum_Price;
decimal All_Sum_Price = 0;
if (Request.QueryString["Id_Factor"] != null && Request.QueryString["Id_Factor"].Length > 0)
{
dm.Id_Factor = decimal.Parse(Request.QueryString["Id_Factor"].ToString());
GridView1.DataSource = ac.select_factor_detail(dm);
GridView1.DataBind();
DataTable dt = ac.select_factor_one(dm);
Label10.Text = dt.Rows[0]["date_register"].ToString();
Label11.Text = dt.Rows[0]["id"].ToString();
Label20.Text = dt.Rows[0]["factor_code"].ToString();
Label32.Text = BLL.PublicClass.numberToMoney(dt.Rows[0]["sum_price"].ToString());
Label31.Text = BLL.PublicClass.numberToMoney(dt.Rows[0]["send_price"].ToString());
Label34.Text = BLL.PublicClass.numberToMoney(dt.Rows[0]["tasx"].ToString());
if (Label34.Text.Trim() == "0")
{
Label33.Visible = false;
Label34.Visible = false;
Image3.Visible = false;
}
Label44.Text = BLL.PublicClass.numberToMoney(dt.Rows[0]["discount"].ToString());
if (Label44.Text.Trim() == "0")
{
Label43.Visible = false;
Label44.Visible = false;
Image5.Visible = false;
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Sum_Price = decimal.Parse(((Label)(GridView1.Rows[i].FindControl("Label24"))).Text);
All_Sum_Price = All_Sum_Price + Sum_Price;
}
Label36.Text = BLL.PublicClass.numberToMoney(All_Sum_Price.ToString());
//Label47.Text = ds.Tables[0].Rows[0]["bank_name"].ToString();
//Label42.Text = ds.Tables[0].Rows[0]["peyment_code"].ToString();
//Label49.Text = ds.Tables[0].Rows[0]["bank_code"].ToString();
//Label51.Text = ds.Tables[0].Rows[0]["peyment_date"].ToString();
//Label53.Text = ds.Tables[0].Rows[0]["peyment_price"].ToString();
//Label56.Text = ds.Tables[0].Rows[0]["customer_name"].ToString();
//Label62.Text = ds.Tables[0].Rows[0]["customer_time_recive"].ToString();
//Label66.Text = ds.Tables[0].Rows[0]["description"].ToString();
lbDescription.Text = dt.Rows[0]["description"].ToString();
}
}
void fill_factor()
{
Shoping ac = new Shoping();
ShopingDatum dm = new ShopingDatum();
DataSet ds = new DataSet();
decimal Sum_Price;
decimal All_Sum_Price = 0;
dm.Id_Factor = decimal.Parse(Request.QueryString["Id_Factor"].ToString());
GridView1.DataSource = ac.select_factor_detail(dm);
GridView1.DataBind();
DataTable dt = ac.select_factor_one(dm);
Label38.Text = Request.QueryString["Id_Factor"].ToString();
Label22.Text = BLL.PublicClass.numberToMoney(dt.Rows[0]["sum_price"].ToString());
Label19.Text = BLL.PublicClass.numberToMoney(dt.Rows[0]["send_price"].ToString());
Label33.Text = BLL.PublicClass.numberToMoney(dt.Rows[0]["tasx"].ToString());
if (Label33.Text == "0")
{
lblTasx.Visible = false;
}
Label40.Text = dt.Rows[0]["factor_condition"].ToString();
Label2.Text = dt.Rows[0]["date_register"].ToString();
Label4.Text = dt.Rows[0]["peyment_date"].ToString();
Label12.Text = BLL.PublicClass.numberToMoney(dt.Rows[0]["discount"].ToString());
if (Label12.Text == "0")
{
DivTakhfif.Visible = false;
}
if (Label4.Text.Length == 0)
{
PayDiv.Visible = false;
}
Label7.Text = dt.Rows[0]["date_send"].ToString();
if (Label7.Text.Length == 0)
{
SendDiv.Visible = false;
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Sum_Price = decimal.Parse(((Label)(GridView1.Rows[i].FindControl("Label14"))).Text);
All_Sum_Price = All_Sum_Price + Sum_Price;
}
Label15.Text = BLL.PublicClass.numberToMoney(All_Sum_Price.ToString());
}
//<اطلاعات فيش واريزي را نشان دهد>
void fill_peyment()
{
Shoping ac = new Shoping();
ShopingDatum dm = new ShopingDatum();
DataSet ds = new DataSet();
if (Request.QueryString["Id_Factor"] != null && Request.QueryString["Factor_Code"] != null &&
Request.Cookies["Id_User"] != null)
{
dm.Id_Factor = decimal.Parse(Request.QueryString["Id_Factor"]);
dm.Factor_Code = Request.QueryString["Factor_Code"];
dm.Id_User = decimal.Parse(Request.Cookies["Id_User"].Value);
}
DataTable dt = ac.select_factor_one(dm);
if (dt.Rows.Count > 0)
{
TextBox1.Text = dt.Rows[0]["peyment_code"].ToString();
TextBox9.Text = dt.Rows[0]["bank_code"].ToString();
TextBox2.Text = dt.Rows[0]["peyment_date"].ToString();
TextBox3.Text = dt.Rows[0]["peyment_price"].ToString();
TextBox4.Text = dt.Rows[0]["customer_name"].ToString();
TextBox5.Text = dt.Rows[0]["customer_tell"].ToString();
TextBox6.Text = dt.Rows[0]["customer_time_recive"].ToString();
TextBox7.Text = dt.Rows[0]["customer_address"].ToString();
TextBox8.Text = dt.Rows[0]["description"].ToString();
if (dt.Rows[0]["peyment_kind"].ToString() == "واريز به حساب")
{
RadioButton2.Checked = true;
RadioButton1.Checked = false;
}
else
{
RadioButton2.Checked = false;
RadioButton1.Checked = true;
}
if (dt.Rows[0]["bank_name"].ToString().Length > 0)
{
DropDownList1.Items.FindByText(dt.Rows[0]["bank_name"].ToString()).Selected = true;
}
if (TextBox2.Text.Length == 0)
{
fill_user();
PublicClass p = new PublicClass();
TextBox2.Text = p.GetDate();
}
}
}
void fill_factor()
{
int userid;
Shoping ac = new Shoping();
ShopingDatum dm = new ShopingDatum();
DataSet ds = new DataSet();
decimal Sum_Price;
decimal All_Sum_Price = 0;
dm.Id_Factor = decimal.Parse(Request.QueryString["Id_Factor"].ToString());
GridView1.DataSource = ac.select_factor_detail(dm);
GridView1.DataBind();
DataTable dt = ac.select_factor_one(dm);
userid = int.Parse(dt.Rows[0]["id_user"].ToString());
Label38.Text = Request.QueryString["Id_Factor"].ToString();
Label22.Text = BLL.PublicClass.numberToMoney(dt.Rows[0]["sum_price"].ToString());
TextBox11.Text = dt.Rows[0]["send_price"].ToString();
TextBox10.Text = dt.Rows[0]["tasx"].ToString();
TextBoxTakhfif.Text = dt.Rows[0]["Discount"].ToString();
Label40.Text = dt.Rows[0]["factor_condition"].ToString();
Label2.Text = dt.Rows[0]["date_register"].ToString();
Label4.Text = dt.Rows[0]["peyment_date"].ToString();
txtDescription.Text = dt.Rows[0]["description"].ToString();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Sum_Price = decimal.Parse(((Label)(GridView1.Rows[i].FindControl("Label14"))).Text);
All_Sum_Price = All_Sum_Price + Sum_Price;
}
Label15.Text = BLL.PublicClass.numberToMoney(All_Sum_Price.ToString());
TextBox1.Text = dt.Rows[0]["peyment_code"].ToString();
TextBox9.Text = dt.Rows[0]["bank_code"].ToString();
TextBox2.Text = dt.Rows[0]["peyment_date"].ToString();
TextBox3.Text = dt.Rows[0]["peyment_price"].ToString();
TextBox4.Text = dt.Rows[0]["customer_name"].ToString();
TextBox5.Text = dt.Rows[0]["customer_tell"].ToString();
TextBox6.Text = dt.Rows[0]["customer_time_recive"].ToString();
TextBox7.Text = dt.Rows[0]["customer_address"].ToString();
TextBox8.Text = dt.Rows[0]["description"].ToString();
if (dt.Rows[0]["peyment_kind"].ToString() == "واريز به حساب")
{
RadioButton2.Checked = true;
RadioButton1.Checked = false;
}
else
{
RadioButton2.Checked = false;
RadioButton1.Checked = true;
}
if (dt.Rows[0]["bank_name"].ToString().Length > 0)
{
DropDownList1.Items.FindByText(dt.Rows[0]["bank_name"].ToString()).Selected = true;
}
if (Label4.Text.Length == 0)
{
Label4.Text = "هنوز ثبت نشده است";
FillUser(decimal.Parse(dt.Rows[0]["ID_User"].ToString()));
}
Label7.Text = dt.Rows[0]["date_send"].ToString();
if (Label7.Text.Length == 0)
{
Label7.Text = "هنوز ارسال نشده است";
}
TextBox12.Text = new BLL.user().select_one_user(new userDatum()
{
Id = userid
}).Rows[0]["post_code"].ToString();
}