/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WeiXinPF.Model.wx_mz_animate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update wx_mz_animate set ");
strSql.Append("iid=@iid,");
strSql.Append("width=@width,");
strSql.Append("height=@height,");
strSql.Append("x_loaction=@x_loaction,");
strSql.Append("y_location=@y_location,");
strSql.Append("animate_type=@animate_type,");
strSql.Append("start_seconds=@start_seconds,");
strSql.Append("continue_seconds=@continue_seconds,");
strSql.Append("animate_img=@animate_img,");
strSql.Append("createdate=@createdate,");
strSql.Append("sort_id=@sort_id");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@iid", SqlDbType.Int, 4),
new SqlParameter("@width", SqlDbType.Float, 8),
new SqlParameter("@height", SqlDbType.Float, 8),
new SqlParameter("@x_loaction", SqlDbType.Float, 8),
new SqlParameter("@y_location", SqlDbType.Float, 8),
new SqlParameter("@animate_type", SqlDbType.NVarChar, 200),
new SqlParameter("@start_seconds", SqlDbType.Float, 8),
new SqlParameter("@continue_seconds", SqlDbType.Float, 8),
new SqlParameter("@animate_img", SqlDbType.NVarChar, 800),
new SqlParameter("@createdate", SqlDbType.DateTime),
new SqlParameter("@sort_id", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.iid;
parameters[1].Value = model.width;
parameters[2].Value = model.height;
parameters[3].Value = model.x_loaction;
parameters[4].Value = model.y_location;
parameters[5].Value = model.animate_type;
parameters[6].Value = model.start_seconds;
parameters[7].Value = model.continue_seconds;
parameters[8].Value = model.animate_img;
parameters[9].Value = model.createdate;
parameters[10].Value = model.sort_id;
parameters[11].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WeiXinPF.Model.wx_mz_animate DataRowToModel(DataRow row)
{
WeiXinPF.Model.wx_mz_animate model = new WeiXinPF.Model.wx_mz_animate();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["iid"] != null && row["iid"].ToString() != "")
{
model.iid = int.Parse(row["iid"].ToString());
}
if (row["width"] != null && row["width"].ToString() != "")
{
model.width = decimal.Parse(row["width"].ToString());
}
if (row["height"] != null && row["height"].ToString() != "")
{
model.height = decimal.Parse(row["height"].ToString());
}
if (row["x_loaction"] != null && row["x_loaction"].ToString() != "")
{
model.x_loaction = decimal.Parse(row["x_loaction"].ToString());
}
if (row["y_location"] != null && row["y_location"].ToString() != "")
{
model.y_location = decimal.Parse(row["y_location"].ToString());
}
if (row["animate_type"] != null)
{
model.animate_type = row["animate_type"].ToString();
}
if (row["start_seconds"] != null && row["start_seconds"].ToString() != "")
{
model.start_seconds = decimal.Parse(row["start_seconds"].ToString());
}
if (row["continue_seconds"] != null && row["continue_seconds"].ToString() != "")
{
model.continue_seconds = decimal.Parse(row["continue_seconds"].ToString());
}
if (row["animate_img"] != null)
{
model.animate_img = row["animate_img"].ToString();
}
if (row["createdate"] != null && row["createdate"].ToString() != "")
{
model.createdate = DateTime.Parse(row["createdate"].ToString());
}
if (row["sort_id"] != null && row["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(row["sort_id"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WeiXinPF.Model.wx_mz_animate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_mz_animate(");
strSql.Append("iid,width,height,x_loaction,y_location,animate_type,start_seconds,continue_seconds,animate_img,createdate,sort_id)");
strSql.Append(" values (");
strSql.Append("@iid,@width,@height,@x_loaction,@y_location,@animate_type,@start_seconds,@continue_seconds,@animate_img,@createdate,@sort_id)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@iid", SqlDbType.Int, 4),
new SqlParameter("@width", SqlDbType.Float, 8),
new SqlParameter("@height", SqlDbType.Float, 8),
new SqlParameter("@x_loaction", SqlDbType.Float, 8),
new SqlParameter("@y_location", SqlDbType.Float, 8),
new SqlParameter("@animate_type", SqlDbType.NVarChar, 200),
new SqlParameter("@start_seconds", SqlDbType.Float, 8),
new SqlParameter("@continue_seconds", SqlDbType.Float, 8),
new SqlParameter("@animate_img", SqlDbType.NVarChar, 800),
new SqlParameter("@createdate", SqlDbType.DateTime),
new SqlParameter("@sort_id", SqlDbType.Int, 4)
};
parameters[0].Value = model.iid;
parameters[1].Value = model.width;
parameters[2].Value = model.height;
parameters[3].Value = model.x_loaction;
parameters[4].Value = model.y_location;
parameters[5].Value = model.animate_type;
parameters[6].Value = model.start_seconds;
parameters[7].Value = model.continue_seconds;
parameters[8].Value = model.animate_img;
parameters[9].Value = model.createdate;
parameters[10].Value = model.sort_id;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WeiXinPF.Model.wx_mz_animate GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,iid,width,height,x_loaction,y_location,animate_type,start_seconds,continue_seconds,animate_img,createdate,sort_id from wx_mz_animate ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
WeiXinPF.Model.wx_mz_animate model = new WeiXinPF.Model.wx_mz_animate();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
