public string UpdateStatus(EdmGroupNewQuery query) // add by yachao1120j 2015-9-21
{
string josn;
string sql = "";
try
{
if (query.enabled == 0)
{
query.enabled = 1;
}
else
{
query.enabled = 0;
}
sql = _edmgroupdao.UpdateStatus(query);
if (_dbAccess.execCommand(sql) > 0)
{
josn = "{success:true}";
}
else
{
josn = "{success:false}";
}
return josn;
}
catch (Exception ex)
{
throw new Exception("EdmGroupNewMgr-->UpdateStatus-->" + ex.Message + sql, ex);
}
}
} // add by yachao1120j 2015-9-21
public string UpdateStatus(EdmGroupNewQuery query) // add by yachao1120j 2015-9-21
{
StringBuilder strSql = new StringBuilder();
try
{
strSql.AppendFormat(@"Update edm_group_new set enabled='{0}' WHERE group_id={1}", query.enabled, query.group_id);
return strSql.ToString();
}
catch (Exception ex)
{
throw new Exception("EdmGroupNewDao-->UpdateStatus-->" + ex.Message + strSql.ToString(), ex);
}
}
//插入信息
public int EdmGroupNewInsert(EdmGroupNewQuery query)
{
StringBuilder sql = new StringBuilder();
query.Replace4MySQL();
try
{
sql.Append("insert into edm_group_new (group_name, is_member_edm,trial_url, sort_order,description,group_createdate,group_create_userid,group_update_userid)values ");
sql.AppendFormat("('{0}','{1}','{2}','{3}','{4}',NOW(),'{5}','{6}')", query.group_name, query.is_member_edm,query.trial_url, query.sort_order, query.description,query.group_create_userid,query.group_update_userid);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("EdmGroupNewDao-->EdmGroupNewInsert-->" + sql.ToString() + ex.Message);
}
}
//判断是新增 还是 编辑
public int SaveEdmGroupNewAdd(EdmGroupNewQuery query)
{
try
{
if (query.group_id == 0)//新增
{
return _edmgroupdao.EdmGroupNewInsert(query);
}
else//編輯
{
return _edmgroupdao.EdmGroupNewUpdate(query);
}
}
catch (Exception ex)
{
throw new Exception("EdmGroupNewMgr-->SaveEdmGroupNewAdd-->" + ex.Message);
}
}
public List<EdmGroupNewQuery> GetEdmGroupNewList(EdmGroupNewQuery query, out int totalCount)
{
StringBuilder str = new StringBuilder();
StringBuilder strcont = new StringBuilder();
totalCount = 0;
try
{
str.AppendFormat(" select group_id,group_name,is_member_edm,trial_url,enabled,sort_order,description from edm_group_new egn ");
strcont.AppendFormat(" where 1=1 ");
strcont.AppendFormat(" and egn.group_name like '%{0}%'", query.group_name);
strcont.Append(" order by enabled desc, is_member_edm desc, sort_order ");
str.Append(strcont);
if (query.IsPage)
{
StringBuilder strpage = new StringBuilder();//
StringBuilder strcontpage = new StringBuilder();
strpage.AppendFormat("SELECT count(biao.group_id) as totalCount FROM(select egn.group_id from edm_group_new egn ");
strpage.Append(strcont);
strpage.AppendFormat(")as biao ");
DataTable _dt = _access.getDataTable(strpage.Append(strcontpage).ToString());
if (_dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]);
str.AppendFormat(" limit {0},{1}", query.Start, query.Limit);
}
}
return _access.getDataTableForObj<EdmGroupNewQuery>(str.ToString());// 獲取查詢記錄
}
catch (Exception ex)
{
throw new Exception("EdmGroupNewDao-->GetEdmGroupNewList-->" + ex.Message);
}
} // add by yachao1120j 2015-9-21
public List<EdmGroupNewQuery> GetEdmGroupNewList(EdmGroupNewQuery query, out int totalCount) // add by yachao1120j 2015-9-21
{
try
{
List<EdmGroupNewQuery> store = new List<EdmGroupNewQuery>();
store = _edmgroupdao.GetEdmGroupNewList(query, out totalCount);
foreach(var item in store)
{
if (item.is_member_edm == 0)
{
item.is_member_edm_string = "";
}
if (item.is_member_edm == 1)
{
item.is_member_edm_string = "會員電子報";
}
}
return store;
}
catch (Exception ex)
{
throw new Exception("EdmGroupNewMgr->GetEdmGroupNewList" + ex.Message);
}
}
public HttpResponseBase SaveEdmGroupNewAdd() //add by yachao1120j 2015-9-22
{
string json = string.Empty;
try
{
EdmGroupNewQuery query = new EdmGroupNewQuery();
edmgroupmgr = new EdmGroupNewMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
query.group_id = Convert.ToInt32(Request.Params["group_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["group_name"]))
{
query.group_name = Request.Params["group_name"];
}
if (!string.IsNullOrEmpty(Request.Params["is_member_edm"]))
{
query.is_member_edm = Convert.ToInt32(Request.Params["is_member_edm"]);
}
if (!string.IsNullOrEmpty(Request.Params["trial_url"]))
{
query.trial_url = Request.Params["trial_url"];
}
if (!string.IsNullOrEmpty(Request.Params["sort_order"]))
{
query.sort_order = Convert.ToInt32(Request.Params["sort_order"]);
}
if (!string.IsNullOrEmpty(Request.Params["description"]))
{
query.description = Request.Params["description"];
}
query.group_create_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
query.group_update_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
int _dt = edmgroupmgr.SaveEdmGroupNewAdd(query);
if (_dt > 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,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return Response;
}
public HttpResponseBase UpdateStats()
{
string json = string.Empty;
try
{
edmgroupmgr = new EdmGroupNewMgr(mySqlConnectionString);
EdmGroupNewQuery query = new EdmGroupNewQuery();
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
query.group_id = Convert.ToInt32(Request.Params["id"]);
}
if (!string.IsNullOrEmpty(Request.Params["active"]))
{
query.enabled = Convert.ToInt32(Request.Params["active"]);
}
json = edmgroupmgr.UpdateStatus(query);
}
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 GetEdmGroupNewList()// add by yachao1120j 2015-9-21
{
string json = string.Empty;
int totalcount = 0;
try
{
EdmGroupNewQuery query = new EdmGroupNewQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
edmgroupmgr = new EdmGroupNewMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["group_name_list"]))
{
query.group_name = Request.Params["group_name_list"];
}
List<EdmGroupNewQuery> list = edmgroupmgr.GetEdmGroupNewList(query, out totalcount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
// timeConverter.DateTimeFormat = "yyyy-MM-dd";
json = "{success:true,totalCount:" + totalcount + ",data:" + JsonConvert.SerializeObject(list, Formatting.Indented, timeConverter) + "}";
}
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 Response;
}
//更新信息
public int EdmGroupNewUpdate(EdmGroupNewQuery query)
{
StringBuilder sql = new StringBuilder();
query.Replace4MySQL();
try
{
sql.AppendFormat("update edm_group_new set group_name = '{0}', is_member_edm = '{1}', trial_url='{2}',sort_order = '{3}',description='{4}',group_update_userid='{5}' where group_id='{6}' ", query.group_name, query.is_member_edm, query.trial_url, query.sort_order, query.description,query.group_update_userid, query.group_id);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("EdmGroupNewDao-->EdmGroupNewUpdate-->" + sql.ToString() + ex.Message);
}
}
