public static DataTable getTableFromXml(this DAL.clsCmd cmd, string sField)
{
var ds = new DataSet();
ds.ReadXml(new System.IO.StringReader(cmd.getStringValue(sField)));
return(ds.Tables[0]);
}
public string getSelectAllScript(DAL.clsCmd prm)
{
StringBuilder sb1 = new StringBuilder();
sb1.Append(getSelectAllScript());
addWhereCondition(sb1, prm);
return(sb1.ToString());
}
public static List <T> getList <T>(this DAL.clsCmd cmd, string sField)
{
return(Newtonsoft.Json.JsonConvert.DeserializeObject <List <T> >(cmd.getStringValue(sField)));
}
public static DataTable getTableFromJSON(this DAL.clsCmd cmd, string sField)
{
return(Newtonsoft.Json.JsonConvert.DeserializeObject <System.Data.DataTable>(cmd.getStringValue(sField)));
}