DA/MembersMap.cs

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

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

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


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



        /// <summary>
        /// 插入一行到members表
        /// </summary>
        /// <param name="info"></param>
        /// <returns>成功则返回这一行的ID；失败返回-1·</returns>        
        public int InsertOneline(Members members)
        {
            try
            {
               //string mBirthday = members.mBirthday.ToString().Replace('/', '-');
               //string mStartDate = members.mStartDate.ToString().Replace('/', '-');

                string sqlStr="insert into {0} (mgId,mCardNum, mName, mSex, mLinkphone," +
                       " mPoint, mBirthday,mStartDate,mState,mRemark,mId,mSpell) "
                       + " values({1},'{2}','{3}','{4}',{5},'{6}','{7}','{8}','{9}','{10}','{11}','{12}');";
                string sql= String.Format(sqlStr,
                        table_name, members.mgId,members.mCardNum,members.mName, members.mSex, members.mLinkphone,members.mPoint,
                        members.mBirthday, members.mStartDate, members.mState, members.mRemark,members.mId,members.mSpell);

                bool isSuccessful = SqlExecution.ExecuteSqlNoReturnedData(sql);
                if (!isSuccessful)
                    return -1;
                string sqlStr2 = String.Format("SELECT max(mId) from {0}", table_name);
                DataSet ds = SqlExecution.ExecuteSqlReturnedData(sqlStr2);
                string id = ds.Tables[0].Rows[0][0].ToString();
                if (!string.IsNullOrEmpty(id))
                    return 1;
                else
                    return -1;
            }
            catch
            { 
                return -1; 
            }           

        }


        public bool DeleteOneline(string mId)
        {
            try