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