/// <summary> /// 得到一个对象实体 /// </summary> public RoadSolution.Model.Attendance GetModel(string AID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from Attendance "); strSql.Append(" where AID='" + AID + "'"); RoadSolution.Model.Attendance model = new RoadSolution.Model.Attendance(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); model.AID = AID; if (ds.Tables[0].Rows.Count > 0) { model.UserID = ds.Tables[0].Rows[0]["UserID"].ToString(); model.Date = ds.Tables[0].Rows[0]["Date"].ToString(); if (ds.Tables[0].Rows[0]["Time"].ToString() != "") { model.Time = DateTime.Parse(ds.Tables[0].Rows[0]["Time"].ToString()); } model.Photo = ds.Tables[0].Rows[0]["Photo"].ToString(); if (ds.Tables[0].Rows[0]["Lat"].ToString() != "") { model.Lat = decimal.Parse(ds.Tables[0].Rows[0]["Lat"].ToString()); } if (ds.Tables[0].Rows[0]["Lng"].ToString() != "") { model.Lng = decimal.Parse(ds.Tables[0].Rows[0]["Lng"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(RoadSolution.Model.Attendance model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Attendance set "); strSql.Append("UserID='" + model.UserID + "',"); strSql.Append("Date='" + model.Date + "',"); strSql.Append("Time='" + model.Time + "',"); strSql.Append("Photo='" + model.Photo + "',"); strSql.Append("Lat=" + model.Lat + ","); strSql.Append("Lng=" + model.Lng + ""); strSql.Append(" where AID='" + model.AID + "'"); DbHelperSQL.ExecuteSql(strSql.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(RoadSolution.Model.Attendance model) { model.AID = GetMaxId().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Attendance("); strSql.Append("AID,UserID,Date,Time,Photo,Lat,Lng"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + model.AID + "',"); strSql.Append("'" + model.UserID + "',"); strSql.Append("'" + model.Date + "',"); strSql.Append("'" + model.Time + "',"); strSql.Append("'" + model.Photo + "',"); strSql.Append("" + model.Lat + ","); strSql.Append("" + model.Lng + ""); strSql.Append(")"); DbHelperSQL.ExecuteSql(strSql.ToString()); return(model.AID); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(RoadSolution.Model.Attendance model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(RoadSolution.Model.Attendance model) { return(dal.Add(model)); }