public List<VoteEventQuery> GetVoteEventDownList(VoteEventQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendLine(@"SELECT event_id,CONCAT_WS('-',event_id,event_name) AS event_name FROM vote_event");
sql.AppendFormat(" where 1=1 ");
if (query.event_id != 0)
{
sql.AppendFormat(@" and event_id='{0}' ", query.event_id);
}
//if (!string.IsNullOrEmpty(query.event_name))
//{
// sql.AppendFormat(@" and event_name='{0}' ", query.event_name);
//}
if (query.event_status != 0)
{
sql.AppendFormat(@" and event_status='{0}' ", query.event_status);
}
return _access.getDataTableForObj<VoteEventQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("VoteEventDao.GetVoteEventDownList-->" + ex.Message + sql.ToString(), ex);
}
}
/// <summary>
/// 活動名稱下拉列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List<VoteEventQuery> GetVoteEventDownList(VoteEventQuery query)
{
try
{
return veDao.GetVoteEventDownList(query);
}
catch (Exception ex)
{
throw new Exception("VoteEventMgr-->GetVoteEventDownList-->" + ex.Message, ex);
}
}
/// <summary>
/// 列表頁
/// </summary>
/// <param name="query"></param>
/// <param name="totalcount"></param>
/// <returns></returns>
public List<VoteEventQuery> GetVoteEventList(VoteEventQuery query, out int totalcount)
{
try
{
return veDao.GetVoteEventList(query, out totalcount);
}
catch (Exception ex)
{
throw new Exception("VoteEventMgr-->GetVoteEventList-->" + ex.Message, ex);
}
}
public List<VoteEventQuery> GetVoteEventList(VoteEventQuery query, out int totalcount)
{
StringBuilder sqlfield = new StringBuilder();
StringBuilder sqlcount = new StringBuilder();
StringBuilder sqlwhere = new StringBuilder();
try
{
sqlfield.AppendFormat(@" SELECT event_id,event_name,event_desc,event_banner,event_start, ");
sqlfield.AppendFormat(@" event_end,word_length,vote_everyone_limit,vote_everyday_limit,number_limit, ");
sqlfield.AppendFormat(@" present_event_id,create_user,create_time,update_user,update_time,event_status,is_repeat ");
sqlwhere.AppendFormat(@" from vote_event ");
sqlwhere.AppendFormat(" where 1=1 ");
sqlcount.Append("select count(event_id) as totalCount ");
if (query.event_id != 0)
{
sqlwhere.AppendFormat(@" and (event_id='{0}' or event_name like N'%{0}%' or event_desc like N'%{0}%' ) ", query.event_id);
}
if (!string.IsNullOrEmpty(query.event_name))
{
sqlwhere.AppendFormat(@" and (event_name like N'%{0}%' or event_desc like N'%{0}%')", query.event_name);
}
totalcount = 0;
if (query.IsPage)
{
sqlcount.Append(sqlwhere.ToString());
//DataTable _dt = _access.getDataTable("select event_id " + sqlfrom.ToString() + sqlwhere.ToString());
DataTable _dt = _access.getDataTable(sqlcount.ToString());
totalcount = Convert.ToInt32(_dt.Rows[0]["totalCount"]);
sqlwhere.AppendFormat(@" ORDER BY event_id DESC ");
sqlwhere.AppendFormat(@" limit {0},{1}", query.Start, query.Limit);
}
else {
sqlwhere.AppendFormat(@" ORDER BY event_id DESC ");
}
sqlfield.Append(sqlwhere.ToString());
return _access.getDataTableForObj<VoteEventQuery>(sqlfield.ToString());
}
catch (Exception ex)
{
throw new Exception("VoteEventDao.GetVoteEventList-->" + ex.Message + sqlfield.ToString() + sqlcount.ToString(), ex);
}
}
/// <summary>
/// 添加活動時，活動標題不能重複
/// </summary>
/// <returns></returns>
public HttpResponseBase SelectByEventName()
{
string json = "";
try
{
VoteEventQuery query = new VoteEventQuery();
if (!string.IsNullOrEmpty(Request.Params["event_id"]))
{
query.event_id = Convert.ToInt32(Request.Params["event_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["event_name"]))
{
query.event_name = Request.Params["event_name"];
}
query.event_name = query.event_name.Trim();
veMgr = new VoteEventMgr(mySqlConnectionString);
if (veMgr.SelectByEventName(query) <= 0)
{
json = "{success:true,msg:'0'}";//返回json數據
}
else
{
json = "{success:true,msg:'1'}";//返回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;
}
/// <summary>
/// 新增或者修改
/// </summary>
/// <returns></returns>
public HttpResponseBase SaveEvent()
{
string json = string.Empty;
VoteEvent vevent = new VoteEvent();
veMgr = new VoteEventMgr(mySqlConnectionString);
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_Min_Element");
SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue");
SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME");
SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD");
//擴展名、最小值、最大值
string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value;
string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value;
string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value;
string localBannerPath = imgLocalPath + PaperPath;//圖片存儲地址
FileManagement fileLoad = new FileManagement();
try
{
List<VoteEventQuery> store = new List<VoteEventQuery>();
VoteEventQuery veq = new VoteEventQuery();
if (!string.IsNullOrEmpty(Request.Params["event_id"]))
{
int totalCount = 0;
veq.IsPage = false;
veq.event_id = int.Parse(Request.Params["event_id"]);
store = veMgr.GetVoteEventList(veq, out totalCount);
}
vevent.event_name = Request.Params["event_name"];
vevent.event_desc = Request.Params["event_desc"];
if (!string.IsNullOrEmpty(Request.Params["event_start"]))
{
vevent.event_start = DateTime.Parse(Request.Params["event_start"]);
}
if (!string.IsNullOrEmpty(Request.Params["event_end"]))
{
vevent.event_end = DateTime.Parse(Request.Params["event_end"]);
}
if (!string.IsNullOrEmpty(Request.Params["word_length"]))
{
vevent.word_length = int.Parse(Request.Params["word_length"]);
}
if (!string.IsNullOrEmpty(Request.Params["vote_everyone_limit"]))
{
vevent.vote_everyone_limit = int.Parse(Request.Params["vote_everyone_limit"]);
}
if (!string.IsNullOrEmpty(Request.Params["vote_everyday_limit"]))
{
vevent.vote_everyday_limit = int.Parse(Request.Params["vote_everyday_limit"]);
}
if (!string.IsNullOrEmpty(Request.Params["number_limit"]))
{
vevent.number_limit = int.Parse(Request.Params["number_limit"]);
}
if (!string.IsNullOrEmpty(Request.Params["is_repeat"]))
{
vevent.is_repeat = int.Parse(Request.Params["is_repeat"]);
}
vevent.present_event_id = Request.Params["present_event_id"];
vevent.event_status = 0;
vevent.update_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
vevent.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
#region 上傳圖片
string oldImg = string.Empty;
foreach (var item in store)
{
oldImg = item.event_banner;
}
if (!string.IsNullOrEmpty(Request.Params["event_id"]) && Request.Params["event_banner"] == oldImg)
{
vevent.event_banner = oldImg;
}
else
{
string ServerPath = string.Empty;
try
{
ServerPath = Server.MapPath(imgLocalServerPath + PaperPath);
if (Request.Files["event_banner"] != null && Request.Files["event_banner"].ContentLength > 0)
{
HttpPostedFileBase file = Request.Files["event_banner"];
string fileName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
//獲取圖片名稱
fileName = Path.GetFileName(file.FileName);
//獲得後綴名
fileExtention = Path.GetExtension(file.FileName);
//獲得不帶後綴名的文件名
fileName = Path.GetFileNameWithoutExtension(file.FileName);
string NewFileName = string.Empty;
BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt();
NewFileName = hash.Md5Encrypt(fileName, "32");
//判斷目錄是否存在，不存在則創建
FTP f_cf = new FTP();
f_cf.MakeMultiDirectory(localBannerPath.Substring(0, localBannerPath.Length - PaperPath.Length + 1), PaperPath.Substring(1, PaperPath.Length - 2).Split('/'), ftpuser, ftppwd);
fileName = NewFileName + fileExtention;
NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑
string ErrorMsg = string.Empty;
bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)//上傳成功
{
vevent.event_banner = fileName;
//上傳新圖片成功后，再刪除舊的圖片
CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片
FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldImg))
{
FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd);
ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片
}
}
}
else
{
//上傳之前刪除已有的圖片
CommonFunction.DeletePicFile(ServerPath + oldImg);//刪除本地圖片
FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldImg))
{
FTP ftps = new FTP(localBannerPath + oldImg, ftpuser, ftppwd);
ftps.DeleteFile(localBannerPath + oldImg);//刪除ftp:71.159上的舊圖片
}
vevent.event_banner = "";
}
}
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}";
}
}
#endregion
if (!string.IsNullOrEmpty(Request.Params["event_id"]))
{
vevent.event_id = int.Parse(Request.Params["event_id"]);
//rgModel.group_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString();
if (veMgr.Update(vevent) > 0)
{
json = "{success:true,msg:'修改成功!'}";
}
else
{
json = "{success:true,msg:'修改失敗!'}";
}
}
else
{
vevent.create_time = DateTime.Now;
vevent.update_time = vevent.create_time;
if (veMgr.Save(vevent) > 0)
{
json = "{success:true,msg:'保存成功!'}";
}
else
{
json = "{success:true,msg:'修改失敗!'}";
}
}
}
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 HttpResponseBase GetVoteEventList()
{
List<VoteEventQuery> store = new List<VoteEventQuery>();
string json = string.Empty;
try
{
VoteEventQuery query = new VoteEventQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
int totalCount = 0;
veMgr = new VoteEventMgr(mySqlConnectionString);
_muMgr = new ManageUserMgr(mySqlConnectionString);
ManageUserQuery muq = new ManageUserQuery();
muq.IsPage = false;
List<ManageUserQuery> mustore = _muMgr.GetNameMail(muq, out totalCount);
if (!string.IsNullOrEmpty(Request.Params["search_content"]))
{
int value = 0;
if (int.TryParse(Request.Params["search_content"], out value))
{
query.event_id = value;
}
else
{
query.event_name = Request.Params["search_content"];
}
}
store = veMgr.GetVoteEventList(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
foreach (var item in store)
{
if (item.event_banner != "")
{
item.event_banner = imgServerPath + PaperPath + item.event_banner;
}
int indexc = mustore.FindIndex((ManageUserQuery e) => e.user_id == uint.Parse(item.create_user.ToString()));
if (indexc != -1)
{
item.cuser = mustore[indexc].user_name;
}
else
{
item.cuser = string.Empty;
}
int indexu = mustore.FindIndex((ManageUserQuery e) => e.user_id == uint.Parse(item.update_user.ToString()));
if (indexu != -1)
{
item.uuser = mustore[indexu].user_name;
}
else
{
item.uuser = 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;
}
public HttpResponseBase GetEventId()
{
List<VoteEventQuery> store = new List<VoteEventQuery>();
string json = string.Empty;
try
{
VoteEventQuery query = new VoteEventQuery();
veMgr = new VoteEventMgr(mySqlConnectionString);
//query.event_status = 1;
store = veMgr.GetVoteEventDownList(query);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
json = "{success:true,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;
}
