/// <summary> /// 得到一个对象实体 /// </summary> public Tz888.Model.InfoStatic.InfoStaticQueueTab GetModel(int InfoID) { SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.Int, 4) }; parameters[0].Value = InfoID; Tz888.Model.InfoStatic.InfoStaticQueueTab model = new Tz888.Model.InfoStatic.InfoStaticQueueTab(); DataSet ds = DbHelperSQL.RunProcedure("InfoStaticQueueTab_GetModel", parameters, "ds"); model.InfoID = InfoID; if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["InfoID"].ToString() != "") { model.InfoID = int.Parse(ds.Tables[0].Rows[0]["InfoID"].ToString()); } model.InfoType = ds.Tables[0].Rows[0]["InfoType"].ToString(); if (ds.Tables[0].Rows[0]["StateFlag"].ToString() != "") { model.StateFlag = int.Parse(ds.Tables[0].Rows[0]["StateFlag"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更改队列中等待信息的状态 /// </summary> /// <param name="InfoID"></param> /// <param name="StateFlag"></param> /// <returns></returns> public bool SetNoteStateFlag(int InfoID, int StateFlag) { Tz888.Model.InfoStatic.InfoStaticQueueTab model = this.GetModel(InfoID); if (model == null) { return(false); } model.StateFlag = StateFlag; return(this.Update(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Tz888.Model.InfoStatic.InfoStaticQueueTab model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@InfoType", SqlDbType.Char, 10), new SqlParameter("@StateFlag", SqlDbType.Int, 4) }; parameters[0].Value = model.InfoID; parameters[1].Value = model.InfoType; parameters[2].Value = model.StateFlag; DbHelperSQL.RunProcedure("InfoStaticQueueTab_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Tz888.Model.InfoStatic.InfoStaticQueueTab model) { return(dal.Update(model)); }