/// <summary>
/// 判斷product_mange的合法性
/// </summary>
/// <param name="paramername"></param>
/// <param name="parameternumber"></param>
/// <returns></returns>
public List<ConfigQuery> Query(string paramername, int parameternumber)
{
// List<ConfigQuery> lcq = new List<ConfigQuery>();
//strSql = string.Format("select * FROM config where config_name LIKE '%" + paramername + "%';");
//DataTable dt = _accessMySql.getDataTable(strSql);
//if (dt != null)
//{
// for (int i = 1; i < parameternumber; i++)
// {
// ConfigQuery query = new ConfigQuery();
// query.chaek = dt.Rows[3 * i]["config_value"].ToString();
// if (dt.Rows[3 * i + 1]["config_value"].ToString() != "")
// {
// query.name = dt.Rows[3 * i + 1]["config_value"].ToString();
// }
// else
// {
// if (dt.Rows[3 * i + 2]["config_value"].ToString() != "")
// {
// query.name = dt.Rows[3 * i + 2]["config_value"].ToString();
// query.name = query.name.Substring(0, query.name.LastIndexOf("@"));
// }
// }
// query.email = dt.Rows[3 * i + 2]["config_value"].ToString();
// lcq.Add(query);
// }
//}
List<ConfigQuery> lcq = new List<ConfigQuery>();
string strSql = string.Format("select * from config where config_name LIKE '" + paramername + "%' order by id ;");
DataTable dt = _accessMySql.getDataTable(strSql);
if (dt != null)
{
ArrayList configNameList = new ArrayList();
for (int i = 1; i <= parameternumber; i++)
{
ConfigQuery query = new ConfigQuery();
string tempKeyCheck = paramername + "_chaek_" + i.ToString();
string tempKeyName = paramername + "_name_" + i.ToString();
string tempKeyEmail = paramername + "_email_" + i.ToString();
if (dt.Rows[3 * i - 3]["config_name"].ToString() == tempKeyCheck)
{
//check==1並且email不為空
if (dt.Rows[3 * i - 3]["config_value"].ToString() == "1" && !string.IsNullOrEmpty(dt.Rows[3 * i - 1]["config_value"].ToString()))
{
query.name = dt.Rows[3 * i - 2]["config_value"].ToString();
query.email = dt.Rows[3 * i - 1]["config_value"].ToString();
lcq.Add(query);
}
}
}
}
return lcq;
}
public System.Data.DataTable GetConfig(ConfigQuery query)
{
try
{
return _configDao.GetConfig(query);
}
catch (Exception ex)
{
throw new Exception("ConfigMgr-->GetConfig-->" + ex.Message, ex);
}
}
public List<ConfigQuery> CheckUserName(ConfigQuery query)
{
try
{
return _configDao.CheckUserName(query);
}
catch (Exception ex)
{
throw new Exception("ConfigMgr-->CheckUserName-->" + ex.Message, ex);
}
}
public System.Data.DataTable ConfigCheck(ConfigQuery query)
{
try
{
return _configDao.ConfigCheck(query);
}
catch (Exception ex)
{
throw new Exception("ConfigMgr-->ConfigCheckName-->" + ex.Message, ex);
}
}
public int UpdateConfig(ConfigQuery query)
{
try
{
return _configDao.UpdateConfig(query);
}
catch (Exception ex)
{
throw new Exception("ConfigMgr-->UpdateConfig-->" + ex.Message, ex);
}
}
public List<ConfigQuery> CheckUserName(ConfigQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("SELECT config_value FROM config where config_name = '{0}' ",query.config_name);
return _accessMySql.getDataTableForObj<ConfigQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception(" ConfigDao-->CheckUserName-->" + ex.Message + sql.ToString(), ex);
}
}
public List<ConfigQuery> CheckSingleConfig(ConfigQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("SELECT id from config where config_name like '%{0}%' AND config_value='{1}'",query.config_name,query.config_value);
return _accessMySql.getDataTableForObj<ConfigQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception(" ConfigDao-->CheckSingleConfig-->" + ex.Message + sql.ToString(), ex);
}
}
public DataTable GetConfigByLike(ConfigQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("SELECT config_name,config_value FROM config WHERE config_name LIKE '%{0}%';", query.config_name);
return _accessMySql.getDataTable(sql.ToString());
}
catch (Exception ex)
{
throw new Exception(" ConfigDao-->GetConfigByLike-->" + ex.Message + sql.ToString(), ex);
}
}
public DataTable ConfigCheck(ConfigQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("select config_name, config_value,config_content from config where config_name='{0}' ORDER BY config_name ASC;", query.config_name);
return _accessMySql.getDataTable(sql.ToString());
}
catch (Exception ex)
{
throw new Exception(" ConfigDao-->ConfigCheckName-->" + ex.Message + sql.ToString(), ex);
}
}
public int UpdateConfig(ConfigQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.Append("set sql_safe_updates=0;");
sql.AppendFormat("UPDATE config SET config_value='{0}' WHERE config_name='{1}' ;", query.config_value,query.config_name);
sql.Append("set sql_safe_updates=1;");
return _accessMySql.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception(" ConfigDao-->UpdateConfig-->" + ex.Message + sql.ToString(), ex);
}
}
public int InsertConfig(ConfigQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("INSERT INTO config (config_name,config_value,config_content) VALUES('{0}','{1}','{2}');", query.config_name, query.config_value, query.config_content);
return _accessMySql.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception(" ConfigDao-->InsertConfig-->" + ex.Message + sql.ToString(), ex);
}
}