public FieldManage() { if (_sqlBase == null) { _sqlBase = new Common.DBUtility.SqlBase(ESqlConnType.ConnectionStringJCJT); } if (_sqlDebugTool == null) { _sqlDebugTool = new SqlBase(ESqlConnType.ConnectionStringDebugTool); } }
public static string GetMdataJson(string sql, string table_name, ESqlConnType connType = ESqlConnType.ConnectionStringJCJT) { StringBuilder sb = new StringBuilder(); Common.DBUtility.SqlBase sqlbase = new Common.DBUtility.SqlBase(connType); DataSet ds = sqlbase.ExecuteDataset(sql); DataTable dt = ds.Tables[0]; string json = Common.DBUtility.JsonHelper.SerializeObject(dt); sb.Append(",\"" + table_name + "\":"); sb.Append(json); return(sb.ToString()); }
public static string GetDataJson(string sqlstr, string tableName, ESqlConnType connType = ESqlConnType.ConnectionStringJCJT) { StringBuilder sb = new StringBuilder(); sb.Append("{\"calcData\":{\"\":"); string sql = string.Format(@sqlstr); Common.DBUtility.SqlBase sqlbase = new Common.DBUtility.SqlBase(connType); DataSet ds = sqlbase.ExecuteDataset(sql); ds.Tables[0].TableName = tableName; string json = Common.DBUtility.JsonHelper.SerializeObject(ds); sb.Append(json); sb.Append("}}"); return(sb.ToString()); }
public TargetForm(FormMain main) { InitializeComponent(); //Init(); _formMain = main; if (_sqlBase == null) { _sqlBase = new SqlBase(); } if (_sqlDebugTool == null) { _sqlDebugTool = new SqlBase(ESqlConnType.ConnectionStringDebugTool); } if (_sqlJGJG == null) { _sqlJGJG = new SqlBase(ESqlConnType.ConnectionStringJCJG); } List <string> jcjgInfos = Common.StringsOper.GetTextList(AppDomain.CurrentDomain.BaseDirectory + @"Resources\检测机构配置.txt"); }
public static string GetAfferentDataJson(string type, string sql, ESqlConnType connType = ESqlConnType.ConnectionStringCF, string m_json = null) { StringBuilder sb = new StringBuilder(); StringBuilder sb2 = new StringBuilder(); sb.Append("{\"calcData\":[{"); //string sql = string.Format(@"select top 1 * from " + tableName); Common.DBUtility.SqlBase sqlbase = new Common.DBUtility.SqlBase(connType); DataSet ds = sqlbase.ExecuteDataset(sql); DataTable dt = ds.Tables[0]; string[] jcxm_list = dt.Rows[0]["jcxm"].ToString().Split('、', ','); foreach (string item in jcxm_list) { sb2.Append("\"" + item + "\":{"); DataTable dt_json = ToDataTable(dt.Select(" jcxm like '%" + item.Trim() + "%'")); string json = Common.DBUtility.JsonHelper.SerializeObject(dt_json); sb2.Append("\"" + type + "\":" + json + ""); sb2.Append(",\"S_BY_RW_XQ\":[{"); sb2.Append("\"RECID\":\"19085206791636631332933\","); sb2.Append("\"SJWCKSSJ\":\"1900/1/1 0:00:00\","); sb2.Append("\"SJWCJSSJ\":\"1900/1/1 0:00:00\","); sb2.Append("}]"); if (m_json != null) { sb2.Append(m_json); } sb2.Append("},"); } sb.Append(sb2.ToString().TrimEnd(',')); sb.Append("}]}"); return(sb.ToString()); }