/// <summary>
/// 获取最低级的tree
/// </summary>
/// <param name="car"></param>
/// <returns></returns>
public static JObject getLastJobjectCar(DC_CAR_Model car)
{
var model = T_SYS_DICTCls.getListModel(new T_SYS_DICTSW {
DICTTYPEID = "33", DICTVALUE = car.CARTYPE
}).FirstOrDefault();
var name = car.NAME + "【" + model.DICTNAME + "】";
//getPosition
StringBuilder sb = new StringBuilder();
string carimage = "car_" + car.CARTYPE;
//偏移量计算
// double[] arr = ClsPositionUtil.gcj_To_Gps84(double.Parse(car.WD), double.Parse(car.JD));
if (!string.IsNullOrEmpty(car.JD) || !string.IsNullOrEmpty(car.WD))
{
double[] arr = ClsPositionTrans.GpsTransform(double.Parse(car.WD), double.Parse(car.JD), ConfigCls.getSDELonLatTransform());
if (arr.Length > 0)
{
car.JD = arr[1].ToString();
car.WD = arr[0].ToString();
}
//string sb = "<a onClick="">" + name + "</a>";
sb.AppendFormat("<font onClick='movetocar(\"{0}\",\"{1}\",\"{2}\")'>{3}</font>", car.JD, car.WD, carimage, name);
}
else
{
sb.AppendFormat("<font onClick='alert(\"缺少经纬度无法定位。\")'>{0}</font>", name);
}
JObject root = new JObject {
{ "id", car.DC_CAR_ID }, { "text", sb.ToString() }
};
return(root);
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(DC_CAR_Model m)
{
if (m.opMethod == "Add")
{
//SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
Message msgUser = BaseDT.DC_CAR.Add(m);
return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url));
}
if (m.opMethod == "Mdy")
{
//SystemCls.LogSave("4", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
Message msgUser = BaseDT.DC_CAR.Mdy(m);
return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url));
}
if (m.opMethod == "MdyJWD")
{
//SystemCls.LogSave("4", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
Message msgUser = BaseDT.DC_CAR.MdyJWD(m);
return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url));
}
if (m.opMethod == "Del")
{
//SystemCls.LogSave("5", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m));
Message msgUser = BaseDT.DC_CAR.Del(m);
return(new Message(msgUser.Success, msgUser.Msg, msgUser.Url));
}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 获取分页
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <DC_CAR_Model> getModelList(DC_CAR_SW sw, out int total)
{
var result = new List <DC_CAR_Model>();
DataTable dt = BaseDT.DC_CAR.getDT(sw, out total);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt33 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "33"
}); //数据中心车辆类型
for (int i = 0; i < dt.Rows.Count; i++)
{
DC_CAR_Model m = new DC_CAR_Model();
m.DC_CAR_ID = dt.Rows[i]["DC_CAR_ID"].ToString();
m.CARTYPE = dt.Rows[i]["CARTYPE"].ToString();
m.CARTYPEName = BaseDT.T_SYS_DICT.getName(dt33, m.CARTYPE);
m.NUMBER = dt.Rows[i]["NUMBER"].ToString();
m.NAME = dt.Rows[i]["NAME"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
//m.BUYYEAR =dt.Rows[i]["BUYYEAR"].ToString();
m.BUYPRICE = dt.Rows[i]["BUYPRICE"].ToString();
m.PLATENUM = dt.Rows[i]["PLATENUM"].ToString();
m.DRIVER = dt.Rows[i]["DRIVER"].ToString();
m.CONTACTS = dt.Rows[i]["CONTACTS"].ToString();
m.GPSEQUIP = dt.Rows[i]["GPSEQUIP"].ToString();
m.GPSTELL = dt.Rows[i]["GPSTELL"].ToString();
m.STOREADDR = dt.Rows[i]["STOREADDR"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.BUYYEAR = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUYYEAR"].ToString());
if (m.BYORGNO.Substring(6, 3) != "000")
{
m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
}
m.ORGXSName = BaseDT.T_SYS_ORG.getSXName(dtORG, m.BYORGNO);
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dt33.Clear();
dt33.Dispose();
return(result);
}
/// <summary>
/// 护林员上传
/// </summary>
/// <param name="filePath">文件路径</param>
public static void CarUpload(string filePath)
{
HSSFWorkbook hssfworkbook;
try
{
using (FileStream file = new FileStream(filePath, FileMode.Open, FileAccess.Read))
{
hssfworkbook = new HSSFWorkbook(file);
}
}
catch (Exception e)
{
throw e;
}
NPOI.SS.UserModel.ISheet sheet = hssfworkbook.GetSheetAt(0);
int rowCount = sheet.LastRowNum;
for (int i = (sheet.FirstRowNum + 1); i <= rowCount; i++)
{
IRow row = sheet.GetRow(i);
string[] arr = new string[12];
for (int k = 0; k < arr.Length; k++)
{
if (k != 6)
{
arr[k] = row.GetCell(k) == null ? "" : row.GetCell(k).ToString();//循环获取每一单元格内容
}
else
{
arr[k] = row.GetCell(k).DateCellValue.ToString("yyyy-MM-dd");
}
}
DC_CAR_Model m = new DC_CAR_Model();
//单位 车辆类型 名称 编号 号牌 存储地点 购买年份 购买价格 驾驶员 联系方式 经度 纬度
if (string.IsNullOrEmpty(arr[0]) || string.IsNullOrEmpty(arr[2]))
{
continue;
}
m.BYORGNO = BaseDT.T_SYS_ORG.getCodeByName(arr[0]);
m.NAME = arr[2];
m.NUMBER = arr[3];
m.PLATENUM = arr[4];
m.STOREADDR = arr[5];
m.BUYYEAR = arr[6];
if (m.BUYYEAR == "9999-12-31")
{
m.BUYYEAR = "1900-01-01";
}
m.BUYPRICE = arr[7];
m.DRIVER = arr[8];
m.CONTACTS = arr[9];
string jd = arr[10];
string wd = arr[11];
if (string.IsNullOrEmpty(jd) == false && string.IsNullOrEmpty(wd) == false)
{
double[] brr = ClsPositionTrans.GpsTransform(double.Parse(wd), double.Parse(jd), "1");
m.JD = brr[1].ToString();
m.WD = brr[0].ToString();
}
if (arr[1].Trim() == "指挥车")//装备类型
{
m.CARTYPE = "1";
}
else if (arr[1].Trim() == "运兵车")
{
m.CARTYPE = "2";
}
else if (arr[1].Trim() == "供水车")
{
m.CARTYPE = "3";
}
else if (arr[1].Trim() == "通讯车")
{
m.CARTYPE = "4";
}
else if (arr[1].Trim() == "宣传车")
{
m.CARTYPE = "5";
}
else
{
m.CARTYPE = "1";
}
BaseDT.DC_CAR.Add(m);
string a = row.GetCell(0).ToString();
string a1 = row.GetCell(1).ToString();
string a2 = row.GetCell(2).ToString();
}
}
