public string GetHtml() { StringBuilder sb = new StringBuilder(); if (String.IsNullOrEmpty(FieldName)) { return(Provider.DesignMode ? Provider.GetResource("Select field name") : String.Empty); } Type entityType = Provider.GetEntityType(EntityName); Type fieldType = entityType.GetProperty(FieldName).PropertyType; PropertyInfo pi = entityType.GetProperty(FieldName); ColumnDetailAttribute attrField = (ColumnDetailAttribute)CMSUtility.GetAttribute(pi, typeof(ColumnDetailAttribute)); EditFormFieldPropsAttribute attrEdit = (EditFormFieldPropsAttribute)CMSUtility.GetAttribute(pi, typeof(EditFormFieldPropsAttribute)); ControlType ct = attrEdit.ControlType; if (ct == ControlType.Undefined) { ct = Provider.GetDefaultControlType(attrField.ColumnType, pi, attrField); } string label = FieldName.HumanReadable(); sb.AppendFormat(@" <div class=""form-group""> <label for=""{0}"" class=""col-sm-4 control-label no-padding-right""> {1} </label> <div class=""{3}""> {2} </div> </div>", FieldName, label, GetControlHtml(fieldType, attrField, attrEdit, ct), ct == ControlType.DateTimeEdit ? "col-sm-4 col-xs-6 input-group" : "col-sm-8"); return(sb.ToString()); }
private string getModuleTypesJSON() { SortedDictionary <string, ArrayList> grups = new SortedDictionary <string, ArrayList>(); foreach (Type type in Provider.GetModuleTypes()) { ModuleInfoAttribute mInfo = (ModuleInfoAttribute)CMSUtility.GetAttribute(type, typeof(ModuleInfoAttribute)); string grup = Provider.GetResource(mInfo.Grup); if (!mInfo.Visible) { continue; //*** } if (!grups.ContainsKey(grup)) { grups.Add(grup, new ArrayList()); } grups[grup].Add("{name:'" + Provider.GetResource(type.Name) + "',id:'" + type.Name + "'}"); } ArrayList res = new ArrayList(); foreach (string grup in grups.Keys) { //grups[grup].Sort(); res.Add("{grup:'" + grup + "', items:[" + String.Join(",", (string[])grups[grup].ToArray(typeof(string))) + "]}"); } return("[" + String.Join(",", (string[])res.ToArray(typeof(string))) + "]"); }
private string getEntityTypesJSON() { ArrayList al = new ArrayList(); foreach (Type type in Provider.GetEntityTypes()) { ListFormPropsAttribute attr = (ListFormPropsAttribute)CMSUtility.GetAttribute(type, typeof(ListFormPropsAttribute)); //if (attr.VisibleAtMainMenu) al.Add(String.Format("['{0}','{1}',{2}]", type.Name, Provider.GetResource(type.Name), attr.VisibleAtMainMenu.ToJS())); } //al.Sort(); return("[" + String.Join(",", (string[])al.ToArray(typeof(string))) + "]"); }
private List <string> getColumnCategories() { List <string> res = new List <string>(); foreach (Column field in Provider.Database.Tables[EntityName].Columns) { EditFormFieldPropsAttribute attrEdit = (EditFormFieldPropsAttribute)CMSUtility.GetAttribute(Provider.GetEntityType(EntityName).GetProperty(field.Name), typeof(EditFormFieldPropsAttribute)); if (field.IsPrimaryKey || !attrEdit.Visible) { continue; //*** } res.Add(attrEdit.Category); } return(res.Distinct().ToList()); }
private string generateFormHtml() { StringBuilder sb = new StringBuilder(); sb.AppendFormat(@"$ var e = new {0}(); var id = int.Parse(Provider.Request.eId ?? ""0""); if(id>0) e = Provider.Database.Read(typeof({0}), id); if(Provider.Request.cmdName){{ if(Provider.Request.cmdName==""save"") {{ e.SetFieldsByPostData(Provider.Request.Form); e.Save(); Provider.Response.Redirect(""/{0}View.aspx?eId=""+e.Id); }} }} $ <script> \$(function(){{ loadForm('#form', $=Utility.ToJSON(e)$, '$=Provider.Request.mode$'); }}); </script> <div class=""page-header""> <h1> {0} <small> <i class=""icon-double-angle-right""></i> $=e.Id > 0 ? 'Edit details' : 'Add new'$ </small> </h1> </div> <form id=""form"" method=""post"" action=""$=Provider.Request.RawUrl$"" enctype=""multipart/form-data"" class=""form-horizontal"" role=""form"" autocomplete=""off""> <input type=""hidden"" name=""cmdName"" value=""save""/> <input type=""hidden"" name=""Id"" value=""$=e.Id$""/>", EntityName); sb.AppendLine(); int i = 0; foreach (var category in getColumnCategories()) { if (i == 0) { sb.AppendLine("<div class=\"row\">\r\n<div class=\"col-sm-9\">"); } else if (i == 1) { sb.AppendLine( "<div class=\"row\">\r\n<div class=\"col-xs-12 col-sm-6\">\r\n<h3 class=\"header smaller lighter blue\">" + category + "</h3>"); } else { sb.AppendLine("<div class=\"col-xs-12 col-sm-6\">\r\n<h3 class=\"header smaller lighter blue\">" + category + "</h3>"); } foreach (Column field in Provider.Database.Tables[EntityName].Columns) { EditFormFieldPropsAttribute attrEdit = (EditFormFieldPropsAttribute)CMSUtility.GetAttribute(Provider.GetEntityType(EntityName).GetProperty(field.Name), typeof(EditFormFieldPropsAttribute)); if (field.IsPrimaryKey || !attrEdit.Visible || attrEdit.Category != category) { continue; //*** } var ff = new FormField { EntityName = this.EntityName, FieldName = field.Name }; sb.AppendLine(ff.GetHtml()); } if (i == 0) { sb.AppendLine(@" </div> <div class=""col-sm-3""> <img name=""Picture"" class=""img-responsive"" src=""/UserFiles/contact.png"" /> <input type=""file"" id=""Picture"" name=""Picture"" /><br/> $ if(e.Id>0){ $ <em><i class=""icon-ok green""></i>Added by $=e.InsertUser.FullName$ on $=e.InsertDate.ToString(""dd-MM-yyyy"")$</em> $ } $ </div> </div>"); } else { sb.AppendLine("</div>"); } i++; } sb.AppendLine(@" <div class=""clearfix form-actions""> <div class=""text-right""> <button class=""btn btn-info"" type=""submit""> <i class=""icon-ok bigger-110""></i> Save </button> <button class=""btn"" type=""button"" onclick=""history.go(-1)""> <i class=""icon-undo bigger-110""></i> Cancel </button> </div> </div> </form>"); return(sb.ToString()); }
private void getEntityDocs() { string entityName = context.Request["entityName"]; Type entityType = Provider.GetEntityType(entityName); object obj = Provider.CreateEntity(entityType); StringBuilder sb = new StringBuilder(); sb.Append("<h2>Database Properties</h2>"); sb.Append("<table>\n"); sb.AppendFormat("<tr class=\"header\"><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td></tr>\n", "Name", "Type", "Declaring Type", "Description", "Default Value"); int i = 0; foreach (PropertyInfo pi in entityType.GetProperties()) { if (!pi.CanWrite) { continue; } if (pi.Name == "Item") { continue; } string caption = Provider.GetResource(pi.DeclaringType.Name + "." + pi.Name); if (caption.StartsWith(pi.DeclaringType.Name + ".") && !Provider.DesignMode) { caption = pi.Name; } string description = Provider.GetResource(pi.DeclaringType.Name + "." + pi.Name + "Desc"); sb.AppendFormat("<tr{5}><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td></tr>\n", pi.Name, getShortName(pi.PropertyType), pi.DeclaringType.Name, caption == description ? "" : (caption + ". ") + description, pi.GetValue(obj, null), i % 2 == 0 ? "":" class=\"odd\""); i++; } sb.Append("</table>\n"); i = 0; sb.Append("<h2>Read Only Properties</h2>"); sb.Append("<table>\n"); sb.AppendFormat("<tr class=\"header\"><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>\n", "Type", "Name", "Declaring Type", "Description"); foreach (PropertyInfo pi in entityType.GetProperties()) { if (pi.CanWrite) { continue; } if (pi.Name == "Item") { continue; } DescriptionAttribute desc = pi.GetAttribute <DescriptionAttribute>() ?? new DescriptionAttribute(); sb.AppendFormat("<tr{4}><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>\n", getShortName(pi.PropertyType), pi.Name, pi.DeclaringType.Name, desc.Description, i % 2 == 0 ? "" : " class=\"odd\""); i++; } sb.Append("</table>\n"); i = 0; sb.Append("<h2>Methods</h2>"); sb.Append("<table>\n"); sb.AppendFormat("<tr class=\"header\"><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>\n", "Type", "Name", "Declaring Type", "Description"); foreach (MethodInfo pi in entityType.GetMethods(BindingFlags.Public | BindingFlags.Instance)) { if (pi.IsSpecialName) { continue; } DescriptionAttribute desc = pi.GetAttribute <DescriptionAttribute>() ?? new DescriptionAttribute(); sb.AppendFormat("<tr{4}><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>\n", getShortName(pi.ReturnType), pi.Name + "(" + pi.GetParameters().Select(p => "<b>" + getShortName(p.ParameterType) + "</b> " + p.Name).StringJoin(", ") + ")", pi.DeclaringType.Name, desc.Description, i % 2 == 0 ? "" : " class=\"odd\""); i++; } sb.Append("</table>\n"); i = 0; if (obj.GetType() != typeof(Lang)) { sb.Append("<h2>Related Entities</h2>"); sb.Append("<table>\n"); sb.AppendFormat("<tr class=\"header\"><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>\n", "Entity Name", "Related Field Name", "Label", "Description"); foreach (Type type in Provider.GetEntityTypes()) { foreach (PropertyInfo pi in type.GetProperties()) { if (pi.DeclaringType == typeof(BaseEntity)) { continue; //*** BaseEntity'deki UpdateUserId ve InsertUserId bütün entitilerde var, gereksiz bir ilişki kalabalığı oluşturuyor } ColumnDetailAttribute fda = (ColumnDetailAttribute)CMSUtility.GetAttribute(pi, typeof(ColumnDetailAttribute)); if (fda.References == entityType) { sb.AppendFormat("<tr{4}><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>\n", type.Name, pi.Name, Provider.GetResource(type.Name).ToHTMLString(), Provider.GetResource(type.Name + "Desc").ToHTMLString(), i % 2 == 0 ? "" : " class=\"odd\""); i++; } } } sb.Append("</table>\n"); } Provider.Response.Write(sb.ToString()); }
internal override string show() { StringBuilder sb = new StringBuilder(); if (String.IsNullOrEmpty(EntityName)) { return(Provider.GetResource("Select entity")); } Cinar.Database.Table tbl = Provider.Database.Tables[EntityName]; if (tbl == null) { return(Provider.GetResource("The table [entityName] coulnd't be found").Replace("[entityName]", EntityName)); } string pageUrl = Provider.Request.Url.Scheme + "://" + Provider.Request.Url.Authority + Provider.Request.RawUrl; CinarUriParser uriParser = new CinarUriParser(pageUrl); if (!String.IsNullOrEmpty(Provider.Request["delete"])) { deleteEntity(); uriParser.QueryPart.Remove("delete"); pageUrl = uriParser.ToString(); } BaseEntity testEntity = Provider.CreateEntity(EntityName); if (String.IsNullOrEmpty(ShowFields)) { ShowFields = String.Format("{0},Visible", testEntity.GetNameColumn()); } StringBuilder sbFrom = new StringBuilder(); sbFrom.AppendFormat("[{0}]\n", EntityName); // generate SQL string[] showFieldsArr = ShowFields.Split(','); string[] showFieldsArrWithAs = new string[showFieldsArr.Length]; for (int i = 0; i < showFieldsArr.Length; i++) { string field = showFieldsArr[i]; PropertyInfo pi = testEntity.GetType().GetProperty(field); EditFormFieldPropsAttribute attrib = (EditFormFieldPropsAttribute)CMSUtility.GetAttribute(pi, typeof(EditFormFieldPropsAttribute)); ColumnDetailAttribute fieldProps = (ColumnDetailAttribute)CMSUtility.GetAttribute(pi, typeof(ColumnDetailAttribute)); string caption = Provider.GetResource(pi.DeclaringType.Name + "." + pi.Name); if (fieldProps.References != null) { BaseEntity testRefEntity = Provider.CreateEntity(fieldProps.References.Name); showFieldsArrWithAs[i] = "T" + field + "." + testRefEntity.GetNameColumn() + " as [" + caption + "]"; sbFrom.AppendFormat("\tleft join [{0}] as {1} ON {1}.{2} = [{3}].{4}\n", fieldProps.References.Name, "T" + field, "Id", EntityName, field); } else { showFieldsArrWithAs[i] = EntityName + "." + field + " as [" + caption + "]"; } } ShowFields = String.Join(",", showFieldsArrWithAs); ShowFields = EntityName + ".Id," + ShowFields; FilterParser filterParser = new FilterParser(this.Filter, EntityName); string where = filterParser.GetWhere(); int pageNo = 0; Int32.TryParse(Provider.Request["pageNo"], out pageNo); string sql = Provider.Database.AddPagingToSQL(String.Format(@" select {0} from {1} where 1=1 {2} order by {3} {4} ", ShowFields, sbFrom.ToString(), String.IsNullOrEmpty(where) ? "" : ("and " + where), EntityName + "." + this.OrderBy, this.Ascending ? "asc" : "desc"), HowManyItems, pageNo); DataTable dt = Provider.Database.GetDataTable(sql, filterParser.GetParams()); sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n"); // header sb.Append("<tr class=\"header\">\n"); for (int i = 0; i < dt.Columns.Count; i++) { if (i == 0) { continue; } string colName = dt.Columns[i].ColumnName; string img = ""; uriParser.QueryPart["orderBy"] = showFieldsArr[i - 1]; if (this.OrderBy == showFieldsArr[i - 1]) { uriParser.QueryPart["ascending"] = (!this.Ascending).ToString(); img = this.Ascending ? " (asc)" : " (desc)"; } else { uriParser.QueryPart["ascending"] = "True"; } sb.AppendFormat("<td><a href=\"{0}\">{1}</a>{2}</td>\n", uriParser.ToString(), colName, img); } if (this.Editable) { sb.AppendFormat("<td>{0}</td>\n", " "); } if (this.Deletable) { sb.AppendFormat("<td>{0}</td>\n", " "); } sb.Append("</tr>\n"); string nameField = testEntity.GetNameColumn(); // data uriParser = new CinarUriParser(pageUrl); foreach (DataRow dr in dt.Rows) { sb.Append("<tr class=\"data\">\n"); string editUrl = this.EditPage + "?item=" + dr[0] + "&returnUrl=" + Provider.Server.UrlEncode(Provider.Request.RawUrl); for (int i = 0; i < dt.Columns.Count; i++) { if (i == 0) { continue; } object data = (dr.IsNull(i) || dr[i].Equals("")) ? " " : dr[i]; if (showFieldsArr[i - 1] == nameField && this.Editable) { data = "<a href=\"" + editUrl + "\">" + data + "</a>"; } if (dr.Table.Columns[i].DataType == typeof(bool)) { data = ((bool)data) ? Provider.GetResource("Yes") : Provider.GetResource("No"); } sb.AppendFormat("<td>{0}</td>\n", data); } if (this.Deletable) { uriParser.QueryPart["delete"] = dr[0].ToString(); sb.AppendFormat("<td><span class=\"cbtn cdelete\" onclick=\"if(confirm('Kayýt silinecek!')) location.href='{0}'\"></span></td>\n", uriParser.ToString()); } if (this.Editable) { sb.AppendFormat("<td><span class=\"cbtn cedit\" onclick=\"location.href='{0}'\"></span></td>\n", editUrl); } sb.Append("</tr>\n"); } // paging string prevPageLink = "", nextPageLink = ""; uriParser = new CinarUriParser(pageUrl); if (pageNo > 0) { uriParser.QueryPart["pageNo"] = (pageNo - 1).ToString(); prevPageLink = String.Format("<a href=\"{0}\"><< {1}</a> ", uriParser.Uri.ToString(), Provider.GetModuleResource("Previous Page")); } if (dt.Rows.Count == HowManyItems) { uriParser.QueryPart["pageNo"] = (pageNo + 1).ToString(); nextPageLink = String.Format(" <a href=\"{0}\">{1} >></a>", uriParser.Uri.ToString(), Provider.GetModuleResource("Next Page")); } sb.AppendFormat("<tr class=\"footer\"><td colspan=\"100\">{0} {1}</td></tr>\n", prevPageLink, nextPageLink); sb.Append("</table>\n"); if (!String.IsNullOrEmpty(NewRecordLink)) { sb.AppendFormat("<p class=\"newRec\"><a href=\"{0}\">{1}</a></p>\n", this.EditPage + "?returnUrl=" + Provider.Server.UrlEncode(Provider.Request.RawUrl), NewRecordLink); } return(sb.ToString()); }