/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
if (SysConvert.ToString(drpQWHID.EditValue) == "")
{
this.ShowMessage("请选择仓库");
return;
}
string FormDateS = "2014-01-01";
string FormDateE = "2222-01-01";
if (chkFormDate.Checked)
{
FormDateS = txtFormDateS.DateTime.ToString("yyyy-MM-dd");
FormDateE = txtFormDateE.DateTime.ToString("yyyy-MM-dd");
}
string sql = string.Empty;
sql = "SELECT ID FROM WH_StorgeJS WHERE JSDateS=" + SysString.ToDBString(FormDateS) + " AND JSDateE=" + SysString.ToDBString(FormDateE);
sql += " AND JSFlag=1";
DataTable dtJS = SysUtils.Fill(sql);
//string sql = "EXEC USP3_WH_InOutStorgeRpt " + SysString.ToDBString(FormDateS) + "," + SysString.ToDBString(FormDateE) + "," + SysString.ToDBString(HTDataConditionStr);
//DataTable dt = SysUtils.Fill(sql);
//gridView1.GridControl.DataSource = dt;
//gridView1.GridControl.Show();
DataTable dt;
if (dtJS.Rows.Count != 0)//同样的日期范围有结算数据，直接访问结算数据
{
StorgeJSDtsRule rule = new StorgeJSDtsRule();
string conditionStr = " AND MainID=" + SysString.ToDBString(dtJS.Rows[0]["ID"].ToString());
if (!Common.CheckLookUpEditBlank(drpQWHID))
{
conditionStr += " AND WHID=" + SysString.ToDBString(SysConvert.ToString(drpQWHID.EditValue));
}
conditionStr += GetConditionStr();
dt = rule.RShow(conditionStr, ProcessGrid.GetQueryField(gridView1));
lblQueryDesc.Text = "好快，你查询的可是仓库结算数据哦！！！";
Application.DoEvents();
}
else
{
lblQueryDesc.Text = "数据量较大，查询较慢，请耐心等待。";
Application.DoEvents();
int timeout = SystemConfiguration.DBTimeOut;
SystemConfiguration.DBTimeOut = 100000;
sql = "EXEC USP3_WH_InOutStorgeRpt " + SysString.ToDBString(SysConvert.ToString(drpQWHID.EditValue)) + "," + SysString.ToDBString(FormDateS) + "," + SysString.ToDBString(FormDateE) + "," + SysString.ToDBString(HTDataConditionStr);
dt = SysUtils.Fill(sql);
SystemConfiguration.DBTimeOut = timeout;
}
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定结算数据
/// </summary>
public void BindGrid()
{
StorgeJSDtsRule rule = new StorgeJSDtsRule();
string conditionStr = " AND MainID=" + SysString.ToDBString(HTDataID);
if (!Common.CheckLookUpEditBlank(drpQWHID))
{
conditionStr += " AND WHID=" + SysString.ToDBString(SysConvert.ToString(drpQWHID.EditValue));
}
if (txtQItemCode.Text.Trim() != string.Empty)
{
conditionStr += " AND ItemCode=" + SysString.ToDBString(txtQItemCode.Text);
}
if (txtJHFormNo.Text.Trim() != string.Empty)
{
conditionStr += " AND JHFormNo=" + SysString.ToDBString(txtJHFormNo.Text);
}
gridView1.GridControl.DataSource = rule.RShow(conditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
