/// <summary>
/// 得到一个实体对象
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public static Model.RTKPostPurview GetModel(string UserName)
{
string strSql = "select * from RTKPostPurview where UserName = '******'";
Model.RTKPostPurview model = new Model.RTKPostPurview();
DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString);
model.UserName = UserName;
if (ds.Tables[0].Rows.Count > 0)
{
model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);
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.StartTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["StartTime"]);
model.EndTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["EndTime"]);
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据,根据Name
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update1(Model.RTKPostPurview model)
{
string strSql = "update RTKPostPurview set EndTime=@EndTime where UserName = '******'";
SqlParameter EndTime = new SqlParameter("EndTime", SqlDbType.DateTime); EndTime.Value = model.EndTime;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { EndTime }, connectionString) == 1 ? true : false);
}
/// <summary>
/// 更新一条数据,根据ID
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(Model.RTKPostPurview model)
{
string strSql = "update RTKPostPurview set UserName=@UserName, CoorTransEnable=@CoorTransEnable, HeightTransEnable=@HeightTransEnable, SHPTransEnable=@SHPTransEnable, DXFTransEnable=@DXFTransEnable, PPPserverEnable=@PPPserverEnable, ObsQualityEnable=@ObsQualityEnable, BaseLineEnable=@BaseLineEnable, MultiBaseLineEnable=@MultiBaseLineEnable, StartTime=@StartTime, EndTime=@EndTime where ID = " + model.ID.ToString();
SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName;
SqlParameter CoorTransEnable = new SqlParameter("CoorTransEnable", SqlDbType.Int); CoorTransEnable.Value = model.CoorTransEnable;
SqlParameter HeightTransEnable = new SqlParameter("HeightTransEnable", SqlDbType.Int); HeightTransEnable.Value = model.HeightTransEnable;
SqlParameter SHPTransEnable = new SqlParameter("SHPTransEnable", SqlDbType.Int); SHPTransEnable.Value = model.SHPTransEnable;
SqlParameter DXFTransEnable = new SqlParameter("DXFTransEnable", SqlDbType.Int); DXFTransEnable.Value = model.DXFTransEnable;
SqlParameter PPPserverEnable = new SqlParameter("PPPserverEnable", SqlDbType.Int); PPPserverEnable.Value = model.PPPserverEnable;
SqlParameter ObsQualityEnable = new SqlParameter("ObsQualityEnable", SqlDbType.Int); ObsQualityEnable.Value = model.ObsQualityEnable;
SqlParameter BaseLineEnable = new SqlParameter("BaseLineEnable", SqlDbType.Int); BaseLineEnable.Value = model.BaseLineEnable;
SqlParameter MultiBaseLineEnable = new SqlParameter("MultiBaseLineEnable", SqlDbType.Int); MultiBaseLineEnable.Value = model.MultiBaseLineEnable;
SqlParameter StartTime = new SqlParameter("StartTime", SqlDbType.DateTime); StartTime.Value = model.StartTime;
SqlParameter EndTime = new SqlParameter("EndTime", SqlDbType.DateTime); EndTime.Value = model.EndTime;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, CoorTransEnable, HeightTransEnable, SHPTransEnable, DXFTransEnable, PPPserverEnable, ObsQualityEnable, BaseLineEnable, MultiBaseLineEnable, StartTime, EndTime }, connectionString) == 1 ? true : false);
}
