DAL/IcUserInfo.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using Model;

namespace DAL
{
	public class IcUserInfo
	{
		private int _recordcount;
		public IcUserInfo(){}
		public int RecordCount
		{
			get { return _recordcount; }
		}
		public int Insert(cUserInfoInfo cUserInfoInfo)
		{
			int id = 0;
			string Sql = "INSERT INTO UserInfo (U_Name,U_Pass,U_Mail) VALUES (@U_Name,@U_Pass,@U_Mail); SELECT @@IDENTITY;";
			SqlParameter[] parms = new SqlParameter[]{
														 new SqlParameter("@U_Name", SqlDbType.VarChar, 20),
														 new SqlParameter("@U_Pass", SqlDbType.VarChar, 32),
														 new SqlParameter("@U_Mail", SqlDbType.VarChar, 100)};
			parms[0].Value = cUserInfoInfo.U_Name;
			parms[1].Value = cUserInfoInfo.U_Pass;
			parms[2].Value = cUserInfoInfo.U_Mail;
			SqlDataReader dr = SqlHelper.ExecuteReader(ICon.Cnn, CommandType.Text, Sql, parms);
			if(dr.Read())
			{
				id = Int32.Parse(dr.GetDecimal(0).ToString());
			}
			dr.Close();
			ICon.Close();
			return id;
		}


		public int Update(cUserInfoInfo cUserInfoInfo)
		{
			string Sql = "UPDATE UserInfo SET U_Name = @U_Name,U_Pass = @U_Pass,U_Mail = @U_Mail WHERE U_ID = @U_ID";
			SqlParameter[] parms = new SqlParameter[]{
														 new SqlParameter("@U_ID", SqlDbType.Int, 4),
														 new SqlParameter("@U_Name", SqlDbType.VarChar, 20),
														 new SqlParameter("@U_Pass", SqlDbType.VarChar, 32),
														 new SqlParameter("@U_Mail", SqlDbType.VarChar, 100)};
			parms[0].Value = cUserInfoInfo.U_ID;
			parms[1].Value = cUserInfoInfo.U_Name;
			parms[2].Value = cUserInfoInfo.U_Pass;
			parms[3].Value = cUserInfoInfo.U_Mail;
			try
			{
				SqlHelper.ExecuteNonQuery(ICon.Cnn, CommandType.Text, Sql, parms);
				ICon.Close();
				return 1;
			}
			catch
			{
				return 0;
			}