/// <summary>
/// 得到回复规则的【图文】信息
/// </summary>
/// <param name="rid">规则主键Id</param>
/// <returns></returns>
public IList<MxWeiXinPF.Model.wx_requestRuleContent> GetTuWenContent(int rid)
{
IList<MxWeiXinPF.Model.wx_requestRuleContent> rcList = new List<Model.wx_requestRuleContent>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 10 rContent,rContent2 ,picUrl,detailUrl from wx_requestRuleContent ");
strSql.Append(" where rid=@rid order by seq asc");
SqlParameter[] parameters = {
new SqlParameter("@rid", SqlDbType.Int,4)
};
parameters[0].Value = rid;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
MxWeiXinPF.Model.wx_requestRuleContent model = new MxWeiXinPF.Model.wx_requestRuleContent();
while (sr.Read())
{
model = new MxWeiXinPF.Model.wx_requestRuleContent();
model.rContent = sr["rContent"].ToString();
model.rContent2 = sr["rContent2"].ToString();
model.picUrl = sr["picUrl"].ToString();
model.detailUrl = sr["detailUrl"].ToString();
rcList.Add(model);
}
sr.Close();
return rcList;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.Model.wx_requestRuleContent model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_requestRuleContent(");
strSql.Append("uId,rId,rContent,rContent2,detailUrl,picUrl,mediaUrl,meidaHDUrl,remark,seq,createDate,extInt,extInt2,extStr,extStr2,extstr3)");
strSql.Append(" values (");
strSql.Append("@uId,@rId,@rContent,@rContent2,@detailUrl,@picUrl,@mediaUrl,@meidaHDUrl,@remark,@seq,@createDate,@extInt,@extInt2,@extStr,@extStr2,@extstr3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@uId", SqlDbType.Int, 4),
new SqlParameter("@rId", SqlDbType.Int, 4),
new SqlParameter("@rContent", SqlDbType.Text),
new SqlParameter("@rContent2", SqlDbType.VarChar, 2000),
new SqlParameter("@detailUrl", SqlDbType.VarChar, 1000),
new SqlParameter("@picUrl", SqlDbType.VarChar, 1000),
new SqlParameter("@mediaUrl", SqlDbType.VarChar, 1500),
new SqlParameter("@meidaHDUrl", SqlDbType.VarChar, 1500),
new SqlParameter("@remark", SqlDbType.VarChar, 2000),
new SqlParameter("@seq", SqlDbType.Int, 4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@extInt", SqlDbType.Int, 4),
new SqlParameter("@extInt2", SqlDbType.Int, 4),
new SqlParameter("@extStr", SqlDbType.VarChar, 800),
new SqlParameter("@extStr2", SqlDbType.VarChar, 1000),
new SqlParameter("@extstr3", SqlDbType.VarChar, 1500)
};
parameters[0].Value = model.uId;
parameters[1].Value = model.rId;
parameters[2].Value = model.rContent;
parameters[3].Value = model.rContent2;
parameters[4].Value = model.detailUrl;
parameters[5].Value = model.picUrl;
parameters[6].Value = model.mediaUrl;
parameters[7].Value = model.meidaHDUrl;
parameters[8].Value = model.remark;
parameters[9].Value = model.seq;
parameters[10].Value = model.createDate;
parameters[11].Value = model.extInt;
parameters[12].Value = model.extInt2;
parameters[13].Value = model.extStr;
parameters[14].Value = model.extStr2;
parameters[15].Value = model.extstr3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到回复规则的语音信息
/// </summary>
/// <param name="rid">规则主键Id</param>
/// <returns></returns>
public MxWeiXinPF.Model.wx_requestRuleContent GetMusicContent(int rid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 rContent,rContent2 ,mediaUrl from wx_requestRuleContent ");
strSql.Append(" where rid=@rid");
SqlParameter[] parameters = {
new SqlParameter("@rid", SqlDbType.Int,4)
};
parameters[0].Value = rid;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(),parameters);
MxWeiXinPF.Model.wx_requestRuleContent model = new MxWeiXinPF.Model.wx_requestRuleContent();
while (sr.Read())
{
model.rContent = sr["rContent"].ToString();
model.rContent2 = sr["rContent2"].ToString();
model.mediaUrl = sr["mediaUrl"].ToString();
}
sr.Close();
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_requestRuleContent GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 id,uId,rId,rContent,rContent2,detailUrl,picUrl,mediaUrl,meidaHDUrl,remark,seq,createDate,extInt,extInt2,extStr,extStr2,extstr3 from wx_requestRuleContent ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
MxWeiXinPF.Model.wx_requestRuleContent model=new MxWeiXinPF.Model.wx_requestRuleContent();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_requestRuleContent DataRowToModel(DataRow row)
{
MxWeiXinPF.Model.wx_requestRuleContent model=new MxWeiXinPF.Model.wx_requestRuleContent();
if (row != null)
{
if(row["id"]!=null && row["id"].ToString()!="")
{
model.id=int.Parse(row["id"].ToString());
}
if(row["uId"]!=null && row["uId"].ToString()!="")
{
model.uId=int.Parse(row["uId"].ToString());
}
if(row["rId"]!=null && row["rId"].ToString()!="")
{
model.rId=int.Parse(row["rId"].ToString());
}
if(row["rContent"]!=null)
{
model.rContent=row["rContent"].ToString();
}
if(row["rContent2"]!=null)
{
model.rContent2=row["rContent2"].ToString();
}
if(row["detailUrl"]!=null)
{
model.detailUrl=row["detailUrl"].ToString();
}
if(row["picUrl"]!=null)
{
model.picUrl=row["picUrl"].ToString();
}
if(row["mediaUrl"]!=null)
{
model.mediaUrl=row["mediaUrl"].ToString();
}
if(row["meidaHDUrl"]!=null)
{
model.meidaHDUrl=row["meidaHDUrl"].ToString();
}
if(row["remark"]!=null)
{
model.remark=row["remark"].ToString();
}
if(row["seq"]!=null && row["seq"].ToString()!="")
{
model.seq=int.Parse(row["seq"].ToString());
}
if(row["createDate"]!=null && row["createDate"].ToString()!="")
{
model.createDate=DateTime.Parse(row["createDate"].ToString());
}
if(row["extInt"]!=null && row["extInt"].ToString()!="")
{
model.extInt=int.Parse(row["extInt"].ToString());
}
if(row["extInt2"]!=null && row["extInt2"].ToString()!="")
{
model.extInt2=int.Parse(row["extInt2"].ToString());
}
if(row["extStr"]!=null)
{
model.extStr=row["extStr"].ToString();
}
if(row["extStr2"]!=null)
{
model.extStr2=row["extStr2"].ToString();
}
if(row["extstr3"]!=null)
{
model.extstr3=row["extstr3"].ToString();
}
}
return model;
}
/// <summary>
/// 得到回复规则的【图文】信息
/// </summary>
/// <param name="rid">规则主键Id</param>
/// <returns></returns>
public IList<MxWeiXinPF.Model.wx_requestRuleContent> GetTuWenContent(int rid)
{
IList<MxWeiXinPF.Model.wx_requestRuleContent> rcList = new List<Model.wx_requestRuleContent>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 10 rContent,rContent2 ,picUrl,detailUrl from wx_requestRuleContent ");
strSql.Append(" where rid=@rid order by seq asc");
SqlParameter[] parameters = {
new SqlParameter("@rid", SqlDbType.Int,4)
};
parameters[0].Value = rid;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
MxWeiXinPF.Model.wx_requestRuleContent model = new MxWeiXinPF.Model.wx_requestRuleContent();
while (sr.Read())
{
model = new MxWeiXinPF.Model.wx_requestRuleContent();
model.rContent = sr["rContent"].ToString();
model.rContent2 = sr["rContent2"].ToString();
model.picUrl = sr["picUrl"].ToString();
model.detailUrl = sr["detailUrl"].ToString();
rcList.Add(model);
}
sr.Close();
return rcList;
}
/// <summary>
/// 得到回复规则的语音信息
/// </summary>
/// <param name="rid">规则主键Id</param>
/// <returns></returns>
public MxWeiXinPF.Model.wx_requestRuleContent GetMusicContent(int rid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 rContent,rContent2 ,mediaUrl from wx_requestRuleContent ");
strSql.Append(" where rid=@rid");
SqlParameter[] parameters = {
new SqlParameter("@rid", SqlDbType.Int,4)
};
parameters[0].Value = rid;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(),parameters);
MxWeiXinPF.Model.wx_requestRuleContent model = new MxWeiXinPF.Model.wx_requestRuleContent();
while (sr.Read())
{
model.rContent = sr["rContent"].ToString();
model.rContent2 = sr["rContent2"].ToString();
model.mediaUrl = sr["mediaUrl"].ToString();
}
sr.Close();
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_requestRuleContent GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 id,uId,rId,rContent,rContent2,detailUrl,picUrl,mediaUrl,meidaHDUrl,remark,seq,createDate,extInt,extInt2,extStr,extStr2,extstr3 from wx_requestRuleContent ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
MxWeiXinPF.Model.wx_requestRuleContent model=new MxWeiXinPF.Model.wx_requestRuleContent();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_requestRuleContent DataRowToModel(DataRow row)
{
MxWeiXinPF.Model.wx_requestRuleContent model=new MxWeiXinPF.Model.wx_requestRuleContent();
if (row != null)
{
if(row["id"]!=null && row["id"].ToString()!="")
{
model.id=int.Parse(row["id"].ToString());
}
if(row["uId"]!=null && row["uId"].ToString()!="")
{
model.uId=int.Parse(row["uId"].ToString());
}
if(row["rId"]!=null && row["rId"].ToString()!="")
{
model.rId=int.Parse(row["rId"].ToString());
}
if(row["rContent"]!=null)
{
model.rContent=row["rContent"].ToString();
}
if(row["rContent2"]!=null)
{
model.rContent2=row["rContent2"].ToString();
}
if(row["detailUrl"]!=null)
{
model.detailUrl=row["detailUrl"].ToString();
}
if(row["picUrl"]!=null)
{
model.picUrl=row["picUrl"].ToString();
}
if(row["mediaUrl"]!=null)
{
model.mediaUrl=row["mediaUrl"].ToString();
}
if(row["meidaHDUrl"]!=null)
{
model.meidaHDUrl=row["meidaHDUrl"].ToString();
}
if(row["remark"]!=null)
{
model.remark=row["remark"].ToString();
}
if(row["seq"]!=null && row["seq"].ToString()!="")
{
model.seq=int.Parse(row["seq"].ToString());
}
if(row["createDate"]!=null && row["createDate"].ToString()!="")
{
model.createDate=DateTime.Parse(row["createDate"].ToString());
}
if(row["extInt"]!=null && row["extInt"].ToString()!="")
{
model.extInt=int.Parse(row["extInt"].ToString());
}
if(row["extInt2"]!=null && row["extInt2"].ToString()!="")
{
model.extInt2=int.Parse(row["extInt2"].ToString());
}
if(row["extStr"]!=null)
{
model.extStr=row["extStr"].ToString();
}
if(row["extStr2"]!=null)
{
model.extStr2=row["extStr2"].ToString();
}
if(row["extstr3"]!=null)
{
model.extstr3=row["extstr3"].ToString();
}
}
return model;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MxWeiXinPF.Model.wx_requestRuleContent model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_requestRuleContent set ");
strSql.Append("uId=@uId,");
strSql.Append("rId=@rId,");
strSql.Append("rContent=@rContent,");
strSql.Append("rContent2=@rContent2,");
strSql.Append("detailUrl=@detailUrl,");
strSql.Append("picUrl=@picUrl,");
strSql.Append("mediaUrl=@mediaUrl,");
strSql.Append("meidaHDUrl=@meidaHDUrl,");
strSql.Append("remark=@remark,");
strSql.Append("seq=@seq,");
strSql.Append("createDate=@createDate,");
strSql.Append("extInt=@extInt,");
strSql.Append("extInt2=@extInt2,");
strSql.Append("extStr=@extStr,");
strSql.Append("extStr2=@extStr2,");
strSql.Append("extstr3=@extstr3");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@uId", SqlDbType.Int,4),
new SqlParameter("@rId", SqlDbType.Int,4),
new SqlParameter("@rContent", SqlDbType.Text),
new SqlParameter("@rContent2", SqlDbType.VarChar,2000),
new SqlParameter("@detailUrl", SqlDbType.VarChar,1000),
new SqlParameter("@picUrl", SqlDbType.VarChar,1000),
new SqlParameter("@mediaUrl", SqlDbType.VarChar,1500),
new SqlParameter("@meidaHDUrl", SqlDbType.VarChar,1500),
new SqlParameter("@remark", SqlDbType.VarChar,2000),
new SqlParameter("@seq", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@extInt", SqlDbType.Int,4),
new SqlParameter("@extInt2", SqlDbType.Int,4),
new SqlParameter("@extStr", SqlDbType.VarChar,800),
new SqlParameter("@extStr2", SqlDbType.VarChar,1000),
new SqlParameter("@extstr3", SqlDbType.VarChar,1500),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.uId;
parameters[1].Value = model.rId;
parameters[2].Value = model.rContent;
parameters[3].Value = model.rContent2;
parameters[4].Value = model.detailUrl;
parameters[5].Value = model.picUrl;
parameters[6].Value = model.mediaUrl;
parameters[7].Value = model.meidaHDUrl;
parameters[8].Value = model.remark;
parameters[9].Value = model.seq;
parameters[10].Value = model.createDate;
parameters[11].Value = model.extInt;
parameters[12].Value = model.extInt2;
parameters[13].Value = model.extStr;
parameters[14].Value = model.extStr2;
parameters[15].Value = model.extstr3;
parameters[16].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
