//订单编号dropdownlist显示
public void dropdownList()
{
this.DropDownList1.DataSource = SaleInManager.GetOrderSelect();
this.DropDownList1.DataTextField = "BuyOrderID";
this.DropDownList1.DataValueField = "BuyOrderID";
this.DropDownList1.DataBind();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
int count = Convert.ToInt32(context.Request["rows"].ToString());
int index = Convert.ToInt32(context.Request["page"].ToString());
List <addorder> list = SaleInManager.GetNum(count, index);
context.Response.Write("{\"total\":\"" + SaleInManager.GetSum() + "\",\"rows\":" + JsonConvert.SerializeObject(list) + "}");
}
//商品信息展示
public void Product()
{
string order = this.DropDownList1.SelectedValue;
this.DropDownList4.DataSource = SaleInManager.GetProductname(order);
this.DropDownList4.DataTextField = "ProductsName";
this.DropDownList4.DataValueField = "ProductsID";
this.DropDownList4.DataBind();
}
//通过订单编号显示库房
public void Store()
{
string orderid = this.DropDownList1.SelectedValue;
this.DropDownList2.DataSource = SaleInManager.GetStore(orderid);
this.DropDownList2.DataTextField = "HouseName";
this.DropDownList2.DataValueField = "HouseID";
this.DropDownList2.DataBind();
}
//供应商信息展示
public void Suppler()
{
string order = this.DropDownList1.SelectedValue;
this.DropDownList5.DataSource = SaleInManager.GetSupplier(order);
this.DropDownList5.DataTextField = "SupplierName";
this.DropDownList5.DataValueField = "SupplierID";
this.DropDownList5.DataBind();
}
//通过入库单号查询显示库房
public void Store()
{
string id = Request["id"].ToString();
DataTable dt = SaleInManager.GetSaleStore(id);
this.DropDownList1.DataSource = dt;
this.DropDownList1.DataTextField = "HouseName";
this.DropDownList1.DataValueField = "HouseID";
this.DropDownList1.DataBind();
}
//通过订单编号和库房显示库区
public void House()
{
string order = this.DropDownList1.SelectedValue;
int store = Convert.ToInt32(this.DropDownList2.SelectedValue);
this.DropDownList3.DataSource = SaleInManager.GetHouse(order, store);
this.DropDownList3.DataTextField = "SubareaName";
this.DropDownList3.DataValueField = "ID";
this.DropDownList3.DataBind();
}
//通过订单编号和库房，显示库区
public void House()
{
string id = Request["id"].ToString();
int store = Convert.ToInt32(this.DropDownList1.SelectedValue);
DataTable dt = SaleInManager.GetSaleHouse(id, store);
this.DropDownList2.DataSource = dt;
this.DropDownList2.DataTextField = "SubareaName";
this.DropDownList2.DataValueField = "ID";
this.DropDownList2.DataBind();
}
//通过订单编号显示商品信息
public void productDetail()
{
string order = this.DropDownList1.SelectedValue;
DataTable dt = SaleInManager.GetProduct(order);
this.TextBox3.Text = dt.Rows[0]["Price"].ToString();
this.TextBox4.Text = dt.Rows[0]["Quantity"].ToString();
this.TextBox5.Text = dt.Rows[0]["TaxRate"].ToString();
this.TextBox6.Text = dt.Rows[0]["DiscountRate"].ToString();
this.TextBox7.Text = dt.Rows[0]["Description"].ToString();
}
//接收id
public void All()
{
string id = Request["id"].ToString();
DataTable dt = SaleInManager.GetSaleDetail(id);
this.TextBox1.Text = dt.Rows[0]["ReceiptOrderID"].ToString();
this.TextBox8.Text = dt.Rows[0]["ReceiptOrderDate"].ToString();
this.TextBox2.Text = dt.Rows[0]["UserName"].ToString();
this.TextBox5.Text = dt.Rows[0]["TotalPrice"].ToString();
this.TextBox6.Text = dt.Rows[0]["StateName"].ToString();
this.TextBox9.Text = dt.Rows[0]["TradeDate"].ToString();
this.TextBox7.Text = dt.Rows[0]["Description"].ToString();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
addorder ad = new addorder();
ad.ProductsID = Convert.ToInt32(context.Request["ProductsID"].ToString());
ad.Price = context.Request["Price"].ToString();
ad.Quantity = Convert.ToInt32(context.Request["Quantity"].ToString());
ad.TaxRate = context.Request["TaxRate"].ToString();
ad.DiscountRate = context.Request["DiscountRate"].ToString();
ad.SupplierID = context.Request["SupplierID"].ToString();
ad.Description = context.Request["Description"].ToString();
ad.ReceiptOrderID = context.Request["ReceiptOrderID"].ToString();
bool rows = SaleInManager.insertProduct(ad);
context.Response.Write(rows);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
addorder ad = new addorder();
ad.ReceiptOrderID = context.Request["ReceiptOrderID"].ToString();
ad.ReceiptOrderDate = context.Request["ReceiptOrderDate"].ToString();
ad.BuyOrderID = context.Request["BuyOrderID"].ToString();
ad.StoreHouseID = Convert.ToInt32(context.Request["StoreHouseID"].ToString());
ad.HouseDetailID = Convert.ToInt32(context.Request["HouseDetailID"].ToString());
ad.TradeDate = context.Request["TradeDate"].ToString();
ad.userName = context.Request["UserName"].ToString();
ad.Description = context.Request["Description"].ToString();
ad.TotalPrice = context.Request["TotalPrice"].ToString();
ad.State = context.Request["State"].ToString();
bool rows = SaleInManager.GetSale(ad);
context.Response.Write(rows);
}
