protected void Page_Load(object sender, EventArgs e)
{
ClsAjaxRequest js = new ClsAjaxRequest();
gstrTable = Pub.Request(this, "Table");
gintDB = Ly.String.Source(Pub.Request(this, "DB")).toInteger;
gstrConnString = Pub.IO.ReadAllText(Server.MapPath(WebConfig.SZ_PATH_CONNECTSTRING));
try {
using (System.IO.FileStream fs = System.IO.File.Open(Server.MapPath(WebConfig.SZ_PATH_INSTALLSQL + "/" + gstrTable + ".txt"), System.IO.FileMode.Open, System.IO.FileAccess.Read, System.IO.FileShare.ReadWrite)) {
byte[] bs = new byte[fs.Length];
fs.Read(bs, 0, (int)fs.Length);
gstrContext = System.Text.Encoding.UTF8.GetString(bs);
}
using (Ly.Data.SQLClient Conn = new Ly.Data.SQLClient(gstrConnString)) {
Conn.ExecuteNonQuery(gstrContext);
}
js.Message = "执行成功!";
js.Refresh = 1;
} catch (Exception ex) {
js.Message = "执行发生异常:\\n" + ex.Message;
}
Response.Write(js.ToString());
Response.End();
}
public void SqlExecute(dyk.Script.Code.Variable.String str)
{
try {
using (Ly.Data.SQLClient Conn = new Ly.Data.SQLClient(gszConnString)) {
Conn.ExecuteNonQuery(str.Value);
}
} catch (Exception ex) {
throw new Exception("数据库执行发生异常:" + ex.Message + ";执行语句:" + str.Value);
}
}
//执行SQL语句并返回首行的第一个值
private string Fun_SqlExecute(List <StorageUnit> list, StoragePool pool)
{
switch (list.Count)
{
case 1:
string szArg0 = Ly.ZBox.StorageUnit.GetStringValue(list[0], pool);
string res = "";
using (Ly.Data.SQLClient Conn = new Ly.Data.SQLClient(gszConnString)) {
Conn.ExecuteNonQuery(szArg0);
}
return(res);
default:
throw new Exception("参数数量不正确，未找到" + list.Count + "参数的定义。");
}
}
