/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(JC_FIRE_PLOTTING_Model m) { if (string.IsNullOrEmpty(m.JCFID)) { return(new Message(false, "添加失败,请传递正确的火情序号!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO JC_FIRE_PLOTTING( JCFID, PLOTTINGTIME, PLOTTINGTITLE, PLOTTINGFILENAME)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.JCFID)); sb.AppendFormat(",'{0}'", PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PLOTTINGTITLE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PLOTTINGFILENAME)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { logs.Error(sb.ToString()); return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 删除标绘 /// </summary> /// <returns></returns> public JsonResult RemoveFlyFire() { string id = Request.Params["id"]; var m = new JC_FIRE_PLOTTING_Model(); m.opMethod = "Del"; m.JC_FIRE_PLOTTINGID = id; var ms = JC_FIRE_PLOTTINGCls.Manager(m); return(Json(ms)); }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(JC_FIRE_PLOTTING_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete JC_FIRE_PLOTTING"); sb.AppendFormat(" where JC_FIRE_PLOTTINGID= '{0}'", ClsSql.EncodeSql(m.JC_FIRE_PLOTTINGID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { logs.Error(sb.ToString()); return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
public JsonResult Upload(HttpPostedFileBase upFile, string jcfid, string subjectName) { if (upFile == null) { return(Json(new { purl = "", error = "请上传文件" })); } string fileName = System.IO.Path.GetFileName(upFile.FileName); string ipath = System.Configuration.ConfigurationManager.AppSettings["FireFlaPath"].ToString();//相对路径 string PhysicalPath = Server.MapPath(ipath + "\\"); if (!Directory.Exists(PhysicalPath)) //判断文件夹是否已经存在 { Directory.CreateDirectory(PhysicalPath); //创建文件夹 } string filePhysicalPath = PhysicalPath + fileName; string purl = "", error = ""; try { //int i = 0; upFile.SaveAs(filePhysicalPath); //写库 var m = new JC_FIRE_PLOTTING_Model();//监测_火情标绘表 m.opMethod = "Add"; m.JCFID = jcfid; m.PLOTTINGFILENAME = fileName; //文件名称 m.PLOTTINGTIME = DateTime.Now.ToString(); //标绘时间 var infolist = JC_FIRE_PLOTTINGCls.getModelList(new JC_FIRE_PLOTTING_SW { JCFID = jcfid }); //if (infolist.Any()) //{ // i = infolist.Max(p => Convert.ToInt32(p.PLOTTINGTITLE));//获取最大序号标题 //} m.PLOTTINGTITLE = subjectName; var ms = JC_FIRE_PLOTTINGCls.Manager(m); purl = PhysicalPath + fileName; } catch (Exception ex) { error = ex.Message; } return(Json(new{ purl = purl, error = error })); }
/// <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="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(JC_FIRE_PLOTTING_Model m) { if (m.opMethod == "Add") { //SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_FIRE_PLOTTING.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { //SystemCls.LogSave("4", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_FIRE_PLOTTING.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { //SystemCls.LogSave("5", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_FIRE_PLOTTING.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(JC_FIRE_PLOTTING_Model m) { StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO //JCFID, PLOTTINGTIME, PLOTTINGTITLE, PLOTTINGFILENAME sb.AppendFormat("UPDATE JC_FIRE_PLOTTING"); sb.AppendFormat(" set "); sb.AppendFormat("PLOTTINGTITLE={0}", ClsSql.saveNullField(m.PLOTTINGTITLE)); sb.AppendFormat(",PLOTTINGFILENAME={0}", ClsSql.saveNullField(m.PLOTTINGFILENAME)); sb.AppendFormat(" where JC_FIRE_PLOTTINGID= '{0}'", ClsSql.EncodeSql(m.JC_FIRE_PLOTTINGID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { logs.Error(sb.ToString()); return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 本地文件上传服务器 /// </summary> /// <returns></returns> public JsonResult UploadFileFromLocal() { ILog logs = LogHelper.GetInstance(); Message ms = null; string localpath = Request.Params["localpath"]; //本地路径(包含文件名) string jcfid = Request.Params["jcfid"]; //监测火情id FileStream myStream = new FileStream(localpath, FileMode.Open, FileAccess.Read); byte[] dataByte = new byte[myStream.Length]; myStream.Read(dataByte, 0, dataByte.Length); //写到2进制数组中 myStream.Close(); FileStream fos = null; try { var i = 0; string ipath = System.Configuration.ConfigurationManager.AppSettings["FireFlaPath"].ToString(); //相对路径 string PhysicalPath = Server.MapPath(ipath + "\\"); if (!Directory.Exists(PhysicalPath)) //判断文件夹是否已经存在 { Directory.CreateDirectory(PhysicalPath); //创建文件夹 } string filename = System.IO.Path.GetFileName(localpath); //文件名 fos = new FileStream(PhysicalPath + filename, FileMode.OpenOrCreate, FileAccess.ReadWrite); fos.Write(dataByte, 0, dataByte.Length); fos.Close(); //写库 var m = new JC_FIRE_PLOTTING_Model();//监测_火情标绘表 m.opMethod = "Add"; m.JCFID = jcfid; m.PLOTTINGFILENAME = filename; //文件名称 m.PLOTTINGTIME = DateTime.Now.ToString(); //标绘时间 var infolist = JC_FIRE_PLOTTINGCls.getModelList(new JC_FIRE_PLOTTING_SW { JCFID = jcfid }); if (infolist.Any()) { i = infolist.Max(p => Convert.ToInt32(p.PLOTTINGTITLE));//获取最大序号标题 } m.PLOTTINGTITLE = (++i).ToString(); ms = JC_FIRE_PLOTTINGCls.Manager(m); if (ms.Success == true) { ms = new Message(true, "上传服务器成功", ""); } else { ms = new Message(false, "上传服务器出错", ""); } } catch (Exception ex) { logs.Error(ex.Message); ms = new Message(false, "上传服务器出错", ""); } finally { if (fos != null) { try { fos.Close(); } catch { ms = new Message(false, "上传服务器出错", ""); } } } return(Json(ms)); }