private void BindData()
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("CardPassword_QueryCardPassword_All");
if (dt == null)
{
string Condition = "";
if (rbExp.Checked)
{
Condition += "state = -1";
}
else if (rbUse.Checked)
{
Condition += "state = 1";
}
else if (rbNoUse.Checked)
{
Condition += "state = 0";
}
if (tbCardPasswordID.Text.Trim() != "")
{
int _AgentID = -1;
Condition += " and ID = " + new CardPassword().GetCardPasswordID(PF.GetCallCert(), Shove._Web.Utility.FilteSqlInfusion(tbCardPasswordID.Text.Trim()), ref _AgentID).ToString();
}
if (tbDateTime.Text.Trim() != "")
{
DateTime dtFrom = DateTime.Parse("1981-01-01");
try
{
dtFrom = DateTime.Parse(tbDateTime.Text.Trim());
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "时间格式填写有错误！");
return;
}
Condition += " and DateTime > '" + dtFrom.ToString() + "'";
}
dt = new DAL.Views.V_CardPasswordDetails().Open("ID, Money, Period, State, AgentID, UseDateTime, RealityName", Condition, "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "CardPassword_QueryCardPassword");
return;
}
Shove._Web.Cache.SetCache("CardPassword_QueryCardPassword_All", dt, 1200);
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData()
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("CardPassword_QueryCardPassword_All");
if (dt == null)
{
string Condition = "";
if (rbExp.Checked)
{
Condition += "state = -1";
}
else if (rbUse.Checked)
{
Condition += "state = 1";
}
else if (rbNoUse.Checked)
{
Condition += "state = 0";
}
if (tbCardPasswordID.Text.Trim() != "")
{
int _AgentID = -1;
Condition += " and ID = " + new CardPassword().GetCardPasswordID(PF.GetCallCert(), Shove._Web.Utility.FilteSqlInfusion(tbCardPasswordID.Text.Trim()), ref _AgentID).ToString();
}
if (tbDateTime.Text.Trim() != "")
{
DateTime dtFrom = DateTime.Parse("1981-01-01");
try
{
dtFrom = DateTime.Parse(tbDateTime.Text.Trim());
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "时间格式填写有错误！");
return;
}
Condition += " and DateTime > '" + dtFrom.ToString() + "'";
}
dt = new DAL.Views.V_CardPasswordDetails().Open("ID, Money, Period, State, AgentID, UseDateTime, RealityName", Condition, "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "CardPassword_QueryCardPassword");
return;
}
Shove._Web.Cache.SetCache("CardPassword_QueryCardPassword_All", dt, 1200);
}
PF.DataGridBindData(g, dt, gPager);
}
protected void btnExcel_Click(object sender, EventArgs e)
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("CardPassword_QueryUseCardPassword_" + _CardPasswordAgentUser.ID.ToString());
if (dt == null)
{
string Condition = "AgentID = " + _CardPasswordAgentUser.ID.ToString() + " and State = 1";
if (tbCardPasswordID.Text.Trim() != "")
{
int _AgentID = -1;
Condition += " and ID = " + new CardPassword().GetCardPasswordID(PF.GetCallCert(), Shove._Web.Utility.FilteSqlInfusion(tbCardPasswordID.Text.Trim()), ref _AgentID).ToString();
}
if (tbDateTime.Text.Trim() != "")
{
DateTime dtFrom = DateTime.Parse("1981-01-01");
try
{
dtFrom = DateTime.Parse(tbDateTime.Text.Trim());
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "时间格式填写有错误！");
return;
}
Condition += " and UseDateTime > '" + dtFrom.ToString() + "'";
}
dt = new DAL.Views.V_CardPasswordDetails().Open("ID, Money, UseDateTime, RealityName", Condition, "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "CardPassword_QueryUseCardPassword");
return;
}
Shove._Web.Cache.SetCache("CardPassword_QueryUseCardPassword_" + _CardPasswordAgentUser.ID.ToString(), dt);
}
dt.Columns.Add("Number", typeof(System.String));
CardPassword cp = new CardPassword();
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["Number"] = "[" + cp.GenNumber(PF.GetCallCert(), _CardPasswordAgentUser.ID, Shove._Convert.StrToLong(dt.Rows[i]["ID"].ToString(), -1)) + "]";
dt.AcceptChanges();
}
dt.Columns.Remove(dt.Columns[0]);
string FileName = "T_CardPassword.xls";
HttpResponse response = Page.Response;
response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
Response.ContentType = "application/ms-excel";
response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
foreach (DataColumn dc in dt.Columns)
{
response.Write(dc.ColumnName + "\t");
}
response.Write("\n");
foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
response.Write(dr[i].ToString() + "\t");
}
response.Write("\n");
}
response.End();
}
protected void btnExcel_Click(object sender, EventArgs e)
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("CardPassword_QueryUseCardPassword_" + _CardPasswordAgentUser.ID.ToString());
if (dt == null)
{
string Condition = "AgentID = " + _CardPasswordAgentUser.ID.ToString() + " and State = 1";
if (tbCardPasswordID.Text.Trim() != "")
{
int _AgentID = -1;
Condition += " and ID = " + new CardPassword().GetCardPasswordID(PF.GetCallCert(), Shove._Web.Utility.FilteSqlInfusion(tbCardPasswordID.Text.Trim()), ref _AgentID).ToString();
}
if (tbDateTime.Text.Trim() != "")
{
DateTime dtFrom = DateTime.Parse("1981-01-01");
try
{
dtFrom = DateTime.Parse(tbDateTime.Text.Trim());
}
catch
{
Shove._Web.JavaScript.Alert(this.Page, "时间格式填写有错误！");
return;
}
Condition += " and UseDateTime > '" + dtFrom.ToString() + "'";
}
dt = new DAL.Views.V_CardPasswordDetails().Open("ID, Money, UseDateTime, RealityName", Condition, "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "CardPassword_QueryUseCardPassword");
return;
}
Shove._Web.Cache.SetCache("CardPassword_QueryUseCardPassword_" + _CardPasswordAgentUser.ID.ToString(), dt);
}
dt.Columns.Add("Number", typeof(System.String));
CardPassword cp = new CardPassword();
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["Number"] = "[" + cp.GenNumber(PF.GetCallCert(), _CardPasswordAgentUser.ID, Shove._Convert.StrToLong(dt.Rows[i]["ID"].ToString(), -1)) + "]";
dt.AcceptChanges();
}
dt.Columns.Remove(dt.Columns[0]);
string FileName = "T_CardPassword.xls";
HttpResponse response = Page.Response;
response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
Response.ContentType = "application/ms-excel";
response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
foreach (DataColumn dc in dt.Columns)
{
response.Write(dc.ColumnName + "\t");
}
response.Write("\n");
foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
response.Write(dr[i].ToString() + "\t");
}
response.Write("\n");
}
response.End();
}
protected void btnExcel_Click(object sender, EventArgs e)
{
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable("CardPassword_QueryUseCardPassword_" + base._CardPasswordAgentUser.ID.ToString());
if (cacheAsDataTable == null)
{
string condition = "AgentID = " + base._CardPasswordAgentUser.ID.ToString() + " and State = 1";
if (this.tbCardPasswordID.Text.Trim() != "")
{
int agentID = -1;
condition = condition + " and ID = " + new CardPassword().GetCardPasswordID(PF.GetCallCert(), Utility.FilteSqlInfusion(this.tbCardPasswordID.Text.Trim()), ref agentID).ToString();
}
if (this.tbDateTime.Text.Trim() != "")
{
DateTime time = DateTime.Parse("1981-01-01");
try
{
time = DateTime.Parse(this.tbDateTime.Text.Trim());
}
catch
{
JavaScript.Alert(this.Page, "时间格式填写有错误！");
return;
}
condition = condition + " and UseDateTime > '" + time.ToString() + "'";
}
cacheAsDataTable = new Views.V_CardPasswordDetails().Open("ID, Money, UseDateTime, RealityName", condition, "");
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", "CardPassword_QueryUseCardPassword");
return;
}
Shove._Web.Cache.SetCache("CardPassword_QueryUseCardPassword_" + base._CardPasswordAgentUser.ID.ToString(), cacheAsDataTable);
}
cacheAsDataTable.Columns.Add("Number", typeof(string));
CardPassword password = new CardPassword();
for (int i = 0; i < cacheAsDataTable.Rows.Count; i++)
{
cacheAsDataTable.Rows[i]["Number"] = "[" + password.GenNumber(PF.GetCallCert(), base._CardPasswordAgentUser.ID, _Convert.StrToLong(cacheAsDataTable.Rows[i]["ID"].ToString(), -1L)) + "]";
cacheAsDataTable.AcceptChanges();
}
cacheAsDataTable.Columns.Remove(cacheAsDataTable.Columns[0]);
string str2 = "T_CardPassword.xls";
HttpResponse response = this.Page.Response;
response.AppendHeader("Content-Disposition", "attachment;filename=" + str2);
base.Response.ContentType = "application/ms-excel";
response.ContentEncoding = Encoding.GetEncoding("gb2312");
foreach (DataColumn column in cacheAsDataTable.Columns)
{
response.Write(column.ColumnName + "\t");
}
response.Write("\n");
foreach (DataRow row in cacheAsDataTable.Rows)
{
for (int j = 0; j < cacheAsDataTable.Columns.Count; j++)
{
response.Write(row[j].ToString() + "\t");
}
response.Write("\n");
}
response.End();
}
private void BindData()
{
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable("CardPassword_QueryUseCardPassword_" + base._CardPasswordAgentUser.ID.ToString());
if (cacheAsDataTable == null)
{
string condition = "AgentID = " + base._CardPasswordAgentUser.ID.ToString() + " and State = 1";
if (this.tbCardPasswordID.Text.Trim() != "")
{
int agentID = -1;
condition = condition + " and ID = " + new CardPassword().GetCardPasswordID(PF.GetCallCert(), Utility.FilteSqlInfusion(this.tbCardPasswordID.Text.Trim()), ref agentID).ToString();
}
if (this.tbDateTime.Text.Trim() != "")
{
DateTime time = DateTime.Parse("1981-01-01");
try
{
time = DateTime.Parse(this.tbDateTime.Text.Trim());
}
catch
{
JavaScript.Alert(this.Page, "时间格式填写有错误！");
return;
}
condition = condition + " and UseDateTime > '" + time.ToString() + "'";
}
cacheAsDataTable = new Views.V_CardPasswordDetails().Open("ID, Money, UseDateTime, RealityName, Name", condition, "");
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", "CardPassword_QueryUseCardPassword");
return;
}
Shove._Web.Cache.SetCache("CardPassword_QueryUseCardPassword_" + base._CardPasswordAgentUser.ID.ToString(), cacheAsDataTable);
}
PF.DataGridBindData(this.g, cacheAsDataTable, this.gPager);
}
