/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在</returns> public static bool isExists(JC_FIRE_PLOTTING_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from JC_FIRE_PLOTTING where 1=1"); if (string.IsNullOrEmpty(sw.JC_FIRE_PLOTTINGID) == false) { sb.AppendFormat(" where JC_FIRE_PLOTTINGID= '{0}'", ClsSql.EncodeSql(sw.JC_FIRE_PLOTTINGID)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <JC_FIRE_PLOTTING_Model> getModelList(JC_FIRE_PLOTTING_SW sw) { var result = new List <JC_FIRE_PLOTTING_Model>(); DataTable dt = BaseDT.JC_FIRE_PLOTTING.getDT(sw);//列表 for (int i = 0; i < dt.Rows.Count; i++) { JC_FIRE_PLOTTING_Model m = new JC_FIRE_PLOTTING_Model(); m.JC_FIRE_PLOTTINGID = dt.Rows[i]["JC_FIRE_PLOTTINGID"].ToString(); m.JCFID = dt.Rows[i]["JCFID"].ToString(); m.PLOTTINGTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["PLOTTINGTIME"].ToString()); m.PLOTTINGTITLE = dt.Rows[i]["PLOTTINGTITLE"].ToString(); m.PLOTTINGFILENAME = dt.Rows[i]["PLOTTINGFILENAME"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 获取单条记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static JC_FIRE_PLOTTING_Model getModel(JC_FIRE_PLOTTING_SW sw) { var result = new List <JC_FIRE_PLOTTING_Model>(); DataTable dt = BaseDT.JC_FIRE_PLOTTING.getDT(sw);//列表 JC_FIRE_PLOTTING_Model m = new JC_FIRE_PLOTTING_Model(); if (dt.Rows.Count > 0) { int i = 0; m.JC_FIRE_PLOTTINGID = dt.Rows[i]["JC_FIRE_PLOTTINGID"].ToString(); m.JCFID = dt.Rows[i]["JCFID"].ToString(); m.PLOTTINGTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["PLOTTINGTIME"].ToString()); m.PLOTTINGTITLE = dt.Rows[i]["PLOTTINGTITLE"].ToString(); m.PLOTTINGFILENAME = dt.Rows[i]["PLOTTINGFILENAME"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取记录 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(JC_FIRE_PLOTTING_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM JC_FIRE_PLOTTING"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.JC_FIRE_PLOTTINGID) == false) { sb.AppendFormat(" AND JC_FIRE_PLOTTINGID = '{0}'", ClsSql.EncodeSql(sw.JC_FIRE_PLOTTINGID)); } if (string.IsNullOrEmpty(sw.JCFID) == false) { sb.AppendFormat(" AND JCFID = '{0}'", ClsSql.EncodeSql(sw.JCFID)); } string sql = ""; sql = " SELECT JC_FIRE_PLOTTINGID, JCFID, PLOTTINGTIME, PLOTTINGTITLE, PLOTTINGFILENAME" + sb.ToString() + " order by PLOTTINGTIME"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }