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