/// <summary>
/// 获取基础数据
/// </summary>
/// <returns></returns>
public String getData()
{
string saleId = Session["saleId"].ToString();
int pagesize = 20;
int currentPage = Convert.ToInt32(Request["page"]);
if (currentPage == 0)
{
currentPage = 1;
}
string search = "";
//string stockId = Request["stockId"];
string sellId = Request["sellId"];
string cutomerName = Request["customer"];
if ((sellId == "" || sellId == null) && (cutomerName == "" || cutomerName == null))
{
search = "saleTaskId='" + saleId + "' and deleteState=0";
}
else if (sellId != "" && sellId != null && (cutomerName == "" || cutomerName == null))
{
search = "saleTaskId='" + saleId + "' and deleteState=0 and sellOffHeadID=" + "'" + sellId + "'";
}
else if ((sellId == "" || sellId == null) && cutomerName != "" && cutomerName != null)
{
search = "saleTaskId='" + saleId + "' and deleteState=0 and customerName like " + "'%" + cutomerName + "%'";
}
else
{
search = "saleTaskId='" + saleId + "' and deleteState=0 and customerName like " + "'%" + cutomerName + "%'" + " and sellOffHeadID=" + "'" + sellId + "'";
}
TableBuilder tb = new TableBuilder();
tb.StrTable = "V_SellOffHead";
tb.OrderBy = "makingTime desc";
tb.StrColumnlist = "sellOffHeadID,saleTaskId,kinds,count,totalPrice,realPrice,userName,customerName,makingTime,defaultDiscount,state";
tb.IntPageSize = pagesize;
tb.IntPageNum = currentPage;
tb.StrWhere = search;
ds = uBll.selectByPage(tb, out totalCount, out intPageCount);
//获取客户
//dsCustom = libraryCollectionBll.getCustomer();
StringBuilder strb = new StringBuilder();
int row = 0;//判断销退单头中是否有单体
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
//strb.Append("<tr><td>" + ds.Tables[0].Rows[i]["saleTaskId"].ToString() + "</td>");
int state = int.Parse(ds.Tables[0].Rows[i]["state"].ToString());
string dc = ds.Tables[0].Rows[i]["defaultDiscount"].ToString();
double defaultDiscount = double.Parse(dc); //* 100;
string headId = ds.Tables[0].Rows[i]["sellOffHeadID"].ToString();
strb.Append("<tr>");
strb.Append("<td class='sellId'>" + headId + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["userName"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["customerName"].ToString() + "</td>");
strb.Append("<td>" + (state > 0 ? "已完成" : "处理中") + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["kinds"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["count"].ToString() + "</td>");
//strb.Append("<td>" + defaultDiscount + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["totalPrice"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["realPrice"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["makingTime"].ToString() + "</td>");
//strb.Append("<td>" + "<button class='btn btn-success btn-sm btn_add'><i class='fa fa-plus fa-lg'></i></button>" + "<button class='btn btn-info btn-sm search_back'><i class='fa fa-search'></i></button>" + "<button class='btn btn-danger btn-sm btndelete'><i class='fa fa-trash'></i></button>" + "</td></tr>");
strb.Append("<td>");
if (state == 0)
{
strb.Append("<button class='btn btn-success btn-sm btn_add'><i class='fa fa-plus fa-lg'></i></button>");
//strb.Append("<button class='btn btn-info btn-sm search_back'><i class='fa fa-search'></i></button>");
}
if (state == 1)
{
//strb.Append("<button class='btn btn-info btn-sm search_back'><i class='fa fa-search'></i></button>");
}
strb.Append("<button class='btn btn-info btn-sm search_back'><i class='fa fa-search'></i></button>");
row = smBll.GetCount(headId);
if (row == 0)
{
strb.Append("<button class='btn btn-danger btn-sm btndelete'><i class='fa fa-trash'></i></button>");
}
strb.Append("</td>");
}
strb.Append("<input type='hidden' value='" + intPageCount + "' id='intPageCount' />");
strb.Append("<input type='hidden' value='" + Session["saleId"].ToString() + "' id='saleTaskId' />");
string op = Request["op"];
if (op == "paging")
{
Response.Write(strb.ToString());
Response.End();
}
return(strb.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
string sellId = Session["sellId"].ToString();
string op = Request["op"];
//GetData();
if (op == "paging")
{
GetData();
}
if (op == "search")
{
//string bookNum = Request["bookNum"];
string ISBN = Request["ISBN"];
string bookNum = Request["bookNO"];
int bookCount = smBll.getBookCount(bookNum);
if (bookNum == "" || bookNum == null)
{
bookds = bookBll.SelectByIsbn(ISBN);
if (bookds != null && bookds.Tables[0].Rows.Count > 0)
{
//如果有两条及两条以上显示表格
if (bookds.Tables[0].Rows.Count > 1)
{
getbook();
}
Response.Write(GetData());
Response.End();
}
else
{
Response.Write("暂无此数据");
Response.End();
}
}
else if (bookCount == 0)
{
Response.Write("销售单据中无此数据");
Response.End();
}
else
{
Response.Write(GetData());
Response.End();
}
}
if (op == "add")
{
addSalemon();
}
//保存单据
if (op == "sure")
{
int row = smBll.GetCount(sellId);
if (row > 0)
{
string result = updateSellHead();
Session["type"] = "search";
if (result == "更新成功")
{
Response.Write("更新成功");
Response.End();
}
else
{
Response.Write("保存失败");
Response.End();
}
}
else
{
Response.Write("该单据没有任何数据，无法保存");
Response.End();
}
}
string exportOp = Request.QueryString["op"];
if (exportOp == "export")
{
export();
}
DataSet headDs = shBll.Select(sellId);
DataTable tRows = headDs.Tables[0];
if (tRows.Rows.Count > 0 && headDs != null)
{
DataRow dr = tRows.Rows[0];
staticsKinds = Convert.ToInt32(dr["kinds"].ToString());
staticsNumber = Convert.ToInt32(dr["count"].ToString());
staticsTotalPrice = Convert.ToDouble(dr["totalPrice"].ToString());
staticsRealPrice = Convert.ToDouble(dr["realPrice"]);
staticsTime = Convert.ToDateTime(dr["makingTime"]);
}
//else
//{
// Response.Write("没有这条数据");
// Response.End();
//}
}