/// <summary>
/// 管理
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Man(JC_INFRAREDCAMERA_PHOTO_Model m)
{
if (string.IsNullOrEmpty(m.MANTIME))
{
m.MANTIME = ClsSwitch.SwitTM(DateTime.Now);
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE tb_rcvtmp");
sb.AppendFormat(" set ");
sb.AppendFormat("MANSTATE='{0}'", ClsSql.EncodeSql(m.MANSTATE));
sb.AppendFormat(",MANRESULT='{0}'", ClsSql.EncodeSql(m.MANRESULT));
sb.AppendFormat(",MANTIME='{0}'", ClsSql.EncodeSql(m.MANTIME));
sb.AppendFormat(",MANUSERID='{0}'", ClsSql.EncodeSql(m.MANUSERID));
sb.AppendFormat(" where smid= '{0}'", ClsSql.EncodeSql(m.smid));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功！", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 删除相机图片
/// </summary>
/// <returns></returns>
public JsonResult DeletCameraPhoto()
{
string smid = Request.Params["smid"];//接收信息id
var sw = new JC_INFRAREDCAMERA_PHOTO_Model();
sw.smid = smid;
sw.opMethod = "Del";
var ms = JC_INFRAREDCAMERACls.ManagerPhoto(sw);
return(Json(ms));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(JC_INFRAREDCAMERA_PHOTO_Model m)
{
DataBaseClass.ExeSql("delete tb_rcvmmsfiles where mmsfilesid in(select mmsfilesid from tb_rcvtmp where smid in(" + m.smid + "))");
DataBaseClass.ExeSql("delete from tb_rcvtmp where smid in(" + m.smid + ")");
bool bln = true;// DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功！", ""));
}
else
{
return(new Message(false, "删除失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 根据查询条件获取某一条信息记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static JC_INFRAREDCAMERA_PHOTO_Model getModelNewPhoto(JC_INFRAREDCAMERA_PHOTO_SW sw)
{
DataTable dt = BaseDT.JC_INFRAREDCAMERA_PHOTO.getNewDT(sw);
JC_INFRAREDCAMERA_PHOTO_Model m = new JC_INFRAREDCAMERA_PHOTO_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.JC_INFRAREDCAMERA_PHOTOID = dt.Rows[i]["JC_INFRAREDCAMERA_PHOTOID"].ToString();
m.INFRAREDCAMERAID = dt.Rows[i]["INFRAREDCAMERAID"].ToString();
m.PHOTOTIME = dt.Rows[i]["PHOTOTIME"].ToString();
m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message ManagerPhoto(JC_INFRAREDCAMERA_PHOTO_Model m)
{
if (m.opMethod == "Del")
{
SystemCls.LogSave("5", "红外相机图片:" + m.smid, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_INFRAREDCAMERA_PHOTO.Del(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
if (m.opMethod == "Man")
{
SystemCls.LogSave("5", "红外相机图片:" + m.smid, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_INFRAREDCAMERA_PHOTO.Man(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <JC_INFRAREDCAMERA_PHOTO_Model> getListNewModelPhoto(JC_INFRAREDCAMERA_PHOTO_SW sw)
{
DataTable dt = BaseDT.JC_INFRAREDCAMERA_PHOTO.getNewDT(sw);//列表
var result = new List <JC_INFRAREDCAMERA_PHOTO_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_INFRAREDCAMERA_PHOTO_Model m = new JC_INFRAREDCAMERA_PHOTO_Model();
m.JC_INFRAREDCAMERA_PHOTOID = dt.Rows[i]["JC_INFRAREDCAMERA_PHOTOID"].ToString();
m.INFRAREDCAMERAID = dt.Rows[i]["INFRAREDCAMERAID"].ToString();
m.PHOTOTIME = dt.Rows[i]["PHOTOTIME"].ToString();
m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取用户列表（分页）
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <JC_INFRAREDCAMERA_PHOTO_Model> getListModelPhotoPager(JC_INFRAREDCAMERA_PHOTO_SW sw, out int total)
{
var result = new List <JC_INFRAREDCAMERA_PHOTO_Model>();
DataTable dt = BaseDT.JC_INFRAREDCAMERA_PHOTO.getDT(sw, out total);//用户列表
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
});
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_INFRAREDCAMERA_PHOTO_Model m = new JC_INFRAREDCAMERA_PHOTO_Model();
m.smid = dt.Rows[i]["smid"].ToString();
m.tpa = dt.Rows[i]["tpa"].ToString();
m.recvdatetime = ClsSwitch.SwitTM(dt.Rows[i]["recvdatetime"].ToString());
m.filename = dt.Rows[i]["filename"].ToString();
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = ClsSwitch.SwitTM(dt.Rows[i]["MANTIME"].ToString());
m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
if (!string.IsNullOrEmpty(m.MANUSERID))
{
DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'");
if (drUser.Length > 0)
{
m.ManUserName = drUser[0]["USERNAME"].ToString();
}
}
m.BasicInfoModel = getModel(new JC_INFRAREDCAMERA_BASICINFO_SW {
PHONE = m.tpa
});
result.Add(m);
}
dtUser.Clear();
dtUser.Dispose();
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取某一条信息记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static JC_INFRAREDCAMERA_PHOTO_Model getModelPhoto(JC_INFRAREDCAMERA_PHOTO_SW sw)
{
DataTable dt = BaseDT.JC_INFRAREDCAMERA_PHOTO.getDT(sw);
JC_INFRAREDCAMERA_PHOTO_Model m = new JC_INFRAREDCAMERA_PHOTO_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.smid = dt.Rows[i]["smid"].ToString();
m.tpa = dt.Rows[i]["tpa"].ToString();
m.recvdatetime = ClsSwitch.SwitTM(dt.Rows[i]["recvdatetime"].ToString());
m.filename = dt.Rows[i]["filename"].ToString();
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = ClsSwitch.SwitTM(dt.Rows[i]["MANTIME"].ToString());
m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
if (!string.IsNullOrEmpty(m.MANUSERID))
{
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
USERID = m.MANUSERID
});
DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'");
if (drUser.Length > 0)
{
m.ManUserName = drUser[0]["USERNAME"].ToString();
}
dtUser.Clear();
dtUser.Dispose();
}
m.BasicInfoModel = getModel(new JC_INFRAREDCAMERA_BASICINFO_SW {
PHONE = m.tpa
});
}
dt.Clear();
dt.Dispose();
return(m);
}
