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