/// <summary> /// 查询列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <T_BASE_SJYPZModel> QueryList(string swhere, string orders) { List <T_BASE_SJYPZModel> models = new List <T_BASE_SJYPZModel>(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.PZBM,"); sBuilder.Append("T.PZMC,"); sBuilder.Append("T.SJIP,"); sBuilder.Append("T.SJPORT,"); sBuilder.Append("T.SJSID,"); sBuilder.Append("T.SJUSERID,"); sBuilder.Append("T.SJPASSWORD,"); sBuilder.Append("T.SFSC,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3,"); sBuilder.Append("T.CJR,"); sBuilder.Append("T.CJSJ,"); sBuilder.Append("T.XGR,"); sBuilder.Append("T.XGSJ,"); sBuilder.Append("T.SJC "); sBuilder.Append("FROM T_BASE_SJYPZ T "); if (!String.IsNullOrEmpty(swhere)) { sBuilder.Append(String.Format("WHERE {0} ", swhere)); } if (!String.IsNullOrEmpty(orders)) { sBuilder.Append(String.Format("ORDER BY {0} ", orders)); } XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString()); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { T_BASE_SJYPZModel model = new T_BASE_SJYPZModel(); model.PZBM = ToString(dr["PZBM"]); model.PZMC = ToString(dr["PZMC"]); model.SJIP = ToString(dr["SJIP"]); model.SJPORT = ToString(dr["SJPORT"]); model.SJSID = ToString(dr["SJSID"]); model.SJUSERID = ToString(dr["SJUSERID"]); model.SJPASSWORD = ToString(dr["SJPASSWORD"]); model.SFSC = ToInt(dr["SFSC"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); model.CJR = ToString(dr["CJR"]); model.CJSJ = ToString(dr["CJSJ"]); model.XGR = ToString(dr["XGR"]); model.XGSJ = ToString(dr["XGSJ"]); model.SJC = ToString(dr["SJC"]); models.Add(model); } } return(models); }
public static List <DataTable> GetDataSet(Model.T_BASE_SJYPZModel sjy, string sql, ref string errorinfo) { List <DataTable> models = new List <DataTable>(); string connectstring = String.Format(m_ConnectStringModel[Convert.ToInt32(sjy.BL1)], sjy.SJIP, sjy.SJPORT, sjy.SJSID, sjy.SJUSERID, Careysoft.Basic.Public.DES.Decrypt(sjy.SJPASSWORD, "EPad@)!!")); XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(XMLDbHelper.DbHelperType.ORACLE, connectstring, true); if (!af.Connected()) { errorinfo = "目标数据无法连接!"; return(models); } string[] sqlArray = sql.Split(';'); for (int i = 0; i < sqlArray.Length; i++) { if (!String.IsNullOrEmpty(sqlArray[i])) { DataSet ds = af.Query(sqlArray[i]); if (ds != null && ds.Tables.Count > 0) { models.Add(ds.Tables[0]); } } } return(models); }
/// <summary> /// 查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public T_D_TASK_MSTModel Query(string id) { T_D_TASK_MSTModel model = new T_D_TASK_MSTModel(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.ID,"); sBuilder.Append("T.GROUPID,"); sBuilder.Append("T.TASKNAME,"); sBuilder.Append("T.TASKNUMBER,"); sBuilder.Append("T.TASKDONUMBER,"); sBuilder.Append("T.BEGINDATETIME,"); sBuilder.Append("T.LASTDATETIME,"); sBuilder.Append("T.INTERVAL,"); sBuilder.Append("T.INTERVALTYPE,"); sBuilder.Append("T.INTERVALADDTYPE,"); sBuilder.Append("T.SFSC,"); sBuilder.Append("T.SFJY,"); sBuilder.Append("T.CJR,"); sBuilder.Append("T.CJSJ,"); sBuilder.Append("T.XGR,"); sBuilder.Append("T.XGSJ,"); sBuilder.Append("T.SJC,"); sBuilder.Append("T.TASKDISCRIBE "); sBuilder.Append("FROM T_D_TASK_MST T "); sBuilder.Append("WHERE T.ID=:ID "); OracleParameter[] oparams = { new OracleParameter(":ID", OracleType.VarChar) }; oparams[0].Value = id; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString(), oparams); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; model.ID = ToString(dr["ID"]); model.TASKNAME = ToString(dr["TASKNAME"]); model.TASKNUMBER = ToInt(dr["TASKNUMBER"]); model.TASKDONUMBER = ToInt(dr["TASKDONUMBER"]); model.BEGINDATETIME = ToString(dr["BEGINDATETIME"]); model.LASTDATETIME = ToString(dr["LASTDATETIME"]); model.INTERVAL = ToInt(dr["INTERVAL"]); model.INTERVALTYPE = ToString(dr["INTERVALTYPE"]); model.INTERVALADDTYPE = ToString(dr["INTERVALADDTYPE"]); model.SFSC = ToInt(dr["SFSC"]); model.SFJY = ToInt(dr["SFJY"]); model.CJR = ToString(dr["CJR"]); model.CJSJ = ToString(dr["CJSJ"]); model.XGR = ToString(dr["XGR"]); model.XGSJ = ToString(dr["XGSJ"]); model.SJC = ToString(dr["SJC"]); model.TASKDISCRIBE = ToString(dr["TASKDISCRIBE"]); model.GROUPID = ToString(dr["GROUPID"]); } model.SlvList = QuerySlvList(id); return(model); }
/// <summary> /// 查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public T_D_SQLDATA_MSTModel Query(string id) { T_D_SQLDATA_MSTModel model = new T_D_SQLDATA_MSTModel(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.ID,"); sBuilder.Append("T.SJYID,"); sBuilder.Append("T2.PZMC SJYMC,"); sBuilder.Append("T.SQLDATANAME,"); sBuilder.Append("T.SQLDATADISCRIBE,"); sBuilder.Append("T.SQL,"); sBuilder.Append("T.SQLTYPE,"); sBuilder.Append("T.CJR,"); sBuilder.Append("T.CJSJ,"); sBuilder.Append("T.XGR,"); sBuilder.Append("T.XGSJ,"); sBuilder.Append("T.SJC,"); sBuilder.Append("T.SFSC,"); sBuilder.Append("T.SFJY,"); sBuilder.Append("T.UNITTYPEID,"); sBuilder.Append("T3.LXMC UNITTYPENAME "); sBuilder.Append("FROM T_D_SQLDATA_MST T "); sBuilder.Append("LEFT JOIN T_BASE_SJYPZ T2 ON T.SJYID=T2.PZBM "); sBuilder.Append("LEFT JOIN T_BASE_UNITTYPE T3 ON T.UNITTYPEID=T3.LXBM "); sBuilder.Append("WHERE T.ID=:ID "); OracleParameter[] oparams = { new OracleParameter(":ID", OracleType.VarChar) }; oparams[0].Value = id; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString(), oparams); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; model.ID = ToString(dr["ID"]); model.SJYID = ToString(dr["SJYID"]); model.SQLDATANAME = ToString(dr["SQLDATANAME"]); model.SQLDATADISCRIBE = ToString(dr["SQLDATADISCRIBE"]); model.SQL = ToString(dr["SQL"]); model.SQLTYPE = ToString(dr["SQLTYPE"]); model.CJR = ToString(dr["CJR"]); model.CJSJ = ToString(dr["CJSJ"]); model.XGR = ToString(dr["XGR"]); model.XGSJ = ToString(dr["XGSJ"]); model.SJC = ToString(dr["SJC"]); model.SFSC = ToInt(dr["SFSC"]); model.SFJY = ToInt(dr["SFJY"]); model.UNITTYPEID = ToString(dr["UNITTYPEID"]); model.SJYMC = ToString(dr["SJYMC"]); model.UNITTYPENAME = ToString(dr["UNITTYPENAME"]); model.SLVList = QuerySlvList(id); } return(model); }
/// <summary> /// 查询 /// </summary> /// <param name="pzbm"></param> /// <returns></returns> public T_BASE_SJYPZModel Query(string pzbm) { T_BASE_SJYPZModel model = new T_BASE_SJYPZModel(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.PZBM,"); sBuilder.Append("T.PZMC,"); sBuilder.Append("T.SJIP,"); sBuilder.Append("T.SJPORT,"); sBuilder.Append("T.SJSID,"); sBuilder.Append("T.SJUSERID,"); sBuilder.Append("T.SJPASSWORD,"); sBuilder.Append("T.SFSC,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3,"); sBuilder.Append("T.CJR,"); sBuilder.Append("T.CJSJ,"); sBuilder.Append("T.XGR,"); sBuilder.Append("T.XGSJ,"); sBuilder.Append("T.SJC "); sBuilder.Append("FROM T_BASE_SJYPZ T "); sBuilder.Append("WHERE T.PZBM=:PZBM "); OracleParameter[] oparams = { new OracleParameter(":PZBM", OracleType.VarChar) }; oparams[0].Value = pzbm; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString(), oparams); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; model.PZBM = ToString(dr["PZBM"]); model.PZMC = ToString(dr["PZMC"]); model.SJIP = ToString(dr["SJIP"]); model.SJPORT = ToString(dr["SJPORT"]); model.SJSID = ToString(dr["SJSID"]); model.SJUSERID = ToString(dr["SJUSERID"]); model.SJPASSWORD = ToString(dr["SJPASSWORD"]); model.SFSC = ToInt(dr["SFSC"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); model.CJR = ToString(dr["CJR"]); model.CJSJ = ToString(dr["CJSJ"]); model.XGR = ToString(dr["XGR"]); model.XGSJ = ToString(dr["XGSJ"]); model.SJC = ToString(dr["SJC"]); } return(model); }
private List <T_S_TASK_SLV_SLVModel> QuerySlvSlvList(string slvid) { string swhere = String.Format(" T.TASKSLVID='{0}'", slvid); string orders = "T.ID"; List <T_S_TASK_SLV_SLVModel> models = new List <T_S_TASK_SLV_SLVModel>(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.ID,"); sBuilder.Append("T.TASKSLVID,"); sBuilder.Append("T.SQLDATASLVID,"); sBuilder.Append("T.SQLDATASLVVAL,"); sBuilder.Append("T.SQLDARASLVNAME,"); sBuilder.Append("T.SQLDARASQLTYPE,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3,"); sBuilder.Append("T.SJC "); sBuilder.Append("FROM T_S_TASK_SLV_SLV T "); if (!String.IsNullOrEmpty(swhere)) { sBuilder.Append(String.Format("WHERE {0} ", swhere)); } if (!String.IsNullOrEmpty(orders)) { sBuilder.Append(String.Format("ORDER BY {0} ", orders)); } XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString()); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { T_S_TASK_SLV_SLVModel model = new T_S_TASK_SLV_SLVModel(); model.ID = ToString(dr["ID"]); model.TASKSLVID = ToString(dr["TASKSLVID"]); model.SQLDATASLVID = ToString(dr["SQLDATASLVID"]); model.SQLDATASLVVAL = ToString(dr["SQLDATASLVVAL"]); model.SQLDARASLVNAME = ToString(dr["SQLDARASLVNAME"]); model.SQLDARASQLTYPE = ToString(dr["SQLDARASQLTYPE"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); model.SJC = ToString(dr["SJC"]); models.Add(model); } } return(models); }
public List <T_D_SQLDATA_SLVModel> QuerySlvList(string mstid) { List <T_D_SQLDATA_SLVModel> models = new List <T_D_SQLDATA_SLVModel>(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.ID,"); sBuilder.Append("T.MSTID,"); sBuilder.Append("T.PARAMETERNAME,"); sBuilder.Append("T.PARAMETERTYPE,"); sBuilder.Append("T.PARAMETERDISC,"); sBuilder.Append("T.DEFAULTVALUE,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3,"); sBuilder.Append("T.SJC "); sBuilder.Append("FROM T_D_SQLDATA_SLV T "); sBuilder.Append("WHERE T.MSTID=:MSTID "); OracleParameter[] oparams = { new OracleParameter(":MSTID", OracleType.VarChar) }; oparams[0].Value = mstid; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString(), oparams); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { T_D_SQLDATA_SLVModel model = new T_D_SQLDATA_SLVModel(); model.ID = ToString(dr["ID"]); model.MSTID = ToString(dr["MSTID"]); model.PARAMETERNAME = ToString(dr["PARAMETERNAME"]); model.PARAMETERTYPE = ToString(dr["PARAMETERTYPE"]); model.PARAMETERDISC = ToString(dr["PARAMETERDISC"]); model.DEFAULTVALUE = ToString(dr["DEFAULTVALUE"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); model.SJC = ToString(dr["SJC"]); models.Add(model); } } return(models); }
/// <summary> /// 查询 /// </summary> /// <param name="lxbm"></param> /// <returns></returns> public T_BASE_UNITTYPEModel Query(string lxbm) { T_BASE_UNITTYPEModel model = new T_BASE_UNITTYPEModel(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.LXBM,"); sBuilder.Append("T.FLXBM,"); sBuilder.Append("T.LXMC,"); sBuilder.Append("T.SFSC,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3,"); sBuilder.Append("T.CJR,"); sBuilder.Append("T.CJSJ,"); sBuilder.Append("T.XGR,"); sBuilder.Append("T.XGSJ,"); sBuilder.Append("T.SJC "); sBuilder.Append("FROM T_BASE_UNITTYPE T "); sBuilder.Append("WHERE T.LXBM=:LXBM "); OracleParameter[] oparams = { new OracleParameter(":LXBM", OracleType.VarChar) }; oparams[0].Value = lxbm; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString(), oparams); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; model.LXBM = ToString(dr["LXBM"]); model.FLXBM = ToString(dr["FLXBM"]); model.LXMC = ToString(dr["LXMC"]); model.SFSC = ToInt(dr["SFSC"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); model.CJR = ToString(dr["CJR"]); model.CJSJ = ToString(dr["CJSJ"]); model.XGR = ToString(dr["XGR"]); model.XGSJ = ToString(dr["XGSJ"]); model.SJC = ToString(dr["SJC"]); } return(model); }
/// <summary> /// 查询列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <T_B_USERModel> QueryList(string swhere, string orders) { List <T_B_USERModel> models = new List <T_B_USERModel>(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.USERNAME,"); sBuilder.Append("T.PASSWORD,"); sBuilder.Append("T.XM,"); sBuilder.Append("T.USERTYPE,"); sBuilder.Append("T.SFJY,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3 "); sBuilder.Append("FROM T_B_USER T "); if (!String.IsNullOrEmpty(swhere)) { sBuilder.Append(String.Format("WHERE {0} ", swhere)); } if (!String.IsNullOrEmpty(orders)) { sBuilder.Append(String.Format("ORDER BY {0} ", orders)); } XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString()); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { T_B_USERModel model = new T_B_USERModel(); model.USERNAME = ToString(dr["USERNAME"]); model.PASSWORD = ToString(dr["PASSWORD"]); model.XM = ToString(dr["XM"]); model.USERTYPE = ToString(dr["USERTYPE"]); model.SFJY = ToInt(dr["SFJY"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); models.Add(model); } } return(models); }
/// <summary> /// 查询 /// </summary> /// <param name="username"></param> /// <returns></returns> public T_B_USERModel Query(string username) { T_B_USERModel model = new T_B_USERModel(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.USERNAME,"); sBuilder.Append("T.PASSWORD,"); sBuilder.Append("T.XM,"); sBuilder.Append("T.USERTYPE,"); sBuilder.Append("T.SFJY,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3 "); sBuilder.Append("FROM T_B_USER T "); sBuilder.Append("WHERE T.USERNAME=:USERNAME "); OracleParameter[] oparams = { new OracleParameter(":USERNAME", OracleType.VarChar) }; oparams[0].Value = username; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString(), oparams); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; model.USERNAME = ToString(dr["USERNAME"]); model.PASSWORD = ToString(dr["PASSWORD"]); model.XM = ToString(dr["XM"]); model.USERTYPE = ToString(dr["USERTYPE"]); model.SFJY = ToInt(dr["SFJY"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); } return(model); }
/// <summary> /// 查询列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <T_D_TASK_MSTModel> QueryList(string swhere, string orders) { List <T_D_TASK_MSTModel> models = new List <T_D_TASK_MSTModel>(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.ID,"); sBuilder.Append("T.GROUPID,"); sBuilder.Append("T.TASKNAME,"); sBuilder.Append("T.TASKNUMBER,"); sBuilder.Append("T.TASKDONUMBER,"); sBuilder.Append("T.BEGINDATETIME,"); sBuilder.Append("T.LASTDATETIME,"); sBuilder.Append("T.INTERVAL,"); sBuilder.Append("T.INTERVALTYPE,"); sBuilder.Append("T.INTERVALADDTYPE,"); sBuilder.Append("T.SFSC,"); sBuilder.Append("T.SFJY,"); sBuilder.Append("T.CJR,"); sBuilder.Append("T.CJSJ,"); sBuilder.Append("T.XGR,"); sBuilder.Append("T.XGSJ,"); sBuilder.Append("T.SJC,"); sBuilder.Append("T.TASKDISCRIBE "); sBuilder.Append("FROM T_D_TASK_MST T "); if (!String.IsNullOrEmpty(swhere)) { sBuilder.Append(String.Format("WHERE {0} ", swhere)); } if (!String.IsNullOrEmpty(orders)) { sBuilder.Append(String.Format("ORDER BY {0} ", orders)); } XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString()); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { T_D_TASK_MSTModel model = new T_D_TASK_MSTModel(); model.ID = ToString(dr["ID"]); model.TASKNAME = ToString(dr["TASKNAME"]); model.TASKNUMBER = ToInt(dr["TASKNUMBER"]); model.TASKDONUMBER = ToInt(dr["TASKDONUMBER"]); model.BEGINDATETIME = ToString(dr["BEGINDATETIME"]); model.LASTDATETIME = ToString(dr["LASTDATETIME"]); model.INTERVAL = ToInt(dr["INTERVAL"]); model.INTERVALTYPE = ToString(dr["INTERVALTYPE"]); model.INTERVALADDTYPE = ToString(dr["INTERVALADDTYPE"]); model.SFSC = ToInt(dr["SFSC"]); model.SFJY = ToInt(dr["SFJY"]); model.CJR = ToString(dr["CJR"]); model.CJSJ = ToString(dr["CJSJ"]); model.XGR = ToString(dr["XGR"]); model.XGSJ = ToString(dr["XGSJ"]); model.SJC = ToString(dr["SJC"]); model.TASKDISCRIBE = ToString(dr["TASKDISCRIBE"]); model.GROUPID = ToString(dr["GROUPID"]); models.Add(model); } } return(models); }
private List <Model.T_D_TASK_SLVModel> QuerySlvList(string mstid) { string swhere = String.Format(" T.MSTID='{0}'", mstid); string orders = "T.ID"; List <T_D_TASK_SLVModel> models = new List <T_D_TASK_SLVModel>(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.ID,"); sBuilder.Append("T4.LXMC GROUPMC,"); sBuilder.Append("T3.PZMC SJYMC,"); sBuilder.Append("T3.PZBM SJYBM,"); sBuilder.Append("T2.SQLDATANAME,"); sBuilder.Append("T2.SQLTYPE,"); sBuilder.Append("T2.SQL,"); sBuilder.Append("T2.SFJY SQLDATASFJY,"); sBuilder.Append("T2.SFSC SQLDATASFSC,"); sBuilder.Append("T.MSTID,"); sBuilder.Append("T.SQLDATAID,"); sBuilder.Append("T.BL1,"); sBuilder.Append("T.BL2,"); sBuilder.Append("T.BL3,"); sBuilder.Append("T.SJC,"); sBuilder.Append("T.TASKTYPE,"); sBuilder.Append("T.OUTPUTTYPE,"); sBuilder.Append("T.OUTPUTPATH "); sBuilder.Append("FROM T_D_TASK_SLV T "); sBuilder.Append("LEFT JOIN T_D_SQLDATA_MST T2 ON T.SQLDATAID=T2.ID "); sBuilder.Append("LEFT JOIN T_BASE_SJYPZ T3 ON T2.SJYID=T3.PZBM "); sBuilder.Append("LEFT JOIN T_BASE_UNITTYPE T4 ON T2.UNITTYPEID=T4.LXBM "); if (!String.IsNullOrEmpty(swhere)) { sBuilder.Append(String.Format("WHERE {0} ", swhere)); } if (!String.IsNullOrEmpty(orders)) { sBuilder.Append(String.Format("ORDER BY {0} ", orders)); } XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString()); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { T_D_TASK_SLVModel model = new T_D_TASK_SLVModel(); model.ID = ToString(dr["ID"]); model.MSTID = ToString(dr["MSTID"]); model.SQLDATAID = ToString(dr["SQLDATAID"]); model.BL1 = ToString(dr["BL1"]); model.BL2 = ToString(dr["BL2"]); model.BL3 = ToString(dr["BL3"]); model.SJC = ToString(dr["SJC"]); model.TASKTYPE = ToString(dr["TASKTYPE"]); model.OUTPUTTYPE = ToString(dr["OUTPUTTYPE"]); model.OUTPUTPATH = ToString(dr["OUTPUTPATH"]); model.GROUPMC = ToString(dr["GROUPMC"]); model.SJYMC = ToString(dr["SJYMC"]); model.SQLDATANAME = ToString(dr["SQLDATANAME"]); model.SQLTYPE = ToString(dr["SQLTYPE"]); model.SQL = ToString(dr["SQL"]); model.SJYBM = ToString(dr["SJYBM"]); model.SQLDATASFJY = ToInt(dr["SQLDATASFJY"]); model.SQLDATASFSC = ToInt(dr["SQLDATASFSC"]); model.SlvList = QuerySlvSlvList(model.ID); models.Add(model); } } return(models); }
/// <summary> /// 查询列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <T_D_SQLDATA_MSTModel> QueryList(string swhere, string orders) { List <T_D_SQLDATA_MSTModel> models = new List <T_D_SQLDATA_MSTModel>(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("SELECT "); sBuilder.Append("T.ID,"); sBuilder.Append("T.SJYID,"); sBuilder.Append("T2.PZMC SJYMC,"); sBuilder.Append("T.SQLDATANAME,"); sBuilder.Append("T.SQLDATADISCRIBE,"); sBuilder.Append("T.SQL,"); sBuilder.Append("T.SQLTYPE,"); sBuilder.Append("T.CJR,"); sBuilder.Append("T.CJSJ,"); sBuilder.Append("T.XGR,"); sBuilder.Append("T.XGSJ,"); sBuilder.Append("T.SJC,"); sBuilder.Append("T.SFSC,"); sBuilder.Append("T.SFJY,"); sBuilder.Append("T.UNITTYPEID,"); sBuilder.Append("T3.LXMC UNITTYPENAME "); sBuilder.Append("FROM T_D_SQLDATA_MST T "); sBuilder.Append("LEFT JOIN T_BASE_SJYPZ T2 ON T.SJYID=T2.PZBM "); sBuilder.Append("LEFT JOIN T_BASE_UNITTYPE T3 ON T.UNITTYPEID=T3.LXBM "); if (!String.IsNullOrEmpty(swhere)) { sBuilder.Append(String.Format("WHERE {0} ", swhere)); } if (!String.IsNullOrEmpty(orders)) { sBuilder.Append(String.Format("ORDER BY {0} ", orders)); } XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DataSet ds = af.Query(sBuilder.ToString()); if (ds != null && ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { T_D_SQLDATA_MSTModel model = new T_D_SQLDATA_MSTModel(); model.ID = ToString(dr["ID"]); model.SJYID = ToString(dr["SJYID"]); model.SQLDATANAME = ToString(dr["SQLDATANAME"]); model.SQLDATADISCRIBE = ToString(dr["SQLDATADISCRIBE"]); model.SQL = ToString(dr["SQL"]); model.SQLTYPE = ToString(dr["SQLTYPE"]); model.CJR = ToString(dr["CJR"]); model.CJSJ = ToString(dr["CJSJ"]); model.XGR = ToString(dr["XGR"]); model.XGSJ = ToString(dr["XGSJ"]); model.SJC = ToString(dr["SJC"]); model.SFSC = ToInt(dr["SFSC"]); model.SFJY = ToInt(dr["SFJY"]); model.UNITTYPEID = ToString(dr["UNITTYPEID"]); model.SJYMC = ToString(dr["SJYMC"]); model.UNITTYPENAME = ToString(dr["UNITTYPENAME"]); models.Add(model); } } return(models); }