protected void btnLoadOut_Click(object sender, EventArgs e)
{
ChangeTrackingList <EntitySearcher> changeTrackingList = ViewState["sql"] as ChangeTrackingList <EntitySearcher>;
List <FineOffice.Modules.CRM_Trader> list = traderBll.GetList(changeTrackingList);
FineOffice.Web.WebExcelHelper excelHelper = new FineOffice.Web.WebExcelHelper();
FineOffice.Common.Excel.ExcelHelper toExcel = new FineOffice.Common.Excel.ExcelHelper();
string serverPath = Server.MapPath("~/Config/Template/CRM_Trader.xml");
List <ExcelHeader> headerList = toExcel.GetHeaderList(serverPath);
toExcel.ApplicationName = excelHelper.ApplicationName;
toExcel.Author = excelHelper.Author;
toExcel.Comments = excelHelper.Comments;
System.IO.MemoryStream ms = toExcel.Export <FineOffice.Modules.CRM_Trader>(list, traderGrid.Title, headerList);
byte[] output = ms.ToArray();
FineOffice.Web.FileTypeHelper typeHelper = new FineOffice.Web.FileTypeHelper();
Response.AddHeader("Content-Disposition", "attachment; filename=" + typeHelper.ToHexString(string.Format("{0}{1:yyyyMMdd}", traderGrid.Title, DateTime.Now) + ".xls"));
Response.AddHeader("Content-Length", output.Length.ToString());
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.OutputStream.Write(output, 0, output.Length);
Response.Flush();
Response.End();
}
protected void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (uploadFile.HasFile)
{
HttpPostedFile excel = uploadFile.PostedFile;
Stream fileStream = excel.InputStream;
FineOffice.Web.WebExcelHelper excelHelper = new FineOffice.Web.WebExcelHelper();
FineOffice.Common.Excel.ExcelHelper toExcel = new FineOffice.Common.Excel.ExcelHelper();
string serverPath = Server.MapPath("~/Config/Template/CNS_CensusMember.xml");
List <ExcelHeader> headerList = toExcel.GetHeaderList(serverPath);
List <FineOffice.Modules.CNS_CensusMember> list = toExcel.Import <FineOffice.Modules.CNS_CensusMember>(fileStream, 0, 0, headerList);
fileStream.Close();
uploadFile.Reset();
gridMember.DataSource = list;
gridMember.DataBind();
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btnTemplates_Click(object sender, EventArgs e)
{
FineOffice.Web.WebExcelHelper excelHelper = new FineOffice.Web.WebExcelHelper();
FineOffice.Common.Excel.ExcelHelper toExcel = new FineOffice.Common.Excel.ExcelHelper();
string serverPath = Server.MapPath("~/Config/Template/CNS_CensusMember.xml");
List <ExcelHeader> headerList = toExcel.GetHeaderList(serverPath);
toExcel.ApplicationName = excelHelper.ApplicationName;
toExcel.Author = excelHelper.Author;
toExcel.Comments = excelHelper.Comments;
System.IO.MemoryStream ms = toExcel.Export <FineOffice.Modules.CNS_CensusMember>(new List <FineOffice.Modules.CNS_CensusMember>(), memberGird.Title, headerList);
byte[] output = ms.ToArray();
FineOffice.Web.FileTypeHelper typeHelper = new FineOffice.Web.FileTypeHelper();
Response.AddHeader("Content-Disposition", "attachment; filename=" + typeHelper.ToHexString(memberGird.Title + ".xls"));
Response.AddHeader("Content-Length", output.Length.ToString());
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); //设置输出流的字符集
Response.OutputStream.Write(output, 0, output.Length); //输出
Response.Flush();
Response.End();
}
/// <summary>
/// 保存导入数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
FineOffice.Common.Excel.ExcelHelper toExcel = new FineOffice.Common.Excel.ExcelHelper();
FineOffice.Web.WebExcelHelper excelHelper = new FineOffice.Web.WebExcelHelper();
string serverPath = Server.MapPath("~/Config/Template/CNS_CensusMember.xml");
List <ExcelHeader> headerList = toExcel.GetHeaderList(serverPath);
try
{
foreach (GridRow row in gridMember.Rows)
{
gridMember.SelectedRowIndex = row.RowIndex;
Dictionary <string, object> valueMap = new Dictionary <string, object>();
foreach (GridColumn column in gridMember.Columns)
{
FineUI.BoundField field = column as FineUI.BoundField;
string value = row.Values[column.ColumnIndex].ToString();
if (field != null)
{
valueMap.Add(field.DataField, value);
}
}
FineOffice.Modules.CNS_CensusMember model = toExcel.Create <FineOffice.Modules.CNS_CensusMember>(headerList, valueMap);
FineOffice.Modules.CNS_CensusRegister register = registerBll.GetModel(m => m.RegisterNO == model.RegisterNO);
if (register == null)
{
register = new FineOffice.Modules.CNS_CensusRegister();
register.RegisterNO = model.RegisterNO;
register.HouseHolder = model.HouseHolder;
FineOffice.Modules.CNS_CensusType type = typeBll.GetModel(t => t.CensusTypeName == model.CensusTypeName);
if (type == null)
{
type = new FineOffice.Modules.CNS_CensusType();
type.CensusTypeName = model.CensusTypeName;
type = typeBll.Add(type);
}
register.CensusTypeID = type.ID;
registerBll.Add(register);
}
if (model.Gender == "男")
{
model.Sex = 1;
}
else
{
model.Sex = 0;
}
FineOffice.Modules.CNS_PoliticalAffiliation political = politicalBll.GetModel(m => m.Political == model.Political);
if (political == null)
{
political = new FineOffice.Modules.CNS_PoliticalAffiliation();
political.Political = model.Political;
political = politicalBll.Add(political);
}
model.PoliticalID = political.ID;
FineOffice.Modules.AM_Kind kind = kindBll.GetModel(m => m.Name == model.Education);
if (kind != null)
{
model.EducationID = kind.ID;
}
memberBll.Add(model);
}
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference("member_close"));
}
catch (Exception ex)
{
FineUI.Alert.ShowInParent(ex.Message);
}
}