/// <summary> /// 增加一条数据 /// </summary> public int AddM_TimeOutInfo(M_TimeOutInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into tb_M_TimeOutInfo("); strSql.Append("m_ConfigInfoID,m_Type,m_ObjID,remind_type,exist_timeout,timeout)"); strSql.Append(" values ("); strSql.Append("@m_ConfigInfoID,@m_Type,@m_ObjID,@remind_type,@exist_timeout,@timeout)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@m_ConfigInfoID", SqlDbType.Int,4), new SqlParameter("@m_Type", SqlDbType.Int,4), new SqlParameter("@m_ObjID", SqlDbType.Int,4), new SqlParameter("@remind_type", SqlDbType.Int,4), new SqlParameter("@exist_timeout", SqlDbType.Bit,1), new SqlParameter("@timeout", SqlDbType.DateTime)}; parameters[0].Value = model.m_ConfigInfoID; parameters[1].Value = model.m_Type; parameters[2].Value = model.m_ObjID; parameters[3].Value = model.remind_type; parameters[4].Value = model.exist_timeout; parameters[5].Value = model.timeout; object obj = DbHelper.ExecuteScalar(CommandType.Text,strSql.ToString(), parameters); if (obj == null) { return -1; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public void UpdateM_TimeOutInfo(M_TimeOutInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update tb_M_TimeOutInfo set "); strSql.Append("m_ConfigInfoID=@m_ConfigInfoID,"); strSql.Append("m_Type=@m_Type,"); strSql.Append("m_ObjID=@m_ObjID,"); strSql.Append("remind_type=@remind_type,"); strSql.Append("exist_timeout=@exist_timeout,"); strSql.Append("timeout=@timeout"); strSql.Append(" where m_TimeOutInfoID=@m_TimeOutInfoID "); SqlParameter[] parameters = { new SqlParameter("@m_TimeOutInfoID", SqlDbType.Int,4), new SqlParameter("@m_ConfigInfoID", SqlDbType.Int,4), new SqlParameter("@m_Type", SqlDbType.Int,4), new SqlParameter("@m_ObjID", SqlDbType.Int,4), new SqlParameter("@remind_type", SqlDbType.Int,4), new SqlParameter("@exist_timeout", SqlDbType.Bit,1), new SqlParameter("@timeout", SqlDbType.DateTime)}; parameters[0].Value = model.m_TimeOutInfoID; parameters[1].Value = model.m_ConfigInfoID; parameters[2].Value = model.m_Type; parameters[3].Value = model.m_ObjID; parameters[4].Value = model.remind_type; parameters[5].Value = model.exist_timeout; parameters[6].Value = model.timeout; DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public M_TimeOutInfo GetM_TimeOutInfoModel(int m_TimeOutInfoID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 m_TimeOutInfoID,m_ConfigInfoID,m_Type,m_ObjID,remind_type,exist_timeout,timeout from tb_M_TimeOutInfo "); strSql.Append(" where m_TimeOutInfoID=@m_TimeOutInfoID "); SqlParameter[] parameters = { new SqlParameter("@m_TimeOutInfoID", SqlDbType.Int,4)}; parameters[0].Value = m_TimeOutInfoID; M_TimeOutInfo model=new M_TimeOutInfo(); DataSet ds=DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["m_TimeOutInfoID"].ToString()!="") { model.m_TimeOutInfoID=int.Parse(ds.Tables[0].Rows[0]["m_TimeOutInfoID"].ToString()); } if(ds.Tables[0].Rows[0]["m_ConfigInfoID"].ToString()!="") { model.m_ConfigInfoID=int.Parse(ds.Tables[0].Rows[0]["m_ConfigInfoID"].ToString()); } if(ds.Tables[0].Rows[0]["m_Type"].ToString()!="") { model.m_Type=int.Parse(ds.Tables[0].Rows[0]["m_Type"].ToString()); } if(ds.Tables[0].Rows[0]["m_ObjID"].ToString()!="") { model.m_ObjID=int.Parse(ds.Tables[0].Rows[0]["m_ObjID"].ToString()); } if(ds.Tables[0].Rows[0]["remind_type"].ToString()!="") { model.remind_type=int.Parse(ds.Tables[0].Rows[0]["remind_type"].ToString()); } if(ds.Tables[0].Rows[0]["exist_timeout"].ToString()!="") { if((ds.Tables[0].Rows[0]["exist_timeout"].ToString()=="1")||(ds.Tables[0].Rows[0]["exist_timeout"].ToString().ToLower()=="true")) { model.exist_timeout=true; } else { model.exist_timeout=false; } } if(ds.Tables[0].Rows[0]["timeout"].ToString()!="") { model.timeout=DateTime.Parse(ds.Tables[0].Rows[0]["timeout"].ToString()); } return model; } else { return null; } }