/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.weixin_request_rule GetModel(int account_id, int request_type)
{
StringBuilder strSql = new StringBuilder();
StringBuilder str1 = new StringBuilder();
Model.weixin_request_rule model = new Model.weixin_request_rule();
//利用反射获得属性的所有公共属性
PropertyInfo[] pros = model.GetType().GetProperties();
foreach (PropertyInfo p in pros)
{
//拼接字段，忽略List<T>
if (!p.Name.Equals("values") && !p.Name.Equals("contents"))
{
str1.Append(p.Name + ",");
}
}
strSql.Append("select top 1 " + str1.ToString().Trim(','));
strSql.Append(" from " + databaseprefix + "weixin_request_rule");
strSql.AppendFormat(" where account_id={0} and request_type='{1}'", account_id, request_type);
DataSet ds = WriteDataBase.QueryFillDataSet(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataTable GetImagesList(int article_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,article_id,thumb_path,original_path,sort_id,remark,add_time,channel_id ");
strSql.Append(" FROM " + databaseprefix + "article_albums ");
strSql.Append(" where article_id=" + article_id);
strSql.Append(" order by sort_id asc, id asc");
DataSet ds = WriteDataBase.QueryFillDataSet(strSql.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 将对象转换实体
/// </summary>
public Model.weixin_request_rule DataRowToModel(DataRow row)
{
Model.weixin_request_rule model = new Model.weixin_request_rule();
if (row != null)
{
#region 主表信息======================
//利用反射获得属性的所有公共属性
Type modelType = model.GetType();
for (int i = 0; i < row.Table.Columns.Count; i++)
{
//查找实体是否存在列表相同的公共属性
PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
if (proInfo != null && row[i] != DBNull.Value)
{
proInfo.SetValue(model, row[i], null);//用索引值设置属性值
}
}
#endregion
#region 子表信息======================
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select * from " + databaseprefix + "weixin_request_content");
strSql1.Append(" where rule_id=" + model.id);
DataTable dt1 = WriteDataBase.QueryFillDataSet(strSql1.ToString()).Tables[0];
if (dt1.Rows.Count > 0)
{
int rowsCount = dt1.Rows.Count;
List <Model.weixin_request_content> models = new List <Model.weixin_request_content>();
Model.weixin_request_content modelt;
for (int n = 0; n < rowsCount; n++)
{
modelt = new Model.weixin_request_content();
Type modeltType = modelt.GetType();
for (int i = 0; i < dt1.Rows[n].Table.Columns.Count; i++)
{
PropertyInfo proInfo = modeltType.GetProperty(dt1.Rows[n].Table.Columns[i].ColumnName);
if (proInfo != null && dt1.Rows[n][i] != DBNull.Value)
{
proInfo.SetValue(modelt, dt1.Rows[n][i], null);
}
}
models.Add(modelt);
}
model.contents = models;
}
#endregion
}
return(model);
}
/// <summary>
/// 得到关健字查询的规则ID及回复类型(如需提高效率可使用存储过程)
/// </summary>
public int GetKeywordsRuleId(int account_id, string keywords, out int response_type)
{
int rule_id = 0;
//精确匹配
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("select top 1 id,response_type from " + databaseprefix + "weixin_request_rule");
strSql3.Append(" where account_id=" + account_id + " and request_type=1");
strSql3.Append(" and(keywords like '" + keywords + "|%' or keywords='%|" + keywords + "' or keywords like '%|" + keywords + "|%' or keywords='" + keywords + "')");
strSql3.Append(" order by sort_id asc,add_time desc");
DataSet ds3 = WriteDataBase.QueryFillDataSet(strSql3.ToString());
if (ds3.Tables[0].Rows.Count > 0)
{
rule_id = int.Parse(ds3.Tables[0].Rows[0][0].ToString());
response_type = int.Parse(ds3.Tables[0].Rows[0][1].ToString());
return(rule_id);
}
//模糊匹配
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("select top 1 id,response_type from " + databaseprefix + "weixin_request_rule");
strSql2.Append(" where account_id=" + account_id + " and request_type=1 and keywords like '%" + keywords + "%'");
strSql2.Append(" order by sort_id asc,add_time desc");
DataSet ds2 = WriteDataBase.QueryFillDataSet(strSql2.ToString());
if (ds2.Tables[0].Rows.Count > 0)
{
rule_id = int.Parse(ds2.Tables[0].Rows[0][0].ToString());
response_type = int.Parse(ds2.Tables[0].Rows[0][1].ToString());
return(rule_id);
}
//默认回复
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select top 1 id,response_type from " + databaseprefix + "weixin_request_rule");
strSql1.Append(" where account_id=" + account_id + " and request_type=0");
strSql1.Append(" order by sort_id asc,add_time desc");
DataSet ds1 = WriteDataBase.QueryFillDataSet(strSql1.ToString());
if (ds1.Tables[0].Rows.Count > 0)
{
rule_id = int.Parse(ds1.Tables[0].Rows[0][0].ToString());
response_type = int.Parse(ds1.Tables[0].Rows[0][1].ToString());
return(rule_id);
}
response_type = 0;
return(rule_id);
}
/// <summary>
/// 获取站点未添加数据
/// </summary>
public DataSet GetList(int site_id, int oauth_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * FROM " + databaseprefix + "oauth_app");
strSql.Append(" where is_lock=0 and id not in(");
strSql.Append("select oauth_id from " + databaseprefix + "site_oauth where site_id=" + site_id);
if (oauth_id > 0)
{
strSql.Append(" and oauth_id<>" + oauth_id);
}
strSql.Append(")");
strSql.Append(" order by sort_id asc,id desc");
return(WriteDataBase.QueryFillDataSet(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(string channel_name, int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" * ");
strSql.Append(" FROM " + databaseprefix + DTKeys.TABLE_CHANNEL_ARTICLE + channel_name);
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(WriteDataBase.QueryFillDataSet(strSql.ToString()));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public override Model.article_attribute_field GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
StringBuilder str1 = new StringBuilder();
Model.article_attribute_field model = new Model.article_attribute_field();
//利用反射获得属性的所有公共属性
Type modelType = model.GetType();
PropertyInfo[] pros = modelType.GetProperties();
foreach (PropertyInfo p in pros)
{
str1.Append(p.Name + ",");//拼接字段
}
strSql.Append("select top 1 " + str1.ToString().Trim(','));
strSql.Append(" from " + databaseprefix + "article_attribute_field");
strSql.Append(" where id=" + id);
DataTable dt = WriteDataBase.QueryFillDataSet(strSql.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows[0].Table.Columns.Count; i++)
{
//查找实体是否存在列表相同的公共属性
PropertyInfo proInfo = modelType.GetProperty(dt.Rows[0].Table.Columns[i].ColumnName);
if (proInfo != null && dt.Rows[0][i] != DBNull.Value)
{
proInfo.SetValue(model, dt.Rows[0][i], null);//用索引值设置属性值
}
}
return(model);
}
else
{
return(null);
}
}