public int Insert(Model.proimage model)
{
StringBuilder sql = new StringBuilder();
sql.Append(" insert into proimage ");
sql.Append(" values (");
sql.Append("@imageid,@imageurl,@color,@sizeid");
sql.Append(")");
SqlParameter[] par =
{
new SqlParameter("@imageid", SqlDbType.VarChar, 50),
new SqlParameter("@imageurl", SqlDbType.VarChar, 100),
new SqlParameter("@color", SqlDbType.VarChar, 50),
new SqlParameter("@sizeid", SqlDbType.VarChar, 50),
};
par[0].Value = model.imageid;
par[1].Value = model.imageurl;
par[2].Value = model.color;
par[3].Value = model.sizeid;
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
//
public SqlDataReader dsim(Model.proimage aa)
{
StringBuilder sql = new StringBuilder();
sql.Append("select top 1 _imageurl from proimage where _imageid=@id");
SqlParameter[] par =
{
new SqlParameter("@id", SqlDbType.VarChar, 50)
};
par[0].Value = aa.id;
return(Common.DbHelperSQL.ExecuteReader(sql.ToString(), par));
}
public int selectid(Model.proimage mym)
{
StringBuilder sql = new StringBuilder();
sql.Append(" select _id from proimage ");
sql.Append(" where _sizeid=@sizeid ");
SqlParameter[] par =
{
new SqlParameter("@sizeid", SqlDbType.VarChar, 50)
};
par[0].Value = mym.sizeid;
return((int)Common.DbHelperSQL.GetSingle(sql.ToString(), par));
}
public int upimage(Model.proimage mym)
{
string sql = "update proimage set _imageurl='" + mym.imageurl + "' where _sizeid='" + mym.sizeid + "'";
return(Common.DB.ExecuteSql(sql));
}
//
public SqlDataReader drim(Model.proimage aa)
{
DAL.proimage da = new DAL.proimage();
return(da.dsim(aa));
}
public int upimage(Model.proimage mym)
{
DAL.proimage dal = new DAL.proimage();
return(dal.upimage(mym));
}
public int selectid(Model.proimage myb)
{
DAL.proimage dal = new DAL.proimage();
return(dal.selectid(myb));
}
public int insert(Model.proimage myb)
{
DAL.proimage dal = new DAL.proimage();
return(dal.Insert(myb));
}
