private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (Session["Login"] == null)
{
Response.Redirect("../Exit.aspx");
return;
}
string strAssid = Request.QueryString["aid"];
string strCardid = Request.QueryString["cid"];
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
busi = new BusiComm.BusiQuery(strcons);
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (!IsPostBack)
{
Session.Remove("asold");
Session.Remove("asnew");
CMSMStruct.AssociatorStruct ass1 = busi.GetAssDetailInfo(strAssid, strCardid);
txtAssID.Text = ass1.strAssID;
txtCardID.Text = ass1.strCardID;
txtAssName.Text = ass1.strAssName;
txtSpell.Text = ass1.strSpell;
txtAssNbr.Text = ass1.strAssNbr;
if (ass1.strAssTypeDisp == "X" || ass1.strAssTypeDisp == "x")
{
this.FillDropDownList("AssAT", this.ddlAssType, "vcCommSign='AT'");
this.ddlAssType.Enabled = false;
}
else
{
this.FillDropDownList("AT1", this.ddlAssType);
this.ddlAssType.Enabled = true;
}
ddlAssType.SelectedIndex = ddlAssType.Items.IndexOf(ddlAssType.Items.FindByValue(ass1.strAssType));
txtLinkPhone.Text = ass1.strLinkPhone;
txtEmail.Text = ass1.strEmail;
txtLinkAddress.Text = ass1.strLinkAddress;
txtComments.Text = ass1.strComments;
Session["asold"] = ass1;
}
}
public ArrayList DownAssData(string strBeginDate)
{
DataTable dtAss = new DataTable();
ArrayList alAss = new ArrayList();
try
{
string sql1 = "select * from tbAssociator where vcCardID<>'V9999' and vcAssType<>'AT999' and dtOperDate>='" + strBeginDate + "' order by iAssID,vcCardID";
dtAss = SqlHelper.ExecuteDataTable(con, CommandType.Text, sql1);
for (int i = 0; i < dtAss.Rows.Count; i++)
{
CMSMStruct.AssociatorStruct asstmp = new CMSMStruct.AssociatorStruct();
asstmp.strAssID = dtAss.Rows[i]["iAssID"].ToString();
asstmp.strCardID = dtAss.Rows[i]["vcCardID"].ToString();
asstmp.strAssName = dtAss.Rows[i]["vcAssName"].ToString();
asstmp.strSpell = dtAss.Rows[i]["vcSpell"].ToString();
asstmp.strAssNbr = dtAss.Rows[i]["vcAssNbr"].ToString();
asstmp.strLinkPhone = dtAss.Rows[i]["vcLinkPhone"].ToString();
asstmp.strLinkAddress = dtAss.Rows[i]["vcLinkAddress"].ToString();
asstmp.strEmail = dtAss.Rows[i]["vcEmail"].ToString();
asstmp.strAssType = dtAss.Rows[i]["vcAssType"].ToString();
asstmp.strAssState = dtAss.Rows[i]["vcAssState"].ToString();
asstmp.dCharge = Double.Parse(dtAss.Rows[i]["nCharge"].ToString());
asstmp.iIgValue = int.Parse(dtAss.Rows[i]["iIgValue"].ToString());
asstmp.strCardFlag = dtAss.Rows[i]["vcCardFlag"].ToString();
asstmp.strComments = dtAss.Rows[i]["vcComments"].ToString();
asstmp.strCreateDate = dtAss.Rows[i]["dtCreateDate"].ToString();
asstmp.strOperDate = dtAss.Rows[i]["dtOperDate"].ToString();
asstmp.strDeptID = dtAss.Rows[i]["vcDeptID"].ToString();
alAss.Add(asstmp);
}
}
catch (Exception e)
{
clog.WriteLine(e);
return(null);
}
finally
{
con.Close();
}
return(alAss);
}
private void btMod_Click(object sender, System.EventArgs e)
{
CMSMStruct.AssociatorStruct asold = (CMSMStruct.AssociatorStruct)Session["asold"];
if (asold.strCardID != txtCardID.Text.Trim() || txtAssID.Text.Trim() == "")
{
this.SetErrorMsgPageBydir("保存失败，请重试！");
return;
}
CMSMStruct.AssociatorStruct asnew = new CMSMStruct.AssociatorStruct();
asnew.strCardID = asold.strCardID;
asnew.strAssID = asold.strAssID;
if (txtAssName.Text.Trim() == "")
{
this.SetErrorMsgPageBydir("会员姓名不能为空！");
return;
}
asnew.strAssName = txtAssName.Text.Trim();
asnew.strSpell = txtSpell.Text.Trim();
asnew.strAssNbr = txtAssNbr.Text.Trim();
asnew.strLinkPhone = txtLinkPhone.Text.Trim();
asnew.strLinkAddress = txtLinkAddress.Text.Trim();
asnew.strEmail = txtEmail.Text.Trim();
asnew.strComments = txtComments.Text.Trim();
asnew.strAssType = ddlAssType.SelectedItem.Value;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (!busi.UpdateAssDetail(asnew, asold, ls1))
{
this.SetErrorMsgPageBydir("修改会员资料失败，请重试！");
return;
}
else
{
this.SetSuccMsgPageBydir("修改会员资料成功！", "BusiQuery/wfmAssInfo.aspx");
return;
}
}
private void sbtnOk_Click(object sender, System.EventArgs e)
{
this.listBox1.Items.Clear();
string downFileName = "down" + SysInitial.LocalDept + ".L00";
string filePath = @"E:\\BreadWorksDataBak\\DownLoad\\";
string strYDate = this.dateTimePicker1.Value.Year.ToString();
string strMDate = this.dateTimePicker1.Value.Month.ToString();
string strDDate = this.dateTimePicker1.Value.Day.ToString();
if (strMDate.Length < 2)
{
strMDate = "0" + strMDate;
}
if (strDDate.Length < 2)
{
strDDate = "0" + strDDate;
}
string strBeginDate = strYDate + "-" + strMDate + "-" + strDDate;
// ArrayList alDown=new ArrayList();
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
else
{
string[] fileall = Directory.GetFiles(filePath);
if (fileall.Length > 0)
{
for (int i = 0; i < fileall.Length; i++)
{
System.IO.File.Delete(fileall[i]);
}
}
}
#region 载
this.listBox1.Items.Add("开始下载...");
this.listBox1.Items.Add("\n");
// err=null;
// ca.DownMainDeptData(strBeginDate,downFileName,out err);
#region 加载会员资料
this.listBox1.Items.Add("加载会员资料...");
this.Refresh();
ArrayList alDownUser = new ArrayList();
err = null;
alDownUser = ca.DownAssData(strBeginDate, out err);
if (alDownUser == null || err != null)
{
MessageBox.Show("加载会员资料错误，请重试！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (err != null)
{
clog.WriteLine(err);
}
return;
}
#endregion
// #region 加载会员资料变更记录
// this.listBox1.Items.Add("加载会员资料变更记录...");
// this.Refresh();
// ArrayList alDownUserAlter=new ArrayList();
// err=null;
// alDownUserAlter=ca.DownAssChange(strBeginDate,out err);
// if(alDownUserAlter==null||err!=null)
// {
// MessageBox.Show("加载会员资料变更记录错误，请重试！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
// if(err!=null)
// {
// clog.WriteLine(err);
// }
// return;
// }
// #endregion
StreamWriter swFile = new StreamWriter(filePath + downFileName + ".tmp", true);
#region 写会员资料
CMSMStruct.AssociatorStruct asstmp = null;
swFile.WriteLine("USERTOL=" + alDownUser.Count.ToString());
for (int i = 0; i < alDownUser.Count; i++)
{
asstmp = alDownUser[i] as CMSMStruct.AssociatorStruct;
swFile.WriteLine(sts.ToAssString(asstmp));
}
swFile.WriteLine("END");
this.listBox1.Items.Add("下载会员资料记录数：" + alDownUser.Count.ToString());
#endregion
// #region 写会员资料变更记录
// CMSMStruct.AssChangeStruct assChange=null;
// swFile.WriteLine("ALTETOL=" + alDownUserAlter.Count.ToString());
// for(int i=0;i<alDownUserAlter.Count;i++)
// {
// assChange=alDownUserAlter[i] as CMSMStruct.AssChangeStruct;
// swFile.WriteLine(sts.ToAssChangeString(assChange));
// }
// swFile.WriteLine("END");
// this.listBox1.Items.Add("下载会员资料变更记录数：" + alDownUserAlter.Count.ToString());
// #endregion
swFile.Close();
//加密
DESEncryptor dese = new DESEncryptor();
dese.InputFilePath = filePath + downFileName + ".tmp";
dese.OutFilePath = filePath + downFileName;
dese.EncryptKey = "cmsmyykx";
dese.FileDesEncrypt();
if (dese.NoteMessage != null)
{
MessageBox.Show("下载文件处理出错，请重试！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.clog.WriteLine(dese.NoteMessage);
return;
}
dese = null;
if (System.IO.File.Exists(filePath + downFileName + ".tmp"))
{
System.IO.File.Delete(filePath + downFileName + ".tmp");
}
// if(err!=null)
// {
// this.listBox1.Items.Add("下载数据失败，请重试！");
// this.listBox1.Items.Add(err.ToString());
// return;
// }
this.listBox1.Items.Add("\n");
this.listBox1.Items.Add(strBeginDate + "以后的数据已经下载完成！");
this.Refresh();
#endregion
}