public int ManageUserUpd(ManageUserQuery q)
{
try
{
return _manageUserDao.ManageUserUpd(q);
}
catch (Exception ex)
{
throw new Exception("ManageUserMgr-->ManageUserUpd-->" + ex.Message, ex);
}
}
public List<ManageUserQuery> GetManageUserList(ManageUserQuery query, out int totalcount)
{
try
{
return _manageUserDao.GetManageUserList(query, out totalcount);
}
catch (Exception ex)
{
throw new Exception("ManageUserMgr-->GetManageUserList-->" + ex.Message, ex);
}
}
public List<ManageUserQuery> GetNameMail(ManageUserQuery query, out int totalcount)
{
StringBuilder sql = new StringBuilder();
StringBuilder sqlCondi = new StringBuilder();
try
{
sql.Append(@" select user_id, user_username as user_name,user_email ");
sqlCondi.Append(" from manage_user ");
sqlCondi.Append(" where 1=1 ");
if (query.user_status != 0)
{
sqlCondi.AppendFormat(" and user_status='{0}' ", query.user_status);
}
if (!string.IsNullOrEmpty(query.user_username))
{
sqlCondi.AppendFormat(" and user_username LIKE '%{0}%' ", query.user_username);
}
sqlCondi.Append(" order by user_id asc ");
totalcount = 0;
if (query.IsPage)
{
DataTable _dt = _access.getDataTable("select count(user_id) as totalCount " + sqlCondi.ToString());
if (_dt.Rows.Count > 0)
{
totalcount = int.Parse(_dt.Rows[0]["totalCount"].ToString());
}
sqlCondi.AppendFormat(" limit {0},{1}", query.Start, query.Limit);
}
sql.Append(sqlCondi.ToString());
return _access.getDataTableForObj<ManageUserQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ManageUserDao.GetNameMail-->" + ex.Message + sql.ToString(), ex);
}
}
public int ManageUserAdd(ManageUserQuery q)
{
StringBuilder sb = new StringBuilder();
StringBuilder sel_id = new StringBuilder();
DataTable dt = new DataTable();
try
{
sb.Append("SELECT * FROM serial where serial_id='1';");
dt = _access.getDataTable(sb.ToString());
if (dt.Rows.Count > 0)
{
q.user_id = uint.Parse(dt.Rows[0]["serial_value"].ToString()) + 1;
sb.Clear();
sb.AppendFormat("insert into manage_user (user_id,user_username,user_email,user_status,user_lastvisit,user_last_login,manage,user_createdate,user_updatedate,erp_id,user_password) VALUE ");
sb.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}') ;", q.user_id, q.user_username, q.user_email, q.user_status, q.user_lastvisit, q.user_last_login, q.manage, q.user_createdate, q.user_updatedate, q.erp_id, q.user_password);
sb.AppendFormat("update serial set serial_value='{0}' where serial_id='1'; ", q.user_id);
return _access.execCommand(sb.ToString());
}
else
{
return 0;
}
}
catch (Exception ex)
{
throw new Exception("ManageUserDao-->ManageUserAdd" + ex.Message + sb.ToString(), ex);
}
}
public HttpResponseBase GetManageUserList()
{
List<ManageUserQuery> store = new List<ManageUserQuery>();
string json = string.Empty;
int totalCount = 0;
try
{
_manageuserMgr = new ManageUserMgr(mySqlConnectionString);
ManageUserQuery query = new ManageUserQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
if (!string.IsNullOrEmpty(Request.Params["limit"]))
{
query.Limit = Convert.ToInt32(Request.Params["limit"]);
}
if (!string.IsNullOrEmpty(Request.Params["search_status"]))
{
query.search_status = Request.Params["search_status"];
}
if (!string.IsNullOrEmpty(Request.Params["s_mail"]))
{
query.user_email = Request.Params["s_mail"];
}
if (!string.IsNullOrEmpty(Request.Params["s_name"]))
{
query.user_username = Request.Params["s_name"];
}
if (!string.IsNullOrEmpty(Request.Params["login_sum"]))
{
query.login_sum = Request.Params["login_sum"];
}
if (!string.IsNullOrEmpty(Request.Params["relation_id"]))//待回覆
{
query.userid = Request.Params["relation_id"];
}
store = _manageuserMgr.GetManageUserList(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
foreach (var item in store)
{
if (Convert.ToBoolean(Request.Params["isSecret"]))
{
item.user_email = item.user_email.Split('@')[0] + "@***";
}
item.lastlogin = CommonFunction.GetNetTime(item.user_last_login);
item.creattime = CommonFunction.GetNetTime(item.user_createdate);
item.updtime = CommonFunction.GetNetTime(item.user_updatedate);
}
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase UpdateStatus()
{
string json = string.Empty;
try
{
_manageuserMgr = new ManageUserMgr(mySqlConnectionString);
ManageUserQuery query = new ManageUserQuery();
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
query.user_id = uint.Parse(Request.Params["id"]);
}
query.user_status = 1;
query.user_updatedate = uint.Parse(CommonFunction.GetPHPTime(DateTime.Now.ToString()).ToString());
if (_manageuserMgr.UpdStatus(query) > 0)
{
json = "{success:true}";
}
else
{
json = "{success:false}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,msg:'操作失敗!'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public int UpdStatus(ManageUserQuery query)
{
try
{
return _manageUserDao.UpdStatus(query);
}
catch (Exception ex)
{
throw new Exception("ManageUserMgr-->UpdStatus-->" + ex.Message, ex);
}
}
/// <summary>
/// 用戶管理列表頁
/// </summary>
/// <returns></returns>
public HttpResponseBase MailUserList()
{
string jsonStr = string.Empty;
try
{
List<MailUserQuery> MailUserStore = new List<MailUserQuery>();
MailUserQuery query = new MailUserQuery();
if (!string.IsNullOrEmpty(Request.Params["user_name"]))
{
query.user_name = Request.Params["user_name"];
}
if (!string.IsNullOrEmpty(Request.Params["user_mail"]))
{
query.user_mail = Request.Params["user_mail"];
}
if (!string.IsNullOrEmpty(Request.Params["relation_id"]))//待回覆
{
query.row_id = Convert.ToInt32(Request.Params["relation_id"]);
}
List<ManageUserQuery> ManageUseStore = new List<ManageUserQuery>();
ManageUserQuery ManageUserQuery = new ManageUserQuery();
ManageUserQuery.IsPage = false;
#region 查詢管理人員綁定到表中
DataTable _dtManageUser = new DataTable();
_dtManageUser.Columns.Add("user_id", typeof(String));
_dtManageUser.Columns.Add("user_name", typeof(String));
int total = 0;
_IManageUserMgr = new ManageUserMgr(mySqlConnectionString);
ManageUseStore = _IManageUserMgr.GetNameMail(ManageUserQuery, out total);
foreach (var item in ManageUseStore)
{
DataRow dr = _dtManageUser.NewRow();
dr[0] = item.user_id;
dr[1] = item.user_name;
_dtManageUser.Rows.Add(dr);
}
#endregion
if (!string.IsNullOrEmpty(Request.Params["pagers"]))
{
if (Convert.ToInt32(Request.Params["pagers"]) == 0)
{
query.IsPage = false;
}
}
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
_IMailUserMgr = new MailUserMgr(mySqlConnectionString);
int totalCount = 0;
MailUserStore = _IMailUserMgr.GetMailUserStore(query, out totalCount);//查询出供應商出貨單
foreach (var item in MailUserStore)
{
item.nameemail = item.user_name + "(" + item.user_mail + ")";
DataRow[] rows = _dtManageUser.Select("user_id='" + item.create_user + "'");
foreach (DataRow row in rows)//篩選出的最多只有一條數據，
{
item.create_user_name = item.create_user.ToString();
if (!string.IsNullOrEmpty(row["user_id"].ToString()))
{
item.create_user_name = row["user_name"].ToString();//---創建人
}
}
rows = _dtManageUser.Select("user_id='" + item.update_user + "'");
foreach (DataRow row in rows)//篩選出的最多只有一條數據，
{
item.update_user_name = item.update_user.ToString();
if (!string.IsNullOrEmpty(row["user_id"].ToString()))
{
item.update_user_name = row["user_name"].ToString();//---修改人
}
}
if (Convert.ToBoolean(Request.Params["isSecret"]))
{
if (!string.IsNullOrEmpty(item.user_name))
{
item.user_name = item.user_name.Substring(0, 1) + "**";
}
item.user_mail = item.user_mail.Split('@')[0] + "@***";
if (item.nameemail.ToString().Length > 3)
{
item.nameemail = item.nameemail.Substring(0, 3) + "***";
}
else
{
item.nameemail = item.nameemail + "***";
}
}
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(MailUserStore, Formatting.Indented, timeConverter) + "}";//返回json數據
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false,msg:0}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
public List<ManageUserQuery> GetManageUserList(ManageUserQuery query, out int totalcount)
{
StringBuilder sql = new StringBuilder();
StringBuilder sqlCondi = new StringBuilder();
StringBuilder sqlFrom = new StringBuilder();
try
{
sql.Append(@" SELECT user_id,user_username,user_email,user_status,user_login_attempts,user_last_login,manage,user_createdate,user_updatedate,erp_id ");
sqlFrom.Append(" FROM manage_user ");
if (!string.IsNullOrEmpty(query.userid))
{
sqlCondi.AppendFormat(" and user_id = '{0}' ", query.userid);
}
if (!string.IsNullOrEmpty(query.user_username))
{
sqlCondi.AppendFormat(" and user_username like N'%{0}%' ", query.user_username);
}
if (!string.IsNullOrEmpty(query.user_email))
{
sqlCondi.AppendFormat(" and user_email like N'%{0}%' ", query.user_email);
}
if (query.search_status != "-1")
{
sqlCondi.AppendFormat(" and user_status = '{0}' ", query.search_status);
}
if (!string.IsNullOrEmpty(query.login_sum))
{
sqlCondi.AppendFormat(" and user_login_attempts >= '{0}' ", query.login_sum);
}
if (sqlCondi.Length > 0)
{
sqlFrom.Append(" where " + sqlCondi.ToString().TrimStart().Remove(0, 3));
}
totalcount = 0;
if (query.IsPage)
{
DataTable _dt = _access.getDataTable("select count(user_id) as totalCount " + sqlFrom.ToString());
if (_dt.Rows.Count > 0)
{
totalcount = int.Parse(_dt.Rows[0]["totalCount"].ToString());
}
sqlFrom.Append(" order by user_id desc ");
sqlFrom.AppendFormat(" limit {0},{1};", query.Start, query.Limit);
}
sql.Append(sqlFrom.ToString());
return _access.getDataTableForObj<ManageUserQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ManageUserDao.GetNameMail-->" + ex.Message + sql.ToString(), ex);
}
}
public int CheckEmail(ManageUserQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
if (!string.IsNullOrEmpty(query.user_email))
{
sb.AppendFormat("SELECT user_username FROM manage_user WHERE user_email='{0}'; ", query.user_email);
return _access.getDataTable(sb.ToString()).Rows.Count;
}
else
{
return 0;
}
}
catch (Exception ex)
{
throw new Exception("ProductDao-->CheckEmail" + ex.Message + sb.ToString(), ex);
}
}
public DataTable GetUser(ManageUserQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.Append("SELECT user_id,user_username as config_name,user_email FROM manage_user where 1=1 ");
if (query.user_id != 0)
{
sql.AppendFormat(" and user_id='{0}' ", query.user_id);
}
return _accessMySql.getDataTable(sql.ToString());
}
catch (Exception ex)
{
throw new Exception(" ConfigDao-->GetUser-->" + ex.Message + sql.ToString(), ex);
}
}
public HttpResponseBase GetManagerUser()
{
string json = string.Empty;
ManageUser mu = new ManageUser();
ManageUserQuery muq = new ManageUserQuery();
int totalCount = 0;
List<ManageUser> store = new List<ManageUser>();
List<ManageUserQuery> storeq = new List<ManageUserQuery>();
try
{
_muMgr = new ManageUserMgr(mySqlConnectionString);
//判斷輸入密碼是否和登入密碼一樣
if (!string.IsNullOrEmpty(Request.Params["user_id"]))
{
mu.user_id = uint.Parse(Request.Params["user_id"]);
store = _muMgr.GetManageUser(mu);
if (store.Count > 0)
{
if (!string.IsNullOrEmpty(Request.Params["secret_password"]))
{
HashEncrypt hmd5 = new HashEncrypt();
if (hmd5.SHA256Encrypt(Request.Params["secret_password"]) == store[0].user_password)
{
json = "{success:false}";
}
else
{
json = "{success:true}";
}
}
}
else
{
json = "{success:false}";
}
}
//獲取管理用戶下拉列表
else
{
muq.IsPage = false;
muq.user_username = Request.Params["user_name"];
muq.user_status = 1;
storeq = _muMgr.GetNameMail(muq, out totalCount);
json = "{success:true,data:" + JsonConvert.SerializeObject(storeq, Formatting.Indented) + "}";//返回json數據
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public int UpdPassword(ManageUserQuery q)
{
try
{
return _manageUserDao.UpdPassword(q);
}
catch (Exception ex)
{
throw new Exception("ManageUserMgr-->UpdPassword-->" + ex.Message, ex);
}
}
public int CheckEmail(ManageUserQuery query)
{
try
{
return _manageUserDao.CheckEmail(query);
}
catch (Exception ex)
{
throw new Exception("ManageUserMgr-->CheckEmail-->" + ex.Message, ex);
}
}
public int ManageUserUpd(ManageUserQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("update manage_user set user_username='******' ", query.user_username);
if (!string.IsNullOrEmpty(query.user_email))
{
sb.AppendFormat(",user_email='{0}' ", query.user_email);
}
sb.AppendFormat(",erp_id='{0}',user_status='{1}',manage='{2}',user_updatedate='{3}' ", query.erp_id, query.user_status, query.manage, query.user_updatedate);
if (!string.IsNullOrEmpty(query.user_delete_email))
{
sb.AppendFormat(",user_delete_email='{0}' ", query.user_delete_email);
}
sb.AppendFormat(" where user_id ='{0}' ;", query.user_id);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("ManageUserDao-->ManageUserUpd" + ex.Message + sb.ToString(), ex);
}
}
public DataTable GetDesign(ManageUserQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.Append(@"SELECT m.user_username,m.user_id from t_fgroup tf
LEFT JOIN t_groupcaller tg ON tf.rowid=tg.groupId
LEFT JOIN manage_user m ON tg.callid=m.user_email
LEFT JOIN t_parametersrc t ON t.parameterCode=tf.rowid
WHERE t.parameterType='design';");
return _accessMySql.getDataTable(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("DesignRequestDao.GetDesign-->" + ex.Message + sb.ToString(), ex);
}
}
public HttpResponseBase GetDesign()
{
string json = string.Empty;
ManageUserQuery q = new ManageUserQuery();
DataTable store = new DataTable();
_DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString);
try
{
store = _DesignRequestMgr.GetDesign(q);
json = "{success:true,data:" + JsonConvert.SerializeObject(store) + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public int UpdStatus(ManageUserQuery query)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat("update manage_user set user_status='{0}',user_login_attempts=0,user_updatedate='{1}' ", query.user_status, query.user_updatedate);
sb.AppendFormat(" where user_id ='{0}' ;", query.user_id);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("ManageUserDao-->UpdStatus" + ex.Message + sb.ToString(), ex);
}
}
public System.Data.DataTable GetUser(ManageUserQuery query)
{
try
{
return _configDao.GetUser(query);
}
catch (Exception ex)
{
throw new Exception("ConfigMgr-->GetUser-->" + ex.Message, ex);
}
}
/// <summary>
/// 用戶管理中，添加用戶時的下拉框綁定數據
/// </summary>
/// <returns></returns>
public HttpResponseBase ManageUser()
{
string jsonStr = string.Empty;
try
{
List<ManageUserQuery> store = new List<ManageUserQuery>();
ManageUserQuery query = new ManageUserQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
query.IsPage = false;
query.user_status = 1;
_IManageUserMgr = new ManageUserMgr(mySqlConnectionString);
int totalCount = 0;
store = _IManageUserMgr.GetNameMail(query, out totalCount);//查询出供應商出貨單
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd";
jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false,msg:0}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
public HttpResponseBase SaveManageUser()
{
string json = string.Empty;
DataTable dt = new DataTable();
bool isupdate = false;
string password;
try
{
#region 發送email設置
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig Mail_From = _siteConfigMgr.GetConfigByName("Mail_From");
SiteConfig Mail_Host = _siteConfigMgr.GetConfigByName("Mail_Host");
SiteConfig Mail_Port = _siteConfigMgr.GetConfigByName("Mail_Port");
SiteConfig Mail_UserName = _siteConfigMgr.GetConfigByName("Mail_UserName");
SiteConfig Mail_UserPasswd = _siteConfigMgr.GetConfigByName("Mail_UserPasswd");
string EmailFrom = Mail_From.Value;//發件人郵箱
string SmtpHost = Mail_Host.Value;//smtp服务器
string SmtpPort = Mail_Port.Value;//smtp服务器端口
string EmailUserName = Mail_UserName.Value;//郵箱登陸名
string EmailPassWord = Mail_UserPasswd.Value;//郵箱登陸密碼
#endregion
_manageuserMgr = new ManageUserMgr(mySqlConnectionString);
ManageUserQuery store = new ManageUserQuery();
ManageUserQuery query = new ManageUserQuery();
if (!string.IsNullOrEmpty(Request.Params["user_id"]))
{//如果是編輯獲取該id數據
int totalCount = 0;
query.IsPage = false;
query.user_id = uint.Parse(Request.Params["user_id"]);
query.userid = Request.Params["user_id"];
query.search_status = "-1";
store = _manageuserMgr.GetManageUserList(query, out totalCount).FirstOrDefault();
isupdate = true;
}
if (!string.IsNullOrEmpty(Request.Params["user_username"]))
{
query.user_username = Request.Params["user_username"];
}
if (!string.IsNullOrEmpty(Request.Params["user_email"]))
{
query.user_email = Request.Params["user_email"];
if (store != null)
{
if (store.user_email == query.user_email)
{//如果編輯沒有變email就空值
query.user_email = string.Empty;
}
}
}
if (!string.IsNullOrEmpty(Request.Params["erp_id"]))
{
query.erp_id = Request.Params["erp_id"];
}
if (!string.IsNullOrEmpty(Request.Params["user_status"]))
{
query.user_status = uint.Parse(Request.Params["user_status"]);
}
else
{
query.user_status = 0;
}
if (!string.IsNullOrEmpty(Request.Params["manage"]))
{
query.manage = uint.Parse(Request.Params["manage"]);
}
else
{
query.manage = 0;
}
Random rd = new Random();
password = CommonFunction.Getserials(8, rd);
query.user_password = hmd5.SHA256Encrypt(password);
query.user_lastvisit = uint.Parse(CommonFunction.GetPHPTime(DateTime.Now.ToString()).ToString());
query.user_last_login = query.user_lastvisit;
query.user_createdate = query.user_lastvisit;
query.user_updatedate = query.user_lastvisit;
if (_manageuserMgr.CheckEmail(query) > 0 && !string.IsNullOrEmpty(query.user_email))
{//判斷新增編輯過得email數據庫是否有重複
json = "{success:true,msg:2}";
}
else
{
if (isupdate)
{
#region 編輯
if (query.user_status == 3)
{
query.user_delete_email = query.user_email;
Random re = new Random();
query.user_email = DateTime.Now.ToString("yyyyMMddhhmmss") + hmd5.SHA256Encrypt(CommonFunction.Getdeleteemail(32, re));
if (_manageuserMgr.ManageUserUpd(query) > 0)
{
json = "{success:true,msg:1}";
}
else
{
json = "{success:false,msg:4}";
}
}
else
{
if (_manageuserMgr.ManageUserUpd(query) > 0)
{
json = "{success:true,msg:1}";
}
else
{
json = "{success:false,msg:4}";
}
}
#endregion
}
else
{
#region 新增
if (_manageuserMgr.ManageUserAdd(query) > 0)
{
FileStream fs = new FileStream(Server.MapPath("../ImportUserIOExcel/901.html"), FileMode.OpenOrCreate, FileAccess.Read);
StreamReader sr = new StreamReader(fs, Encoding.UTF8);
string strTemp = sr.ReadToEnd();
sr.Close();
fs.Close();
_paraMgr = new ParameterMgr(mySqlConnectionString);
string linkurl = string.Empty;
Parametersrc paModel = _paraMgr.QueryUsed(new Parametersrc { ParameterType = "admin_link_url" }).FirstOrDefault();
if (paModel != null)
{
linkurl = paModel.ParameterCode;
}
strTemp = strTemp.Replace("{{$s_user_username$}}", query.user_username);
strTemp = strTemp.Replace("{{$u_admin_url$}}", linkurl);
strTemp = strTemp.Replace("{{$s_email$}}", query.user_email);
strTemp = strTemp.Replace("{{$s_password$}}", password);
if (CommonFunction.sendmail(EmailFrom, FromName, query.user_email, query.user_name, EmailTile, strTemp, "", SmtpHost, Convert.ToInt32(SmtpPort), EmailUserName, EmailPassWord))
{
json = "{success:true,msg:1}";
}
else
{
json = "{success:true,msg:3}";
}
}
else
{
json = "{success:false,msg:4}";
}
#endregion
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,msg:'操作失敗!'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public DataTable GetDesign(ManageUserQuery query)
{
try
{
return _DesignRequestDao.GetDesign(query);
}
catch (Exception ex)
{
throw new Exception("DesignRequestMgr.GetDesign-->" + ex.Message, ex);
}
}
public HttpResponseBase GetVoteArticleList()
{
List<VoteArticleQuery> store = new List<VoteArticleQuery>();
string json = string.Empty;
int totalCount = 0;
try
{
_muMgr = new ManageUserMgr(mySqlConnectionString);
ManageUserQuery muq = new ManageUserQuery();
muq.IsPage = false;
List<ManageUserQuery> mustore = _muMgr.GetNameMail(muq, out totalCount);
VoteArticleQuery query = new VoteArticleQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
if (!string.IsNullOrEmpty(Request.Params["limit"]))
{
query.Limit = Convert.ToInt32(Request.Params["limit"]);
}
if (!string.IsNullOrEmpty(Request.Params["ddlSel"]))
{
query.event_id = Convert.ToInt32(Request.Params["ddlSel"]);
}
if (!string.IsNullOrEmpty(Request.Params["selcontent"]))
{
query.article_title = Request.Params["selcontent"];
}
if (!string.IsNullOrEmpty(Request.Params["date"]))
{
query.date = Convert.ToInt32(Request.Params["date"]);
}
if (!string.IsNullOrEmpty(Request.Params["time_start"]))
{
query.time_start = Convert.ToDateTime(Request.Params["time_start"]).ToString("yyyy-MM-dd HH:mm:ss");
}
if (!string.IsNullOrEmpty(Request.Params["time_end"]))
{
query.time_end = Convert.ToDateTime(Request.Params["time_end"]).ToString("yyyy-MM-dd HH:mm:ss");
}
_votearticle = new VoteArticleMgr(mySqlConnectionString);
store = _votearticle.GetAll(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
foreach (var item in store)
{
item.kendo_editor = Server.HtmlDecode(Server.HtmlDecode(item.article_content));
if (item.article_banner != "")
{
item.article_banner = imgServerPath + PaperPath + item.article_banner;
}
int indexc = mustore.FindIndex((ManageUserQuery e) => e.user_id == uint.Parse(item.create_user.ToString()));
if (indexc != -1)
{
item.creat_name = mustore[indexc].user_name;
}
else
{
item.creat_name = string.Empty;
}
int indexu = mustore.FindIndex((ManageUserQuery e) => e.user_id == uint.Parse(item.update_user.ToString()));
if (indexu != -1)
{
item.upd_name = mustore[indexu].user_name;
}
else
{
item.upd_name = string.Empty;
}
}
//listUser是准备转换的对象
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
