public int Update(RedirectGroup query)
{
try
{
return _RdGroupdao.Update(query);
}
catch (Exception ex)
{
throw new Exception("RedirectGroupMgr.Update-->" + ex.Message, ex);
}
}
public List<RedirectGroupQuery> QueryAll(RedirectGroup query, out int totalCount)
{
try
{
return _RdGroupdao.QueryAll(query, out totalCount);
}
catch (Exception ex)
{
throw new Exception("RedirectGroupMgr.QueryAll-->" + ex.Message, ex);
}
}
public string Save(RedirectGroup query)
{
StringBuilder sql = new StringBuilder("");
try
{
query.Replace4MySQL();
sql.Append(" INSERT INTO redirect_group(group_id,group_name,group_createdate,group_updatedate,group_ipfrom,group_type) ");
sql.AppendFormat(" VALUES ('{0}','{1}','{2}','{3}','{4}','{5}')", query.group_id, query.group_name, query.group_createdate, query.group_updatedate, query.group_ipfrom,query.group_type);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("RedirectGroupDao-->Save-->" + ex.Message + sql.ToString(), ex);
}
}
public int Update(RedirectGroup query)
{
StringBuilder sql = new StringBuilder("");
try
{
query.Replace4MySQL();
sql.AppendFormat("UPDATE redirect_group set ");
sql.AppendFormat(" group_name='{0}',group_updatedate='{1}',group_ipfrom='{2}',group_type='{3}' ", query.group_name, query.group_updatedate, query.group_ipfrom,query.group_type);
sql.AppendFormat(" WHERE group_id='{0}' ;", query.group_id);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("RedirectGroupDao-->Update-->" + ex.Message + sql.ToString(), ex);
}
}
public List<RedirectGroupQuery> QueryAll(RedirectGroup query, out int totalCount)
{
StringBuilder sql = new StringBuilder();
try
{
query.Replace4MySQL();
StringBuilder sqlConi = new StringBuilder();
sqlConi.Append(" SELECT group_id,group_name,group_createdate, FROM_UNIXTIME(group_createdate) createdate,group_updatedate,FROM_UNIXTIME(group_updatedate) updatedate,group_ipfrom,group_type,t.parameterName ");
sql.Append(" FROM redirect_group left join t_parametersrc t on group_type = t.parameterCode AND t.parameterType='group_type' WHERE 1=1 ");
if (query.group_id != 0)
{
sql.AppendFormat(" AND group_id={0}", query.group_id);
}
if(!string.IsNullOrEmpty(query.group_name))
{
sql.AppendFormat(" AND group_name LIKE '%{0}%' ", query.group_name);
}
if (!string.IsNullOrEmpty(query.group_type))
{
sql.AppendFormat(" AND group_type ='{0}' ", query.group_type);
}
sql.Append(" ORDER BY group_name ");
totalCount = 0;
if (query.IsPage)
{
StringBuilder consql = new StringBuilder("SELECT count(group_id) ");
DataTable dt = _access.getDataTable(consql.ToString() + sql.ToString());
if (dt != null && dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(dt.Rows[0][0].ToString());
}
sql.AppendFormat(" LIMIT {0},{1};", query.Start, query.Limit);
}
return _access.getDataTableForObj<RedirectGroupQuery>(sqlConi.ToString() + sql.ToString());
}
catch (Exception ex)
{
throw new Exception("RedirectGroupDao-->QueryAll-->" + ex.Message + sql.ToString(), ex);
}
}
public int Save(RedirectGroup query)
{
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connectionStr);
StringBuilder sbExSql = new StringBuilder();
SerialDao _serialDao = new SerialDao(connectionStr);
int id = 0;
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
//開啟事物
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
StringBuilder Sql = new StringBuilder();
//修改表serial
Serial serial = new Serial();
serial.Serial_id = 3;
mySqlCmd.CommandText = _serialDao.Update(serial.Serial_id);//獲取鏈接管理在serial裡面的值
sbExSql.Append(mySqlCmd.CommandText);
query.group_id = Convert.ToUInt32(mySqlCmd.ExecuteScalar());
sbExSql.Append(_RdGroupdao.Save(query));
id = _access.execCommand(_RdGroupdao.Save(query));
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("RedirectGroupMgr-->Save-->" + ex.Message + sbExSql.ToString(), ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return id;
}
public HttpResponseBase RedirectGroupList()
{
List<RedirectGroupQuery> rgli = new List<RedirectGroupQuery>();
string json = string.Empty;
try
{
RedirectGroup RGModel = new RedirectGroup();
RGModel.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
RGModel.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量
_rdGroupMgr = new RedirectGroupMgr(mySqlConnectionString);
RGModel.group_name = Request.Params["search_content"];
int totalCount = 0;
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
rgli = _rdGroupMgr.QueryAll(RGModel, out totalCount);
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(rgli, 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:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase SaveGroup()
{
string json = string.Empty;
try
{
RedirectGroup rgModel = new RedirectGroup();
_rdGroupMgr = new RedirectGroupMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
rgModel.group_id = Convert.ToUInt32(Request.Params["group_id"].ToString());
rgModel.group_name = Request.Params["group_name"].ToString();
rgModel.group_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime());
if (!string.IsNullOrEmpty(Request.Params["group_type"].ToString()))
{
rgModel.group_type = Request.Params["group_type"].ToString();
}
rgModel.group_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString();
if (_rdGroupMgr.Update(rgModel) > 0)
{
json = "{success:true}";
}
}
else
{
rgModel.group_name = Request.Params["group_name"].ToString();
if (!string.IsNullOrEmpty(Request.Params["group_type"].ToString()))
{
rgModel.group_type = Request.Params["group_type"].ToString();
}
rgModel.group_createdate = Convert.ToUInt32(CommonFunction.GetPHPTime());
rgModel.group_updatedate = rgModel.group_createdate;
rgModel.group_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString();
if (_rdGroupMgr.Save(rgModel) > 0)
{
json = "{success:true}";
}
}
}
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;
}