/// <summary> /// 得到一个对象实体 /// </summary> public CardCenter.Entity.Para_QYXZ DataRowToModel(DataRow row) { CardCenter.Entity.Para_QYXZ model = new CardCenter.Entity.Para_QYXZ(); if (row != null) { if (row["QYXZ_Value"] != null) { model.QYXZ_Value = row["QYXZ_Value"].ToString(); } if (row["QYXZ_Name"] != null) { model.QYXZ_Name = row["QYXZ_Name"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(CardCenter.Entity.Para_QYXZ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Para_QYXZ set "); strSql.Append("QYXZ_Name=@QYXZ_Name"); strSql.Append(" where QYXZ_Value=@QYXZ_Value "); SqlParameter[] parameters = { new SqlParameter("@QYXZ_Name", SqlDbType.NVarChar, 64), new SqlParameter("@QYXZ_Value", SqlDbType.NVarChar, 2) }; parameters[0].Value = model.QYXZ_Name; parameters[1].Value = model.QYXZ_Value; TranHelper.AddTran(strSql, parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(CardCenter.Entity.Para_QYXZ model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Para_QYXZ("); strSql.Append("QYXZ_Value,QYXZ_Name)"); strSql.Append(" values ("); strSql.Append("@QYXZ_Value,@QYXZ_Name)"); SqlParameter[] parameters = { new SqlParameter("@QYXZ_Value", SqlDbType.NVarChar, 2), new SqlParameter("@QYXZ_Name", SqlDbType.NVarChar, 64) }; parameters[0].Value = model.QYXZ_Value; parameters[1].Value = model.QYXZ_Name; TranHelper.AddTran(strSql, parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public CardCenter.Entity.Para_QYXZ GetModel(string QYXZ_Value) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 QYXZ_Value,QYXZ_Name from Para_QYXZ "); strSql.Append(" where QYXZ_Value=@QYXZ_Value "); SqlParameter[] parameters = { new SqlParameter("@QYXZ_Value", SqlDbType.NVarChar, 2) }; parameters[0].Value = QYXZ_Value; CardCenter.Entity.Para_QYXZ model = new CardCenter.Entity.Para_QYXZ(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }