private void BindGrid()
{
if (select_Client.SelectValue != "" && this.txtsDate.Text != "" && this.txteDate.Text != "")
{
ORD_OrderDeliveryBLL ordBll = new ORD_OrderDeliveryBLL();
DataTable dt =ordBll.InitOrderDeliveryList(select_Client.SelectValue,txtsDate.Text, txteDate.Text);
string strSqldel = " DELETE MCS_Logistics.dbo.ORD_OrderAlibrary";
SQLDatabase.RunSQL(strSqldel);
for (int j = 0; j < dt.Rows.Count; j++)
{
string strSql = " INSERT INTO MCS_Logistics.dbo.ORD_OrderAlibrary VALUES (" + int.Parse(dt.Rows[j]["OrderId"].ToString()) + ",'" + dt.Rows[j]["OrderNo"].ToString() + "','" + dt.Rows[j]["JxsId"].ToString() + "','" + dt.Rows[j]["经销商名称"].ToString() + "','" + dt.Rows[j]["StoreId"].ToString() + "','" + dt.Rows[j]["下级客户全称"].ToString() + "','" + dt.Rows[j]["barcode"].ToString() + "','" + dt.Rows[j]["Milkid"].ToString() + "','" + dt.Rows[j]["milkname"].ToString() + "','" + dt.Rows[j]["spec"].ToString() + "','" + dt.Rows[j]["Unit"].ToString() + "','" + DateTime.Parse(dt.Rows[j]["Adate"].ToString()) + "')";
SQLDatabase.RunSQL(strSql);
}
DataTable dtAlibrary = ordBll.InitOrderAlibrayList();
gv_OrderList.DataSource = dtAlibrary;
gv_OrderList.DataBind();
}
}
private void BindGrid()
{
if (select_Client.SelectValue != "" && this.txtsDate.Text != "" && this.txteDate.Text != "")
{
ORD_OrderDeliveryBLL ordBll = new ORD_OrderDeliveryBLL();
DataTable dt = ordBll.InitOrderDeliveryList(select_Client.SelectValue, txtsDate.Text, txteDate.Text);
string strSqldel = " DELETE MCS_Logistics.dbo.ORD_OrderAlibrary";
SQLDatabase.RunSQL(strSqldel);
for (int j = 0; j < dt.Rows.Count; j++)
{
string strSql = " INSERT INTO MCS_Logistics.dbo.ORD_OrderAlibrary VALUES (" + int.Parse(dt.Rows[j]["OrderId"].ToString()) + ",'" + dt.Rows[j]["OrderNo"].ToString() + "','" + dt.Rows[j]["JxsId"].ToString() + "','" + dt.Rows[j]["经销商名称"].ToString() + "','" + dt.Rows[j]["StoreId"].ToString() + "','" + dt.Rows[j]["下级客户全称"].ToString() + "','" + dt.Rows[j]["barcode"].ToString() + "','" + dt.Rows[j]["Milkid"].ToString() + "','" + dt.Rows[j]["milkname"].ToString() + "','" + dt.Rows[j]["spec"].ToString() + "','" + dt.Rows[j]["Unit"].ToString() + "','" + DateTime.Parse(dt.Rows[j]["Adate"].ToString()) + "')";
SQLDatabase.RunSQL(strSql);
}
DataTable dtAlibrary = ordBll.InitOrderAlibrayList();
gv_OrderList.DataSource = dtAlibrary;
gv_OrderList.DataBind();
}
}
