/// <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]);
}
