public static int readCount(string Item_market, string Cat_big, string Cat_middle, string Cat_small, string Item_id, string u)
{
string q = @"select count(*) from dbo.Crwitem ";
q += " where Item_market = '" + Item_market + "'";
q += " and Cat_big = '" + Cat_big + "'";
q += " and Cat_middle = '" + Cat_middle + "'";
q += " and Cat_small = '" + Cat_small + "'";
q += " and Item_id = '" + Item_id + "'";
Hel h = new Hel();
h.url = u;
SqlCommand cmd = new SqlCommand(q);
DataSet ds = h.ExecuteCommand(cmd);
return(int.Parse(ds.Tables[0].Rows[0][0].ToString()));
}
public static DataTable readData(string Item_market, string u)
{
DataTable dt = new DataTable();
string q = @"select * from dbo.Crwitem ";
q += " where Item_market = '" + Item_market + "'";
//q += " and Cat_big = '" + Cat_big + "'";
//q += " and Cat_middle = '" + Cat_middle + "'";
//q += " and Cat_small = '" + Cat_small + "'";
//q += " and Item_id = '" + Item_id + "'";
Hel h = new Hel();
h.url = u;
SqlCommand cmd = new SqlCommand(q);
DataSet ds = h.ExecuteCommand(cmd);
dt = ds.Tables[0];
return(dt);
}