sysconfig.cs

某个公司需要维持良好的客户关系

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

namespace CRM.SQLServerDAL
{
	/// <summary>
	/// SysConfig 的摘要说明。
	/// </summary>
	public class SysConfig : ISysConfig
	{
		#region ISysConfig 成员

		public void Update(SysConfigInfo config)
		{
			object[] parms = {
								config.ConfigId,
								config.SystemName,
								config.Version,
								config.CopyRight,
								config.Manager,
								config.Tel,
								config.Email,
								config.Address,
								config.PayPeriod,
								config.Credit
							 };
			DAI.RunProcNonQuery("CRM_SysConfig_Update",parms);
		}
		public SysConfigInfo GetSysConfig()
		{
			SysConfigInfo config = null;
			using (SqlDataReader rdr = DAI.RunProcReader("CRM_SysConfig_GetSysConfigById"))
			{
				if (rdr.Read())
				{
					config = new SysConfigInfo();

					config.ConfigId = rdr["ConfigId"].ToString();
					config.SystemName = rdr["SystemName"].ToString();
					config.Version = rdr["Version"].ToString();
					config.CopyRight = rdr["CopyRight"].ToString();
					config.Manager = rdr["Manager"].ToString();
					config.Tel = rdr["Tel"].ToString();
					config.Email = rdr["Email"].ToString();
					config.Address = rdr["Address"].ToString();
					config.PayPeriod = rdr["PayPeriod"].ToString();
					config.Credit = rdr["Credit"].ToString();
				}
			}
			return config;
		}
		#endregion
	}
}