/// <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;
}
/// <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 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 string QueryPm()
{
gcMgr = new GroupCallerMgr(connectionString);
paraMgr = new ParameterMgr(connectionString);
fgMgr = new FgroupMgr(connectionString);
muMgr = new ManageUserMgr(connectionString);
groupCaller gc = new groupCaller();
Fgroup fg = new Fgroup();
string json = string.Empty;
try
{
List<Parametersrc> parstore = paraMgr.QueryUsed(new Parametersrc { ParameterType = "vendor_pm" }).ToList();
if (parstore.Count != 0)
{
fg.groupCode = parstore[0].ParameterCode;
// fg.groupName = parstore[0].parameterName;//parameterName是可變的不可依此查詢 edit by shuangshuang0420j 2015.07.28 09:48
Fgroup pmfg = fgMgr.GetSingle(fg);
if (pmfg != null)
{
gc.groupId = pmfg.rowid;
string pm = gcMgr.QueryCallidById(gc);
StringBuilder stb = new StringBuilder("");
stb.Append("{");
stb.Append("success:true,item:[");
//stb.Append("{");
//stb.AppendFormat("\"userId\":\"{0}\",\"userName\":\"{1}\"", 0, "請選擇");
//stb.Append("}");
string nameStr = string.Empty;
string[] pmar = pm.Split(',').ToArray();
foreach (var item in pmar)
{
int total = 0;
ManageUserQuery mu = muMgr.GetManageUserList(new ManageUserQuery { user_email = item, search_status = "-1" }, out total).FirstOrDefault();
if (total == 1 && mu != null)
{
stb.Append("{");
stb.AppendFormat("\"userId\":\"{0}\",\"userName\":\"{1}\"", mu.user_id, mu.user_username);
stb.Append("}");
}
}
stb.Append("]}");
json = stb.ToString().Replace("}{", "},{");
}
//else
//{
// json = "{success:false,error:1}";
//}
}
//else
//{
// json = "{success:false,error:0}";
//}
}
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 = "[]";
}
return json;
}
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 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;
}
/// <summary>
/// 對賬號解鎖重設
/// </summary>
/// <returns>數據庫操作結果</returns>
public JsonResult UnlockAndReset()
{
string jsonStr = string.Empty;
try
{
sasMgr = new SecretAccountSetMgr(mySqlConnectionString);
_muMgr = new ManageUserMgr(mySqlConnectionString);
int id = Convert.ToInt32(Request.Params["id"]);
int activeValue = Convert.ToInt32(Request.Params["active"]);
SecretAccountSet sas = new SecretAccountSet();
sas.id = id;
SecretAccountSet oldsas = sasMgr.Select(sas);//獲得用戶的密保信息
if (oldsas.secret_limit == oldsas.secret_count && oldsas.secret_limit != 0)
{
sas.status = 0;
}
else
{
sas.status = 1;
}
sas.pwd_status = oldsas.pwd_status;
sas.user_login_attempts = 0;
if (sasMgr.Update(sas) > 0)
{
return Json(new { success = "true" });
}
else
{
return Json(new { 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);
return Json(new { success = "false" });
}
}
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 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;
}
