public AzSqlProgram(ClsPage owner, string connstr, Ly.Formats.Json json)
{
//
// TODO: 在此处添加构造函数逻辑
//
gPro = new Ly.ZBox.Program("", new AzSqlLibrary(owner, connstr, json));
}
protected void Page_Load(object sender, EventArgs e)
{
gTabs = new Ly.DB.Dream.Tables(this.ConnectString);
gstrPath = "";
if (Request["Path"] != null)
{
gstrPath = Request["Path"].ToString().Trim().Replace("\\", "/");
}
if (gstrPath.StartsWith("/") || gstrPath.IndexOf("..") >= 0)
{
gstrPath = "";
}
if (gstrPath != "" && !gstrPath.EndsWith("/"))
{
gstrPath += "/";
}
gstrFullPath = "/" + gstrPath;
gJson = new Ly.Formats.Json(Pub.IO.ReadAllText(Server.MapPath(this.WebConfig.SystemExtensionPath)));
gnType = Ly.String.Source(this["Type"]).toInteger;
gnChat = Ly.String.Source(this["ID"]).toInteger;
gszTempSign = this["Sign"];
if (gnType <= 0 || gnType > 4)
{
gnType = 1;
gnChat = (int)this.UserInfo.Department;
}
gszSign = "";
switch (gnType)
{
case 1:
gszSign = "Department:" + gnChat;
break;
case 2:
gszSign = "User:"******"Group:" + gnChat;
break;
case 4:
gszSign = gszTempSign;
gnChat = 0;
break;
}
if (gszSign == "")
{
gszSign = "Unknow";
}
}
public AzSqlLibrary(ClsPage owner, string connstr, Ly.Formats.Json json)
{
//
// TODO: 在此处添加构造函数逻辑
//
gTab = new Ly.DB.Dream.Tables(connstr);
gnTable = 0;
gbTable = false;
gParent = owner;
gJson = json;
gszConnString = connstr;
}
protected void Page_Load(object sender, EventArgs e)
{
gszTable = this["Table"];
gnTableID = Ly.String.Source(this["ID"]).toInteger;
//gszConnString = Pub.IO.ReadAllText(Server.MapPath(this.WebConfig.ConnectStringPath));
//gTab = new Ly.DB.Dream.AzTables(gszConnString);
gszConnString = this.BaseConnectString;
//检测登录状态
if (this.UserInfo.ID <= 0)
{
Response.Redirect("/Default.aspx");
}
gSystemTables = new dyk.DB.Base.SystemTables.ExecutionExp(gszConnString);
gSystemColumns = new dyk.DB.Base.SystemColumns.ExecutionExp(gszConnString);
if (gnTableID > 0)
{
if (gSystemTables.GetDataByID(gnTableID))
{
gSystemColumns.GetDatasByParentID(gnTableID);
gszTable = gSystemTables.Structure.Text;
}
}
gszUIPath = gSystemTables.Structure.SavePath + "/UI.json";
//if (gSystemTables.Structure.ID > 0) {
// gszUIPath = this.WebConfig.SharePath + "/" + gSystemTables.Structure.Name + "/UI.json";
//} else {
// gszUIPath = this.WebConfig.SharePath + "/" + gszTable + "/UI.json";
//}
//gszColPath = Server.MapPath(this.WebConfig.SystemColumnsSettingPath + "/" + gszTable + ".json");
//if (System.IO.File.Exists(gszColPath))
//{
// gszJsonCol = Pub.IO.ReadAllEncryptionText(gszColPath);
//}
//else
//{
// gszJsonCol = "{}";
// Pub.IO.WriteAllEncryptionText(gszColPath, gszJsonCol);
//}
if (System.IO.File.Exists(Server.MapPath(gszUIPath)))
{
gszJsonUI = Pub.IO.ReadAllEncryptionText(Server.MapPath(gszUIPath));
}
else
{
gszJsonUI = "{}";
Pub.IO.WriteAllEncryptionText(Server.MapPath(gszUIPath), gszJsonUI);
}
//gJsonCol = new Ly.Formats.Json(Pub.IO.ReadAllEncryptionText(gszColPath));
gJsonUI = new Ly.Formats.Json(gszJsonUI);
}
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);
}
