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); }