private string recordsJson(List <ColumnMdl> columns) { StringBuilder json = new StringBuilder(); ColumnMdl mdl = null; for (int i = 0; i < columns.Count; i++) { mdl = columns[i]; json.Append("{name:\"").Append(mdl.ColumnName).Append("\"").Append("},"); } json.Append("{name:\"").Append("rw").Append("\"},"); json.Append("{name:\"").Append("rfid").Append("\"}"); if (json.Length > 0) { json.Insert(0, "["); json.Append("]"); } else { json.Append("[]"); } return(json.ToString()); }
private List <string> GetPrimaryKey() { List <string> keys = new List <string>(); for (int i = 0; i < this.columns.Count; i++) { ColumnMdl mdl = this.columns[i]; if (mdl.IsPrimaryKey.Equals(Public_Flag.Y.ToString())) { keys.Add(mdl.ColumnName); } if (!this.hasDflag) { hasDflag = mdl.ColumnName.Equals("dflag"); } } return(keys); }
public List <ColumnMdl> GetColumns() { List <ColumnMdl> list = new List <ColumnMdl>(); var mtdList = (from p in gDB.tsttabdefs where p.tbnm == this.tableName && p.isen == "Y" orderby p.cono select p).Cast <tsttabdef>().ToList(); for (int i = 0; i < mtdList.Count; i++) { tsttabdef mtd = mtdList[i]; ColumnMdl column = new ColumnMdl(); column.ColumnName = mtd.conm; string precision = mtd.dapr; if (!precision.Equals(string.Empty)) { column.DataPrecision = Convert.ToInt32(precision); } column.DataType = mtd.daty; string dataSize = mtd.dasz.ToString(); if (!dataSize.Equals(string.Empty)) { column.DataSize = Convert.ToInt32(dataSize); } column.IsPrimaryKey = mtd.ispk.ToString(); column.ResourceId = mtd.rsid; column.IsRequired = mtd.isrq.ToString(); column.IsDisplay = mtd.isdp.ToString(); column.DefaultValue = mtd.dfva; column.ControlType = mtd.ctty; list.Add(column); } return(list); }
private string columnsJson(List <ColumnMdl> columns) { StringBuilder json = new StringBuilder(); for (int i = 0; i < columns.Count; i++) { ColumnMdl mdl = columns[i]; string isRequired = mdl.IsRequired.Equals(string.Empty) ? "False" : mdl.IsRequired.Equals(Public_Flag.Y.ToString()).ToString(); string isPrimaryKey = mdl.IsPrimaryKey.Equals(string.Empty) ? "False" : mdl.IsPrimaryKey.Equals(Public_Flag.Y.ToString()).ToString(); string resourceId = mdl.ResourceId.Equals(string.Empty) ? mdl.ColumnName : "HRMSRes." + mdl.ResourceId; string display = mdl.IsDisplay.Equals(string.Empty) ? "False" : mdl.IsDisplay.Equals(Public_Flag.Y.ToString()).ToString(); string defaultValue = mdl.DefaultValue; string defaultValueFormula = mdl.DefaultValue; if (!defaultValue.Equals(string.Empty)) { if (defaultValue.Equals(Public_DefaultValue.sysuser.ToString())) { defaultValue = "ContextInfo.currentUser"; } else if (defaultValue.Equals(Public_DefaultValue.sysdate.ToString())) { defaultValue = "\"" + UtilDatetime.FormateDateTime1(DateTime.Now) + "\""; } else { defaultValue = "\"" + defaultValue + "\""; } } else { defaultValue = "\"" + defaultValue + "\""; } json.Append("{"); json.Append("header:typeof ").Append(resourceId).Append(" ==\"undefined\"").Append("?\"").Append(mdl.ColumnName).Append("\":").Append(resourceId).Append(",") .Append("sortable:true").Append(",") .Append("isPk:\"").Append(mdl.IsPrimaryKey.Equals(Public_Flag.Y.ToString())).Append("\",") .Append("required:\"").Append(isRequired).Append("\",") .Append("type:\"").Append(mdl.DataType).Append("\",") .Append("size:").Append(mdl.DataSize).Append(",") .Append("precision:\"").Append(mdl.DataPrecision).Append("\",") .Append("defaultValue:").Append(defaultValue).Append(",") .Append("defaultValueFormula:\"").Append(defaultValueFormula).Append("\",") .Append("isDisplay:\"").Append(display).Append("\",") .Append("align:").Append(GetPostionByType(mdl.DataType)).Append(",") .Append("dataIndex:\"").Append(mdl.ColumnName).Append("\"").Append(","); if (mdl.DataType == "datetime") { switch (mdl.DefaultValue.ToUpper()) { case "SYSDATE": case "DATE TIME": case "": default: json.Append("renderer:formatDate").Append(","); break; case "DATE ONLY": json.Append("renderer:formatDateNoTime").Append(","); break; } //if (mdl.DefaultValue == "sysdate") // json.Append("renderer:formatDate").Append(","); //else //{ // if (mdl.DefaultValue.ToUpper() == "DATE ONLY") // { // json.Append("renderer:formatDateNoTime").Append(","); // } // else // { // if (mdl.DefaultValue == null || mdl.DefaultValue.Trim() == string.Empty) // json.Append("renderer:formatDate").Append(","); // else // json.Append("renderer:formatDateNoTime").Append(","); // } //} } json.Append("controlType:\"").Append(mdl.ControlType).Append("\"").Append(""); json.Append("}"); if (i < columns.Count - 1) { json.Append(","); } } if (json.Length > 0) { json.Insert(0, "["); json.Append("]"); } else { json.Append("[]"); } return(json.ToString()); }