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