/// <summary>
/// 得到一个实体对象
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Model.RTKSurveyRec GetModel(int ID)
{
string strSql = "select * from RTKSurveyRec where ID = " + ID.ToString();
Model.RTKSurveyRec model = new Model.RTKSurveyRec();
DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString);
model.ID = ID;
if (ds.Tables[0].Rows.Count > 0)
{
model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);
model.UserName = Convert.ToString(ds.Tables[0].Rows[0]["UserName"]);
model.Company = Convert.ToString(ds.Tables[0].Rows[0]["Company"]);
model.StartTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["StartTime"]);
model.OnlineSpan = Convert.ToDouble(ds.Tables[0].Rows[0]["OnlineSpan"]);
model.FixedSpan = Convert.ToDouble(ds.Tables[0].Rows[0]["FixedSpan"]);
model.Cost = Convert.ToDouble(ds.Tables[0].Rows[0]["Cost"]);
model.Remark = Convert.ToString(ds.Tables[0].Rows[0]["Remark"]);
return(model);
}
else
{
return(null);
}
}
public bool Update(Model.RTKSurveyRec model)
{
string strSql = "update RTKSurveyRec set UserName=@UserName,Company=@Company,StartTime=@StartTime,OnlineSpan=@OnlineSpan,FixedSpan=@FixedSpan,Cost=@Cost,Remark=@Remark where ID=" + model.ID.ToString();
SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName;
SqlParameter Company = new SqlParameter("Company", SqlDbType.NVarChar); Company.Value = model.Company;
SqlParameter StartTime = new SqlParameter("StartTime", SqlDbType.DateTime); StartTime.Value = model.StartTime;
SqlParameter OnlineSpan = new SqlParameter("OnlineSpan", SqlDbType.Float); OnlineSpan.Value = model.OnlineSpan;
SqlParameter FixedSpan = new SqlParameter("FixedSpan", SqlDbType.Float); FixedSpan.Value = model.FixedSpan;
SqlParameter Cost = new SqlParameter("Cost", SqlDbType.Float); Cost.Value = model.Cost;
SqlParameter Remark = new SqlParameter("Remark", SqlDbType.NVarChar); Remark.Value = model.Remark;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, Company, StartTime, OnlineSpan, FixedSpan, Cost, Remark }, connectionString) == 1 ? true : false);
}
public bool Add(Model.RTKSurveyRec model)
{
string strSql = "insert into RTKSurveyRec(UserName,Company, StartTime, OnlineSpan,FixedSpan,Cost,Remark) values(@UserName, @StartTime, @OnlineSpan,@FixedSpan,@Cost,@Remark)";
SqlParameter UserName = new SqlParameter("UserName", SqlDbType.NVarChar); UserName.Value = model.UserName;
SqlParameter Company = new SqlParameter("Company", SqlDbType.NVarChar); Company.Value = model.Company;
SqlParameter StartTime = new SqlParameter("StartTime", SqlDbType.DateTime); StartTime.Value = model.StartTime;
SqlParameter OnlineSpan = new SqlParameter("OnlineSpan", SqlDbType.Float); OnlineSpan.Value = model.OnlineSpan;
SqlParameter FixedSpan = new SqlParameter("FixedSpan", SqlDbType.Float); FixedSpan.Value = model.FixedSpan;
SqlParameter Cost = new SqlParameter("Cost", SqlDbType.Float); Cost.Value = model.Cost;
SqlParameter Remark = new SqlParameter("Remark", SqlDbType.NVarChar); Remark.Value = model.Remark;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { UserName, Company, StartTime, OnlineSpan, FixedSpan, Cost, Remark }, connectionString) == 1 ? true : false);
}
