/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Cms.Model.sc_stores model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sc_stores(");
strSql.Append("pid,location,city,county,storename,info,sort_id,picurl,linkurl,latitude,longitude,isHidden,updatetime,tel,address,verificationPass)");
strSql.Append(" values (");
strSql.Append("@pid,@location,@city,@county,@storename,@info,@sort_id,@picurl,@linkurl,@latitude,@longitude,@isHidden,@updatetime,@tel,@address,@verificationPass)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@pid", SqlDbType.Int, 4),
new SqlParameter("@location", SqlDbType.VarChar, 350),
new SqlParameter("@city", SqlDbType.VarChar, 350),
new SqlParameter("@county", SqlDbType.VarChar, 350),
new SqlParameter("@storename", SqlDbType.NVarChar, 100),
new SqlParameter("@info", SqlDbType.Text),
new SqlParameter("@sort_id", SqlDbType.Int, 4),
new SqlParameter("@picurl", SqlDbType.NVarChar, 150),
new SqlParameter("@linkurl", SqlDbType.NVarChar, 150),
new SqlParameter("@latitude", SqlDbType.NVarChar, 50),
new SqlParameter("@longitude", SqlDbType.NVarChar, 50),
new SqlParameter("@isHidden", SqlDbType.Int, 4),
new SqlParameter("@updatetime", SqlDbType.DateTime),
new SqlParameter("@tel", SqlDbType.NVarChar, 50),
new SqlParameter("@address", SqlDbType.NVarChar, 300),
new SqlParameter("@verificationPass", SqlDbType.NVarChar, 300)
};
parameters[0].Value = model.pid;
parameters[1].Value = model.location;
parameters[2].Value = model.city;
parameters[3].Value = model.county;
parameters[4].Value = model.storename;
parameters[5].Value = model.info;
parameters[6].Value = model.sort_id;
parameters[7].Value = model.picurl;
parameters[8].Value = model.linkurl;
parameters[9].Value = model.latitude;
parameters[10].Value = model.longitude;
parameters[11].Value = model.isHidden;
parameters[12].Value = model.updatetime;
parameters[13].Value = model.tel;
parameters[14].Value = model.address;
parameters[15].Value = model.verificationPass;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Cms.Model.sc_stores GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,pid,location,city,county,storename,info,sort_id,picurl,linkurl,latitude,longitude,isHidden,updatetime,tel,address,verificationPass from sc_stores ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Cms.Model.sc_stores model = new Cms.Model.sc_stores();
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 Cms.Model.sc_stores DataRowToModel(DataRow row)
{
Cms.Model.sc_stores model = new Cms.Model.sc_stores();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["pid"] != null && row["pid"].ToString() != "")
{
model.pid = int.Parse(row["pid"].ToString());
}
if (row["location"] != null)
{
model.location = row["location"].ToString();
}
if (row["city"] != null)
{
model.city = row["city"].ToString();
}
if (row["county"] != null)
{
model.county = row["county"].ToString();
}
if (row["storename"] != null)
{
model.storename = row["storename"].ToString();
}
if (row["info"] != null)
{
model.info = row["info"].ToString();
}
if (row["sort_id"] != null && row["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(row["sort_id"].ToString());
}
if (row["picurl"] != null)
{
model.picurl = row["picurl"].ToString();
}
if (row["linkurl"] != null)
{
model.linkurl = row["linkurl"].ToString();
}
if (row["latitude"] != null)
{
model.latitude = row["latitude"].ToString();
}
if (row["longitude"] != null)
{
model.longitude = row["longitude"].ToString();
}
if (row["isHidden"] != null && row["isHidden"].ToString() != "")
{
model.isHidden = int.Parse(row["isHidden"].ToString());
}
if (row["updatetime"] != null && row["updatetime"].ToString() != "")
{
model.updatetime = DateTime.Parse(row["updatetime"].ToString());
}
if (row["tel"] != null)
{
model.tel = row["tel"].ToString();
}
if (row["address"] != null)
{
model.address = row["address"].ToString();
}
if (row["verificationPass"] != null)
{
model.verificationPass = row["verificationPass"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Cms.Model.sc_stores model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sc_stores set ");
strSql.Append("pid=@pid,");
strSql.Append("location=@location,");
strSql.Append("city=@city,");
strSql.Append("county=@county,");
strSql.Append("storename=@storename,");
strSql.Append("info=@info,");
strSql.Append("sort_id=@sort_id,");
strSql.Append("picurl=@picurl,");
strSql.Append("linkurl=@linkurl,");
strSql.Append("latitude=@latitude,");
strSql.Append("longitude=@longitude,");
strSql.Append("isHidden=@isHidden,");
strSql.Append("updatetime=@updatetime,");
strSql.Append("tel=@tel,");
strSql.Append("address=@address,");
strSql.Append("verificationPass=@verificationPass");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@pid", SqlDbType.Int, 4),
new SqlParameter("@location", SqlDbType.VarChar, 350),
new SqlParameter("@city", SqlDbType.VarChar, 350),
new SqlParameter("@county", SqlDbType.VarChar, 350),
new SqlParameter("@storename", SqlDbType.NVarChar, 100),
new SqlParameter("@info", SqlDbType.Text),
new SqlParameter("@sort_id", SqlDbType.Int, 4),
new SqlParameter("@picurl", SqlDbType.NVarChar, 150),
new SqlParameter("@linkurl", SqlDbType.NVarChar, 150),
new SqlParameter("@latitude", SqlDbType.NVarChar, 50),
new SqlParameter("@longitude", SqlDbType.NVarChar, 50),
new SqlParameter("@isHidden", SqlDbType.Int, 4),
new SqlParameter("@updatetime", SqlDbType.DateTime),
new SqlParameter("@tel", SqlDbType.NVarChar, 50),
new SqlParameter("@address", SqlDbType.NVarChar, 300),
new SqlParameter("@verificationPass", SqlDbType.NVarChar, 300),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.pid;
parameters[1].Value = model.location;
parameters[2].Value = model.city;
parameters[3].Value = model.county;
parameters[4].Value = model.storename;
parameters[5].Value = model.info;
parameters[6].Value = model.sort_id;
parameters[7].Value = model.picurl;
parameters[8].Value = model.linkurl;
parameters[9].Value = model.latitude;
parameters[10].Value = model.longitude;
parameters[11].Value = model.isHidden;
parameters[12].Value = model.updatetime;
parameters[13].Value = model.tel;
parameters[14].Value = model.address;
parameters[15].Value = model.verificationPass;
parameters[16].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
