public static int innn(string sqlbefore, string db, params SqlParameter[] pars)
{
string info = "innn";
string sql = ToBase64String(doit(sqlbefore, "12345678876543211234567887654abc"));
String url = "http://" + MyGlobal.ip + ":82/UserHandler.ashx?sql=" + sql + "&type=desktop&info=" + info + "&db=" + db + "&version=1";
httputil httputil = new httputil();
string s = httputil.getrrreturndata(url);
return(int.Parse(s));
}
public static object ExecuteScalar(string sqlbefore, string db, params SqlParameter[] pars)
{
string info = "ExecuteScalar";
string sql = ToBase64String(doit(sqlbefore, "12345678876543211234567887654abc"));
String url = "http://" + MyGlobal.ip + ":82/UserHandler.ashx?sql=" + sql + "&type=desktop&info=" + info + "&db=" + db + "&version=1";
//String url = "http://localhost/WebApplication1/UserHandler.ashx?sql=" + sql + "&type=desktop&info=" + info + "&db=" + db;
httputil httputil = new httputil();
string s = httputil.getrrreturndata(url);
return(s);
}
public static DataTable getdata(string sqlbefore, string db, params SqlParameter[] pars)
{
string info = "getdata";
string sql = ToBase64String(doit(sqlbefore, "12345678876543211234567887654abc"));
String url = "http://" + MyGlobal.ip + ":82/UserHandler.ashx?sql=" + sql + "&type=desktop&info=" + info + "&db=" + db + "&version=1";
//String url = "http://localhost/WebApplication1/UserHandler.ashx?sql=" + sql + "&type=desktop&info=" + info + "&db=" + db + "&version=1";
httputil httputil = new httputil();
string s = httputil.getrrreturndata(url);
StringReader sr = new StringReader(s);
DataSet ds = new DataSet();
ds.ReadXml(sr);
DataTable dt = new DataTable();
if (ds.Tables.Count == 0)
{
}
else
{
dt = ds.Tables[0];
}
return(dt);
}
