DA/MemberGradeMap.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
//using System.Linq;
using System.Web;
using System.Data;
using Common;


namespace DA
{
/// <summary>
///MemberGradeMap 的摘要说明
/// </summary>
public class MemberGradeMap
{
	public string table_name = "MemberGrade";


        /// <summary>
        ///
        /// </summary>
        /// <param mgName="info"></param>
        /// <returns>成功则返回这一行的ID；失败返回-1·</returns>        
        public int InsertOneline(MemberGrade memberGrade)
        {
            try
            {
                string sqlStr = String.Format("insert into {0} (mgName,mgStartPoint,mgDiscount) "
                                                + " values('{1}',{2},{3});",
                                              table_name, memberGrade.mgName,memberGrade.mgStartPoint,memberGrade.mgDiscount);
                bool isSuccessful = SqlExecution.ExecuteSqlNoReturnedData(sqlStr);
                if (!isSuccessful)
                    return -1;
                string sqlStr2 = String.Format("SELECT max(mgId) from {0}", table_name);
                DataSet ds = SqlExecution.ExecuteSqlReturnedData(sqlStr2);
                int id = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                if (id > 0)
                    return id;
                else
                    return -1;
            }
            catch
            {
                return -1;
            }
        }


        public bool DeleteOneline(string mgId)
        {
            try
            {
                string str = "delete from {0} where mgId = {1}";
                string sqlStr = String.Format(str, table_name, mgId);
                bool isSuccessful = SqlExecution.ExecuteSqlNoReturnedData(sqlStr);
                if (isSuccessful)
                    return true;
                else
                    return false;
            }