private void BindData()
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("CardPassword_QueryExpiredCardPassword_" + _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(), 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.Tables.T_CardPasswords().Open("ID, DateTime, Money, Period, State", Condition, "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "CardPassword_QueryExpiredCardPassword");
return;
}
Shove._Web.Cache.SetCache("CardPassword_QueryExpiredCardPassword_" + _CardPasswordAgentUser.ID.ToString(), dt);
}
PF.DataGridBindData(g, dt, gPager);
}
public DataSet GetNumbers(int AgentID, string TimeStamp, string Sign, string StartTime, string EndTime)
{
StartTime = Shove._Web.Utility.FilteSqlInfusion(StartTime);
EndTime = Shove._Web.Utility.FilteSqlInfusion(EndTime);
new Log("Agent\\CardPassword").Write(String.Format("Method=GetNumbers\tAgentID={0}\tTimeStamp={1}\tSign={2}\tStartTime={3}\tEndTime={4}", AgentID, TimeStamp, Sign, StartTime, EndTime));
DataSet ds = new DataSet();
short State = 0;
if (Valid(ref ds, ref State, AgentID, TimeStamp, Sign, StartTime, EndTime) < 0)
{
return(ds);
}
DataTable dt = new DAL.Tables.T_CardPasswords().Open("[ID], [DateTime], [Money], State, Period", "AgentID = " + AgentID.ToString() + " and (DateTime between '" + StartTime + "' and '" + EndTime + "' )", "[ID]");
if (dt == null)
{
BuildReturnDataSetForError(-9999, "未知错误", ref ds);
return(ds);
}
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(), AgentID, Shove._Convert.StrToLong(dt.Rows[i]["ID"].ToString(), -1));
dt.AcceptChanges();
}
dt.Columns.Remove(dt.Columns[0]);
BuildReturnDataSet(0, ref ds);
ds.Tables.Add(dt);
return(ds);
}
public DataSet GetNumberInformation(int AgentID, string TimeStamp, string Sign, string Number)
{
new Log("Agent\\CardPassword").Write(String.Format("Method=GetNumberInformation\tAgentID={0}\tTimeStamp={1}\tSign={2}\tNumber={3}", AgentID, TimeStamp, Sign, Number));
DataSet ds = new DataSet();
short State = 0;
if (Valid(ref ds, ref State, AgentID, TimeStamp, Sign, Number) < 0)
{
return(ds);
}
int _AgentID = -1;
long CardPasswordID = new CardPassword().GetCardPasswordID(PF.GetCallCert(), Number, ref _AgentID);
if ((CardPasswordID < 0) || (_AgentID != AgentID))
{
BuildReturnDataSetForError(-5, "卡号不存在", ref ds);
return(ds);
}
DataTable dt = new DAL.Tables.T_CardPasswords().Open("[DateTime], [Money], Period, State", "AgentID = " + AgentID + " and [ID] = " + CardPasswordID.ToString(), "");
if (dt == null)
{
BuildReturnDataSetForError(-9999, "未知错误", ref ds);
return(ds);
}
BuildReturnDataSet(0, ref ds);
ds.Tables.Add(dt);
return(ds);
}
protected void btnExcel_Click(object sender, EventArgs e)
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("CardPassword_QueryExpiredCardPassword_" + _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 DateTime > '" + dtFrom.ToString() + "'";
}
dt = new DAL.Tables.T_CardPasswords().Open("ID, DateTime, Money, Period, State", Condition, "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "CardPassword_QueryExpiredCardPassword");
return;
}
Shove._Web.Cache.SetCache("CardPassword_QueryExpiredCardPassword_" + _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();
}
