public int UpdateState(VoteEvent ve)
{
try
{
return veDao.UpdateState(ve);
}
catch (Exception ex)
{
throw new Exception("VoteEventMgr-->UpdateState-->" + ex.Message, ex);
}
}
public int Save(VoteEvent ve)
{
try
{
return veDao.Save(ve);
}
catch (Exception ex)
{
throw new Exception("VoteEventMgr-->Save-->" + ex.Message, ex);
}
}
public int Save(VoteEvent ve)
{
StringBuilder sql = new StringBuilder();
ve.Replace4MySQL();
try
{
sql.AppendFormat(@" INSERT INTO vote_event(event_name,event_desc,event_banner,event_start,");
sql.AppendFormat(@" event_end,word_length,vote_everyone_limit,vote_everyday_limit,number_limit, ");
sql.AppendFormat(@" present_event_id,create_user,create_time,update_user,update_time,is_repeat,event_status)");
sql.AppendFormat(@" VALUES ('{0}','{1}','{2}','{3}',", ve.event_name, ve.event_desc, ve.event_banner, ve.event_start.ToString("yyyy-MM-dd HH:mm;ss"));
sql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',", ve.event_end.ToString("yyyy-MM-dd HH:mm;ss"), ve.word_length, ve.vote_everyone_limit, ve.vote_everyday_limit, ve.number_limit);
sql.AppendFormat(@" '{0}','{1}','{2}','{3}','{4}', ", ve.present_event_id, ve.create_user, ve.create_time.ToString("yyyy-MM-dd HH:mm;ss"), ve.update_user, ve.update_time.ToString("yyyy-MM-dd HH:mm;ss"));
sql.AppendFormat(@"'{0}','{1}')", ve.is_repeat,ve.event_status);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("VoteEventDao-->Save-->" + ex.Message + sql.ToString(), ex);
}
}
public int SelectByEventName(VoteEvent m)
{
StringBuilder str = new StringBuilder();
try
{
str.AppendFormat("SELECT event_name,event_id FROM vote_event where event_name ='{0}' and event_id<>'{1}'", m.event_name, m.event_id);
return _access.getDataTable(str.ToString()).Rows.Count;
}
catch (Exception ex)
{
throw new Exception(" VoteEventDao-->SelectByEventName-->" + ex.Message + "sql:" + str.ToString(), ex);
}
}
public int UpdateState(VoteEvent ve)
{
ve.Replace4MySQL();
StringBuilder sql = new StringBuilder();
sql.AppendFormat(@"UPDATE vote_event SET event_status='{0}',update_user='******',", ve.event_status, ve.update_user);
sql.AppendFormat(@"update_time='{0}' ", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sql.AppendFormat(@" where event_id='{0}';", ve.event_id);
try
{
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("VoteEventDao-->UpdateState" + ex.Message + sql.ToString(), ex);
}
}
public int Update(VoteEvent ve)
{
StringBuilder sql = new StringBuilder();
ve.Replace4MySQL();
try
{
sql.AppendFormat(@"UPDATE vote_event set ");
sql.AppendFormat(@" event_name='{0}',event_desc='{1}',event_banner='{2}',", ve.event_name, ve.event_desc, ve.event_banner);
sql.AppendFormat(@" event_start='{0}',event_end='{1}',", ve.event_start.ToString("yyyy-MM-dd HH:mm:ss"), ve.event_end.ToString("yyyy-MM-dd HH:mm:ss"));
sql.AppendFormat(@" word_length='{0}',vote_everyone_limit='{1}',vote_everyday_limit='{2}',", ve.word_length, ve.vote_everyone_limit, ve.vote_everyday_limit);
sql.AppendFormat(@" number_limit='{0}',present_event_id='{1}',", ve.number_limit, ve.present_event_id);
sql.AppendFormat(@" update_user='******',update_time='{1}',is_repeat='{2}' ", ve.update_user, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), ve.is_repeat);
sql.AppendFormat(" WHERE event_id='{0}' ;", ve.event_id);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("VoteEventDao-->Update-->" + ex.Message + sql.ToString(), ex);
}
}
public int SelectByEventName(VoteEvent m)
{
try
{
return veDao.SelectByEventName(m);
}
catch (Exception ex)
{
throw new Exception("VoteEventMgr-->SelectByEventName-->" + ex.Message, ex);
}
}
/// <summary>
/// 更改狀態 啟用或者禁用
/// </summary>
/// <returns></returns>
public JsonResult UpdateEventState()
{
int id = Convert.ToInt32(Request.Params["id"]);
int activeValue = Convert.ToInt32(Request.Params["active"]);
veMgr = new VoteEventMgr(mySqlConnectionString);
VoteEvent vevent = new VoteEvent();
vevent.event_id = id;
vevent.event_status = activeValue;
vevent.update_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
//System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList;
//if (addlist.Length > 0)
//{
// p.ipfrom = addlist[0].ToString();
//}
if (veMgr.UpdateState(vevent) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
}
/// <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;
}
