/// <summary>
/// 采购商、供应商、平台用户信息修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int YongHu_U(EyouSoft.Model.MYongHuInfo info)
{
if (info == null ||
string.IsNullOrEmpty(info.Username) ||
string.IsNullOrEmpty(info.YongHuId) ||
string.IsNullOrEmpty(info.CaoZuoRenId) ||
string.IsNullOrEmpty(info.GongSiId))
{
return(0);
}
info.IssueTime = DateTime.Now;
int dalRetCode = dal.YongHu_CU(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.MYongHuInfo GetFormInfo()
{
var info = new EyouSoft.Model.MYongHuInfo();
info.BuMenName = Utils.GetFormValue(txtBuMenName.UniqueID);
info.CaoZuoRenId = YongHuInfo.YongHuId;
info.ChuShengRiQi = Utils.GetDateTime(Utils.GetFormValue(txtChuShengRiQi.UniqueID), DateTime.Now);
info.DianHua = Utils.GetFormValue(txtDianHua.UniqueID);
info.DiZhi = Utils.GetFormValue(txtDiZhi.UniqueID);
info.Email = Utils.GetFormValue(txtYouXiang.UniqueID);
info.Fax = Utils.GetFormValue(txtFax.UniqueID);
info.GongSiId = YongHuInfo.GongSiId;
info.IssueTime = DateTime.Now;
info.JueSeId = string.Empty;
info.LeiXing = EyouSoft.Model.YongHuLeiXing.采购商;
info.Name = Utils.GetFormValue(txtName.UniqueID);
info.PasswordMD5 = Utils.GetFormValue("txtMiMa");
info.RuZhiRiQi = Utils.GetDateTime(Utils.GetFormValue(txtRuZhiRiQi.UniqueID), DateTime.Now);
info.ShouJi = Utils.GetFormValue(txtShouJi.UniqueID);
info.Status = EyouSoft.Model.YongHuStatus.启用;
info.Username = Utils.GetFormValue(txtUsername.UniqueID);
info.XingBie = Utils.GetEnumValue <EyouSoft.Model.XingBie>(Utils.GetFormValue("txtXingBie"), EyouSoft.Model.XingBie.男);
info.YongHuId = EditId;
info.ZhaoPianFilepath = string.Empty;
info.ZhiWu = Utils.GetFormValue(txtZhiWu.UniqueID);
info.JueSeId = Utils.GetFormValue("txtJueSe");
info.LaiYuan = EyouSoft.Model.LaiYuan.平台添加;
info.ShenHeStatus = EyouSoft.Model.ShenHeStatus.已审核;
#region 照片
var zhaoPianFiles = txtZhaoPian.Files;
if (zhaoPianFiles != null && zhaoPianFiles.Count > 0)
{
info.ZhaoPianFilepath = zhaoPianFiles[0].Filepath;
}
else
{
zhaoPianFiles = txtZhaoPian.YuanFiles;
if (zhaoPianFiles != null && zhaoPianFiles.Count > 0)
{
info.ZhaoPianFilepath = zhaoPianFiles[0].Filepath;
}
}
#endregion
if (!string.IsNullOrEmpty(info.PasswordMD5))
{
info.PasswordMD5 = Utils.MD5Encrypt(info.PasswordMD5);
}
if (string.IsNullOrEmpty(info.YongHuId))
{
if (string.IsNullOrEmpty(info.PasswordMD5))
{
Utils.RCWE_AJAX("0", "请输入用户密码");
}
}
return(info);
}
/// <summary>
/// 采购商、供应商、平台用户信息添加、修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int YongHu_CU(EyouSoft.Model.MYongHuInfo info)
{
var cmd = _db.GetStoredProcCommand("proc_YongHu_CU");
_db.AddInParameter(cmd, "@YongHuId", DbType.AnsiStringFixedLength, info.YongHuId);
_db.AddInParameter(cmd, "@LeiXing", DbType.Int32, info.LeiXing);
_db.AddInParameter(cmd, "@GongSiId", DbType.AnsiStringFixedLength, info.GongSiId);
_db.AddInParameter(cmd, "@Username", DbType.String, info.Username);
_db.AddInParameter(cmd, "@PasswordMD5", DbType.String, info.PasswordMD5);
_db.AddInParameter(cmd, "@JueSeId", DbType.AnsiStringFixedLength, info.JueSeId);
_db.AddInParameter(cmd, "@Status", DbType.Int32, info.Status);
_db.AddInParameter(cmd, "@BuMenName", DbType.String, info.BuMenName);
_db.AddInParameter(cmd, "@Name", DbType.String, info.Name);
_db.AddInParameter(cmd, "@ZhaoPianFilepath", DbType.String, info.ZhaoPianFilepath);
_db.AddInParameter(cmd, "@ZhiWu", DbType.String, info.ZhiWu);
_db.AddInParameter(cmd, "@XingBie", DbType.Int32, info.XingBie);
_db.AddInParameter(cmd, "@ChuShengRiQi", DbType.DateTime, info.ChuShengRiQi);
_db.AddInParameter(cmd, "@ShouJi", DbType.String, info.ShouJi);
_db.AddInParameter(cmd, "@DianHua", DbType.String, info.DianHua);
_db.AddInParameter(cmd, "@Fax", DbType.String, info.Fax);
_db.AddInParameter(cmd, "@Email", DbType.String, info.Email);
_db.AddInParameter(cmd, "@DiZhi", DbType.String, info.DiZhi);
_db.AddInParameter(cmd, "@RuZhiRiQi", DbType.DateTime, info.RuZhiRiQi);
_db.AddInParameter(cmd, "@CaoZuoRenId", DbType.AnsiStringFixedLength, info.CaoZuoRenId);
_db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime);
_db.AddInParameter(cmd, "@Privs", DbType.String, "");
_db.AddInParameter(cmd, "@LaiYuan", DbType.Int32, info.LaiYuan);
_db.AddInParameter(cmd, "@ShenHeStatus", DbType.Int32, info.ShenHeStatus);
_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="yongHuId">用户编号</param>
/// <returns></returns>
public EyouSoft.Model.MYongHuInfo GetInfo(string yongHuId)
{
EyouSoft.Model.MYongHuInfo info = null;
var cmd = _db.GetSqlStringCommand("SELECT A.*,(SELECT A1.Name FROM tbl_GongSi AS A1 WHERE A1.GongSiId=A.GongSiId) AS GongSiName FROM tbl_YongHu AS A WHERE A.YongHuId=@YongHuId");
_db.AddInParameter(cmd, "YongHuId", DbType.AnsiStringFixedLength, yongHuId);
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
info = new EyouSoft.Model.MYongHuInfo();
info.BuMenName = rdr["BuMenName"].ToString();
info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString();
info.ChuShengRiQi = rdr.GetDateTime(rdr.GetOrdinal("ChuShengRiQi"));
info.DianHua = rdr["DianHua"].ToString();
info.DiZhi = rdr["DiZhi"].ToString();
info.Email = rdr["Email"].ToString();
info.Fax = rdr["Fax"].ToString();
info.GongSiId = rdr["GongSiId"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JueSeId = rdr["JueSeId"].ToString();
info.LeiXing = (EyouSoft.Model.YongHuLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing"));
info.Name = rdr["Name"].ToString();
info.PasswordMD5 = rdr["PasswordMD5"].ToString();
info.RuZhiRiQi = rdr.GetDateTime(rdr.GetOrdinal("RuZhiRiQi"));
info.ShouJi = rdr["ShouJi"].ToString();
info.Status = (EyouSoft.Model.YongHuStatus)rdr.GetInt32(rdr.GetOrdinal("Status"));
info.Username = rdr["Username"].ToString();
info.XingBie = (EyouSoft.Model.XingBie)rdr.GetInt32(rdr.GetOrdinal("XingBie"));
info.YongHuId = rdr["YongHuId"].ToString();
info.ZhaoPianFilepath = rdr["ZhaoPianFilepath"].ToString();
info.ZhiWu = rdr["ZhiWu"].ToString();
info.GongSiName = rdr["GongSiName"].ToString();
}
}
return(info);
}
/// <summary>
/// 获取采购商、供应商、平台用户信息集合
/// </summary>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MYongHuInfo> GetYongHus(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MYongHuChaXunInfo chaXun)
{
IList <EyouSoft.Model.MYongHuInfo> items = new List <EyouSoft.Model.MYongHuInfo>();
string fields = "*,(SELECT G.Name FROM tbl_GongSi G WHERE G.GongSiId=tbl_YongHu.GongSiId) GongSiName";
StringBuilder sql = new StringBuilder();
string tableName = "tbl_YongHu";
string orderByString = " IssueTime DESC ";
string heJiString = "";
#region sql
sql.Append(" IsDelete='0' ");
if (chaXun != null)
{
if (chaXun.LeiXing.HasValue)
{
sql.AppendFormat(" AND LeiXing={0} ", (int)chaXun.LeiXing.Value);
}
if (!string.IsNullOrEmpty(chaXun.Name))
{
sql.AppendFormat(" AND Name LIKE '%{0}%' ", chaXun.Name);
}
if (!string.IsNullOrEmpty(chaXun.GongSiId))
{
sql.AppendFormat(" AND GongSiId='{0}' ", chaXun.GongSiId);
}
else if (!string.IsNullOrEmpty(chaXun.GongSiName))
{
sql.AppendFormat(" AND EXISTS(SELECT 1 FORM tbl_GongSi AS A1 WHERE A1.GongSiId=tbl_YongHu.GongSiId AND A1.Name LIKE '%{0}%') ", chaXun.GongSiName);
}
if (!string.IsNullOrEmpty(chaXun.Username))
{
sql.AppendFormat(" AND Username LIKE '%{0}%' ", chaXun.Username);
}
if (chaXun.Status.HasValue)
{
sql.AppendFormat(" AND Status={0} ", (int)chaXun.Status.Value);
}
if (!string.IsNullOrEmpty(chaXun.BuMen))
{
sql.AppendFormat(" AND BuMenName LIKE '%{0}%' ", chaXun.BuMen);
}
if (chaXun.ShenHeStatus.HasValue)
{
sql.AppendFormat(" AND ShenHeStatus={0} ", (int)chaXun.ShenHeStatus.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.MYongHuInfo();
info.BuMenName = rdr["BuMenName"].ToString();
info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString();
info.ChuShengRiQi = rdr.GetDateTime(rdr.GetOrdinal("ChuShengRiQi"));
info.DianHua = rdr["DianHua"].ToString();
info.DiZhi = rdr["DiZhi"].ToString();
info.Email = rdr["Email"].ToString();
info.Fax = rdr["Fax"].ToString();
info.GongSiId = rdr["GongSiId"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JueSeId = rdr["JueSeId"].ToString();
info.LeiXing = (EyouSoft.Model.YongHuLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing"));
info.Name = rdr["Name"].ToString();
info.PasswordMD5 = rdr["PasswordMD5"].ToString();
info.RuZhiRiQi = rdr.GetDateTime(rdr.GetOrdinal("RuZhiRiQi"));
info.ShouJi = rdr["ShouJi"].ToString();
info.Status = (EyouSoft.Model.YongHuStatus)rdr.GetInt32(rdr.GetOrdinal("Status"));
info.Username = rdr["Username"].ToString();
info.XingBie = (EyouSoft.Model.XingBie)rdr.GetInt32(rdr.GetOrdinal("XingBie"));
info.YongHuId = rdr["YongHuId"].ToString();
info.ZhaoPianFilepath = rdr["ZhaoPianFilepath"].ToString();
info.ZhiWu = rdr["ZhiWu"].ToString();
info.GongSiName = rdr["GongSiName"].ToString();
items.Add(info);
}
}
return(items);
}
