/// <summary> /// /// </summary> /// <param name="offset">记录开始位置</param> /// <param name="limit">每页记录条数</param> /// <returns></returns> public static DataSet GetBriefList1(int offset, int limit, string sort = "RegTime", string order = "desc", string search = "") { string deorder = order.ToLower() == "desc" ? "asc" : "desc"; int endRecord = offset + limit; string sql = "SELECT * FROM RTKUserInfo w1,( SELECT TOP " + limit + " w.ID FROM( SELECT TOP " + endRecord + "* FROM RTKUserInfo where UserName like '%" + search + "%' ORDER BY @sort @order) w ORDER BY w.@sort @deorder) w2 WHERE w1.ID = w2.ID ORDER BY w1.@sort @order"; sql = sql.Replace("@sort", sort); sql = sql.Replace("@order", order); sql = sql.Replace("@deorder", deorder); return(DBHelperSQL.GetDataSet(sql, connectionString)); }
/// <summary> /// /// </summary> /// <param name="offset">记录开始位置</param> /// <param name="limit">每页记录条数</param> /// <returns></returns> public static DataSet GetBriefList1(int offset, int limit, string sort = "SubmitTime", string order = "desc", string search = "", string strwhere = "1=1") { string deorder = order.ToLower() == "desc" ? "asc" : "desc"; int endRecord = offset + limit; string sql = "SELECT * FROM InvoiceList w1,( SELECT TOP " + limit + " w.ID FROM( SELECT TOP " + endRecord + "* FROM InvoiceList where OrderNumber like '%" + search + "%' and " + strwhere + " ORDER BY @sort @order) w ORDER BY w.@sort @deorder) w2 WHERE w1.ID = w2.ID ORDER BY w1.@sort @order"; sql = sql.Replace("@sort", sort); sql = sql.Replace("@order", order); sql = sql.Replace("@deorder", deorder); return(DBHelperSQL.GetDataSet(sql, connectionString)); }
public static DataSet GetList1(string username) { string sql = @"select * from RTKUserStatus where UserName in( SELECT r2.UserName FROM[dbo].[RegisterUser] r1, RTKUserInfo r2 WHERE r1.UserName = r2.RegisterUserName AND r2.RegisterUserName ='******')"; return(DBHelperSQL.GetDataSet(sql, connectionString)); }
/// <summary> /// 获得新闻列表 /// </summary> /// <param name="offset">记录开始位置</param> /// <param name="limit">每页记录条数</param> /// <returns></returns> public static DataSet GetBriefList(int offset, int limit) { int endRecord = offset + limit; string sql = "SELECT w1.ID,w1.Title,w1.Time,w1.Pageview,w1.Author FROM News w1,( SELECT TOP " + limit + " w.ID FROM( SELECT TOP " + endRecord + " ID,Title,Time,Pageview,Author FROM News ORDER BY ID ASC) w ORDER BY w.ID DESC) w2 WHERE w1.ID = w2.ID ORDER BY w1.ID ASC"; //SqlParameter Limit = new SqlParameter("@limit", SqlDbType.NVarChar, 500); Limit.Value = limit; //SqlParameter EndRecord = new SqlParameter("@endRecord", SqlDbType.DateTime); //EndRecord.Value = endRecord; //return DBHelperSQL.GetDataSet(sql, new SqlParameter[] { Limit, EndRecord }); return(DBHelperSQL.GetDataSet(sql, connectionString)); }
public static DataSet GetList1(string strWhere) { string strSql = "select Top 3000* from RTKUserPosiRec where "; if (strWhere.Trim() != "") { strSql += strWhere; } DataSet dd = DBHelperSQL.GetDataSet(strSql, connectionString); return(DBHelperSQL.GetDataSet(strSql, connectionString)); }
public static Model.OrderList GetModel(int ID) { string strSql = "select * from OrderList where ID = '" + ID + "'"; Model.OrderList model = new Model.OrderList(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.OrderNumber = Convert.ToString(ds.Tables[0].Rows[0]["OrderNumber"]); model.UserName = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]); model.SubmitTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["SubmitTime"]); model.OrderStatus = Convert.ToInt32(ds.Tables[0].Rows[0]["OrderStatus"]); model.WorkArea = Convert.ToString(ds.Tables[0].Rows[0]["WorkArea"]); model.ServerType = Convert.ToString(ds.Tables[0].Rows[0]["ServerType"]); model.CoorTransEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["CoorTransEnable"]); model.HeightTransEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["HeightTransEnable"]); model.SHPTransEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["SHPTransEnable"]); model.DXFTransEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["DXFTransEnable"]); model.PPPserverEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["PPPserverEnable"]); model.ObsQualityEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["ObsQualityEnable"]); model.BaseLineEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["BaseLineEnable"]); model.MultiBaseLineEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["MultiBaseLineEnable"]); model.CoorSystemEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["CoorSystemEnable"]); model.RoamingServiceEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["RoamingServiceEnable"]); model.RoamingServiceArea = Convert.ToString(ds.Tables[0].Rows[0]["RoamingServiceArea"]); model.AccountNum = Convert.ToInt32(ds.Tables[0].Rows[0]["AccountNum"]); model.ServiceDuration = Convert.ToString(ds.Tables[0].Rows[0]["ServiceDuration"]); model.Price = Convert.ToString(ds.Tables[0].Rows[0]["Price"]); model.Dealer = Convert.ToString(ds.Tables[0].Rows[0]["Dealer"]); model.DealTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["DealTime"]); model.PayMethod = Convert.ToInt32(ds.Tables[0].Rows[0]["PayMethod"]); model.TransferCertificate = Convert.ToString(ds.Tables[0].Rows[0]["TransferCertificate"]); model.PayTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["PayTime"]); model.RoamID = Convert.ToString(ds.Tables[0].Rows[0]["RoamID"]); model.company = Convert.ToString(ds.Tables[0].Rows[0]["company"]); model.OrderContent = Convert.ToString(ds.Tables[0].Rows[0]["OrderContent"]); model.OrdeType = Convert.ToInt32(ds.Tables[0].Rows[0]["OrdeType"]); model.ElevationEnable = Convert.ToInt32(ds.Tables[0].Rows[0]["ElevationEnable"]); model.IsRenew = Convert.ToString(ds.Tables[0].Rows[0]["IsRenew"]); return(model); } else { return(null); } }
public static Model.InternetInformation GetModel(int ID) { string strSql = "select * from InternetInformation where ID = '" + ID + "'"; Model.InternetInformation model = new Model.InternetInformation(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.Type = Convert.ToString(ds.Tables[0].Rows[0]["Type"]); model.DataLineStartP = Convert.ToString(ds.Tables[0].Rows[0]["DataLineStartP"]); model.DataLineEndP = Convert.ToString(ds.Tables[0].Rows[0]["DataLineEndP"]); model.EncryptionTechnology = Convert.ToString(ds.Tables[0].Rows[0]["EncryptionTechnology"]); model.BandWidth = Convert.ToString(ds.Tables[0].Rows[0]["BandWidth"]); model.GreenOperator = Convert.ToString(ds.Tables[0].Rows[0]["GreenOperator"]); model.TechnicalSupportStaff = Convert.ToString(ds.Tables[0].Rows[0]["TechnicalSupportStaff"]); model.FDataLineType = Convert.ToString(ds.Tables[0].Rows[0]["FDataLineType"]); model.FEncryptionTechnology = Convert.ToString(ds.Tables[0].Rows[0]["FEncryptionTechnology"]); model.FBandWidth = Convert.ToString(ds.Tables[0].Rows[0]["FBandWidth"]); model.FGreenOperator = Convert.ToString(ds.Tables[0].Rows[0]["FGreenOperator"]); model.FTechnicalSupportStaff = Convert.ToString(ds.Tables[0].Rows[0]["FTechnicalSupportStaff"]); model.ServerIP = Convert.ToString(ds.Tables[0].Rows[0]["ServerIP"]); model.ServerPort = Convert.ToString(ds.Tables[0].Rows[0]["ServerPort"]); model.ServerMachineName = Convert.ToString(ds.Tables[0].Rows[0]["ServerMachineName"]); model.ServerLogo = Convert.ToString(ds.Tables[0].Rows[0]["ServerLogo"]); model.ServerUse = Convert.ToString(ds.Tables[0].Rows[0]["ServerUse"]); model.ServerRemark = Convert.ToString(ds.Tables[0].Rows[0]["ServerRemark"]); model.StorageIP = Convert.ToString(ds.Tables[0].Rows[0]["StorageIP"]); model.StoragePort = Convert.ToString(ds.Tables[0].Rows[0]["StoragePort"]); model.StorageMachineName = Convert.ToString(ds.Tables[0].Rows[0]["StorageMachineName"]); model.StorageLogo = Convert.ToString(ds.Tables[0].Rows[0]["StorageLogo"]); model.StorageUse = Convert.ToString(ds.Tables[0].Rows[0]["StorageUse"]); model.StorageRemark = Convert.ToString(ds.Tables[0].Rows[0]["StorageRemark"]); model.EquipmentID = Convert.ToString(ds.Tables[0].Rows[0]["EquipmentID"]); model.EquipConfig = Convert.ToString(ds.Tables[0].Rows[0]["EquipConfig"]); model.Topological = Convert.ToString(ds.Tables[0].Rows[0]["Topological"]); model.RouterConfig = Convert.ToString(ds.Tables[0].Rows[0]["RouterConfig"]); return(model); } else { return(null); } }
/// <summary> /// 从数据库中提取出真参数,用于何冰写的坐标转换程序 /// </summary> /// <param name="YSZBXM"></param> /// <param name="MDZBXM"></param> /// <returns></returns> public static Model.OCoorSysPars GetHBModel(string YSZBXM, string MDZBXM) { string strSql = "select * from CoorSysPars where YSZBXM ='" + YSZBXM + "' and MDZBXM='" + MDZBXM + "'"; Model.OCoorSysPars model = new Model.OCoorSysPars(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);; if (ds.Tables[0].Rows.Count > 0) { model.YSZBXM = Convert.ToString(ds.Tables[0].Rows[0]["YSZBXM"]); model.MDZBXM = Convert.ToString(ds.Tables[0].Rows[0]["MDZBXM"]); model.X = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["X"].ToString())); model.Y = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Y"].ToString())); model.Z = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Z"].ToString())); model.aa = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["aa"].ToString())); model.bb = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["bb"].ToString())); model.cc = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["cc"].ToString())); model.m = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["m"].ToString())); model.X = Math.Round(model.X - 243243.24, 4); model.Y = Math.Round(model.Y - 1983435.23, 4); model.Z = Math.Round(model.Z + 1233234.12, 4); model.aa = Math.Round(model.aa - 76755.99, 8); model.bb = Math.Round(model.bb + 4564543.78, 8); model.cc = Math.Round(model.cc + 321907.65, 8); model.m = Math.Round(model.m - 432487.123, 11); model.YSMajorAxis = Convert.ToDouble(ds.Tables[0].Rows[0]["YSMajorAxis"]); model.YSe2 = Convert.ToDouble(ds.Tables[0].Rows[0]["YSe2"]); model.MDMajorAxis = Convert.ToDouble(ds.Tables[0].Rows[0]["MDMajorAxis"]); model.MDe2 = Convert.ToDouble(ds.Tables[0].Rows[0]["MDe2"]); model.YSRemarkName = Convert.ToString(ds.Tables[0].Rows[0]["YSRemarkName"]); model.MDRemarkName = Convert.ToString(ds.Tables[0].Rows[0]["MDRemarkName"]); model.YSDAlpha = Convert.ToDouble(ds.Tables[0].Rows[0]["YSDAlpha"]); model.YSDAlpha = 1 / model.YSDAlpha; model.MDDAlpha = Convert.ToDouble(ds.Tables[0].Rows[0]["MDDAlpha"]); model.MDDAlpha = 1 / model.MDDAlpha; model.CMeridian = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["CMeridian"].ToString())); model.ProjElevation = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["ProjElevation"].ToString())); model.OriginNorth = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["OriginNorth"].ToString())); model.OriginEast = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["OriginEast"].ToString())); model.AreaID = Convert.ToInt32(ds.Tables[0].Rows[0]["AreaID"].ToString()); return(model); } else { return(null); } }
public static DataSet GetBriefList(int offset, int limit, string sort = "ReviceTime", string order = "desc", string Information = "") { string deorder = order.ToLower() == "desc" ? "asc" : "desc"; int endRecord = offset + limit; string sql = "SELECT * FROM EquipReviceRecord w1,( SELECT TOP @limit w.ID FROM( SELECT TOP @endRecord * FROM EquipReviceRecord where Information like '%@search%' ORDER BY @sort @order) w ORDER BY w.@sort @deorder) w2 WHERE w1.ID = w2.ID ORDER BY w1.@sort @order"; sql = sql.Replace("@limit", limit.ToString()); sql = sql.Replace("@sort", sort); sql = sql.Replace("@endRecord", endRecord.ToString()); sql = sql.Replace("@order", order); sql = sql.Replace("@deorder", deorder); sql = sql.Replace("@search", Information); DataSet ds = DBHelperSQL.GetDataSet(sql, connectionString); return(ds); }
/// </summary> /// <param name="offset">记录开始位置</param> /// <param name="limit">每页记录条数</param> /// <returns></returns> public static DataSet GetListByPage1(int offset, int limit, string username, string sort = "StartTime", string order = "desc", string search = "") { string deorder = order.ToLower() == "desc" ? "asc" : "desc"; int endRecord = offset + limit; string sql = "SELECT * FROM RTKSurveyRec w1,( SELECT TOP @limit w.ID FROM( SELECT TOP @endRecord * FROM RTKSurveyRec where @search ORDER BY @sort @order) w ORDER BY w.@sort @deorder) w2 WHERE w1.ID = w2.ID and UserName='******' ORDER BY w1.@sort @order"; sql = sql.Replace("@limit", limit.ToString()); sql = sql.Replace("@sort", sort); sql = sql.Replace("@endRecord", endRecord.ToString()); sql = sql.Replace("@order", order); sql = sql.Replace("@deorder", deorder); sql = sql.Replace("@search", search); DataSet ds = DBHelperSQL.GetDataSet(sql, connectionString); return(ds); }
/// </summary> /// <param name="offset">记录开始位置</param> /// <param name="limit">每页记录条数</param> /// <returns></returns> public static DataSet GetListByPage(int offset, int limit, string sort = "Time", string order = "desc", string search = "", string dType = "") { string deorder = order.ToLower() == "desc" ? "asc" : "desc"; int endRecord = offset + limit; string sql = "SELECT * FROM CoorTransRec w1,( SELECT TOP @limit w.ID FROM( SELECT TOP @endRecord * FROM CoorTransRec where UserName like '%@search%' and Remark like '%@Type%' ORDER BY @sort @order) w ORDER BY w.@sort @deorder) w2 WHERE w1.ID = w2.ID ORDER BY w1.@sort @order"; sql = sql.Replace("@limit", limit.ToString()); sql = sql.Replace("@sort", sort); sql = sql.Replace("@endRecord", endRecord.ToString()); sql = sql.Replace("@order", order); sql = sql.Replace("@deorder", deorder); sql = sql.Replace("@search", search); sql = sql.Replace("@Type", dType); DataSet ds = DBHelperSQL.GetDataSet(sql, connectionString); return(ds); }
public Model.WorkingArea GetModel(string AreaName) { string strSql = "select * from WorkingArea where AreaName = '" + AreaName + "'"; Model.WorkingArea model = new Model.WorkingArea(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.AreaName = AreaName; if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); model.AreaString = Convert.ToString(ds.Tables[0].Rows[0]["AreaString"]); return(model); } else { return(null); } }
public Model.WorkingArea GetModel(int ID) { string strSql = "select * from WorkingArea where ID = " + ID.ToString(); Model.WorkingArea model = new Model.WorkingArea(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.AreaName = Convert.ToString(ds.Tables[0].Rows[0]["AreaName"]); model.AreaString = Convert.ToString(ds.Tables[0].Rows[0]["AreaString"]); return(model); } else { return(null); } }
public static Model.SourceTable GetModel(string Source) { string strSql = "select * from SourceTable where Source = '" + Source + "'"; Model.SourceTable model = new Model.SourceTable(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.Source = Source; if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); model.SourceType = Convert.ToString(ds.Tables[0].Rows[0]["SourceType"]); return(model); } else { return(null); } }
/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="ToUser"></param> /// <returns></returns> public Model.UserMessage GetModel(string ToUser) { string strSql = "select * from UserMessage where ToUser = '******'"; Model.UserMessage model = new Model.UserMessage(); DataSet ds = DBHelperSQL.GetDataSet(strSql); model.ToUser = ToUser; if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); model.level = Convert.ToInt32(ds.Tables[0].Rows[0]["level"]); model.Title = Convert.ToString(ds.Tables[0].Rows[0]["Title"]); model.Content = Convert.ToString(ds.Tables[0].Rows[0]["Content"]); model.FromUser = Convert.ToString(ds.Tables[0].Rows[0]["FromUser"]); model.ToUser = Convert.ToString(ds.Tables[0].Rows[0]["ToUser"]); model.IsRead = Convert.ToInt32(ds.Tables[0].Rows[0]["IsRead"]); model.SentTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["SentTime"]); if (ds.Tables[0].Rows[0]["ReadTime"] == null || ds.Tables[0].Rows[0]["ReadTime"].ToString().Trim() == "") { model.ReadTime = DateTime.Now; } else { model.ReadTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["ReadTime"]); } if (ds.Tables[0].Rows[0]["Remark"] == null || ds.Tables[0].Rows[0]["Remark"].ToString().Trim() == "") { model.Remark = ""; } else { model.Remark = Convert.ToString(ds.Tables[0].Rows[0]["Remark"]); } return(model); } else { return(null); } }
/// <summary> /// /// </summary> /// <param name="offset">记录开始位置</param> /// <param name="limit">每页记录条数</param> /// <returns></returns> public static DataSet GetListByPage(int offset, int limit, int logType, string sort = "LogTime", string order = "desc") { string deorder = order.ToLower() == "desc" ? "asc" : "desc"; int endRecord = offset + limit; string sql = "SELECT * FROM SysLog w1,( SELECT TOP @limit w.ID FROM( SELECT TOP @endRecord * FROM SysLog where LogType = @logType ORDER BY @sort @order) w ORDER BY w.@sort @deorder) w2 WHERE w1.ID = w2.ID ORDER BY w1.@sort @order"; sql = sql.Replace("@limit", limit.ToString()); sql = sql.Replace("@sort", sort); sql = sql.Replace("@endRecord", endRecord.ToString()); sql = sql.Replace("@order", order); sql = sql.Replace("@logType", logType.ToString()); sql = sql.Replace("@deorder", deorder); //SqlParameter Limit = new SqlParameter("@limit", SqlDbType.NVarChar, 500); Limit.Value = limit; //SqlParameter EndRecord = new SqlParameter("@endRecord", SqlDbType.DateTime); //EndRecord.Value = endRecord; //return DBHelperSQL.GetDataSet(sql, new SqlParameter[] { Limit, EndRecord }); DataSet ds = DBHelperSQL.GetDataSet(sql, connectionString); return(ds); }
/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.SiteMonitoring GetModel(int ID) { string strSql = "select * from SiteMonitoring where ID = " + ID.ToString(); Model.SiteMonitoring model = new Model.SiteMonitoring(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.StationOName = Convert.ToString(ds.Tables[0].Rows[0]["StationOName"]); model.SatelliteType = Convert.ToString(ds.Tables[0].Rows[0]["SatelliteType"]); model.Numbering = Convert.ToString(ds.Tables[0].Rows[0]["Numbering"]); model.Track = Convert.ToString(ds.Tables[0].Rows[0]["Track"]); model.Quantity = Convert.ToString(ds.Tables[0].Rows[0]["Quantity"]); model.Angle = Convert.ToString(ds.Tables[0].Rows[0]["Angle"]); model.Time = Convert.ToDateTime(ds.Tables[0].Rows[0]["Time"]); model.Ratio = Convert.ToString(ds.Tables[0].Rows[0]["Ratio"]); model.StorageEable = Convert.ToInt32(ds.Tables[0].Rows[0]["StorageEable"]); model.DesignCapacity = Convert.ToString(ds.Tables[0].Rows[0]["DesignCapacity"]); model.UsedstorageSpace = Convert.ToString(ds.Tables[0].Rows[0]["UsedstorageSpace"]); model.AvailablestorageSpace = Convert.ToString(ds.Tables[0].Rows[0]["AvailablestorageSpace"]); model.ReceiverTemperature = Convert.ToString(ds.Tables[0].Rows[0]["ReceiverTemperature"]); model.ReceiverVoltage = Convert.ToString(ds.Tables[0].Rows[0]["ReceiverVoltage"]); model.ReceiverElectricity = Convert.ToString(ds.Tables[0].Rows[0]["ReceiverElectricity"]); model.ReceiverCPU = Convert.ToString(ds.Tables[0].Rows[0]["ReceiverCPU"]); model.WeatherTemperature = Convert.ToString(ds.Tables[0].Rows[0]["WeatherTemperature"]); model.WeatherVoltage = Convert.ToString(ds.Tables[0].Rows[0]["WeatherVoltage"]); model.WeatherElectricity = Convert.ToString(ds.Tables[0].Rows[0]["WeatherElectricity"]); model.WeatherCPU = Convert.ToString(ds.Tables[0].Rows[0]["WeatherCPU"]); model.UPSTemperature = Convert.ToString(ds.Tables[0].Rows[0]["UPSTemperature"]); model.UPSVoltage = Convert.ToString(ds.Tables[0].Rows[0]["UPSVoltage"]); model.UPSElectricity = Convert.ToString(ds.Tables[0].Rows[0]["UPSElectricity"]); model.UPSCPU = Convert.ToString(ds.Tables[0].Rows[0]["UPSCPU"]); return(model); } else { return(null); } }
/// <summary> /// /// </summary> /// <param name="offset">记录开始位置</param> /// <param name="limit">每页记录条数</param> /// <returns></returns> public static DataSet GetListByPage(int offset, int limit) { int endRecord = offset + limit; string sql = "SELECT * FROM CoorSysPars w1,( SELECT TOP " + limit + " w.ID FROM( SELECT TOP " + endRecord + " * FROM CoorSysPars ORDER BY ID ASC) w ORDER BY w.ID DESC) w2 WHERE w1.ID = w2.ID ORDER BY w1.ID ASC"; //SqlParameter Limit = new SqlParameter("@limit", SqlDbType.NVarChar, 500); Limit.Value = limit; //SqlParameter EndRecord = new SqlParameter("@endRecord", SqlDbType.DateTime); //EndRecord.Value = endRecord; //return DBHelperSQL.GetDataSet(sql, new SqlParameter[] { Limit, EndRecord }); DataSet ds = DBHelperSQL.GetDataSet(sql, connectionString); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { //model.YSZBXM = Convert.ToString(ds.Tables[0].Rows[0]["YSZBXM"]); //model.MDZBXM = Convert.ToString(ds.Tables[0].Rows[0]["MDZBXM"]); if (ds.Tables[0].Rows[i]["YSZBXM"].ToString() != "GD") { continue; } ds.Tables[0].Rows[i]["X"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["X"].ToString()); ds.Tables[0].Rows[i]["Y"] = ds.Tables[0].Rows[i]["Y"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["Y"].ToString()); ds.Tables[0].Rows[i]["Z"] = ds.Tables[0].Rows[i]["Z"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["Z"].ToString()); ds.Tables[0].Rows[i]["aa"] = ds.Tables[0].Rows[i]["aa"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["aa"].ToString()); ds.Tables[0].Rows[i]["bb"] = ds.Tables[0].Rows[i]["bb"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["bb"].ToString()); ds.Tables[0].Rows[i]["cc"] = ds.Tables[0].Rows[i]["cc"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["cc"].ToString()); ds.Tables[0].Rows[i]["m"] = ds.Tables[0].Rows[i]["m"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["m"].ToString()); ds.Tables[0].Rows[i]["X"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["X"]) - 243243.24, 4).ToString(); ds.Tables[0].Rows[i]["Y"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["Y"]) - 1983435.23, 4).ToString(); ds.Tables[0].Rows[i]["Z"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["Z"]) + 1233234.12, 4).ToString(); ds.Tables[0].Rows[i]["aa"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["aa"]) - 76755.99, 8).ToString(); ds.Tables[0].Rows[i]["bb"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["bb"]) + 4564543.78, 8).ToString(); ds.Tables[0].Rows[i]["cc"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["cc"]) + 321907.65, 8).ToString(); ds.Tables[0].Rows[i]["m"] = ds.Tables[0].Rows[i]["X"].ToString() == "" ? "" : Math.Round(Convert.ToDouble(ds.Tables[0].Rows[i]["m"]) - 432487.123, 11).ToString(); ds.Tables[0].Rows[i]["CMeridian"] = ds.Tables[0].Rows[i]["CMeridian"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["CMeridian"].ToString()); ds.Tables[0].Rows[i]["ProjElevation"] = ds.Tables[0].Rows[i]["ProjElevation"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["ProjElevation"].ToString()); ds.Tables[0].Rows[i]["OriginNorth"] = ds.Tables[0].Rows[i]["OriginNorth"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["OriginNorth"].ToString()); ds.Tables[0].Rows[i]["OriginEast"] = ds.Tables[0].Rows[i]["OriginEast"].ToString() == "" ? "" : AES.AESDecrypt(ds.Tables[0].Rows[i]["OriginEast"].ToString()); ds.Tables[0].Rows[i]["AreaID"] = ds.Tables[0].Rows[i]["AreaID"].ToString() == "" ? 99999 : ds.Tables[0].Rows[i]["AreaID"]; } return(ds); }
/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.SysLog GetModel(int ID) { string strSql = "select * from SysLog where ID = '" + ID + "'"; Model.SysLog model = new Model.SysLog(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); model.Remark = Convert.ToString(ds.Tables[0].Rows[0]["Remark"]); model.LogTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["LogTime"]); model.LogType = Convert.ToInt32(ds.Tables[0].Rows[0]["LogType"]); model.UserName = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]); return(model); } else { return(null); } }
/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.News GetModel(int ID) { string strSql = "select * from News where ID = " + ID.ToString(); Model.News model = new Model.News(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.Title = Convert.ToString(ds.Tables[0].Rows[0]["Title"]); model.Author = Convert.ToString(ds.Tables[0].Rows[0]["Author"]); model.Time = (DateTime)ds.Tables[0].Rows[0]["Time"]; model.Details = Convert.ToString(ds.Tables[0].Rows[0]["Details"]); return(model); } else { return(null); } }
public static Model.ServiceConnection GetModel(int ID) { string strSql = "select * from ServiceConnection where ID = '" + ID.ToString() + "'"; Model.ServiceConnection model = new Model.ServiceConnection(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.ServiceName = Convert.ToString(ds.Tables[0].Rows[0]["ServiceName"]); model.ServiceIP = Convert.ToString(ds.Tables[0].Rows[0]["ServiceIP"]); model.ServicePort = Convert.ToString(ds.Tables[0].Rows[0]["ServicePort"]); model.SourceTable = Convert.ToString(ds.Tables[0].Rows[0]["SourceTable"]); return(model); } else { return(null); } }
/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.ResourcesDownload GetModel(int ID) { string strSql = "select * from ResourcesDownload where ID = " + ID.ToString(); Model.ResourcesDownload model = new Model.ResourcesDownload(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.ResourceName = Convert.ToString(ds.Tables[0].Rows[0]["ResourceName"]); model.ResourcePath = Convert.ToString(ds.Tables[0].Rows[0]["ResourcePath"]); model.DownloadTimes = Convert.ToInt32(ds.Tables[0].Rows[0]["DownloadTimes"]); model.UploadUser = Convert.ToString(ds.Tables[0].Rows[0]["UploadUser"]); model.UploadTime = (DateTime)ds.Tables[0].Rows[0]["UploadTime"]; model.IsDeleted = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsDeleted"]); model.Remark = Convert.ToString(ds.Tables[0].Rows[0]["Remark"]); return model; } else { return null; } }
public static Model.CoorSysPars GetModelFormId(int id) { string strSql = "select * from CoorSysPars where ID ='" + id + "'"; Model.CoorSysPars model = new Model.CoorSysPars(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);; if (ds.Tables[0].Rows.Count > 0) { model.YSZBXM = Convert.ToString(ds.Tables[0].Rows[0]["YSZBXM"]); model.MDZBXM = Convert.ToString(ds.Tables[0].Rows[0]["MDZBXM"]); model.X = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["X"].ToString())); model.Y = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Y"].ToString())); model.Z = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["Z"].ToString())); model.aa = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["aa"].ToString())); model.bb = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["bb"].ToString())); model.cc = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["cc"].ToString())); model.m = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["m"].ToString())); model.YSMajorAxis = Convert.ToDouble(ds.Tables[0].Rows[0]["YSMajorAxis"]); model.YSe2 = Convert.ToDouble(ds.Tables[0].Rows[0]["YSe2"]); model.MDMajorAxis = Convert.ToDouble(ds.Tables[0].Rows[0]["MDMajorAxis"]); model.MDe2 = Convert.ToDouble(ds.Tables[0].Rows[0]["MDe2"]); model.YSRemarkName = Convert.ToString(ds.Tables[0].Rows[0]["YSRemarkName"]); model.MDRemarkName = Convert.ToString(ds.Tables[0].Rows[0]["MDRemarkName"]); model.YSDAlpha = Convert.ToDouble(ds.Tables[0].Rows[0]["YSDAlpha"]); model.MDDAlpha = Convert.ToDouble(ds.Tables[0].Rows[0]["MDDAlpha"]); model.CMeridian = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["CMeridian"].ToString())); model.ProjElevation = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["ProjElevation"].ToString())); model.OriginNorth = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["OriginNorth"].ToString())); model.OriginEast = Convert.ToDouble(AES.AESDecrypt(ds.Tables[0].Rows[0]["OriginEast"].ToString())); model.AreaID = Convert.ToInt32(ds.Tables[0].Rows[0]["AreaID"].ToString()); return(model); } else { return(null); } }
public static Model.ServiceConfiguration GetModel(int ID) { string strSql = "select * from ServiceConfiguration where ID = '" + ID + "'"; Model.ServiceConfiguration model = new Model.ServiceConfiguration(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.ServerName = Convert.ToString(ds.Tables[0].Rows[0]["ServerName"]); model.paymentMethod = Convert.ToString(ds.Tables[0].Rows[0]["paymentMethod"]); model.Price = Convert.ToSingle(ds.Tables[0].Rows[0]["Price"]); model.InsertDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["InsertDate"]); model.ProductDescription = Convert.ToString(ds.Tables[0].Rows[0]["ProductDescription"]); return(model); } else { return(null); } }
public static Model.RoamingAreaManagement GetModel() { string strSql = "select top 1 * from RoamingAreaManagement order by ID desc"; Model.RoamingAreaManagement model = new Model.RoamingAreaManagement(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); model.GroupName = Convert.ToString(ds.Tables[0].Rows[0]["GroupName"]); model.Remark = Convert.ToString(ds.Tables[0].Rows[0]["Remark"]); model.GroupRange = Convert.ToString(ds.Tables[0].Rows[0]["GroupRange"]); model.InsertTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["InsertTime"]); return(model); } else { return(null); } }
/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.PersonInfo GetModel(string Contact) { string strSql = "select * from PersonInfo where Contact = '" + Contact + "'"; Model.PersonInfo model = new Model.PersonInfo(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.Contact = Contact; if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); model.ContactIDCardNumber = Convert.ToString(ds.Tables[0].Rows[0]["ContactIDCardNumber"]); model.ContactIDCardFile = Convert.ToString(ds.Tables[0].Rows[0]["ContactIDCardFile"]); model.CertificationTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["CertificationTime"]); model.BelongArea = Convert.ToString(ds.Tables[0].Rows[0]["BelongArea"]); return(model); } else { return(null); } }
/// <summary> /// 根据ID获取一条信息 /// </summary> /// <param name="ID"></param> /// <returns></returns> public static Model.EquipReviceRecord GetModel(int ID) { string strSql = "select * from EquipReviceRecord where ID ='" + ID + "'"; Model.EquipReviceRecord model = new Model.EquipReviceRecord(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.ReviceTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["ReviceTime"]); model.RevicePerson = Convert.ToString(ds.Tables[0].Rows[0]["RevicePerson"]); model.Information = Convert.ToString(ds.Tables[0].Rows[0]["Information"]); model.Contents = Convert.ToString(ds.Tables[0].Rows[0]["Contents"]); model.ReviceID = Convert.ToString(ds.Tables[0].Rows[0]["ReviceID"]); return(model); } else { return(null); } }
public static Model.CompanyInfo GetModel(int ID) { string strSql = "select * from CompanyInfo where ID = '" + ID + "'"; Model.CompanyInfo model = new Model.CompanyInfo(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.Company = Convert.ToString(ds.Tables[0].Rows[0]["Company"]); model.Address = Convert.ToString(ds.Tables[0].Rows[0]["Address"]); model.BelongArea = Convert.ToString(ds.Tables[0].Rows[0]["BelongArea"]); model.BusinessLicense = Convert.ToString(ds.Tables[0].Rows[0]["BusinessLicense"]); model.CertificationTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["CertificationTime"]); model.CompanyTel = Convert.ToString(ds.Tables[0].Rows[0]["CompanyTel"]); model.Contact = Convert.ToString(ds.Tables[0].Rows[0]["Contact"]); model.ContactIDCardFile = Convert.ToString(ds.Tables[0].Rows[0]["ContactIDCardFile"]); model.ContactIDCardNumer = Convert.ToString(ds.Tables[0].Rows[0]["ContactIDCardNumer"]); model.Industry = Convert.ToString(ds.Tables[0].Rows[0]["Industry"]); model.LegalIDCardFile = Convert.ToString(ds.Tables[0].Rows[0]["LegalIDCardFile"]); model.LegalIDCardNumber = Convert.ToString(ds.Tables[0].Rows[0]["LegalIDCardNumber"]); model.LegalPerson = Convert.ToString(ds.Tables[0].Rows[0]["LegalPerson"]); model.OrganizationCode = Convert.ToString(ds.Tables[0].Rows[0]["OrganizationCode"]); model.PowerOfAttorney = Convert.ToString(ds.Tables[0].Rows[0]["PowerOfAttorney"]); model.SurveyingFile = Convert.ToString(ds.Tables[0].Rows[0]["SurveyingFile"]); model.SurveyingNumber = Convert.ToString(ds.Tables[0].Rows[0]["SurveyingNumber"]); model.ServiceAgreementFile = Convert.ToString(ds.Tables[0].Rows[0]["ServiceAgreementFile"]); model.SurveyingQualification = Convert.ToString(ds.Tables[0].Rows[0]["SurveyingQualification"]); model.Balance = Convert.ToSingle(ds.Tables[0].Rows[0]["Balance"]); return(model); } else { return(null); } }
/// <summary> /// 得到一个实体对象根据设备名 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.StationEquip GetModel(string MachineName) { string strSql = "select * from StationEquip where MachineName = '" + MachineName + "'"; Model.StationEquip model = new Model.StationEquip(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.MachineName = MachineName; if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); //model.MachineName = Convert.ToString(ds.Tables[0].Rows[0]["MachineName"]); model.SerialNumber = Convert.ToString(ds.Tables[0].Rows[0]["SerialNumber"]); model.InstallationDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["InstallationDate"]); model.Models = Convert.ToString(ds.Tables[0].Rows[0]["Models"]); return(model); } else { return(null); } }
/// <summary> /// 得到一个实体对象 /// </summary> /// <param name="Id"></param> /// <returns></returns> public static Model.InvoiceInfo GetModel(string Invoice) { string strSql = "select * from InvoiceInfo where Invoice = '" + Invoice + "'"; Model.InvoiceInfo model = new Model.InvoiceInfo(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.Invoice = Invoice; if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); model.TaxNum = Convert.ToString(ds.Tables[0].Rows[0]["TaxNum"]); model.UnitAddress = Convert.ToString(ds.Tables[0].Rows[0]["UnitAddress"]); model.Tel = Convert.ToString(ds.Tables[0].Rows[0]["Tel"]); model.Bank = Convert.ToString(ds.Tables[0].Rows[0]["Bank"]); model.AccountNum = Convert.ToString(ds.Tables[0].Rows[0]["AccountNum"]); model.UserName = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]); return(model); } else { return(null); } }