/// <summary>
/// 用户注册，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int YongHu_ZhuCe(EyouSoft.Model.MZhuCeYongHuInfo info)
{
if (info == null ||
string.IsNullOrEmpty(info.GongSiName) ||
string.IsNullOrEmpty(info.YongHuMing) ||
string.IsNullOrEmpty(info.PasswordMD5))
{
return(0);
}
info.GongSiId = Guid.NewGuid().ToString();
info.YongHuId = Guid.NewGuid().ToString();
info.IssueTime = DateTime.Now;
int dalRetCode = dal.YongHu_ZhuCe(info);
if (dalRetCode == 1)
{
var logInfo = new EyouSoft.Model.MCaoZuoLogInfo();
logInfo.BiaoTi = "用户注册";
logInfo.NeiRong = "用户注册，用户编号：" + info.YongHuId + "。";
logInfo.GuanLianId = info.YongHuId;
BCaoZuoLog.Log_C(logInfo);
}
return(dalRetCode);
}
/// <summary>
/// get form info
/// </summary>
/// <returns></returns>
EyouSoft.Model.MZhuCeYongHuInfo GetFormInfo()
{
var info = new EyouSoft.Model.MZhuCeYongHuInfo();
info.FaRenName = Utils.GetFormValue("txt_farenname");
info.FuZeRenDianHua = Utils.GetFormValue("txt_fuzerendianhua");
info.FuZeRenName = Utils.GetFormValue("txt_fuzerenname");
info.GongSiId = string.Empty;
info.GongSiName = Utils.GetFormValue("txt_gongsiname");
info.IssueTime = DateTime.Now;
info.LaiYuan = EyouSoft.Model.LaiYuan.用户注册;
info.LeiXing = EyouSoft.Model.GongSiLeiXing.采购商;
info.PasswordMD5 = Utils.GetFormValue("txt_mima");
info.ShenHeStatus = EyouSoft.Model.ShenHeStatus.未审核;
info.YongHuId = string.Empty;
info.YongHuMing = Utils.GetFormValue("txt_yonghuming");
info.DiZhi = Utils.GetFormValue("txt_dizhi");
if (Utils.GetQueryStringValue("leixing") == "gys")
{
info.LeiXing = EyouSoft.Model.GongSiLeiXing.供应商;
}
if (string.IsNullOrEmpty(info.GongSiName))
{
Utils.RCWE_AJAX("0", "请输入单位名称");
}
if (string.IsNullOrEmpty(info.YongHuMing))
{
Utils.RCWE_AJAX("0", "请输入用户名");
}
if (string.IsNullOrEmpty(info.PasswordMD5))
{
Utils.RCWE_AJAX("0", "请输入密码");
}
return(info);
}
/// <summary>
/// 用户注册，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int YongHu_ZhuCe(EyouSoft.Model.MZhuCeYongHuInfo info)
{
var cmd = _db.GetStoredProcCommand("proc_YongHu_ZhuCe");
_db.AddInParameter(cmd, "@GongSiId", DbType.AnsiStringFixedLength, info.GongSiId);
_db.AddInParameter(cmd, "@YongHuId", DbType.AnsiStringFixedLength, info.YongHuId);
_db.AddInParameter(cmd, "@GongSiName", DbType.String, info.GongSiName);
_db.AddInParameter(cmd, "@FaRenName", DbType.String, info.FaRenName);
_db.AddInParameter(cmd, "@FuZeRenName", DbType.String, info.FuZeRenName);
_db.AddInParameter(cmd, "@FuZeRenDianHua", DbType.String, info.FuZeRenDianHua);
_db.AddInParameter(cmd, "@YongHuMing", DbType.String, info.YongHuMing);
_db.AddInParameter(cmd, "@PasswordMD5", DbType.String, info.PasswordMD5);
_db.AddInParameter(cmd, "@LeiXing", DbType.Int32, info.LeiXing);
_db.AddInParameter(cmd, "@ShenHeStatus", DbType.Int32, info.ShenHeStatus);
_db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime);
_db.AddInParameter(cmd, "@LaiYuan", DbType.Int32, info.LaiYuan);
_db.AddInParameter(cmd, "@DiZhi", DbType.String, info.DiZhi);
_db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4);
int sqlExceptionCode = 0;
try
{
DbHelper.RunProcedure(cmd, _db);
}
catch (System.Data.SqlClient.SqlException e)
{
sqlExceptionCode = 0 - e.Number;
}
if (sqlExceptionCode < 0)
{
return(sqlExceptionCode);
}
return(Convert.ToInt32(_db.GetParameterValue(cmd, "@RetCode")));
}
/// <summary>
/// 获取注册用户信息集合
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MZhuCeYongHuInfo> GetZhuCeYongHus(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MZhuCeYongHuChaXunInfo chaXun)
{
var items = new List <EyouSoft.Model.MZhuCeYongHuInfo>();
string fields = "*";
StringBuilder sql = new StringBuilder();
string tableName = "view_ZhuCeYongHu";
string orderByString = " IssueTime DESC ";
string heJiString = "";
#region sql
sql.Append(" 1=1 ");
if (chaXun != null)
{
if (chaXun.LeiXing.HasValue)
{
sql.AppendFormat(" AND LeiXing={0} ", (int)chaXun.LeiXing.Value);
}
if (!string.IsNullOrEmpty(chaXun.GongSiName))
{
sql.AppendFormat(" AND GongSiName LIKE '%{0}%' ", chaXun.GongSiName);
}
if (!string.IsNullOrEmpty(chaXun.YongHuMing))
{
sql.AppendFormat(" AND YongHuMing LIKE '%{0}%' ", chaXun.YongHuMing);
}
if (chaXun.ShenHeStatus.HasValue)
{
sql.AppendFormat(" AND ShenHeStatus={0} ", (int)chaXun.ShenHeStatus.Value);
}
if (!string.IsNullOrEmpty(chaXun.YongHuName))
{
sql.AppendFormat(" AND YongHuName LIKE '%{0}%' ", chaXun.YongHuName);
}
if (chaXun.LaiYuan.HasValue)
{
sql.AppendFormat(" AND LaiYuan={0} ", (int)chaXun.LaiYuan.Value);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, sql.ToString(), orderByString, heJiString))
{
while (rdr.Read())
{
var info = new EyouSoft.Model.MZhuCeYongHuInfo();
info.FaRenName = rdr["FanRenName"].ToString();
info.FuZeRenDianHua = rdr["FuZeRenDianHua"].ToString();
info.FuZeRenName = rdr["FuZeRenName"].ToString();
info.GongSiId = rdr["GongSiId"].ToString();
info.GongSiName = rdr["GongSiName"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.LaiYuan = (EyouSoft.Model.LaiYuan)rdr.GetInt32(rdr.GetOrdinal("LaiYuan"));
info.LeiXing = (EyouSoft.Model.GongSiLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing"));
info.ShenHeStatus = (EyouSoft.Model.ShenHeStatus)rdr.GetInt32(rdr.GetOrdinal("ShenHeStatus"));
info.YongHuId = rdr["YongHuId"].ToString();
info.YongHuMing = rdr["YongHuMing"].ToString();
items.Add(info);
}
}
return(items);
}
