protected void Button1_Click(object sender, EventArgs e)
{
this.dgDetails.AllowPaging = false;
DataTable dt = PayMentBLL.GetMemberInfoByMoney(double.Parse(this.jine.Text));
if (dt == null || dt.Rows.Count < 1)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000053", "没有数据，不能导出Excel！") + "')</script>");
return;
}
if (dt.Rows.Count > 0)
{
dgDetails.DataSource = dt;
dgDetails.DataBind();
}
dt.Columns.Remove("Number");
dt.Columns.Remove("MobileTele");
dt.Columns.Remove("name");
dt.Columns.Remove("BankCard");
dt.Columns.Add("remark");
dt.Columns.Add("biaoshi");
foreach (DataRow row in dt.Rows)
{
row["id"] = dt.Rows.IndexOf(row) + 1;
row["remark"] = "1";
row["bankbook"] = Encryption.Encryption.GetDecipherName(row["bankbook"].ToString()); //解密收款银行户名
row["strbankcard"] = Encryption.Encryption.GetDecipherCard(row["strbankcard"].ToString()); //解密收款银行账号
}
DataTable dtt = DAL.DBHelper.ExecuteDataTable(ViewState["dtt"].ToString());
string data = WriteDatagridToCsv(dtt, new string[] { GetTran("000613", "日期"), GetTran("000041", "总金额"), GetTran("006004", "总笔数"), GetTran("006005", "支付宝帐号(Email)") });
data += WriteDatagridToCsv(dt, new string[] { GetTran("001442", "商户流水号"), GetTran("001443", "收款银行户名"), GetTran("001444", "收款银行账号"), GetTran("001446", "收款开户银行"), GetTran("001447", "收款银行所在省份"), GetTran("006006", "收款银行所在市"), GetTran("001451", "收款支行名称"), GetTran("000322", "金额"), GetTran("001453", "对公对私标志"), GetTran("000078", "备注") });
string temp = string.Format("attachment;filename={0}", "FileName.csv");
Response.ClearHeaders();
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-disposition", temp);
Response.HeaderEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(data);
Response.End();
}
protected void BtnRelease_Click(object sender, EventArgs e)
{
if (ViewState["pandaun"] == null)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + GetTran("001461", "对不起，请在发放奖金之前显示要发放的奖金！") + "')</script>");
return;
}
string grant = "公司发放";
//发放当期奖金
int countqishu = CommonDataBLL.getMaxqishu();
Application.Lock();
bool blean = PayMentBLL.UpMemberInfo(countqishu, double.Parse(jine.Text), grant, Request.UserHostAddress, Session["Company"].ToString());
Application.UnLock();
if (blean == false)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + GetTran("001376", "对不起，写入电子帐户失败，请联系维护人员！") + "')</script>");
return;
}
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + GetTran("001464", "工资发放成功！") + "')</script>");
}
