/// <summary>
/// 得到一个对象实体
/// </summary>
public WeiXinPF.Model.wx_xt_base GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,wid,wxTitle,keywords,fengmian,donghua,donghuaSlt,manName,felmanName,nameSeq,tel,statedate,addr,lngX,latY,video,video2,music,word,sqrurl,copyrite,createDate,templateId,templateName,pwd,extStr,extStr2,extInt from wx_xt_base ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
WeiXinPF.Model.wx_xt_base model = new WeiXinPF.Model.wx_xt_base();
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 int Add(WeiXinPF.Model.wx_xt_base model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_xt_base(");
strSql.Append("wid,wxTitle,keywords,fengmian,donghua,donghuaSlt,manName,felmanName,nameSeq,tel,statedate,addr,lngX,latY,video,video2,music,word,sqrurl,copyrite,createDate,templateId,templateName,pwd,extStr,extStr2,extInt)");
strSql.Append(" values (");
strSql.Append("@wid,@wxTitle,@keywords,@fengmian,@donghua,@donghuaSlt,@manName,@felmanName,@nameSeq,@tel,@statedate,@addr,@lngX,@latY,@video,@video2,@music,@word,@sqrurl,@copyrite,@createDate,@templateId,@templateName,@pwd,@extStr,@extStr2,@extInt)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@wid", SqlDbType.Int, 4),
new SqlParameter("@wxTitle", SqlDbType.VarChar, 40),
new SqlParameter("@keywords", SqlDbType.VarChar, 100),
new SqlParameter("@fengmian", SqlDbType.VarChar, 1000),
new SqlParameter("@donghua", SqlDbType.VarChar, 1000),
new SqlParameter("@donghuaSlt", SqlDbType.VarChar, 1000),
new SqlParameter("@manName", SqlDbType.VarChar, 50),
new SqlParameter("@felmanName", SqlDbType.VarChar, 50),
new SqlParameter("@nameSeq", SqlDbType.Int, 4),
new SqlParameter("@tel", SqlDbType.VarChar, 40),
new SqlParameter("@statedate", SqlDbType.DateTime),
new SqlParameter("@addr", SqlDbType.VarChar, 500),
new SqlParameter("@lngX", SqlDbType.Float, 8),
new SqlParameter("@latY", SqlDbType.Float, 8),
new SqlParameter("@video", SqlDbType.VarChar, 1000),
new SqlParameter("@video2", SqlDbType.VarChar, 1000),
new SqlParameter("@music", SqlDbType.VarChar, 1000),
new SqlParameter("@word", SqlDbType.VarChar, 500),
new SqlParameter("@sqrurl", SqlDbType.VarChar, 1000),
new SqlParameter("@copyrite", SqlDbType.VarChar, 200),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@templateId", SqlDbType.Int, 4),
new SqlParameter("@templateName", SqlDbType.VarChar, 300),
new SqlParameter("@pwd", SqlDbType.VarChar, 100),
new SqlParameter("@extStr", SqlDbType.VarChar, 1000),
new SqlParameter("@extStr2", SqlDbType.VarChar, 4000),
new SqlParameter("@extInt", SqlDbType.Int, 4)
};
parameters[0].Value = model.wid;
parameters[1].Value = model.wxTitle;
parameters[2].Value = model.keywords;
parameters[3].Value = model.fengmian;
parameters[4].Value = model.donghua;
parameters[5].Value = model.donghuaSlt;
parameters[6].Value = model.manName;
parameters[7].Value = model.felmanName;
parameters[8].Value = model.nameSeq;
parameters[9].Value = model.tel;
parameters[10].Value = model.statedate;
parameters[11].Value = model.addr;
parameters[12].Value = model.lngX;
parameters[13].Value = model.latY;
parameters[14].Value = model.video;
parameters[15].Value = model.video2;
parameters[16].Value = model.music;
parameters[17].Value = model.word;
parameters[18].Value = model.sqrurl;
parameters[19].Value = model.copyrite;
parameters[20].Value = model.createDate;
parameters[21].Value = model.templateId;
parameters[22].Value = model.templateName;
parameters[23].Value = model.pwd;
parameters[24].Value = model.extStr;
parameters[25].Value = model.extStr2;
parameters[26].Value = model.extInt;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WeiXinPF.Model.wx_xt_base DataRowToModel(DataRow row)
{
WeiXinPF.Model.wx_xt_base model = new WeiXinPF.Model.wx_xt_base();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["wid"] != null && row["wid"].ToString() != "")
{
model.wid = int.Parse(row["wid"].ToString());
}
if (row["wxTitle"] != null)
{
model.wxTitle = row["wxTitle"].ToString();
}
if (row["keywords"] != null)
{
model.keywords = row["keywords"].ToString();
}
if (row["fengmian"] != null)
{
model.fengmian = row["fengmian"].ToString();
}
if (row["donghua"] != null)
{
model.donghua = row["donghua"].ToString();
}
if (row["donghuaSlt"] != null)
{
model.donghuaSlt = row["donghuaSlt"].ToString();
}
if (row["manName"] != null)
{
model.manName = row["manName"].ToString();
}
if (row["felmanName"] != null)
{
model.felmanName = row["felmanName"].ToString();
}
if (row["nameSeq"] != null && row["nameSeq"].ToString() != "")
{
model.nameSeq = int.Parse(row["nameSeq"].ToString());
}
if (row["tel"] != null)
{
model.tel = row["tel"].ToString();
}
if (row["statedate"] != null && row["statedate"].ToString() != "")
{
model.statedate = DateTime.Parse(row["statedate"].ToString());
}
if (row["addr"] != null)
{
model.addr = row["addr"].ToString();
}
if (row["lngX"] != null && row["lngX"].ToString() != "")
{
model.lngX = decimal.Parse(row["lngX"].ToString());
}
if (row["latY"] != null && row["latY"].ToString() != "")
{
model.latY = decimal.Parse(row["latY"].ToString());
}
if (row["video"] != null)
{
model.video = row["video"].ToString();
}
if (row["video2"] != null)
{
model.video2 = row["video2"].ToString();
}
if (row["music"] != null)
{
model.music = row["music"].ToString();
}
if (row["word"] != null)
{
model.word = row["word"].ToString();
}
if (row["sqrurl"] != null)
{
model.sqrurl = row["sqrurl"].ToString();
}
if (row["copyrite"] != null)
{
model.copyrite = row["copyrite"].ToString();
}
if (row["createDate"] != null && row["createDate"].ToString() != "")
{
model.createDate = DateTime.Parse(row["createDate"].ToString());
}
if (row["templateId"] != null && row["templateId"].ToString() != "")
{
model.templateId = int.Parse(row["templateId"].ToString());
}
if (row["templateName"] != null)
{
model.templateName = row["templateName"].ToString();
}
if (row["pwd"] != null)
{
model.pwd = row["pwd"].ToString();
}
if (row["extStr"] != null)
{
model.extStr = row["extStr"].ToString();
}
if (row["extStr2"] != null)
{
model.extStr2 = row["extStr2"].ToString();
}
if (row["extInt"] != null && row["extInt"].ToString() != "")
{
model.extInt = int.Parse(row["extInt"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WeiXinPF.Model.wx_xt_base model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update wx_xt_base set ");
strSql.Append("wid=@wid,");
strSql.Append("wxTitle=@wxTitle,");
strSql.Append("keywords=@keywords,");
strSql.Append("fengmian=@fengmian,");
strSql.Append("donghua=@donghua,");
strSql.Append("donghuaSlt=@donghuaSlt,");
strSql.Append("manName=@manName,");
strSql.Append("felmanName=@felmanName,");
strSql.Append("nameSeq=@nameSeq,");
strSql.Append("tel=@tel,");
strSql.Append("statedate=@statedate,");
strSql.Append("addr=@addr,");
strSql.Append("lngX=@lngX,");
strSql.Append("latY=@latY,");
strSql.Append("video=@video,");
strSql.Append("video2=@video2,");
strSql.Append("music=@music,");
strSql.Append("word=@word,");
strSql.Append("sqrurl=@sqrurl,");
strSql.Append("copyrite=@copyrite,");
strSql.Append("createDate=@createDate,");
strSql.Append("templateId=@templateId,");
strSql.Append("templateName=@templateName,");
strSql.Append("pwd=@pwd,");
strSql.Append("extStr=@extStr,");
strSql.Append("extStr2=@extStr2,");
strSql.Append("extInt=@extInt");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@wid", SqlDbType.Int, 4),
new SqlParameter("@wxTitle", SqlDbType.VarChar, 40),
new SqlParameter("@keywords", SqlDbType.VarChar, 100),
new SqlParameter("@fengmian", SqlDbType.VarChar, 1000),
new SqlParameter("@donghua", SqlDbType.VarChar, 1000),
new SqlParameter("@donghuaSlt", SqlDbType.VarChar, 1000),
new SqlParameter("@manName", SqlDbType.VarChar, 50),
new SqlParameter("@felmanName", SqlDbType.VarChar, 50),
new SqlParameter("@nameSeq", SqlDbType.Int, 4),
new SqlParameter("@tel", SqlDbType.VarChar, 40),
new SqlParameter("@statedate", SqlDbType.DateTime),
new SqlParameter("@addr", SqlDbType.VarChar, 500),
new SqlParameter("@lngX", SqlDbType.Float, 8),
new SqlParameter("@latY", SqlDbType.Float, 8),
new SqlParameter("@video", SqlDbType.VarChar, 1000),
new SqlParameter("@video2", SqlDbType.VarChar, 1000),
new SqlParameter("@music", SqlDbType.VarChar, 1000),
new SqlParameter("@word", SqlDbType.VarChar, 500),
new SqlParameter("@sqrurl", SqlDbType.VarChar, 1000),
new SqlParameter("@copyrite", SqlDbType.VarChar, 200),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@templateId", SqlDbType.Int, 4),
new SqlParameter("@templateName", SqlDbType.VarChar, 300),
new SqlParameter("@pwd", SqlDbType.VarChar, 100),
new SqlParameter("@extStr", SqlDbType.VarChar, 1000),
new SqlParameter("@extStr2", SqlDbType.VarChar, 4000),
new SqlParameter("@extInt", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.wid;
parameters[1].Value = model.wxTitle;
parameters[2].Value = model.keywords;
parameters[3].Value = model.fengmian;
parameters[4].Value = model.donghua;
parameters[5].Value = model.donghuaSlt;
parameters[6].Value = model.manName;
parameters[7].Value = model.felmanName;
parameters[8].Value = model.nameSeq;
parameters[9].Value = model.tel;
parameters[10].Value = model.statedate;
parameters[11].Value = model.addr;
parameters[12].Value = model.lngX;
parameters[13].Value = model.latY;
parameters[14].Value = model.video;
parameters[15].Value = model.video2;
parameters[16].Value = model.music;
parameters[17].Value = model.word;
parameters[18].Value = model.sqrurl;
parameters[19].Value = model.copyrite;
parameters[20].Value = model.createDate;
parameters[21].Value = model.templateId;
parameters[22].Value = model.templateName;
parameters[23].Value = model.pwd;
parameters[24].Value = model.extStr;
parameters[25].Value = model.extStr2;
parameters[26].Value = model.extInt;
parameters[27].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}