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