/// <summary> /// 根据查询条件获取某一条信息记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static JC_INFRAREDCAMERA_BASICINFO_Model getModel(JC_INFRAREDCAMERA_BASICINFO_SW sw) { DataTable dt = BaseDT.JC_INFRAREDCAMERA_BASICINFO.getDT(sw); JC_INFRAREDCAMERA_BASICINFO_Model m = new JC_INFRAREDCAMERA_BASICINFO_Model(); DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 if (dt.Rows.Count > 0) { int i = 0; m.INFRAREDCAMERAID = dt.Rows[i]["INFRAREDCAMERAID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); m.INFRAREDCAMERANAME = dt.Rows[i]["INFRAREDCAMERANAME"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.GC = dt.Rows[i]["GC"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, dt.Rows[i]["BYORGNO"].ToString()); } dt.Clear(); dt.Dispose(); dtORG.Clear(); dtORG.Dispose(); return(m); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static IEnumerable <JC_INFRAREDCAMERA_BASICINFO_Model> getListModel(JC_INFRAREDCAMERA_BASICINFO_SW sw, out int total) { DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 DataTable dt = BaseDT.JC_INFRAREDCAMERA_BASICINFO.getDT(sw, out total); //列表 var result = new List <JC_INFRAREDCAMERA_BASICINFO_Model>(); for (int i = 0; i < dt.Rows.Count; i++) { JC_INFRAREDCAMERA_BASICINFO_Model m = new JC_INFRAREDCAMERA_BASICINFO_Model(); m.INFRAREDCAMERAID = dt.Rows[i]["INFRAREDCAMERAID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); m.INFRAREDCAMERANAME = dt.Rows[i]["INFRAREDCAMERANAME"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.GC = dt.Rows[i]["GC"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.PHONE = dt.Rows[i]["PHONE"].ToString(); m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, dt.Rows[i]["BYORGNO"].ToString()); result.Add(m); } dtORG.Clear(); dtORG.Dispose(); dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(JC_INFRAREDCAMERA_BASICINFO_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE JC_INFRAREDCAMERA_BASICINFO"); sb.AppendFormat(" set "); sb.AppendFormat(" BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",INFRAREDCAMERANAME='{0}'", ClsSql.EncodeSql(m.INFRAREDCAMERANAME)); sb.AppendFormat(" ,PHONE='{0}'", ClsSql.EncodeSql(m.PHONE)); sb.AppendFormat(",JD='{0}'", ClsSql.EncodeSql(m.JD)); sb.AppendFormat(",WD='{0}'", ClsSql.EncodeSql(m.WD)); sb.AppendFormat(",GC='{0}'", ClsSql.EncodeSql(m.GC)); sb.AppendFormat(",ADDRESS='{0}'", ClsSql.EncodeSql(m.ADDRESS)); sb.AppendFormat(" where INFRAREDCAMERAID= '{0}'", ClsSql.EncodeSql(m.INFRAREDCAMERAID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 添加三维库 /// </summary> /// <param name="m">参见模型</param> /// <param name="emid">参见模型</param> /// <returns>参见模型</returns> public static Message AddHONGWAIXIANGJI(JC_INFRAREDCAMERA_BASICINFO_Model m, string emid) { //if (PublicCls.OrgIsZhen(m.BYORGNO) == false) // return new Message(false, "添加失败,所属单位必须为乡镇!", ""); StringBuilder sb = new StringBuilder(); sb.AppendFormat("insert into HONGWAIXIANGJI(OBJECTID,NAME,JD,WD,Shape,ADDRESS) values("); sb.AppendFormat("{0},", ClsSql.saveNullField(emid)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.INFRAREDCAMERANAME)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.JD)); sb.AppendFormat("{0},", ClsSql.saveNullField(m.WD)); sb.AppendFormat("{0},", m.Shape); sb.AppendFormat("{0})", ClsSql.saveNullField(m.ADDRESS)); bool bln = SDEDataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(JC_INFRAREDCAMERA_BASICINFO_Model m) { //if (PublicCls.OrgIsZhen(m.BYORGNO) == false) // return new Message(false, "添加失败,所属单位必须为乡镇!", ""); StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO JC_INFRAREDCAMERA_BASICINFO(BYORGNO,INFRAREDCAMERANAME,PHONE,JD,WD,GC,ADDRESS)"); sb.AppendFormat("output inserted.INFRAREDCAMERAID "); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.INFRAREDCAMERANAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PHONE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.JD)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.WD)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.GC)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ADDRESS)); sb.AppendFormat(")"); string strid = DataBaseClass.ReturnSqlField(sb.ToString()); if (!string.IsNullOrEmpty(strid)) { return(new Message(true, "添加成功!", strid)); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message DelHONGWAIXIANGJI(JC_INFRAREDCAMERA_BASICINFO_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete HONGWAIXIANGJI"); sb.AppendFormat(" where OBJECTID= '{0}'", ClsSql.EncodeSql(m.INFRAREDCAMERAID)); bool bln = SDEDataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 修改空间库 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message MdyHONGWAIXIANGJI(JC_INFRAREDCAMERA_BASICINFO_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE HONGWAIXIANGJI"); sb.AppendFormat(" set "); sb.AppendFormat("NAME={0}", ClsSql.saveNullField(m.INFRAREDCAMERANAME)); sb.AppendFormat(",JD={0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",ADDRESS={0}", ClsSql.saveNullField(m.ADDRESS)); sb.AppendFormat(",Shape={0}", m.Shape); sb.AppendFormat(" where OBJECTID= {0}", ClsSql.saveNullField(m.INFRAREDCAMERAID)); bool bln = SDEDataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(JC_INFRAREDCAMERA_BASICINFO_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "红外相机:" + m.INFRAREDCAMERANAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_INFRAREDCAMERA_BASICINFO.Add(m); if (msgUser.Success == true) { Message msgUser1 = BaseDT.JC_INFRAREDCAMERA_BASICINFO.AddHONGWAIXIANGJI(m, msgUser.Url);//添加三维库 return(new Message(msgUser1.Success, msgUser1.Msg, m.returnUrl)); } return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "红外相机:" + m.INFRAREDCAMERANAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_INFRAREDCAMERA_BASICINFO.Mdy(m); if (msgUser.Success == true) { Message msgUser1 = BaseDT.JC_INFRAREDCAMERA_BASICINFO.MdyHONGWAIXIANGJI(m);//添加三维库 return(new Message(msgUser1.Success, msgUser1.Msg, m.returnUrl)); } return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "红外相机:" + m.INFRAREDCAMERANAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_INFRAREDCAMERA_BASICINFO.Del(m); if (msgUser.Success == true) { Message msgUser1 = BaseDT.JC_INFRAREDCAMERA_BASICINFO.DelHONGWAIXIANGJI(m);//添加三维库 return(new Message(msgUser1.Success, msgUser1.Msg, m.returnUrl)); } return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }