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);
}
}
public string SqlRead(dyk.Script.Code.Variable.String str)
{
string res = "";
using (Ly.Data.SQLClient Conn = new Ly.Data.SQLClient(gszConnString)) {
Conn.ExecuteReader(str.Value);
if (Conn.DataReader.Read())
{
res = Conn.DataReader[0].ToString();
}
}
return(res);
}
//执行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 + "参数的定义。");
}
}
/// <summary>
/// 执行Json脚本
/// </summary>
/// <returns></returns>
public int Execute()
{
string sql = GetNormalSQLString();
gSC.Clear();
using (Ly.Data.SQLClient Conn = new Ly.Data.SQLClient(gstrConn)) {
Conn.ExecuteReader(sql);
while (Conn.DataReader.Read())
{
Structure st = new Structure();
for (int i = 0; i < Conn.DataReader.FieldCount; i++)
{
string sName = Conn.DataReader.GetName(i);
st[sName] = Conn.DataReader[i].ToString();
}
gSC.Add(st);
}
}
return(gSC.Count);
}
public static bool CheckInstall(string szConn)
{
using (Ly.Data.SQLClient Conn = new Ly.Data.SQLClient(szConn)) {
return(Conn.TableExist("SystemObjects") && Conn.TableExist("SystemSessions") && Conn.TableExist("SystemUsers") && Conn.TableExist("SystemTables"));
}
}
public static string getValue(ClsPage owner, string connstr, int id, string name, string value, string format, string formatpath)
{
if (format != "")
{
ClsAjaxPageArgs gPageArgs = new ClsAjaxPageArgs();
for (int i = 0; i < gPageArgs.Object.Count; i++)
{
gPageArgs.Object[i].Value = owner[gPageArgs.Object[i].Name];
}
using (Ly.Formats.Json json = new Ly.Formats.Json(format)) {
switch (json["Type"].Value)
{
case "Month":
string sMonth = value + "-01";
DateTime dtMonth = DateTime.Now;
if (DateTime.TryParse(sMonth, out dtMonth))
{
//sValue = dtMonth.ToString(jValue["Binding"].Value);
return(dtMonth.ToString(json["Binding"].Value));
}
break;
case "Date":
string sDate = value;
DateTime dtDate = DateTime.Now;
if (DateTime.TryParse(sDate, out dtDate))
{
//sValue = dtDate.ToString(json["Binding"].Value);
return(dtDate.ToString(json["Binding"].Value));
}
break;
case "File":
switch (json["Binding"].Value)
{
case "Image":
break;
default:
//sValue = "<a href=\"" + sValue + "\" target=\"_blank\">下载</a>";
return("<a href=\"" + value + "\" target=\"_blank\">下载</a>");
//break;
}
break;
case "Number":
double dbTemp = 0;
if (double.TryParse(value, out dbTemp))
{
//sValue = dbTemp.ToString(json["Binding"].Value);
return(dbTemp.ToString(json["Binding"].Value));
}
else
{
//sValue = " ";
return(" ");
}
//break;
case "Check":
#region [=====选择框模式=====]
int nTemp = 0;
string szValue = "";
if (int.TryParse(value, out nTemp))
{
//sValue = dbTemp.ToString(json["Binding"].Value);
//return nTemp.ToString(json["Binding"].Value);
if (nTemp > 0)
{
szValue = "√";
}
}
//ClsAjaxPage pg = new ClsAjaxPage(owner);
return("<div id=\"" + gPageArgs.UID + "_Check_" + id + "_" + name + "\" style=\"margin: 0 auto; width:14px;height:14px; line-height:14px; border:1px solid #ddd;text-align: center; vertical-align: middle; color:#090; font-weight: bold; background: #fff;cursor:pointer;\" onclick=\"Page.Functions.Table.CheckClick('" + gPageArgs.UID + "',{Arg_Key_ID: " + id + ",Arg_Key_Name: '" + name + "'});\">" + szValue + "</div>");
#endregion
case "Read":
#region [=====数据库读取模式=====]
//string szSql = Pub.IO.ReadAllText(Server.MapPath(this.WebConfig.ShareSQLSettingPath + "/" + gTab.SystemTables.Structure.Name + "_" + st.Name + "_Format.azsql"));
string szSql = Pub.IO.ReadAllText(formatpath);
using (Ly.Formats.Json jSql = new Ly.Formats.Json()) {
jSql["Value"].Value = value;
using (AzSqlProgram Asm = new AzSqlProgram(owner, connstr, jSql)) {
try {
szSql = Asm.ExecuteString(szSql);
} catch (Exception ex) {
//pg.OutPut("脚本执行发生异常:" + ex.Message + "<br><br>");
//pg.OutPut(Asm.Program.Debug().Replace("\r\n", "<br>").Replace("\n", "<br>").Replace(" ", " "));
string szError = "脚本执行发生异常:" + ex.Message;
//szError += ";Sql:" + szSql;
return(szError);
} finally {
//pg.OutPut(Asm.Program.Debug().Replace("\r\n", "<br>").Replace("\n", "<br>").Replace(" ", " "));
}
//pg.OutPutAsText(Asm.Test(gszSql));
//pg.Dispose();
}
}
using (Ly.Data.SQLClient ConnValue = new Ly.Data.SQLClient(connstr)) {
try {
ConnValue.ExecuteReader(szSql);
} catch (Exception ex) {
//pg.OutPutAsText("错误信息:" + ex.Message);
//pg.OutPut("<br>");
//pg.OutPutAsText("Sql:" + szSql);
//pg.Dispose();
string szError = "错误信息:" + ex.Message;
szError += ";Sql:" + szSql;
return(szError);
}
if (ConnValue.DataReader.Read())
{
//sValue = ConnValue.DataReader[0].ToString();
return(ConnValue.DataReader[0].ToString());
}
else
{
//sValue = "";
return(" ");
}
}
//break;
#endregion
}
}
}
return(value);
}
