/// <summary> /// 更新一条数据 /// </summary> public bool Update(Tz888.Model.InfoStatic.SetInfoPageStaticTab model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@LastUpdateTime", SqlDbType.DateTime), new SqlParameter("@MinUpdateTime", SqlDbType.Int, 4), new SqlParameter("@IsActive", SqlDbType.Bit, 1), new SqlParameter("@RunTime", SqlDbType.VarChar, 50), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = model.LastUpdateTime; parameters[2].Value = model.MinUpdateTime; parameters[3].Value = model.IsActive; parameters[4].Value = model.RunTime; parameters[5].Value = model.StartTime; parameters[6].Value = model.EndTime; DbHelperSQL.RunProcedure("SetInfoPageStaticTab_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } return(false); }
/// <summary> /// 得到一个对象实体 /// </summary> public Tz888.Model.InfoStatic.SetInfoPageStaticTab GetModel(int ID) { SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Tz888.Model.InfoStatic.SetInfoPageStaticTab model = new Tz888.Model.InfoStatic.SetInfoPageStaticTab(); DataSet ds = DbHelperSQL.RunProcedure("SetInfoPageStaticTab_GetModel", parameters, "ds"); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["LastUpdateTime"].ToString() != "") { model.LastUpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastUpdateTime"].ToString()); } if (ds.Tables[0].Rows[0]["MinUpdateTime"].ToString() != "") { model.MinUpdateTime = int.Parse(ds.Tables[0].Rows[0]["MinUpdateTime"].ToString()); } if (ds.Tables[0].Rows[0]["IsActive"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsActive"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsActive"].ToString().ToLower() == "true")) { model.IsActive = true; } else { model.IsActive = false; } } model.RunTime = ds.Tables[0].Rows[0]["RunTime"].ToString(); if (ds.Tables[0].Rows[0]["StartTime"].ToString() != "") { model.StartTime = DateTime.Parse(ds.Tables[0].Rows[0]["StartTime"].ToString()); } if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString()); } return(model); } else { return(null); } }
public Tz888.Model.InfoStatic.SetInfoPageStaticTab GetModel() { DataSet ds = this.GetList("*", "ID", 1, 1, 0, 0, ""); Tz888.Model.InfoStatic.SetInfoPageStaticTab model = new Tz888.Model.InfoStatic.SetInfoPageStaticTab(); if (ds.Tables[0].Rows.Count > 0) { model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]); if (ds.Tables[0].Rows[0]["LastUpdateTime"].ToString() != "") { model.LastUpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastUpdateTime"].ToString()); } if (ds.Tables[0].Rows[0]["MinUpdateTime"].ToString() != "") { model.MinUpdateTime = int.Parse(ds.Tables[0].Rows[0]["MinUpdateTime"].ToString()); } if (ds.Tables[0].Rows[0]["IsActive"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsActive"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsActive"].ToString().ToLower() == "true")) { model.IsActive = true; } else { model.IsActive = false; } } model.RunTime = ds.Tables[0].Rows[0]["RunTime"].ToString(); if (ds.Tables[0].Rows[0]["StartTime"].ToString() != "") { model.StartTime = DateTime.Parse(ds.Tables[0].Rows[0]["StartTime"].ToString()); } if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新服务最后启动时间 /// </summary> public bool UpdateLastUpdateTime(int ID) { Tz888.Model.InfoStatic.SetInfoPageStaticTab model = this.GetModel(ID); model.LastUpdateTime = System.DateTime.Now; return(this.Update(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Tz888.Model.InfoStatic.SetInfoPageStaticTab model) { return(dal.Update(model)); }