/// <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); } }