/// <summary>
/// 首次加载
/// </summary>
public void FirstLoad()
{
StringBuilder sb = new StringBuilder();
string Currency = StorageInBrowseBLL.GetMoreCurrencyIDByCountryCode(Country.SelectedValue).ToString();
int intDocType = QueryInStorageBLL.GetDocTypeIDByDocTypeName("RK");
sb.Append(" D.DocTypeID=" + intDocType);
sb.Append(" And " + this.Flag.SelectedValue.ToString() + " and d.Provider=p.ID ");
string columns = "d.*,p.[Name]";
string table = "InventoryDoc As D,ProviderInfo as p";
string key = "D.ID";
ViewState["SQLSTR"] = "select " + columns + " from " + table + " where " + sb.ToString() + " order by " + key + " desc";
Pager pSorting = Page.FindControl("Pager1") as Pager;
pSorting.PageBind(0, 10, table, columns, sb.ToString(), key, "gvInfo");
}
public void getDocDetiles()
{
StringBuilder sb = new StringBuilder();
string Currency = StorageInBrowseBLL.GetMoreCurrencyIDByCountryCode(Country.SelectedValue).ToString();
int intDocType = QueryInStorageBLL.GetDocTypeIDByDocTypeName("RK");
sb.Append(" D.DocTypeID=" + intDocType);
if (ddlCondition.SelectedValue == "ExpectNum")
{
if (txtCondition.Text.Trim() != "")
{
int expectNum = 0;
try
{
expectNum = Convert.ToInt32(txtCondition.Text.Trim());
}
catch
{
this.msg = Transforms.ReturnAlert(GetTran("006829", "期数输入错误!"));
return;
}
sb.Append(" and D." + ddlCondition.SelectedValue + "=" + expectNum.ToString());
}
}
if (ddlCondition.SelectedIndex > 0 && ddlCondition.SelectedIndex <= 3)
{
if (txtCondition.Text.Trim() != "")
{
sb.Append(" and D." + ddlCondition.SelectedValue + " like '%" + txtCondition.Text.Trim() + "%'");
}
}
if (ddlCondition.SelectedValue == "TotalMoney")
{
if (txtCondition.Text.Trim() != "")
{
try
{
Convert.ToDouble(txtCondition.Text.Trim());
}
catch
{
this.msg = Transforms.ReturnAlert(GetTran("002211", "输入错误!"));
return;
}
sb.Append(" and D." + ddlCondition.SelectedValue + " " + DropDownList1.SelectedValue + " " + Convert.ToDouble(txtCondition.Text.Trim().Replace("'", "")));
}
}
if (ddlCondition.SelectedValue == "DocMakeTime")
{
if (txtCondition.Text.Trim() != "")
{
try
{
Convert.ToDateTime(this.TextBox1.Text.Trim().Replace("'", ""));
}
catch
{
this.msg = Transforms.ReturnAlert(GetTran("002211", "输入错误!"));
return;
}
sb.Append(" and DATEADD(day, DATEDIFF(day,0,D." + ddlCondition.SelectedValue + "), 0)" + DropDownList1.SelectedValue + " ' " + this.TextBox1.Text.Trim() + "'");
}
}
sb.Append(" And " + Flag.SelectedValue.ToString() + " and d.Provider=p.ID ");
string columns = "d.*,p.[Name]";
string table = "InventoryDoc As D,ProviderInfo as p";
string key = "D.ID";
ViewState["SQLSTR"] = "select " + columns + " from " + table + " where " + sb.ToString() + " order by " + key + " desc";
Pager pSorting = Page.FindControl("Pager1") as Pager;
pSorting.PageBind(0, 10, table, columns, sb.ToString(), key, "gvInfo");
}