public static int AllDelete(string Item_market, string u) { string q = @"DELETE FROM dbo.Crwitem where Item_market='" + Item_market + "'"; Hel h = new Hel(); h.url = u; SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = q; //cmd.Parameters.Add("@Item_market", SqlDbType.NVarChar, 30).Value = d.Item_market; //cmd.Parameters.Add("@Cat_big", SqlDbType.NVarChar, 100).Value = d.Cat_big; //cmd.Parameters.Add("@Cat_middle", SqlDbType.NVarChar, 100).Value = d.Cat_middle; //cmd.Parameters.Add("@Cat_small", SqlDbType.NVarChar, 100).Value = d.Cat_small; //cmd.Parameters.Add("@Item_id", SqlDbType.NVarChar, 100).Value = d.Item_id; //cmd.Parameters.Add("@Item_nm", SqlDbType.NVarChar, 100).Value = d.Item_nm; //cmd.Parameters.Add("@Item_price", SqlDbType.Int).Value = d.Item_price; //cmd.Parameters.Add("@Item_url", SqlDbType.NVarChar, 500).Value = d.Item_url; //cmd.Parameters.Add("@Writeday", SqlDbType.DateTime).Value = d.Writeday; int ix = h.ExcuteTransaction(cmd); return(ix); }
public static int Save(Models.Product d, string u) { string q = @"UPdate dbo.Crwitem set Item_nm=@Item_nm ,Item_price=@Item_price ,Item_url=@Item_url ,Writeday=@Writeday where Item_market=@Item_market and Cat_big=@Cat_big and Cat_middle=@Cat_middle and Cat_small=@Cat_small and Item_id=@Item_id"; Hel h = new Hel(); h.url = u; SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = q; cmd.Parameters.Add("@Item_market", SqlDbType.NVarChar, 30).Value = d.Item_market; cmd.Parameters.Add("@Cat_big", SqlDbType.NVarChar, 100).Value = d.Cat_big; cmd.Parameters.Add("@Cat_middle", SqlDbType.NVarChar, 100).Value = d.Cat_middle; cmd.Parameters.Add("@Cat_small", SqlDbType.NVarChar, 100).Value = d.Cat_small; cmd.Parameters.Add("@Item_id", SqlDbType.NVarChar, 100).Value = d.Item_id; cmd.Parameters.Add("@Item_nm", SqlDbType.NVarChar, 100).Value = d.Item_nm; cmd.Parameters.Add("@Item_price", SqlDbType.Int).Value = d.Item_price; cmd.Parameters.Add("@Item_url", SqlDbType.NVarChar, 500).Value = d.Item_url; cmd.Parameters.Add("@Writeday", SqlDbType.DateTime).Value = d.Writeday; int ix = h.ExcuteTransaction(cmd); return(ix); }
public static int newSave(Models.Product d, string u) { string q = @"INSERT INTO dbo.Crwitem(Item_market,Cat_big,Cat_middle,Cat_small,Item_id,Item_nm,Item_price,Item_url,Writeday) VALUES (@Item_market, @Cat_big, @Cat_middle,@Cat_small, @Item_id, @Item_nm, @Item_price, @Item_url,@Writeday)"; Hel h = new Hel(); h.url = u; SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = q; cmd.Parameters.Add("@Item_market", SqlDbType.NVarChar, 30).Value = d.Item_market; cmd.Parameters.Add("@Cat_big", SqlDbType.NVarChar, 100).Value = d.Cat_big; cmd.Parameters.Add("@Cat_middle", SqlDbType.NVarChar, 100).Value = d.Cat_middle; cmd.Parameters.Add("@Cat_small", SqlDbType.NVarChar, 100).Value = d.Cat_small; cmd.Parameters.Add("@Item_id", SqlDbType.NVarChar, 100).Value = d.Item_id; cmd.Parameters.Add("@Item_nm", SqlDbType.NVarChar, 100).Value = d.Item_nm; cmd.Parameters.Add("@Item_price", SqlDbType.Int).Value = d.Item_price; cmd.Parameters.Add("@Item_url", SqlDbType.NVarChar, 500).Value = d.Item_url; cmd.Parameters.Add("@Writeday", SqlDbType.DateTime).Value = d.Writeday; int ix = h.ExcuteTransaction(cmd); return(ix); }
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); }