protected void Page_Load(object sender, EventArgs e)
{
//获取品搜数据
long id = Requests.GetQueryLong("id", 0);
long userid = Requests.GetQueryLong("userid", 0);
string username = Requests.GetQueryString("username");
E_PinsouUser data = new E_PinsouUser();
data.ID = id;
data.Pinsou_UserID = userid;
data.UserName = username;
//查询登录信息
DataTable dt = new T_User().Pinsou_AutoLogin(data);
if (dt != null && dt.Rows.Count == 1)//验证通过
{
string name = dt.Rows[0]["Email"].ToString();
string pwd = dt.Rows[0]["password"].ToString();
Login(name, pwd);
}
else //验证失败
{
Jscript.ShowMsg("信息错误无法登录！", this);
return;
}
}
/// <summary>
/// 彻底删除按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
string ciids = hdClientInfoIDs.Value;
hdClientInfoIDs.Value = "";
if (!MLMGC.COMP.StringUtil.IsStringArrayList(ciids))//判断格式是否正确 格式：1,21,321
{
HttpContext.Current.Response.Write("参数错误");
return;
}
E_ItemClientInfo data = new E_ItemClientInfo();
data.EnterpriseID = EnterpriceID;
data.ClientInfoIDs = ciids;
bool flag = new T_ItemClientInfo().ThoroughDelete(data);
if (flag)
{
Jscript.AlertAndRedirect(this, "删除成功", "Recycled.aspx");
}
else
{
Jscript.ShowMsg("删除失败", this);
}
}
/// <summary>
/// 提交退出申请
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
string reason = txtReason.Text.Trim();
if (string.IsNullOrEmpty(reason))
{
Jscript.ShowMsg("请输入退出理由!", this);
return;
}
E_ItemApply data = new E_ItemApply();
data.ItemID = itemid;
data.UserID = UserID;
data.ApplyType = EnumApplyType.申请退出;
data.Reason = reason;
bool flag = new T_ItemApply().Add(data);
if (flag)
{
Jscript.AlertAndRedirect(this, "申请成功", "itemlist.aspx");
}
else
{
Jscript.ShowMsg("申请失败", this);
}
}
/// <summary>
/// 登录
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
protected void Login(string name, string pwd)
{
E_User data = new E_User();
data.UserType = (int)MLMGC.DataEntity.User.UserType.个人用户;
data.UserName = name;
data.Password = MLMGC.COMP.EncryptString.EncryptPassword(pwd);//加密
data = new MLMGC.BLL.User.T_User().UserLogin(data);
if (data != null)
{
E_PersonalUser dataPU = new E_PersonalUser();
dataPU.UserID = data.UserID;
dataPU.PersonalID = data.EnterpriseID;
dataPU.UserName = data.UserName;
dataPU.Password = data.Password;
new MLMGC.Security.PersonalPage().Login(dataPU);
//登录成功添加日志
data.LoginIP = HttpContext.Current.Request.ServerVariables["Remote_Addr"];
data.Browser = HttpContext.Current.Request.Browser.Type;
data.Resolution = "";
bool flag = new MLMGC.BLL.User.T_User().AddLoginInfo(data);
Response.Redirect("../Personal/Default.aspx");
}
else
{
Jscript.ShowMsg("密码错误！", this);
return;
}
}
/// <summary>
/// 还原到共享池处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnRestore_Click(object sender, EventArgs e)
{
string ciids = hdClientInfoIDs.Value;
hdClientInfoIDs.Value = "";
if (!MLMGC.COMP.StringUtil.IsStringArrayList(ciids))//判断格式是否正确 格式：1,21,321
{
HttpContext.Current.Response.Write("参数错误");
return;
}
E_ClientInfo data = new E_ClientInfo();
data.EnterpriseID = EnterpriceID;
data.Mode = EnumClientMode.共享;
data.Status = EnumClientStatus.共享;
data.EPUserTMRID = EPUserTMRID;
data.ClientInfoIDs = ciids;
bool flag = new T_ClientInfoHelper().LeaderRestore(data);
if (flag)
{
Jscript.AlertAndRedirect(this, "还原成功", "Recycled.aspx");
}
else
{
Jscript.ShowMsg("还原失败", this);
}
}
protected void databind()
{
//获取文库编号
int id;
if (!int.TryParse(Request["id"], out id))
{
Jscript.AlertAndRedirect(this, "参数错误", "List.aspx");
return;
}
//根据编号获取文库详情
E_WenKu data = new E_WenKu();
data.WenKuID = id;
data = new T_WenKu().GetModel(data);
if (data == null)
{
Jscript.ShowMsg("未获取对象", this);
return;
}
//判断swf文件是否存在，若不存在，则直接返回
string flashpath = MLMGC.COMP.Config.GetWenKu("swf\\" + data.FileUrl.Substring(0, data.FileUrl.LastIndexOf(".")) + ".swf");
if (!File.Exists(flashpath))
{
Jscript.CloseWindow("对应的文件未找到："+flashpath);
return;
}
lblCaption.Text = data.Caption;
lblIntro.Text = data.Intro;
lblKeyword.Text = data.Keywords;
lblSize.Text = MLMGC.COMP.CommonMethod.FileSize(data.FileSize);
FlashUrl = Config.GetWenKuUrl("swf/"+data.FileUrl.Substring(0, data.FileUrl.LastIndexOf(".")) + ".swf");
}
protected void Page_Load(object sender, EventArgs e)
{
//获取品搜用户数据
long userid = Requests.GetQueryLong("userid", 0);
string username = Requests.GetQueryString("username");
E_PinsouUser data = new E_PinsouUser();
data.Pinsou_UserID = userid;
data.UserName = username;
//去品搜数据库验证用户编号和用户名是否正确
DataTable dt = new T_User().Pinsou_Verification(data);
//判断用户编号和用户名是否正确
if (dt != null && dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
string email = row["Email"].ToString();
//再判断邮箱是否存在
if (string.IsNullOrEmpty(email))
{
Jscript.ShowMsg("邮箱不存在，无法注册！", this);
return;
}
//验证通过后，继续注册
data.Pinsou_UserID = Convert.ToInt32(row["userid"]);
data.Email = email;
data.Password = EncryptString.EncryptPassword(row["password"].ToString());
data.Mobile = row["mobile"].ToString();
data.Fax = row["fax"].ToString();
int result = new T_User().Pinsou_AutoRegister(data);
if (result == -1)//邮箱已存在
{
Jscript.ShowMsg("邮箱不存在，无法注册！", this);
return;
}
else if (result == 0) //注册失败
{
Jscript.ShowMsg("注册失败！", this);
return;
}
else //注册成功直接跳转
{
E_PersonalUser dataPU = new E_PersonalUser();
dataPU.UserID = data.mlb_UserID;
dataPU.PersonalID = data.PersonalID;
dataPU.UserName = data.Email;
dataPU.Password = data.Password;
new MLMGC.Security.PersonalPage().Login(dataPU);
Jscript.AlertAndRedirect(this, "注册成功", "../Personal/Default.aspx");
}
}
else
{
Jscript.ShowMsg("用户编号和用户名错误！", this);
return;
}
}
/// <summary>
/// 点击确定按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
string password = txtPassword.Text.Trim();
string confirm = txtConfirm.Text.Trim();
if (string.IsNullOrEmpty(name))
{
Jscript.ShowMsg("请输入用户名", this);
return;
}
if (string.IsNullOrEmpty(password) & type == "add")
{
Jscript.ShowMsg("添加用户时必须输入密码", this);
return;
}
if (password != confirm)
{
Jscript.ShowMsg("两次密码输入不一致", this);
return;
}
E_Admin data = new E_Admin();
data.AdminID = id;
data.UserName = name;
data.Password = string.IsNullOrEmpty(password) ? "" : EncryptString.EncryptPassword(password);
//先判断一下用户名是否存在
bool b = new T_Admin().Exists(data);
if (b)
{
Jscript.ShowMsg("用户名已存在", this);
return;
}
bool flag = false;
if (type == "add")
{
flag = new T_Admin().Add(data);
}
else if (type == "update")
{
flag = new T_Admin().Update(data);
}
if (flag)
{
Jscript.AlertAndRedirect(this, "操作成功", "adminlist.aspx");
}
else
{
Jscript.ShowMsg("操作失败", this);
}
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
/*
* EnumUtil.BindList<EnumApply>(rbStatus);
*
* int status = Requests.GetQueryInt("status", -1);
* rbStatus.SelectedValue = status.ToString();
*/
//根据EnterpriseID获取ItemID
E_Item item = new T_Item().GetModel(new E_Item()
{
EnterpriseID = EnterpriceID
});
if (item == null)
{
Jscript.ShowMsg("未找到项目", this);
return;
}
string start = Requests.GetQueryString("start");
string end = Requests.GetQueryString("end");
E_ItemApply data = new E_ItemApply();
data.ApplyType = EnumApplyType.申请退出;
data.Status = EnumApply.全部;
data.ItemID = item.ItemID;
data.Page = new MLMGC.DataEntity.E_Page();
if (!string.IsNullOrEmpty(start))
{
data.Page.StartDate = Convert.ToDateTime(start);
txtStartDate.Text = Convert.ToDateTime(start).ToString("yyyy-MM-dd");
}
if (!string.IsNullOrEmpty(end))
{
data.Page.EndDate = Convert.ToDateTime(end);
txtEndDate.Text = Convert.ToDateTime(end).ToString("yyyy-MM-dd");
}
data.Page.PageIndex = pageIndex;
data.Page.PageSize = pageSize;
rpList.DataSource = new T_ItemApply().GetList(data);
rpList.DataBind();
//设置分页样式
pageList1.PageSize = pageSize;
pageList1.CurrentPageIndex = pageIndex;
pageList1.RecordCount = data.Page.TotalCount;
pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount);
pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " ";
}
protected void btnSend_Click(object sender, EventArgs e)
{
if (data == null)
{
Jscript.ShowMsg("读取配置失败", this);
return;
}
MLMGC.Controls.SendMail SM = new MLMGC.Controls.SendMail(data.Email, data.SMTP, data.Port, data.UserName, data.Password, data.UserName);
string errorMessage;
bool b = SM.Send(txtReceiveEmail.Text.Trim(), txtSubject.Text.Trim(), txtContent.Text.Trim(), out errorMessage);
Jscript.ShowMsg("发送" + (b?"成功":"失败" + errorMessage), this);
}
protected void LoginButton_Click(object sender, EventArgs e)
{
E_Admin data = new E_Admin();
data.UserName = StringUtil.safety(UserName.Text);
data.Password = EncryptString.EncryptPassword(StringUtil.safety(Password.Text.Trim()));
T_Admin bll = new T_Admin();
E_Admin model = bll.UserLogin(data);
if (model != null)
{
setSession(model.AdminID, model.UserName, model.Password);
Response.Redirect("index.aspx");
}
Jscript.ShowMsg("帐号或密码错误，无法登录系统！", this);
}
protected void btnExport_Click(object sender, EventArgs e)
{
bool b = false;
T_ClientInfo bll = new T_ClientInfo();
E_ClientInfo data = new E_ClientInfo();
data.PersonalID = PersonalID;
data.SetStatus = int.Parse(rblStatus.SelectedValue.ToString());
DataSet ds = bll.DataExport(data);
Jscript.ShowMsg(b ? "导出成功" : "操作失败", this);
ExportDataSet(ds, "导出——" + DateTime.Now.ToString("yyyyMMddHHss") + "(" + data.Status.ToString() + ")", new List <string>()
{
"名录信息", "来源信息", "行业信息", "地区信息"
});
}
/// <summary>
/// 点击确定按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
//获取界面数据
string name = txtItemName.Text.Trim();
string intro = txtItemIntro.Text.Trim();
string signature = txtSignature.Text.Trim();
string content = txtContent.Content;
string established = txtEstablished.Text.Trim();
if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(content))
{
Jscript.ShowMsg("请认真填写以上内容!", this);
return;
}
E_Item data = new E_Item();
data.EnterpriseID = eid;
data.ItemName = name;
data.ItemIntro = intro;
data.Signature = signature;
data.ItemContent = content;
data.SetStatus = Convert.ToInt32(rbStatus.SelectedValue);
data.Photo = hdUrl.Value.Substring(hdUrl.Value.LastIndexOf("/") + 1);
if (!string.IsNullOrEmpty(established))
{
data.Established = Convert.ToDateTime(txtEstablished.Text.Trim());
}
else
{
data.Established = DateTime.Now;
}
data.CityID = region.RegionID;
bool flag = new T_Item().Update(data);
//Jscript.ShowMsg(string.Format("保存{0}",flag?"成功":"失败"), this);
if (flag)
{
//Jscript.ShowMsg("保存成功", this);
databind();
Jscript.AlertAndRedirect(this, "修改成功", "ItemList.aspx?page=" + Requests.GetQueryString("page"));
}
else
{
Jscript.ShowMsg("保存失败", this);
}
}
/// <summary>
/// 点击确定按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
int lday, lrday, wday, wrday;
if (!int.TryParse(txtLatenDay.Text, out lday) || !int.TryParse(txtLRemindDay.Text, out lrday) || !int.TryParse(txtWishDay.Text, out wday) || !int.TryParse(txtWRemindDay.Text, out wrday))
{
Jscript.ShowMsg("请输入正确的数字", this);
return;
}
if (lday > 999 || wday > 999)
{
Jscript.ShowMsg("设置天数最大为999，请重新设置", this);
return;
}
//数据合法性
if (lrday > 99 || wrday > 99)
{
Jscript.ShowMsg("提醒天数最大为99，请重新设置", this);
return;
}
if ((lrday > 0 && lday > 0 && lrday >= lday) || (wrday >= wday && wrday > 0 && wday > 0))
{
Jscript.ShowMsg("提醒天数不能大于等于设置天数，请重新设置", this);
return;
}
if (lrday < 0 || lday < 0 || wrday < 0 || wday < 0)
{
Jscript.ShowMsg("设置值不能为负数，请重新设置", this);
return;
}
E_TeamModel data = new E_TeamModel();
data.EnterpriseID = EnterpriceID;
data.LatenDay = lday;
data.LRemindDay = lrday;
data.WishDay = wday;
data.WRemindDay = wrday;
data.NotTradedID = Convert.ToInt32(ddlNotTraded.SelectedValue);
bool flag = new T_TeamModel().UpdateDeadLine(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "共享设置", IP = MLMGC.COMP.Requests.GetRealIP()
});
Jscript.ShowMsg(flag ? "修改成功" : "修改失败", this);
}
/// <summary>
/// 删除所有名录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDeleteAll_Click(object sender, EventArgs e)
{
E_ItemClientInfo data = new E_ItemClientInfo();
data.EnterpriseID = EnterpriceID;
bool flag = new T_ItemClientInfo().ThoroughDeleteAll(data);
if (flag)
{
Jscript.AlertAndRedirect(this, "删除成功", "Recycled.aspx");
}
else
{
Jscript.ShowMsg("删除失败", this);
}
}
protected void Delete(int type)
{
E_Log data = new E_Log();
data.EnterpriseID = EnterpriceID;
data.Type = type;
bool flag = new T_Log().Delete(data);
if (flag)
{
Jscript.AlertAndRedirect(this, "删除成功", "LogList.aspx");
}
else
{
Jscript.ShowMsg("删除失败", this);
}
}
/// <summary>
/// 点击确定按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
//获取界面数据
string name = txtDBName.Text.Trim();
//获取界面数据
int num;
if (!int.TryParse(txtMaxNum.Text.Trim(), out num))
{
Jscript.ShowMsg("参数错误", this);
return;
}
E_EnterpriseDB data = new E_EnterpriseDB();
data.DBName = name;
data.MaxNum = num;
bool flag = false;
if (type == "update")
{
data.EnterpriseDBID = dbid;
flag = new T_EnterpriseDB().UpdateMaxNum(data);
}
else
{
//获取数据库文件存放位置
data.Path = Config.GetAppSettings("DBFilePath");
if (string.IsNullOrEmpty(data.Path))
{
Jscript.ShowMsg("配置文件错误，没有找到DBFilePath", this);
return;
}
flag = new T_EnterpriseDB().Add(data);
}
if (flag)
{
Jscript.AlertAndRedirect(this, "操作成功", "list.aspx");
}
else
{
Jscript.ShowMsg("操作失败", this);
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
//验证数据是否正确
string email = txtReceiveEmail.Text.Trim();
string subject = txtSubject.Text.Trim();
string content = txtContent.Text.Trim();
//if (string.IsNullOrEmpty(email) || string.IsNullOrEmpty(subject))
//{
// Jscript.ShowMsg("请", this);
//}
//显示邮件配置信息
E_MailConfig data = new T_MailConfig().GetConfig(new E_MailConfig()
{
EnterpriseID = base.EnterpriceID,
UserID = UserID
});
if (data == null)
{
Jscript.ShowMsg("读取配置失败", this);
return;
}
//处理附件地址
string[] listAtt = hdAttachment.Value.Split(',');
for (int i = 0; i < listAtt.Length; i++)
{
listAtt[i] = MLMGC.COMP.Config.GetEnterpriseM(EnterpriceID, listAtt[i]);
}
MLMGC.Controls.SendMail SM = new MLMGC.Controls.SendMail(data.Email, data.SMTP, data.Port, data.UserName, data.Password, data.Name, listAtt.ToList());
string errorMessage = string.Empty;
string[] eArray = email.Split(',');
bool flag = true;
foreach (string s in eArray)
{
flag = flag && SM.Send(s, subject, content, out errorMessage);
}
//添加操作日志
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "发送电子邮件", IP = MLMGC.COMP.Requests.GetRealIP()
});
Jscript.ShowMsg("发送" + (flag ? "成功" : "失败" + errorMessage), this);
}
/// <summary>
/// DataSet导出Excel
/// </summary>
/// <param name="ds">DataSet</param>
/// <param name="filename">文件名</param>
/// <param name="listname">Sheet表名</param>
protected void ExportDataSet(DataSet ds, string filename, List <string> listname)
{
if (MLMGC.COMP.Data.DataSetIsNotNull(ds))
{
Response.Clear();
Response.BufferOutput = false;
Response.ContentEncoding = System.Text.Encoding.UTF8;
filename = HttpUtility.UrlEncode(filename);
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
Response.ContentType = "application/ms-excel";
StarTech.NPOI.NPOIHelper.ExportExcel(ds, Response.OutputStream, listname);
Response.Close();
}
else
{
Jscript.ShowMsg("无法导出数据", this);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//判断用户是否加入了项目，或者该企业项目是否开通
if (EnterpriseID == 0)
{
Jscript.ShowMsg("您还没有加入项目无法操作!", this);
return;
}
else if (!IsOpen)
{
Jscript.ShowMsg("您所加入的企业项目还未开通!", this);
return;
}
if (!IsPostBack)
{
databind();
}
}
/// <summary>
/// 点击使用按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOpenFlag_Click(object sender, EventArgs e)
{
E_Item data = new E_Item();
data.EnterpriseID = eid;
data.ItemID = iid;
data.OpenFlag = ItemOpenFlag.已开通;
bool flag = new T_Item().UpdateOpenFlag(data);
if (flag)
{
Jscript.ShowMsg("开通成功！", this);
databind();
}
else
{
Jscript.ShowMsg("开通失败！", this);
}
}
/// <summary>
/// 申请该项目
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnApply_Click(object sender, EventArgs e)
{
E_ItemApply data = new E_ItemApply();
data.ItemID = iid;
data.ApplyType = EnumApplyType.申请加入;
data.UserID = UserID;
data.Reason = "";
bool flag = new T_ItemApply().Add(data);
if (flag)
{
Jscript.ShowMsg("申请成功", this);
databind();
}
else
{
Jscript.ShowMsg("留言失败！", this);
}
}
/// <summary>
/// 项目名录－－》个人名录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnIPSwitch_Click(object sender, EventArgs e)
{
//获取导入数量
int num;
if (!int.TryParse(txtTotalCount.Text.Trim(), out num))
{
Jscript.ShowMsg("请输入正确的整数", this);
return;
}
if (num < 0 || num > 2000)
{
Jscript.ShowMsg("请输入1-2000的整数", this);
return;
}
E_ItemClientInfo data = new E_ItemClientInfo();
data.EnterpriseID = EnterpriseID;
data.UserID = UserID;
data.PersonalID = PersonalID;
data.SetStatus = Convert.ToInt32(rbIPSStatus.SelectedValue);
data.SetTarStatus = Convert.ToInt32(rbIPTStatus.SelectedValue);
data.TotalCount = num;
data.IsExchange = cbIPExchange.Checked ? 1 : 0;
DataTable dt = new T_ItemClientInfo().ImportData_IP(data);
string result = string.Empty;
if (dt.Rows[0]["Flag"].ToString().Equals("1"))
{
result = string.Format("<span style=\"color:Green;\"> 本次结果：<br/>总数：{0}<span style=\"margin:10px\"> </span>重复：{1}<span style=\"margin:10px\"> </span>导入：{2}</span>", dt.Rows[0]["Total"], dt.Rows[0]["Repeat"], dt.Rows[0]["Num"]);
}
else
{
result = "<span style=\"color:Red;\">导入失败</span>";
}
lblResult.Text = result;
}
/// <summary>
/// 提交留言处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
//获取界面数据
string username = txtUserName.Text.Trim();
string mobile = txtMobile.Text.Trim();
string tel = txtTel.Text.Trim();
string address = txtAddress.Text.Trim();
string email = txtEmail.Text.Trim();
string message = txtMessage.Text.Trim();
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(mobile) || string.IsNullOrEmpty(message))
{
Jscript.ShowMsg("请请认真填写以上内容！", this);
return;
}
E_ItemMessage data = new E_ItemMessage();
data.ItemID = iid;
data.UserID = UserID;
data.UserName = username;
data.Mobile = mobile;
data.Tel = tel;
data.Address = address;
data.Email = email;
data.Message = message;
bool flag = new T_ItemMessage().Add(data);
if (flag)
{
loadMessage();
txtMessage.Text = "";
}
else
{
Jscript.ShowMsg("留言失败！", this);
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
//string url = @"E:\名录宝\MLMGC\Web\Resource\PersonalData\1\1.xls";
//ImportData import = new ImportData(PersonalID, url);
//bool b = import.Import();
//if (b)//导入成功删除文件
//{
// //System.IO.File.Delete(url);
//}
//Jscript.ShowMsg(b ? "全部导入成功" : String.Join("\\r\\n", import.Result), this);
//上传文件
List <PFileInfo> list = FileUpload1.Upload(PersonalID.ToString());
if (list.Count == 1)//==1 上传成功
{
ImportData import = new ImportData(PersonalID, list[0].FilePath + list[0].FileAddress);
bool b = import.Import();
Jscript.AlertAndRedirect(this, b ? "导入成功" : string.Join("\\r\\n", import.Result), "Importing.aspx");
}
else
{
Jscript.ShowMsg("上传文件失败", this);
}
}
/// <summary>
/// 数据绑定
/// </summary>
private void databind()
{
//获取数据源
dt = new MLMGC.BLL.T_Region().GetList();
if (dt == null || dt.Rows.Count == 0)
{
return;
}
//初始化对象
list = new List <E_Region>();
E_Region region = null;
//-----------------------分析绑定数据-------------------------
//判断是否传值
int regionid, pid = 0;
if (!int.TryParse(hfValue.Value, out regionid))
{
Jscript.ShowMsg("参数错误", this);
return;
}
//查找父节点编号
DataRow[] rows = dt.Select(" regionid=" + regionid);
if (rows.Length == 1)
{
pid = Convert.ToInt32(rows[0]["parentid"]);
}
//获取所有父节点，绑定显示
foreach (DataRow row in dt.Select(" parentid=0"))
{
region = new E_Region();
region.RegionID = Convert.ToInt32(row["RegionID"]);
region.RegionName = row["RegionName"].ToString();
AddChild(region, regionid);
if (region.RegionID == pid) //如果当前节点编号==pid ,则选中该节点
{
region.Selected = " selected=\"selected\"";
//绑定子级
rpSecond.DataSource = region.List;
rpSecond.DataBind();
}
list.Add(region);
}
rpList.DataSource = list;
rpList.DataBind();
//-------------------------拼装json字符串----------------------------
strArray = new StringBuilder("[");
foreach (DataRow row in dt.Rows)
{
strArray.Append("{id:\"" + row["RegionID"] + "\",name:\"" + row["RegionName"] + "\",pid:\"" + row["ParentID"] + "\"},");
}
strArray.Remove(strArray.Length - 1, 1);
strArray.Append("]");
hfData.Value = strArray.ToString();
//-------------------------------------------------------------------
}
/// <summary>
/// 点击确定按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
E_ClientInfo data = new E_ClientInfo();
data.PersonalID = PersonalID;
//data.UserID = UserID;
//data.EPUserTMRID = EPUserTMRID;
data.ClientName = txtName.Text.Trim();
data.Address = txtAddress.Text;
data.ZipCode = txtZipCode.Text;
data.Position = txtPosition.Text;
data.Linkman = txtLinkman.Text;
data.Position = txtPosition.Text;
data.Tel = txtTel.Text.Trim();
data.Mobile = txtMobile.Text.Trim();
data.Fax = txtFax.Text;
data.Email = txtEmail.Text;
data.QQ = txtQQ.Text;
data.MSN = txtMSN.Text;
data.Website = txtWebsite.Text;
data.SourceName = trSource.Visible ? ddlSource.SelectedItem.Text.Trim() : string.Empty;
data.TradeName = trTrade.Visible ? ddlTrade.SelectedItem.Text.Trim() : string.Empty;
data.AreaName = trArea.Visible ? ddlArea.SelectedItem.Text.Trim() : string.Empty;
data.Remark = txtRemark.Text;
if (string.IsNullOrWhiteSpace(data.ClientName))//判断是否输入名录名称
{
Jscript.ShowMsg("请输入名称", this);
txtName.Focus();
return;
}
//添加之前再次确认名录名称、电话、手机是否唯一
bool b = true;
//判断名录名是否存在
b = new T_ClientInfo().Exists(new E_ClientInfo()
{
PersonalID = PersonalID, ClientName = data.ClientName, ClientInfoID = 0
});
if (b)
{
Jscript.ShowMsg("名录名称已存在！", this);
return;
}
DataTable dt;
b = true;
//判断手机是否存在
if (!string.IsNullOrEmpty(data.Mobile))
{
dt = new T_ClientInfo().ExistsContact(new E_ClientInfo {
PersonalID = PersonalID, ClientInfoID = 0, Type = 1, Value = data.Mobile
});
if (dt == null && Convert.ToInt32(dt.Rows[0]["Flag"]) > -1)
{
b = false;
}
}
//判断电话是否存在
if (!string.IsNullOrEmpty(data.Tel))
{
dt = new T_ClientInfo().ExistsContact(new E_ClientInfo {
PersonalID = PersonalID, ClientInfoID = 0, Type = 2, Value = data.Tel
});
if (dt == null && Convert.ToInt32(dt.Rows[0]["Flag"]) > -1)
{
b = false;
}
}
if (!b)
{
Jscript.ShowMsg("录入失败", this);
return;
}
T_ClientInfo bll = new T_ClientInfo();
bool flag = bll.Add(data);
if (flag)
{
Jscript.AlertAndRedirect(this, "录入成功", Request.Url.ToString());
}
else
{
Jscript.ShowMsg("录入失败", this);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
T_TeamModel blltm = new T_TeamModel();
E_TeamModel data = blltm.GetTeamScale(new E_TeamModel()
{
EnterpriseID = base.EnterpriceID
});
if (data == null)
{
Jscript.AlertAndRedirect(this, "请先设置团队模型", "TeamModelSetUp.aspx");
return;
}
int teammodeid = data.TeamModelID;
List <string> aryRole = new List <string>();
List <string> aryAmount = new List <string>();
XmlDocument doc = new XmlDocument();
doc.LoadXml(data.TeamScaleXml);
XmlNodeList root = doc.SelectNodes("root/item[@readonly='false']");
bool bCheck = true;
int num = 0;
foreach (XmlNode n in root)//遍历所有property节点
{
aryRole.Add(n.Attributes["roleID"].Value);
aryAmount.Add(Request.Form["txtAmount" + n.Attributes["roleID"].Value].ToString());
if (int.TryParse(Request.Form["txtAmount" + n.Attributes["roleID"].Value].ToString(), out num) && num > 0)
{
n.ChildNodes[1].InnerText = num.ToString();
}
else
{
bCheck = false;
}
}
if (!bCheck)
{
Jscript.ShowMsg("请输入正确的数据", this);
return;
}
//重新赋值
data.EnterpriseID = EnterpriceID;
data.TeamScaleXml = doc.InnerXml;
data.Child_RoleID = string.Join(",", aryRole.ToArray());
data.Child_RoleAmount = string.Join(",", aryAmount.ToArray());
int i = blltm.UpdateTeamScale(data);
//添加操作日志
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "设置团队规模", IP = MLMGC.COMP.Requests.GetRealIP()
});
switch (i)
{
case 1:
Response.Redirect("TeamSetUp2.aspx");
break;
case -1:
Jscript.ShowMsg("请先清空需要删除的团队中的数据。", this);
break;
default:
Jscript.ShowMsg("修改失败", this);
break;
}
}
/// <summary>
/// 上传文件
/// </summary>
/// <param name="filename">默认为空</param>
/// <returns>当返回值为空，表示上传错误</returns>
public List <PFileInfo> Upload(string filename = null)
{
List <PFileInfo> list = new List <PFileInfo>();
#region 新增上传文件保存
if (Request.Files.Count > 1)
{
StringBuilder sbFileName = new StringBuilder();
try
{
for (int i = 0; i < Request.Files.Count - 1; i++)
{
//if (Request.Files[i].ContentLength > 0)
//{
//文件类型
string fileType = Request.Files[i].FileName.Substring(Request.Files[i].FileName.LastIndexOf('.'));
#region 判断文件类型是否可上传
if (_fileExt.IndexOf("|" + fileType.ToLower() + "") == -1)
{
//TipContent.InnerText = "上传文件类型错误!";
//不是指定文件类型则跳过
_uploadFinish = false;
Jscript.ShowMsg("信息提示:上传文件类型错误", this);
return(null);
}
#endregion
#region 判断文件大小是否超过
string MoveExt = "|.wav|.wma|.mp2|.mp3|.asf|.rm|.rmvb|.mpg|.3gp|.mp4|.flv|.wmv|";
if (MoveExt.IndexOf("|" + fileType.ToLower() + "") == -1)
{
if (Request.Files[i].ContentLength > _sizeLimit)
{
//TipContent.InnerText = "上传文件太大!";
//跳出循环
_uploadFinish = false;
Jscript.ShowMsg("信息提示:上传文件过大", this);
return(null);
}
}
#endregion
//文件显示名称
string newFileTitle = Request.Files[i].FileName.Substring(Request.Files[i].FileName.LastIndexOf('\\') + 1);
//文件名
string newFileName = filename + Request.Files[i].FileName.Substring(Request.Files[i].FileName.LastIndexOf('.'));
if (string.IsNullOrEmpty(filename))//判断是否指定文件名
{
newFileName = DateTime.Now.Ticks.ToString() + Request.Files[i].FileName.Substring(Request.Files[i].FileName.LastIndexOf('.'));
}
// DateTime.Now.ToString("HHmmssms" + i) + "_" + Request.Files[i].FileName.Substring(Request.Files[i].FileName.LastIndexOf('\\') + 1);
//文件保存物理路径
//修改_virtualPath2路径 如果存在 "YWBL/"不追加时间:lzz
string newFilePath = "";
//齐鹏飞 注释2011-04-18
//if (_virtualPath2.Substring(0, _virtualPath2.IndexOf('/') + 1).Contains("YWBL/"))
//{
// newFilePath = _folder + _virtualPath.Replace("/", "\\") + "\\" + _virtualPath2.Replace("/", "\\");
//}
//else
//{
// newFilePath = _folder + _virtualPath.Replace("/", "\\") + "\\" + _virtualPath2.Replace("/", "\\") + DateTime.Now.ToString("yyyy") + "\\" + DateTime.Now.ToString("MM") + "\\" + DateTime.Now.ToString("dd") + "\\";
//}
//newFilePath = _folder + _virtualPath.Replace("/", "\\") + "\\" + DateTime.Now.ToString("yyyy") + "\\" + DateTime.Now.ToString("MM") + "\\" + DateTime.Now.ToString("dd") + "\\";
newFilePath = _folder + _virtualPath.Replace("/", "\\");
System.IO.Directory.CreateDirectory(newFilePath);
//文件大小,单位字节
string fileSize = Request.Files[i].ContentLength.ToString();
Request.Files[i].SaveAs(newFilePath + newFileName);
#region 将上传成功的文件信息保存至list中
//修改_virtualPath2路径 如果存在 "YWBL/"不追加时间:lzz 齐鹏飞 注释 2011-04-18
//if (_virtualPath2.Substring(0, _virtualPath2.IndexOf('/') + 1).Contains("YWBL/"))
//{
// list.Add(new PFileInfo(newFileName, fileSize, "/" + _virtualPath2 + newFileName));
//}
//else
//{
// list.Add(new PFileInfo(newFileName, fileSize, "/" + _virtualPath2 + DateTime.Now.ToString("yyyy") + "/" + DateTime.Now.ToString("MM") + "/" + DateTime.Now.ToString("dd") + "/" + newFileName));
//}
//list.Add(new PFileInfo(newFileTitle, fileSize, "/" + DateTime.Now.ToString("yyyy") + "/" + DateTime.Now.ToString("MM") + "/" + DateTime.Now.ToString("dd") + "/" + newFileName, fileType));
list.Add(new PFileInfo(newFileTitle, fileSize, newFileName, fileType, newFilePath));
#endregion
if (Request.Files.Count - 1 == list.Count)
{
_uploadFinish = true;
}
//}
}
}
catch (Exception ex)
{
TipContent.InnerText = "上传文件出错!<br>" + ex.ToString();
_uploadFinish = false;
}
}
else
{
_uploadFinish = true;
}
#endregion
#region 判断是否继续,false删除已上传附件
if (!_uploadFinish)
{
//上传出现错误,则删除list中已上传附件
for (int i = 0; i < list.Count; i++)
{
//删除文件
DeleteFile(_folder.Substring(0, _folder.Length - 1) + "\\" + _virtualPath.Replace("/", "\\") + list[i].FileAddress.Replace("/", "\\"));
}
}
else
{
#region 除反显文件
if (hdDelFileList.Value != "" && hdDelFileList.Value != "[]")
{
List <PFileInfo> listDel = (List <PFileInfo>)JavaScriptConvert.DeserializeObject(hdDelFileList.Value.ToString(), typeof(List <PFileInfo>));
for (int i = 0; i < listDel.Count; i++)
{
//删除文件
DeleteFile(_folder.Substring(0, _folder.Length - 1) + "\\" + _virtualPath.Replace("/", "\\") + listDel[i].FileAddress.Replace("/", "\\"));
}
}
#endregion
#region 将新增文件与未删除的反显文件组合
if (hdOldFileList.Value != "" && hdOldFileList.Value != "[]")
{
List <PFileInfo> listOld = (List <PFileInfo>)JavaScriptConvert.DeserializeObject(hdOldFileList.Value.ToString(), typeof(List <PFileInfo>));
listOld.AddRange(list);
list = listOld;
}
#endregion
}
#endregion
////没有选择上传文件
//if (_uploadFinish && _IsHave)
//{
// if (list == null)
// {
// TipContent.InnerText = "请上传文件!";
// _uploadFinish = false;
// }
// else if (list.Count == 0)
// {
// TipContent.InnerText = "请上传文件!";
// _uploadFinish = false;
// }
//}
return(list);
}
protected void btnNext_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(ddlName.SelectedValue))
{
Jscript.ShowMsg("名录名称必须选择", this);
return;
}
if (!CheckDropDownList())
{
Jscript.ShowMsg("设置重复,请重新设置", this);
return;
}
//保存设置
List <E_CorreField> list = new List <E_CorreField>();
list.Add(new E_CorreField()
{
Name = "ClientName", Source = ddlName.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "Address", Source = ddlAddress.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "ZipCode", Source = ddlZipCode.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "WebiSite", Source = ddlWebiSite.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "Linkman", Source = ddlLinkman.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "Position", Source = ddlPosition.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "Tel", Source = ddlTel.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "Mobile", Source = ddlMobile.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "Fax", Source = ddlFax.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "Email", Source = ddlEmail.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "QQ", Source = ddlQQ.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "MSN", Source = ddlMSN.SelectedValue
});
list.Add(new E_CorreField()
{
Name = "Remark", Source = ddlRemark.SelectedValue
});
bool b = new ImportingData(PersonalID).SaveConfiguration(list);
if (b)
{
Response.Redirect("ImportingStep3.aspx");
}
else
{
Jscript.ShowMsg("保存失败", this);
}
}
