brokerclass.cs

主要是一个图片展示效果

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

/// <summary>
/// BrokerClass 的摘要说明
/// </summary>
public class BrokerClass
{
    public BrokerClass() { }

    private static string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();

    /// <summary>
    /// 删除经纪人帐号
    /// </summary>
    /// <param name="brokerId"></param>
    public void DeleteBroker(int brokerId)
    {
        string sql = "Delete From R_Broker where BrokerId=" + brokerId ;
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sql, null);
    }

    /// <summary>
    /// 会员密码找回
    /// </summary>
    /// <param name="brokerName"></param>
    /// <param name="xinPass"></param>
    /// <param name="question"></param>
    /// <param name="answer"></param>
    public int BackBrokerPass(string brokerName,string xinPass,string question,string answer)
    {
        SqlParameter[] paras = { new SqlParameter("@BrokerName",brokerName),new SqlParameter("@XinPass",xinPass),new SqlParameter("@Question",question),new SqlParameter("@Answer",answer),new SqlParameter("@Result",SqlDbType.Int)};
        paras[4].Direction = ParameterDirection.Output;
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "B_BackBrokerPass", paras);
        return Convert.ToInt32(paras[4].Value);
    }

    /// <summary>
    /// 修改密码
    /// </summary>
    /// <param name="brokerId"></param>
    /// <param name="jiuPass"></param>
    /// <param name="xinPass"></param>
    /// <returns></returns>
    public int BrokerModifyPass(int brokerId,string jiuPass,string xinPass)
    {
        SqlParameter[] paras = { new SqlParameter ("@BrokerId",brokerId),new SqlParameter("@JiuPass",jiuPass),new SqlParameter("@XinPass",xinPass),new SqlParameter("@Result",SqlDbType.Int)};
        paras[3].Direction = ParameterDirection.Output;
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "B_BrokerModifyPass", paras);
        return Convert.ToInt32(paras[3].Value);
    }

    /// <summary>
    /// 添加经纪人
    /// </summary>
    /// <param name="brokerName"></param>
    /// <param name="brokerPass"></param>
    /// <param name="question"></param>
    /// <param name="answer"></param>
    /// <returns></returns>
    public int BrokerAdd(string brokerName,string brokerPass,string question,string answer,string company,string licence)
    {
        SqlParameter[] paras = { new SqlParameter("@BrokerName", brokerName), new SqlParameter("@BrokerPass", brokerPass) ,new SqlParameter("@Question",question),new SqlParameter("@Answer",answer),new SqlParameter("@Company",company),new SqlParameter("@Licence",licence),new SqlParameter("@Result",SqlDbType.Int)};
        paras[6].Direction = ParameterDirection.Output;
        Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "B_BrokerAdd", paras);
        return Convert.ToInt32(paras[6].Value);
    }

    /// <summary>
    /// 验证
    /// </summary>
    /// <returns></returns>
    public int BrokerValidate(int brokerId)
    {
        string sql = "Update R_Broker Set BrokerStatus = 1 Where BrokerId = "+ brokerId;
        int result = Real.DAL.SqlHelper.ExecuteNonQuery(strCon, CommandType.Text, sql, null);
        return result;
    }
}