/// <summary>
/// 绑定Staff信息的数据源
/// </summary>
private void BindSource(Sale sale, int start)
{
DataTable table;
SaleProvider provider = new SaleProvider();
table = provider.SelectRec(sale, start, this.ListPager1.PageSize);
this.GridView1.DataSource = table.DefaultView;
this.GridView1.DataBind();
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
if (this.GridView1.Rows[i].Cells[3].Text.ToString() == " ")
{
this.GridView1.Rows[i].Cells[8].Enabled = false;
this.GridView1.Rows[i].Cells[9].Enabled = false;
}
else if (Convert.ToInt32(this.GridView1.Rows[i].Cells[3].Text.ToString()) == 0)
{
this.GridView1.Rows[i].Cells[8].Enabled = false;
this.GridView1.Rows[i].Cells[9].Enabled = false;
}
}
}
protected void btn_Result_Click(object sender, EventArgs e)
{
Sale sale = new Sale();
if (user_manage == 0)
{
sale.Staffinfo_Id = staffinfo_id;
}
sale.Sale_Id = 0;
sale.Year_Month = 0;
if (this.txt_Position.Text != "")
{
sale.Sale_Id = Convert.ToInt32(this.txt_Position.Text);
}
if (this.txt_Yearmonth.Text != "")
{
sale.Year_Month = Convert.ToInt32(this.txt_Yearmonth.Text);
}
if (this.txt_Name.Text != "")
{
StaffProvider provider1 = new StaffProvider();
sale.Staffinfo_Id = provider1.GetStaffinfoId(this.txt_Name.Text.ToString());
}
SaleProvider provider = new SaleProvider();
this.ListPager1.RecordCount = provider.GetSize();
this.BindSource(sale, 0);
this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int rowIndex = e.RowIndex;
Sale sale = new Sale();
sale.Sale_Id = Convert.ToInt32(this.GridView1.DataKeys[rowIndex].Value);
SaleProvider provider = new SaleProvider();
if (provider.Delete(sale))
{
this.Alert("删除成功!!!");
if (user_manage == 0)
{
sale.Staffinfo_Id = staffinfo_id;
}
sale.Sale_Id = 0;
sale.Year_Month = 0;
if (this.txt_Position.Text != "")
{
sale.Sale_Id = Convert.ToInt32(this.txt_Position.Text);
}
if (this.txt_Yearmonth.Text != "")
{
sale.Year_Month = Convert.ToInt32(this.txt_Yearmonth.Text);
}
this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1;
this.BindSource(sale);
}
}
/// <summary>
/// 绑定Staff信息的数据源
/// </summary>
private void BindSource(int sale_id, int staffinfo_id, int buyer_id)
{
DataTable table;
SaleProvider provider = new SaleProvider();
table = provider.GetDetails(sale_id);
this.GridView1.DataSource = table.DefaultView;
this.GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SaleProvider provider = new SaleProvider();
this.ListPager1.RecordCount = provider.GetSize();
this.BindSource("", 0, 0);
}
this.account.Text = Session["LOGINED"].ToString();
this.datetime.Text = this.BindDayWeek();
this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange);
}
/// <summary>
/// 绑定Users信息的数据源
/// </summary>
private void BindSource(int start, string goodId, int yearmonth, int staffinfoId)
{
Sale sale = new Sale();
sale.Good_Id = goodId;
sale.Year_Month = yearmonth;
sale.Staffinfo_Id = staffinfoId;
SaleProvider provider = new SaleProvider();
DataTable table = provider.Select1(sale, start, this.ListPager1.PageSize);
this.GridView1.DataSource = table.DefaultView;
this.GridView1.DataBind();
}
private void BindText()
{
Sale sale = new Sale();
sale.Sale_Id = Convert.ToInt32(id);
SaleProvider provider = new SaleProvider();
DataTable table = new DataTable();
table = provider.Select(sale);
purchase_price = Convert.ToInt32(table.Rows[0]["purchase_price"].ToString());
Session["PURCHASEPRICE"] = purchase_price.ToString();
this.ddl_GoodId.SelectedIndex = this.ddl_GoodId.Items.IndexOf(this.ddl_GoodId.Items.FindByValue(table.Rows[0]["good_id"].ToString()));
this.txt_goodname.Text = table.Rows[0]["good_name"].ToString();
this.txt_price.Text = table.Rows[0]["sale_price"].ToString();
this.txt_num.Text = table.Rows[0]["sale_num"].ToString();
this.txt_datetime.Text = table.Rows[0]["sale_datetime"].ToString();
this.ddl_buyerid.SelectedIndex = this.ddl_buyerid.Items.IndexOf(this.ddl_buyerid.Items.FindByValue(table.Rows[0]["buyer_id"].ToString()));
}
protected void btn_Result_Click(object sender, EventArgs e)
{
Sale sale = new Sale();
int staffinfoId = 0;
sale.Good_Id = "";
sale.Year_Month = 0;
if (this.txt_Name.Text != "")
{
sale.Good_Id = this.txt_Name.Text;
}
if (this.txt_Yearmonth.Text != "")
{
sale.Year_Month = Convert.ToInt32(this.txt_Yearmonth.Text);
}
SaleProvider provider = new SaleProvider();
this.ListPager1.RecordCount = provider.GetSize(sale);
this.BindSource(0, sale.Good_Id, sale.Year_Month, staffinfoId);
this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange);
}
protected void Page_Load(object sender, EventArgs e)
{
if (user_id == 0)
{
user_id = Convert.ToInt32(Session["USERID"].ToString());
}
if (user_manage == 0)
{
user_manage = Convert.ToInt32(Session["USERMANAGE"].ToString());
}
if (staffinfo_id == 0)
{
StaffProvider provider = new StaffProvider();
staffinfo_id = provider.GetStaffinfoId(user_id);
}
if (!IsPostBack)
{
SaleProvider provider = new SaleProvider();
Sale sale = new Sale();
this.GridView1.DataKeyNames = new string[] { "sale_id", "staffinfo_id", "buyer_id" };
if (user_manage == 0)
{
sale.Staffinfo_Id = staffinfo_id;
this.txt_Name.Enabled = false;
}
this.ListPager1.RecordCount = provider.GetSize();
this.BindSource(sale, 0);
}
this.account.Text = GetAccout();//Session["LOGINED"].ToString();
this.datetime.Text = this.BindDayWeek();
this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange);
}
protected void btn_sure_Click(object sender, EventArgs e)
{
Sale sales = this.AddSale();
SaleProvider provider = new SaleProvider();
switch (this.OperationFlag)
{
case Operation.Add:
if (true == String.IsNullOrEmpty(sales.Good_Id))
{
this.Alert("商品编号没设置，添加失败!!!");
break;
}
if (sales.Staffinfo_Id == 0)
{
this.Alert("员工编号为0，添加失败!!!");
break;
}
if (this.IsSame() == 1)
{
break;
}
if (this.IsRecValid() == false)
{
break;
}
sales.Purchase_Price = purchase_price.ToString();
if (provider.Insert(sales))
{
StockProvider stockProvider = new StockProvider();
Stock stock = new Stock();
stock.Stock_Num = sales.Sale_Num;
stock.Good_Id = sales.Good_Id;
stock.Stock_Oper = -1;
stock.Staffinfo_Id = sales.Staffinfo_Id;
stock.Purchase_Price = sales.Purchase_Price;
stock.Purchase_Datetime = DateTime.Now.ToString("yyyyMMdd");
if (stockProvider.Insert(stock))
{
this.Alert("添加成功!!!");
this.TextCancel();
int sum = Convert.ToInt32(Session["STOCKSUM"].ToString());
sum -= Convert.ToInt32(sales.Sale_Num);
Session["STOCKSUM"] = sum.ToString();
this.lbl_StockNum.Text = "库存还剩：" + sum.ToString();
}
}
break;
case Operation.Update:
if (false == String.IsNullOrEmpty(sales.Good_Id))
{
this.Alert("参数错误，修改失败!!!");
break;
}
sales.Purchase_Price = Session["PURCHASEPRICE"].ToString();
if (provider.Update(sales))
{
this.Alert("修改成功!!!");
this.BindText();
}
break;
}
}
protected void btn_Export_Click(object sender, EventArgs e)
{
System.Web.UI.WebControls.GridView dg = new System.Web.UI.WebControls.GridView();
/*
* BoundField field1 = new BoundField();
* field1.DataField = "sale_id";
* field1.HeaderText = "销售单号";
* dg.Columns.Add(field1);
*
* BoundField field2 = new BoundField();
* field2.DataField = "good_id";
* field2.HeaderText = "商品编号";
* dg.Columns.Add(field2);
*
* BoundField field3 = new BoundField();
* field3.DataField = "sale_price";
* field3.HeaderText = "销售单价";
* dg.Columns.Add(field3);
*
* BoundField field4 = new BoundField();
* field4.DataField = "purchase_price";
* field4.HeaderText = "采购单价";
* dg.Columns.Add(field4);
*
* BoundField field5 = new BoundField();
* field5.DataField = "purchase_total";
* field5.HeaderText = "成本总价";
* dg.Columns.Add(field5);
*
* BoundField field6 = new BoundField();
* field6.DataField = "sale_num";
* field6.HeaderText = "销售数量";
* dg.Columns.Add(field6);
*
*
* BoundField field7 = new BoundField();
* field7.DataField = "sale_total";
* field7.HeaderText = "销售总价";
* dg.Columns.Add(field7);
*
* BoundField field8 = new BoundField();
* field8.DataField = "sale_profit";
* field8.HeaderText = "利润";
* dg.Columns.Add(field8);
*
* BoundField field9 = new BoundField();
* field9.DataField = "sale_datetime";
* field9.HeaderText = "销售时间";
* dg.Columns.Add(field9);
*
* BoundField field10 = new BoundField();
* field10.DataField = "buyer_bh";
* field10.HeaderText = "采购商编号";
* dg.Columns.Add(field10);
*/
Sale sale = new Sale();
sale.Good_Id = "";
sale.Year_Month = 0;
if (this.txt_Name.Text != "")
{
sale.Good_Id = this.txt_Name.Text;
}
if (this.txt_Yearmonth.Text != "")
{
sale.Year_Month = Convert.ToInt32(this.txt_Yearmonth.Text);
}
SaleProvider provider = new SaleProvider();
DataTable table = provider.Select1(sale, 0, 0);
dg.DataSource = table.DefaultView;
dg.DataBind();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=Record.xls");
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
dg.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
