//查询数据
private void QueryData(out OrderInfoInvoke orderInfoInvokeObj, out List <PurchaseOrder> lstPurchaseOrder)
{
string warehouse = string.Empty;//
//从配置文件读取默认的仓库--地王26库
if (System.Configuration.ConfigurationManager.AppSettings.AllKeys.Contains("DefaultWHCode"))
{
warehouse = System.Configuration.ConfigurationManager.AppSettings["DefaultWHCode"].ToString();
}
else
{
warehouse = "20101";
}
string billType = "PurchaseOrder"; //单据类型
string startTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", System.DateTime.Now); //开始时间
if (txtStartTime.Text.Trim() != string.Empty)
{
DateTime dateEnd = Convert.ToDateTime(txtStartTime.Text.Trim());
DateTime endT = new DateTime(dateEnd.Year, dateEnd.Month, dateEnd.Day, 00, 00, 00);//获取开始时间，精确到秒
startTime = endT.ToString();
}
string endTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", System.DateTime.Now);//结束时间
if (txtEndTime.Text.Trim() != string.Empty)
{
DateTime dateEnd = Convert.ToDateTime(txtEndTime.Text.Trim());
//DateTime endT = new DateTime(dateEnd.Year, dateEnd.Month, dateEnd.Day, System.DateTime.Now.Hour, System.DateTime.Now.Minute,System.DateTime.Now.Second);//获取截止时间，精确到秒
DateTime endT = new DateTime(dateEnd.Year, dateEnd.Month, dateEnd.Day, 23, 59, 59);//获取截止时间，精确到秒
endTime = endT.ToString();
}
int maxCount = 500;//最大查询条数
//是否已导入
string isAlreadyStatus = string.Empty;
if (ddlisAlreadyStatus.SelectedIndex != 0)
{
isAlreadyStatus = ddlisAlreadyStatus.SelectedValue;
}
string queryMsg = "";
orderInfoInvokeObj = OrderInfoInvokeFactory.CreateInstance(warehouse, billType, startTime, endTime, maxCount, isAlreadyStatus);
if (orderInfoInvokeObj.GetNCDataJoinRFID(out lstPurchaseOrder, out queryMsg) == false)
{
ShowMessageBox("查询用友系统采购订单信息失败！详细信息：" + queryMsg);
return;
}
ViewState["lstPurchaseOrder"] = lstPurchaseOrder;
}
//提交
protected void btnSubmit_Click(object sender, EventArgs e)
{
string saveMsg = "";
List <PurchaseOrder> lstPurchaseOrder = new List <PurchaseOrder>(); //所有的采购订单
List <PurchaseOrder> lstSelectPurchase = new List <PurchaseOrder>(); //被选中的采购订单行项目
bool isChecked = false;
OrderInfoInvoke orderInfoInvokeObj = new OrderInfoInvoke();
QueryData(out orderInfoInvokeObj, out lstPurchaseOrder);
if (ViewState["lstPurchaseOrder"] != null)
{
lstPurchaseOrder = (List <PurchaseOrder>)ViewState["lstPurchaseOrder"];
}
//获取选中的行项目
foreach (GridViewRow grow in GridView1.Rows)
{
CheckBox chkSelect = grow.Cells[0].Controls[1] as CheckBox;
if (chkSelect.Checked)
{
isChecked = true;
string ncCode = grow.Cells[1].Text;
foreach (PurchaseOrder purchaseOrder in lstPurchaseOrder)
{
if (purchaseOrder.NCOrderCode == ncCode)
{
lstSelectPurchase.Add(purchaseOrder);
}
}
}
}
if (!isChecked || lstSelectPurchase.Count == 0)
{
ShowMessageBox("请选择需要导入的订单！");
return;
}
bool result = orderInfoInvokeObj.SaveToRFID(lstSelectPurchase, out saveMsg);
if (result)
{
btnReturn.Visible = true;
btnSubmit.Enabled = false;
}
ShowMessageBox(result == true ? "数据导入成功！" : "数据导入失败！", new Exception(saveMsg));
}
//列表排序
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
////保存sortExpression和sortDirection。
string sortExpression = e.SortExpression;
string sortDirection = "ASC";
if (sortExpression.Equals(GridView1.Attributes["sortExpression"]) && "ASC".Equals(GridView1.Attributes["sortDirection"]))
{
sortDirection = "DESC";
}
GridView1.Attributes.Add("sortExpression", sortExpression);
GridView1.Attributes.Add("sortDirection", sortDirection);
//GridView1.DataBind();
List <PurchaseOrder> lstPurchaseOrder = null;
if (ViewState["lstPurchaseOrder"] != null)
{
lstPurchaseOrder = (List <PurchaseOrder>)ViewState["lstPurchaseOrder"];
}
else
{
OrderInfoInvoke orderInfoInvokeObj = new OrderInfoInvoke();
QueryData(out orderInfoInvokeObj, out lstPurchaseOrder);
}
if (lstPurchaseOrder != null)
{
//string sortExpression = e.SortExpression;
SortDirection sortDirection1 = GridView1.Attributes["sortDirection"] == "ASC" ? SortDirection.Ascending : SortDirection.Descending;
if (sortDirection1 == SortDirection.Ascending)
{
lstPurchaseOrder = lstPurchaseOrder.OrderBy(r => r.GetType().GetProperty(sortExpression).GetValue(r, null)).ToList();
}
else
{
lstPurchaseOrder = lstPurchaseOrder.OrderByDescending(r => r.GetType().GetProperty(sortExpression).GetValue(r, null)).ToList();
}
//绑定数据到界面的Gridview
GridView1.DataSource = lstPurchaseOrder;
GridView1.DataBind();
ViewState["lstPurchaseOrder"] = lstPurchaseOrder;
}
}
//页面加载事件
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//设置开始时间和结束时间的默认值
txtStartTime.Text = System.DateTime.Now.ToShortDateString();
txtEndTime.Text = System.DateTime.Now.ToShortDateString();
List <PurchaseOrder> lstPurchaseOrder = null;
OrderInfoInvoke orderInfoInvokeObj = new OrderInfoInvoke();
QueryData(out orderInfoInvokeObj, out lstPurchaseOrder);
if (lstPurchaseOrder != null)
{
//绑定数据到界面的Gridview
GridView1.DataSource = lstPurchaseOrder;
GridView1.DataBind();
}
}
//这里要注意，一定要放在if (!this.IsPostBack)之外
DisplayFixHeader(this.GridView1);//生成固定表头
}
//查询按钮
protected void btnQuery_Click(object sender, EventArgs e)
{
try
{
//清空界面数据
GridView1.DataSource = null;
GridView1.DataBind();
List <PurchaseOrder> lstPurchaseOrder = null;
OrderInfoInvoke orderInfoInvokeObj = new OrderInfoInvoke();
QueryData(out orderInfoInvokeObj, out lstPurchaseOrder);
if (lstPurchaseOrder != null)
{
//绑定数据到界面的Gridview
GridView1.DataSource = lstPurchaseOrder;
GridView1.DataBind();
}
}
catch (Exception ex)
{
ShowMessageBox("数据导入失败！", ex);
}
}
