public static List <String> GetJoinData(string sql, params object[] values) { List <String> tablo = new List <string>(); int kayit = 0; try { if (sql.IndexOf("INNER JOIN") != -1 || sql.IndexOf("LEFT JOIN") != -1 || sql.IndexOf("Inner Join") != -1 || sql.IndexOf("Left Join") != -1 || sql.IndexOf("inner join") != -1 || sql.IndexOf("left join") != -1) { DataSet ds = WebFramework.DataSetFill(sql, values); String verikumesi = null; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { for (int j = 0; j < ds.Tables[0].Columns.Count; j++) { verikumesi += ds.Tables[0].Rows[i][j] + Config.parse.ToString(); } verikumesi = verikumesi.Remove(verikumesi.Length - 1); tablo.Add(verikumesi); verikumesi = null; } kayit = ds.Tables[0].Rows.Count; if (Config.debug == true) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + System.Environment.NewLine + "Count: " + kayit); } return(tablo); } else { if (Config.debug == true) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + System.Environment.NewLine + "Count: " + kayit); } tablo.Add(""); return(tablo); } } else { if (Config.debug == true) { FrameworkHandler.DebugLogger(sql + System.Environment.NewLine + "Could not execute SQL query could not be found in the inner join and left join, please check your query."); } tablo.Add("Couldn't run Sql in question, please check your query."); return(tablo); } } catch (Exception hata) { if (Config.debug == true) { FrameworkHandler.DebugLogger(hata.ToString()); } tablo.Add("Error:" + hata.Message); return(tablo); } }
public static string GetCountData(string sql, params object[] values) { try { int pFrom = sql.IndexOf("AS ") + "AS ".Length; int pTo = sql.LastIndexOf(" FROM "); String sonuc = sql.Substring(pFrom, pTo - pFrom).Trim(); int verikumesi = 0; DataSet ds = WebFramework.DataSetFill(sql, values); if (ds.Tables[0].Rows.Count > 0) { verikumesi = ds.Tables[0].Rows[0].Field <int>(sonuc.Trim()); } else { verikumesi = 0; } if (Config.debug == true) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + System.Environment.NewLine + "Return: " + verikumesi); } return(verikumesi.ToString()); } catch (Exception hata) { if (Config.debug == true) { FrameworkHandler.DebugLogger(hata.ToString()); } return("Error: " + hata.Message); } }
/// <summary> /// Bir tablodan obje değişkenlerinden kayıt getirir. Sadece tek satır kayıt gibi çok fonksiyonlu sql destekler.' /// </summary> /// <param name="sql">Bir sql ifadesi girin.</param> /// <param name="values">sql parametre değerlerini girin.</param> public static T GetSingleData <T>(String sql, params object[] values) { try { Type tip = typeof(T); PropertyInfo[] ps = tip.GetProperties(); DataSet ds = WebFramework.DataSetFill(sql, values); List <T> liste = new List <T>(); var obj = Activator.CreateInstance <T>(); liste.Add(obj); if (ds.Tables[0].Rows.Count > 0) { foreach (var properti in ps) { object deger = null; try { deger = ds.Tables[0].Rows[0].Field <Object>(properti.Name); Type t = Nullable.GetUnderlyingType(properti.PropertyType) ?? properti.PropertyType; object safeValue = (deger == null) ? null : Convert.ChangeType(deger, t); properti.SetValue(obj, safeValue, null); } catch (Exception hata) { if (Config.debug == true) { FrameworkHandler.DebugLogger(hata.ToString()); } } } } if (Config.debug == true) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + System.Environment.NewLine + " Count: " + ds.Tables[0].Rows.Count); } if (ds.Tables[0].Rows.Count > 0) { return(liste[0]); } else { return(default(T)); } } catch (Exception hata) { if (Config.debug == true) { FrameworkHandler.DebugLogger(hata.ToString()); } return(default(T)); } }
public static List <String> GetData(String sql, params object[] values) { List <String> tablo = new List <string>(); try { int pFrom = sql.IndexOf("SELECT ") + "SELECT ".Length; int pTo = sql.LastIndexOf(" FROM "); String sonuc = sql.Substring(pFrom, pTo - pFrom).Trim(); String[] kolonlar = sonuc.Split(','); int kayit = 0; if (sonuc == "*") { tablo.Add("An error occurred while returning the dataset *, please specify the column names instead."); } else { DataSet ds = WebFramework.DataSetFill(sql, values); String verikumesi = null; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { for (int j = 0; j < kolonlar.Length; j++) { verikumesi += ds.Tables[0].Rows[i].Field <Object>(kolonlar[j].Trim()) + Config.parse.ToString(); } verikumesi = verikumesi.Remove(verikumesi.Length - 1); tablo.Add(verikumesi); verikumesi = null; } kayit = ds.Tables[0].Rows.Count; } else { tablo.Add(""); } } if (Config.debug == true) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + System.Environment.NewLine + "Count: " + kayit); } return(tablo); } catch (Exception hata) { tablo.Add("Error: " + hata.Message); if (Config.debug == true) { FrameworkHandler.DebugLogger(hata.ToString()); } return(tablo); } }
protected override void RenderContents(HtmlTextWriter output) { String html = ""; output.AddAttribute(HtmlTextWriterAttribute.Id, this.ID); if (Class != null) { output.AddAttribute("class", this.Class); } try { DataSet ds = null; if (SQL != "") { string prov = Config.provider.ToString(); if (prov == "MSSQL") { ds = WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } else if (prov == "MYSQL") { ds = MySQLDb.WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } else if (prov == "ACCESS") { ds = AccessDb.WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } else if (prov == "ORACLE") { ds = OracleDb.WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { html += "<li data-id='" + ds.Tables[0].Rows[i].Field <Object>(Value) + "'>" + ds.Tables[0].Rows[i].Field <Object>(DisplayValue) + "</li>"; } } } output.RenderBeginTag("ul"); } catch (Exception hata) { output.RenderBeginTag("div"); html = "<p style='color:red;'><strong>Hata:</strong> " + hata.Message + "</p>"; } output.Write(html); output.RenderEndTag(); }
public static string GetSingleData(String sql, params object[] values) { try { int kayit = 0; int pFrom = sql.IndexOf("SELECT ") + "SELECT ".Length; int pTo = sql.LastIndexOf(" FROM "); String sonuc = sql.Substring(pFrom, pTo - pFrom).Trim(); String verikumesi = null; String[] kolonlar = sonuc.Split(','); if (sonuc == "*") { verikumesi = "An error occurred while rotating the line * instead of the column names."; } else { DataSet ds = WebFramework.DataSetFill(sql, values); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < kolonlar.Length; i++) { verikumesi += ds.Tables[0].Rows[0].Field <Object>(kolonlar[i].Trim()) + Config.parse.ToString(); } } else { verikumesi = ""; } kayit = ds.Tables[0].Rows.Count; verikumesi = verikumesi.Remove(verikumesi.Length - 1); } if (Config.debug) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + System.Environment.NewLine + "Count: " + kayit); } return(verikumesi); } catch (Exception hata) { if (Config.debug) { FrameworkHandler.DebugLogger(hata.ToString()); } return("Error: " + hata.Message); } }
public static string GetJSONData(string sql, params object[] values) { try { WebFramework web = new WebFramework(); DataTable dt = web.DataTableGetir(sql, values); if (Config.debug == true) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + " \nCount: " + dt.Rows.Count); } return(Utils.GetJson(dt)); } catch (Exception hata) { if (Config.debug == true) { FrameworkHandler.DebugLogger(hata.ToString()); } return("Error: " + hata.Message); } }
///<summary>ASP.NET taglarını referans ederek UIControl nesnelerine erişerek nesneler oluşturabilirsiniz. ///Örnek: Response.Write(getUI(tablo, sql)) veya Literal1.Text = getUI(tablo, sql) daha fazlası için dökümana bakınız.</summary> ///<param name="tablo">Tablonun UIControl nesnelerine erişmek için bu alan girilmek zorundadır. </param> ///<param name="sql">Tabloyu veritabanından doldurmak istiyorsanız bir sql giriniz eğer doldurmak istemiyorsanız bu alanı boş bırakabilirsiniz.</param> ///<param name="section">UIControl alanlarının oluşturulması için gereken bölüm ismi bu bölüm UIControl özelliklerinde sections parametresinde verdiğiniz bir değeri içerir. (Bu alan doldurulmak zorundadır.)</param> public static string getUI(Type tablo, String sql, String section, params object[] sqlparametreler) { String html = ""; try { DataSet ds = null; if (sql != "") { string prov = Config.provider.ToString(); if (prov == "MSSQL") { ds = WebFramework.DataSetFill(sql, sqlparametreler); } else if (prov == "MYSQL") { ds = MySQLDb.WebFramework.DataSetFill(sql, sqlparametreler); } else if (prov == "ACCESS") { ds = AccessDb.WebFramework.DataSetFill(sql, sqlparametreler); } else if (prov == "ORACLE") { ds = OracleDb.WebFramework.DataSetFill(sql, sqlparametreler); } } PropertyInfo[] props = tablo.GetProperties(); string propName = "", label = "", tip = "", sinif = "", placeholder = "", selectSQL = ""; int maks = 0; Boolean zorunlu = false; foreach (PropertyInfo prop in props) { object[] attrs = prop.GetCustomAttributes(true); foreach (object attr in attrs) { UIController fieldlar = attr as UIController; if (fieldlar != null) { try { propName = prop.Name; zorunlu = fieldlar.Required; label = fieldlar.Label; tip = fieldlar.Tip.ToString(); sinif = fieldlar.Class.ToString(); maks = fieldlar.MaxLength; placeholder = fieldlar.PlaceHolder; selectSQL = fieldlar.SQL; } catch { //Boş field olsa dahi çalışmaya devam edecektir. } string[] sections = fieldlar.Sections.Trim().Split(','); for (int s = 0; s < sections.Length; s++) { if (sections[s].Trim() == section) { if (label != "") { if (tip != "HIDDEN") { html += "<div class='control controlLabel' id='" + Utils.ClearTurkishLetter(section) + "_lbl_" + propName + "'><label for='" + propName + "'>" + label + "</label></div> "; } } if (tip == "TEXTBOX") { if (sql != "") { if (ds.Tables[0].Rows.Count > 0) { html += "<div class='control controlInput' id='" + Utils.ClearTurkishLetter(section) + "_text_" + propName + "'><input id='" + propName + "' name='" + propName + "' class='" + sinif + "' type='text' value='" + ds.Tables[0].Rows[0].Field <Object>(propName) + "'"; } else { html += "<div class='control controlInput' id='" + Utils.ClearTurkishLetter(section) + "_text_" + propName + "'><input id='" + propName + "' name='" + propName + "' class='" + sinif + "' type='text' value=''"; } } else { html += "<div class='control controlInput' id='" + Utils.ClearTurkishLetter(section) + "_text_" + propName + "'><input id='" + propName + "' name='" + propName + "' class='" + sinif + "' type='text'"; } if (zorunlu == true) { html += " required='required' "; } if (maks > 0) { html += " maxlength='" + maks + "' "; } if (placeholder != "") { html += " placeholder='" + placeholder + "' "; } html += "/></div>"; } else if (tip == "CHECKBOX") { html += "<div class='control controlInput' id='" + Utils.ClearTurkishLetter(section) + "_checkbox_" + propName + "'><input id='" + propName + "' name='" + propName + "' class='" + sinif + "' type='checkbox' value='" + fieldlar.value + "'"; if (sql != "") { if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0].Field <Object>(propName) != null) { if (ds.Tables[0].Rows[0].Field <Object>(propName).ToString() == "E" || ds.Tables[0].Rows[0].Field <Object>(propName).ToString() == "Y" || ds.Tables[0].Rows[0].Field <Object>(propName).ToString() == "1" || ds.Tables[0].Rows[0].Field <Object>(propName).ToString() == "true" || ds.Tables[0].Rows[0].Field <Object>(propName).ToString() == "True") { html += " value='" + ds.Tables[0].Rows[0].Field <Object>(propName) + "' checked='checked' "; } } } } if (zorunlu == true) { html += " required='required' "; } html += "/></div>"; } else if (tip == "TEXTAREA") { html += "<div class='control controlTextArea' id='" + Utils.ClearTurkishLetter(section) + "_textarea_" + propName + "'><textarea id='" + propName + "' name='" + propName + "' class='" + sinif + "'"; if (zorunlu == true) { html += " required='required' "; } if (maks > 0) { html += " maxlength='" + maks + "' "; } if (placeholder != "") { html += " placeholder='" + placeholder + "' "; } if (sql != "") { if (ds.Tables[0].Rows.Count > 0) { html += ">" + ds.Tables[0].Rows[0].Field <Object>(propName) + "</textarea></div>"; } else { html += "></textarea></div>"; } } else { html += "></textarea></div>"; } } else if (tip == "SELECT") { html += "<div class='control controlSelect' id='" + Utils.ClearTurkishLetter(section) + "_select_" + propName + "'><select id='" + propName + "' name='" + propName + "' class='" + sinif + "'"; if (zorunlu == true) { html += "required='required'"; } if (selectSQL != "") { DataSet dsSelect = null; string prov = Config.provider.ToString(); if (prov == "MSSQL") { dsSelect = WebFramework.DataSetFill(selectSQL, sqlparametreler); } else if (prov == "MYSQL") { dsSelect = MySQLDb.WebFramework.DataSetFill(selectSQL, sqlparametreler); } else if (prov == "ACCESS") { dsSelect = AccessDb.WebFramework.DataSetFill(selectSQL, sqlparametreler); } else if (prov == "ORACLE") { dsSelect = OracleDb.WebFramework.DataSetFill(selectSQL, sqlparametreler); } if (dsSelect.Tables[0].Rows.Count > 0) { html += ">"; for (int i = 0; i < dsSelect.Tables[0].Rows.Count; i++) { if (sql == "" || sql == null) { html += "<option value='" + dsSelect.Tables[0].Rows[i].Field <Object>(fieldlar.value) + "'>" + dsSelect.Tables[0].Rows[i].Field <Object>(fieldlar.displayValue) + "</option>"; } else { if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0].Field <Object>(propName).ToString() == dsSelect.Tables[0].Rows[i].Field <Object>(fieldlar.value).ToString()) { html += "<option selected value='" + dsSelect.Tables[0].Rows[i].Field <Object>(fieldlar.value) + "'>" + dsSelect.Tables[0].Rows[i].Field <Object>(fieldlar.displayValue) + "</option>"; } else { html += "<option value='" + dsSelect.Tables[0].Rows[i].Field <Object>(fieldlar.value) + "'>" + dsSelect.Tables[0].Rows[i].Field <Object>(fieldlar.displayValue) + "</option>"; } } else { html += "<option value='" + dsSelect.Tables[0].Rows[i].Field <Object>(fieldlar.value) + "'>" + dsSelect.Tables[0].Rows[i].Field <Object>(fieldlar.displayValue) + "</option>"; } } } html += "</select></div>"; } else { html += "></select></div>"; } } else { html += "></select></div>"; } } else if (tip == "FILEUPLOAD") { html += "<div class='control controlInput' id='" + Utils.ClearTurkishLetter(section) + "_fileupload_" + propName + "'><input id='" + propName + "' name='" + propName + "' class='" + sinif + "' type='file'"; if (zorunlu == true) { html += "required='required'"; } html += "/></div>"; } else if (tip == "PASSWORD") { html += "<div class='control controlInput' id='" + Utils.ClearTurkishLetter(section) + "_pass_" + propName + "'><input id='" + propName + "' name='" + propName + "' class='" + sinif + "' type='password'"; if (zorunlu == true) { html += "required='required'"; } if (maks > 0) { html += "maxlength='" + maks + "'"; } if (placeholder != "") { html += "placeholder='" + placeholder + "'"; } html += "/></div>"; } else if (tip == "HIDDEN") { if (sql != "") { if (ds.Tables[0].Rows.Count > 0) { html += "<input id=\"" + propName + "\" name=\"" + propName + "\" value=\"" + ds.Tables[0].Rows[0].Field <Object>(propName) + "\""; } else { html += "<input id=\"" + propName + "\" name=\"" + propName + "\" value=\"\" "; } } else { html += "<input id='" + propName + "' name='" + propName + "' "; } if (zorunlu == true) { html += " required=\"required\" "; } html += " type=\"hidden\" />"; } } } } } } } catch (Exception hata) { html += "<p style='color:red;'><strong>Hata:</strong> " + hata.Message + "</p>"; } return(html); }
protected override void RenderContents(HtmlTextWriter output) { String html = ""; output.AddAttribute(HtmlTextWriterAttribute.Id, this.ID); if (Class != null) { output.AddAttribute("class", this.Class); } try { DataSet ds = null; if (SQL != "") { string[] kolonlar = Columns.Split(','); string[] fieldlar = DisplayFields.Split(','); string prov = Config.provider.ToString(); if (prov == "MSSQL") { ds = WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } else if (prov == "MYSQL") { ds = MySQLDb.WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } else if (prov == "ACCESS") { ds = AccessDb.WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } else if (prov == "ORACLE") { ds = OracleDb.WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } if (ds.Tables[0].Rows.Count > 0) { html += "<thead><tr>"; for (int i = 0; i < fieldlar.Length; i++) { html += "<td>" + fieldlar[i].Trim() + "</td>"; } String content = ""; if (this.Content != null) { Control templateContainer = new Control(); Content.InstantiateIn(templateContainer); content = RenderControl(templateContainer); } if (content != "") { html += "<td class='tablecontrol_content'>" + ContentHeaderTitle + "</td>"; } html += "</tr></thead>"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (PrimaryKey != "") { html += "<tr data-id='" + ds.Tables[0].Rows[i].Field <Object>(PrimaryKey) + "'>"; } else { html += "<tr>"; } for (int j = 0; j < kolonlar.Length; j++) { html += "<td>" + ds.Tables[0].Rows[i].Field <Object>(kolonlar[j].Trim()) + "</td>"; } if (content != "") { html += "<td>" + content + "</td>"; } html += "</tr>"; } } } output.RenderBeginTag("table"); } catch (Exception hata) { output.RenderBeginTag("div"); html += "<p style='color:red;'><strong>Hata:</strong> " + hata.Message + "</p>"; } output.Write(html); output.RenderEndTag(); }
protected override void RenderContents(HtmlTextWriter output) { output.AddAttribute(HtmlTextWriterAttribute.Id, this.ID); if (Class != null) { output.AddAttribute("class", this.Class); } output.RenderBeginTag("div"); output.BeginRender(); try { Type tablo = null; if (this.Content != null) { Control templateContainer = new Control(); Content.InstantiateIn(templateContainer); var s = RenderControl(templateContainer); html = s; // HttpContext.Current.Response.Write("<textarea>"+s+"</textarea>"); } try { tablo = GetType(DataSource); } catch { //DataSource Attributesi boş ise } if (SQL != string.Empty) { HtmlAgilityPack.HtmlDocument dokuman = new HtmlAgilityPack.HtmlDocument(); dokuman.LoadHtml(html); //html = dokuman.DocumentNode.OuterHtml; //Template üzerinde manipule edilen html manipule edilmiş hali ile Content değişkenine atılıyor. //dokuman.LoadHtml(html); PropertyInfo[] props = tablo.GetProperties(); DataSet ds = new DataSet(); string prov = Config.provider.ToString(); if (prov == "MSSQL") { ds = WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } else if (prov == "MYSQL") { ds = MySQLDb.WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } else if (prov == "ACCESS") { ds = AccessDb.WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } else if (prov == "ORACLE") { ds = OracleDb.WebFramework.DataSetFill(SQL, SQLParams.ToArray()); } if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { var paragraflar = dokuman.DocumentNode.SelectNodes("//p[@data-name]"); //Paragraf tagları değişkene atılıyor. if (paragraflar != null) { foreach (HtmlNode node in paragraflar) //düğüm null'dan farklı ise döngüye sokuluyor { object nodeDataName = node.Attributes["data-name"].Value; //düğümdeki data-name attribute değerini okur. //[@data-name='ADSOYAD'] if (nodeDataName != null || nodeDataName.ToString() != String.Empty) //Eğer data-name null'dan veya boş'dan farklı ise { //Model sınıfındaki propertiler döngüye sokulur. foreach (PropertyInfo prop in props) { //Stabil ve doğruluk olması amacıyla model dosyasındaki properti isim ile düğümdeki data-name eşit ise veritabanından veri okulur. if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); //tablo örneğinden sütün adının propertisi okunuyor if (veri != null) //Kayıt null'dan farklı ise { node.InnerHtml += veri.ToString(); //InnerHtml ile tagların arasına ekliyor node.Attributes.Remove("data-name"); //Güvenlik amaçlı data-name attirubetesi siliniyor. } } } } } } var inputlar = dokuman.DocumentNode.SelectNodes("//input[@data-name]"); if (inputlar != null) { foreach (HtmlNode node in inputlar) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null || nodeDataName.ToString() != String.Empty) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { string nodeType = node.Attributes["type"].Value; if (nodeType == "text" || nodeType == "email" || nodeType == "password" || nodeType == "hidden") { node.SetAttributeValue("value", veri.ToString()); } else if (nodeType == "radio" || nodeType == "checkbox") { if (node.Attributes["value"].Value == veri.ToString()) { node.SetAttributeValue("checked", "checked"); } } node.Attributes.Remove("data-name"); } } } } } } var divler = dokuman.DocumentNode.SelectNodes("//div[@data-name]"); if (divler != null) { foreach (HtmlNode node in divler) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null || nodeDataName.ToString() != String.Empty) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.InnerHtml += veri.ToString(); node.Attributes.Remove("data-name"); } } } } } } var imgs = dokuman.DocumentNode.SelectNodes("//img[@data-name]"); if (imgs != null) { foreach (HtmlNode node in imgs) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.SetAttributeValue("src", veri.ToString()); node.Attributes.Remove("data-name"); } } } } } } var textarealar = dokuman.DocumentNode.SelectNodes("//textarea[@data-name]"); if (textarealar != null) { foreach (HtmlNode node in textarealar) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null || nodeDataName.ToString() != String.Empty) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.InnerHtml = veri.ToString(); node.Attributes.Remove("data-name"); } } } } } } var lis = dokuman.DocumentNode.SelectNodes("//li[@data-name]"); if (lis != null) { foreach (HtmlNode node in lis) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null || nodeDataName.ToString() != String.Empty) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.InnerHtml += veri.ToString(); node.Attributes.Remove("data-name"); } } } } } } var tds = dokuman.DocumentNode.SelectNodes("//td[@data-name]"); if (tds != null) { foreach (HtmlNode node in tds) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null || nodeDataName.ToString() != String.Empty) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.InnerHtml += veri.ToString(); node.Attributes.Remove("data-name"); } } } } } } var spanlar = dokuman.DocumentNode.SelectNodes("//span[@data-name]"); if (spanlar != null) { foreach (HtmlNode node in spanlar) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null || nodeDataName.ToString() != String.Empty) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.InnerHtml += veri.ToString(); node.Attributes.Remove("data-name"); } } } } } } var sources = dokuman.DocumentNode.SelectNodes("//source[@data-name]"); if (sources != null) { foreach (HtmlNode node in sources) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.SetAttributeValue("src", veri.ToString()); node.Attributes.Remove("data-name"); } } } } } } var iframes = dokuman.DocumentNode.SelectNodes("//iframe[@data-name]"); if (iframes != null) { foreach (HtmlNode node in iframes) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.SetAttributeValue("src", veri.ToString()); node.Attributes.Remove("data-name"); } } } } } } var labels = dokuman.DocumentNode.SelectNodes("//label[@data-name]"); if (labels != null) { foreach (HtmlNode node in labels) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.InnerHtml += veri.ToString(); node.Attributes.Remove("data-name"); } } } } } } var selects = dokuman.DocumentNode.SelectNodes("//select[@data-name]/option"); if (selects != null) { foreach (HtmlNode node in selects) { object nodeDataName = node.ParentNode.Attributes["data-name"].Value; if (nodeDataName != null) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { if (node.Attributes["value"].Value == veri.ToString()) { node.SetAttributeValue("selected", ""); } } } } } } } //Select optionları seçildikten sonra kalan ve seçilen selectlerin data-name attributeler siliniyor. var selects2 = dokuman.DocumentNode.SelectNodes("//select[@data-name]"); if (selects2 != null) { foreach (HtmlNode node in selects2) { node.Attributes.Remove("data-name"); } } var a = dokuman.DocumentNode.SelectNodes("//a[@data-name]"); if (a != null) { foreach (HtmlNode node in a) { //a tagının hem href hemde yazılacak bir text alanı olduğu için bu iki parametreli alıyor. ÖRNEK: KULLANICI_ID, KULLANICI_ADI //0.indis = href, 1.indis = text alanı object nodeDataName = node.Attributes["data-name"].Value; string[] nodeDataNames = nodeDataName.ToString().Trim().Split(','); //Boşluklar temizlenip virgül ile ayrılıyor değerler. if (nodeDataNames != null) { foreach (PropertyInfo prop in props) { try { if (nodeDataName.ToString().IndexOf(",") == -1) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); string href = null; try { href = node.Attributes["href"].Value; } catch { href = ""; } node.SetAttributeValue("href", href + veri.ToString()); } } else { if (prop.Name == nodeDataNames[1].Trim()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.InnerHtml += veri.ToString(); } } else if (prop.Name == nodeDataNames[0].Trim()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); string href = null; try { href = node.Attributes["href"].Value; } catch { href = ""; } node.SetAttributeValue("href", href + veri.ToString()); } } } catch { } } } node.Attributes.Remove("data-name"); } } var headers = dokuman.DocumentNode.SelectNodes("//*[self::h1[@data-name] or self::h2[@data-name] or self::h3[@data-name] or self::h4[@data-name] or self::h5[@data-name] or self::h6[@data-name]]"); if (headers != null) { foreach (HtmlNode node in headers) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.InnerHtml += veri.ToString(); node.Attributes.Remove("data-name"); } } } } } } var progress = dokuman.DocumentNode.SelectNodes("//progress[@data-name]"); if (progress != null) { foreach (HtmlNode node in progress) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.SetAttributeValue("value", veri.ToString()); node.Attributes.Remove("data-name"); } } } } } } var meters = dokuman.DocumentNode.SelectNodes("//meter[@data-name]"); if (meters != null) { foreach (HtmlNode node in meters) { object nodeDataName = node.Attributes["data-name"].Value; if (nodeDataName != null) { foreach (PropertyInfo prop in props) { if (prop.Name == nodeDataName.ToString()) { Object veri = ds.Tables[0].Rows[i].Field <Object>(prop.Name); if (veri != null) { node.SetAttributeValue("value", veri.ToString()); node.Attributes.Remove("data-name"); } } } } } } tempHTML += dokuman.DocumentNode.OuterHtml; dokuman.LoadHtml(html); } ds = new DataSet(); ds.Dispose(); output.Write(tempHTML); output.RenderEndTag(); output.EndRender(); } else { //ds kaynağında hiç kayıt yok ise. output.Write(html); output.RenderEndTag(); output.EndRender(); } } else { //SQL Attributesi boş ise output.Write(html); output.RenderEndTag(); output.EndRender(); } } catch (Exception hata) { output.RenderBeginTag("div"); html = "<p style='color:red;'><strong>Hata:</strong> " + hata + "</p>"; output.Write(html); output.RenderEndTag(); output.EndRender(); } finally { tempHTML = ""; html = ""; } }