/// <summary> /// 采购商、供应商信息添加、修改,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int GongSi_CU(EyouSoft.Model.MGongSiInfo info) { var cmd = _db.GetStoredProcCommand("proc_GongSi_CU"); _db.AddInParameter(cmd, "@GongSiId", DbType.AnsiStringFixedLength, info.GongSiId); _db.AddInParameter(cmd, "@LeiXing", DbType.Int32, info.LeiXing); _db.AddInParameter(cmd, "@Name", DbType.String, info.Name); _db.AddInParameter(cmd, "@FanRenName", DbType.String, info.FanRenName); _db.AddInParameter(cmd, "@ShengFenId", DbType.Int32, info.ShengFenId); _db.AddInParameter(cmd, "@ChengShiId", DbType.Int32, info.ChengShiId); _db.AddInParameter(cmd, "@DiZhi", DbType.String, info.DiZhi); _db.AddInParameter(cmd, "@YingYeZhiZhaoFilepath", DbType.String, info.YingYeZhiZhaoFilepath); _db.AddInParameter(cmd, "@ZuZhiJiGouFilepath", DbType.String, info.ZuZhiJiGouFilepath); _db.AddInParameter(cmd, "@FuZeRenName", DbType.String, info.FuZeRenName); _db.AddInParameter(cmd, "@FuZeRenDianHua", DbType.String, info.FuZeRenDianHua); _db.AddInParameter(cmd, "@FuZeRenShenFenZhengHao", DbType.String, info.FuZeRenShenFenZhengHao); _db.AddInParameter(cmd, "@FuZeRenZhaoPianFilepath", DbType.String, info.FuZeRenZhaoPianFilepath); _db.AddInParameter(cmd, "@CaiWuName", DbType.String, info.CaiWuName); _db.AddInParameter(cmd, "@CaiWuDianHua", DbType.String, info.CaiWuDianHua); _db.AddInParameter(cmd, "@CaiWuShenFenZhengHao", DbType.String, info.CaiWuShenFenZhengHao); _db.AddInParameter(cmd, "@CaiWuZhaoPianFilepath", DbType.String, info.CaiWuZhaoPianFilepath); _db.AddInParameter(cmd, "@CaoZuoRenId", DbType.AnsiStringFixedLength, info.CaoZuoRenId); _db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime); _db.AddInParameter(cmd, "@LogoFilepath", DbType.String, info.LogoFilepath); _db.AddInParameter(cmd, "@LxQQ", DbType.String, info.LxQQ); _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> /// 采购商、供应商信息修改,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int GongSi_U(EyouSoft.Model.MGongSiInfo info) { if (info == null || string.IsNullOrEmpty(info.Name) || string.IsNullOrEmpty(info.GongSiId) || string.IsNullOrEmpty(info.CaoZuoRenId)) { return(0); } info.IssueTime = DateTime.Now; int dalRetCode = dal.GongSi_CU(info); if (dalRetCode == 1) { var logInfo = new EyouSoft.Model.MCaoZuoLogInfo(); logInfo.BiaoTi = "修改公司信息"; logInfo.NeiRong = "修改公司信息,公司编号:" + info.GongSiId + "。"; logInfo.GuanLianId = info.GongSiId; BCaoZuoLog.Log_C(logInfo); } #region 消息处理 if (dalRetCode == 1 && info.ShenHeStatus == EyouSoft.Model.ShenHeStatus.未审核 && !string.IsNullOrEmpty(info.YingYeZhiZhaoFilepath) && !string.IsNullOrEmpty(info.ZuZhiJiGouFilepath)) { var xiaoXiInfo = new EyouSoft.Model.MXiaoXiInfo(); xiaoXiInfo.BiaoTi = "公司注册待审核"; xiaoXiInfo.ChuLiRenId = string.Empty; xiaoXiInfo.ChuLiTime = null; xiaoXiInfo.FaChuGongSiId = info.GongSiId; xiaoXiInfo.FaChuRenId = info.CaoZuoRenId; xiaoXiInfo.FaChuTime = DateTime.Now; xiaoXiInfo.GuanLianId = info.GongSiId; xiaoXiInfo.JieShouGongSiId = EyouSoft.Model.MGongSiInfo.PingTaiGongSiId; xiaoXiInfo.JieShouRenId = string.Empty; xiaoXiInfo.LeiXing = EyouSoft.Model.XiaoXiLeiXing.公司注册待审核; xiaoXiInfo.NeiRong = "您有一个注册公司信息需要审核,公司名称:" + info.Name + "。"; xiaoXiInfo.Status = EyouSoft.Model.XiaoXiStatus.未读; xiaoXiInfo.XiaoXiId = string.Empty; BXiaoXi.XiaoXi_C(xiaoXiInfo); } #endregion return(dalRetCode); }
/// <summary> /// 获取采购商、供应商信息业务实体 /// </summary> /// <param name="gongSiId">采购商、供应商公司编号</param> /// <returns></returns> public EyouSoft.Model.MGongSiInfo GetInfo(string gongSiId) { EyouSoft.Model.MGongSiInfo info = null; var cmd = _db.GetSqlStringCommand("SELECT A.*,B.Name AS CaoZuoRenName FROM tbl_GongSi AS A LEFT OUTER JOIN tbl_YongHu AS B ON A.CaoZuoRenId=B.YongHuId WHERE A.GongSiId=@GongSiId"); _db.AddInParameter(cmd, "@GongSiId", DbType.AnsiStringFixedLength, gongSiId); using (var rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { info = new EyouSoft.Model.MGongSiInfo(); info.CaiWuDianHua = rdr["CaiWuDianHua"].ToString(); info.CaiWuName = rdr["CaiWuName"].ToString(); info.CaiWuShenFenZhengHao = rdr["CaiWuShenFenZhengHao"].ToString(); info.CaiWuZhaoPianFilepath = rdr["CaiWuZhaoPianFilepath"].ToString(); info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString(); info.ChengShiId = rdr.GetInt32(rdr.GetOrdinal("ChengShiId")); info.DiZhi = rdr["DiZhi"].ToString(); info.FanRenName = rdr["FanRenName"].ToString(); info.FuZeRenDianHua = rdr["FuZeRenDianHua"].ToString(); info.FuZeRenName = rdr["FuZeRenName"].ToString(); info.FuZeRenShenFenZhengHao = rdr["FuZeRenShenFenZhengHao"].ToString(); info.FuZeRenZhaoPianFilepath = rdr["FuZeRenZhaoPianFilepath"].ToString(); info.GongSiId = rdr["GongSiId"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.LeiXing = (EyouSoft.Model.GongSiLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing")); info.Name = rdr["Name"].ToString(); info.ShengFenId = rdr.GetInt32(rdr.GetOrdinal("ShengFenId")); info.YingYeZhiZhaoFilepath = rdr["YingYeZhiZhaoFilepath"].ToString(); info.ZuZhiJiGouFilepath = rdr["ZuZhiJiGouFilepath"].ToString(); info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString(); info.LogoFilepath = rdr["LogoFilepath"].ToString(); info.LxQQ = rdr["LxQQ"].ToString(); info.LaiYuan = (EyouSoft.Model.LaiYuan)rdr.GetInt32(rdr.GetOrdinal("LaiYuan")); info.ShenHeStatus = (EyouSoft.Model.ShenHeStatus)rdr.GetInt32(rdr.GetOrdinal("ShenHeStatus")); } } return(info); }
/// <summary> /// 采购商、供应商信息添加,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int GongSi_C(EyouSoft.Model.MGongSiInfo info) { if (info == null || string.IsNullOrEmpty(info.Name) || string.IsNullOrEmpty(info.CaoZuoRenId)) { return(0); } info.GongSiId = Guid.NewGuid().ToString(); info.IssueTime = DateTime.Now; int dalRetCode = dal.GongSi_CU(info); if (dalRetCode == 1) { var logInfo = new EyouSoft.Model.MCaoZuoLogInfo(); logInfo.BiaoTi = "添加公司信息"; logInfo.NeiRong = "添加公司信息,公司编号:" + info.GongSiId + ",公司类型:" + info.LeiXing + "。"; logInfo.GuanLianId = info.GongSiId; BCaoZuoLog.Log_C(logInfo); } return(dalRetCode); }
/// <summary> /// 获取采购商、供应商信息集合 /// </summary> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <param name="heJi">合计信息</param> /// <returns></returns> public IList <EyouSoft.Model.MGongSiInfo> GetGongSis(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MGongSiChaXunInfo chaXun, out object[] heJi) { heJi = new object[] { }; IList <EyouSoft.Model.MGongSiInfo> items = new List <EyouSoft.Model.MGongSiInfo>(); string fields = "*,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=tbl_GongSi.CaoZuoRenId) AS CaoZuoRenName"; StringBuilder sql = new StringBuilder(); string tableName = "tbl_GongSi"; 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.CgsId)) { sql.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_GongSiGuanXi AS A1 WHERE A1.GongSiId2=tbl_GongSi.GongSiId AND A1.GongSiId1='{0}') ", chaXun.CgsId); } if (chaXun.LaiYuan.HasValue) { sql.AppendFormat(" AND LaiYuan={0} ", (int)chaXun.LaiYuan.Value); } 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.MGongSiInfo(); info.CaiWuDianHua = rdr["CaiWuDianHua"].ToString(); info.CaiWuName = rdr["CaiWuName"].ToString(); info.CaiWuShenFenZhengHao = rdr["CaiWuShenFenZhengHao"].ToString(); info.CaiWuZhaoPianFilepath = rdr["CaiWuZhaoPianFilepath"].ToString(); info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString(); info.ChengShiId = rdr.GetInt32(rdr.GetOrdinal("ChengShiId")); info.DiZhi = rdr["DiZhi"].ToString(); info.FanRenName = rdr["FanRenName"].ToString(); info.FuZeRenDianHua = rdr["FuZeRenDianHua"].ToString(); info.FuZeRenName = rdr["FuZeRenName"].ToString(); info.FuZeRenShenFenZhengHao = rdr["FuZeRenShenFenZhengHao"].ToString(); info.FuZeRenZhaoPianFilepath = rdr["FuZeRenZhaoPianFilepath"].ToString(); info.GongSiId = rdr["GongSiId"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.LeiXing = (EyouSoft.Model.GongSiLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing")); info.Name = rdr["Name"].ToString(); info.ShengFenId = rdr.GetInt32(rdr.GetOrdinal("ShengFenId")); info.YingYeZhiZhaoFilepath = rdr["YingYeZhiZhaoFilepath"].ToString(); info.ZuZhiJiGouFilepath = rdr["ZuZhiJiGouFilepath"].ToString(); info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString(); info.LogoFilepath = rdr["LogoFilepath"].ToString(); info.LxQQ = rdr["LxQQ"].ToString(); info.LaiYuan = (EyouSoft.Model.LaiYuan)rdr.GetInt32(rdr.GetOrdinal("LaiYuan")); info.ShenHeStatus = (EyouSoft.Model.ShenHeStatus)rdr.GetInt32(rdr.GetOrdinal("ShenHeStatus")); items.Add(info); } /* * rdr.NextResult(); * * if (rdr.Read()) * { * if (!rdr.IsDBNull(0)) heJi[0] = rdr.GetDecimal(0); * }*/ } return(items); }