public void SearchWhere()
{
int Counts = 0;
DataTable dt = new Hi.BLL.DIS_StockInOut().GetListPage(Pager.PageSize, Pager.CurrentPageIndex, where ());
this.Rpt_Company.DataSource = dt;
this.Rpt_Company.DataBind();
Counts = new Hi.BLL.DIS_StockInOut().GetPageCount(where ());
Pager.RecordCount = Counts;
page = Pager.CurrentPageIndex.ToString();
}
public void databind()
{
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
KeyID = Common.DesDecrypt((Request["KeyID"] + ""), Common.EncryptKey).ToInt(0);
}
string where = " ISNULL(dr,0)=0 and ID=" + KeyID;
List <Hi.Model.DIS_StockOrder> solist = new Hi.BLL.DIS_StockOrder().GetList("", where, "");
if (solist != null && solist.Count > 0)
{
// 订单编号
lblReceiptNo.InnerText = solist[0].OrderNO;
codeno = solist[0].OrderNO.ToString();
this.Image1.ImageUrl = "~/Distributor/newOrder/Code39.aspx?KeyID=" + codeno;
lblCreateDate.InnerText = solist[0].CreateDate.ToString().ToDateTime().ToString("yyyy-MM-dd");
this.lblType.InnerText = solist[0].StockType;
if (solist[0].Type == 2)//商品出库
{
TitleType = "出库";
this.Title = "商品出库单详细";
}
else if (solist[0].Type == 1)
{
TitleType = "入库";
this.Title = "商品入库单详细";
}
//商品明细
string goods = string.Format(@"select i.*,info.ValueInfo,g.GoodsCode,g.GoodsName,g.Unit,info.TinkerPrice from DIS_StockInOut i left join BD_GoodsInfo info on i.GoodsInfoID=info.ID left join BD_Goods g on info.GoodsID=g.ID where ISNULL(i.dr,0)=0 and i.StockOrderID={0}", KeyID);
DataTable l = new Hi.BLL.DIS_StockInOut().GetDataTable(goods);
if (l != null && l.Rows.Count > 0)
{
rptOrderD.DataSource = l;
rptOrderD.DataBind();
}
}
}
