/// <summary>
/// 采购单发布，返回1成功，其它失败
/// </summary>
/// <param name="cgsId">采购商编号</param>
/// <param name="caiGouDanId">采购单编号</param>
/// <param name="caoZuoRenId">操作人编号</param>
/// <returns></returns>
public int FaBu(string cgsId, string caiGouDanId, string caoZuoRenId)
{
if (string.IsNullOrEmpty(cgsId) || string.IsNullOrEmpty(caiGouDanId) || string.IsNullOrEmpty(caoZuoRenId))
{
return(0);
}
int dalRetCode = dal.SheZhiStatus(cgsId, caiGouDanId, EyouSoft.Model.CaiGouDanStatus.已下单, caoZuoRenId, DateTime.Now);
#region 消息处理
if (dalRetCode == 1)
{
var xiaoXiInfo = new EyouSoft.Model.MXiaoXiInfo();
xiaoXiInfo.BiaoTi = "待报价";
xiaoXiInfo.ChuLiRenId = string.Empty;
xiaoXiInfo.ChuLiTime = null;
xiaoXiInfo.FaChuGongSiId = cgsId;
xiaoXiInfo.FaChuRenId = caoZuoRenId;
xiaoXiInfo.FaChuTime = DateTime.Now;
xiaoXiInfo.GuanLianId = string.Empty;
xiaoXiInfo.JieShouGongSiId = string.Empty;
xiaoXiInfo.JieShouRenId = string.Empty;
xiaoXiInfo.LeiXing = EyouSoft.Model.XiaoXiLeiXing.供应商待报价;
xiaoXiInfo.NeiRong = "您有一个采购单需要报价";
xiaoXiInfo.Status = EyouSoft.Model.XiaoXiStatus.未读;
xiaoXiInfo.XiaoXiId = string.Empty;
var caiGouDingDanItems = new EyouSoft.BLL.BDingDan().GetDingDans(caiGouDanId);
if (caiGouDingDanItems != null && caiGouDingDanItems.Count > 0)
{
foreach (var item in caiGouDingDanItems)
{
xiaoXiInfo.GuanLianId = item.DingDanId;
xiaoXiInfo.JieShouGongSiId = item.GysId;
xiaoXiInfo.NeiRong = "您有一个采购单需要报价，采购单号：" + item.CaiGouDanHao + "。";
BXiaoXi.XiaoXi_C(xiaoXiInfo);
}
}
}
#endregion
if (dalRetCode == 1)
{
var logInfo = new EyouSoft.Model.MCaoZuoLogInfo();
logInfo.BiaoTi = "发布采购信息";
logInfo.NeiRong = "发布采购信息，采购单编号：" + caiGouDanId + "。";
logInfo.GuanLianId = caiGouDanId;
BCaoZuoLog.Log_C(logInfo);
}
return(dalRetCode);
}
/// <summary>
/// 添加消息，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
internal static int XiaoXi_C(EyouSoft.Model.MXiaoXiInfo info)
{
if (info == null || string.IsNullOrEmpty(info.GuanLianId) || string.IsNullOrEmpty(info.FaChuGongSiId) || string.IsNullOrEmpty(info.JieShouGongSiId))
{
return(0);
}
info.XiaoXiId = Guid.NewGuid().ToString();
info.FaChuTime = DateTime.Now;
info.Status = EyouSoft.Model.XiaoXiStatus.未读;
int dalRetCode = new EyouSoft.DAL.DXiaoXi().XiaoXi_C(info);
return(dalRetCode);
}
/// <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>
/// 添加消息，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int XiaoXi_C(EyouSoft.Model.MXiaoXiInfo info)
{
var cmd = _db.GetSqlStringCommand("INSERT INTO [tbl_XiaoXi]([XiaoXiId],[LeiXing],[GuanLianId],[BiaoTi],[NeiRong],[FaChuGongSiId],[FaChuRenId],[FaChuTime],[JieShouGongSiId],[JieShouRenId],[Status],[ChuLiRenId],[ChuLiTime]) VALUES(@XiaoXiId,@LeiXing,@GuanLianId,@BiaoTi,@NeiRong,@FaChuGongSiId,@FaChuRenId,@FaChuTime,@JieShouGongSiId,@JieShouRenId,@Status,@ChuLiRenId,@ChuLiTime)");
_db.AddInParameter(cmd, "@XiaoXiId", DbType.AnsiStringFixedLength, info.XiaoXiId);
_db.AddInParameter(cmd, "@LeiXing", DbType.Int32, info.LeiXing);
_db.AddInParameter(cmd, "@GuanLianId", DbType.AnsiStringFixedLength, info.GuanLianId);
_db.AddInParameter(cmd, "@BiaoTi", DbType.String, info.BiaoTi);
_db.AddInParameter(cmd, "@NeiRong", DbType.String, info.NeiRong);
_db.AddInParameter(cmd, "@FaChuGongSiId", DbType.AnsiStringFixedLength, info.FaChuGongSiId);
_db.AddInParameter(cmd, "@FaChuRenId", DbType.AnsiStringFixedLength, info.FaChuRenId);
_db.AddInParameter(cmd, "@FaChuTime", DbType.DateTime, info.FaChuTime);
_db.AddInParameter(cmd, "@JieShouGongSiId", DbType.AnsiStringFixedLength, info.JieShouGongSiId);
_db.AddInParameter(cmd, "@JieShouRenId", DbType.AnsiStringFixedLength, info.JieShouRenId);
_db.AddInParameter(cmd, "@Status", DbType.Int32, info.Status);
_db.AddInParameter(cmd, "@ChuLiRenId", DbType.AnsiStringFixedLength, "");
_db.AddInParameter(cmd, "@ChuLiTime", DbType.DateTime, DBNull.Value);
DbHelper.ExecuteSql(cmd, _db);
return(1);
}
/// <summary>
/// 获取消息集合
/// </summary>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MXiaoXiInfo> GetXiaoXis(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MXiaoXiChaXunInfo chaXun)
{
IList <EyouSoft.Model.MXiaoXiInfo> items = new List <EyouSoft.Model.MXiaoXiInfo>();
string fields = "*";
StringBuilder sql = new StringBuilder();
string tableName = "tbl_XiaoXi";
string orderByString = " Status ASC,FaChuTime DESC ";
string heJiString = "";
#region sql
sql.Append(" 1=1 ");
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.FaChuGongSiId))
{
sql.AppendFormat(" AND FaChuGongSiId='{0}' ", chaXun.FaChuGongSiId);
}
if (!string.IsNullOrEmpty(chaXun.FaChuRenId))
{
sql.AppendFormat(" AND FaChuRenId='{0}' ", chaXun.FaChuRenId);
}
if (!string.IsNullOrEmpty(chaXun.JieShouGongSiId))
{
sql.AppendFormat(" AND JieShouGongSiId='{0}' ", chaXun.JieShouGongSiId);
}
if (!string.IsNullOrEmpty(chaXun.JieShouRenId))
{
sql.AppendFormat(" AND JieShouRenId='{0}' ", chaXun.JieShouRenId);
}
if (chaXun.LeiXing.HasValue)
{
sql.AppendFormat(" AND LeiXing={0} ", (int)chaXun.LeiXing.Value);
}
if (chaXun.Status.HasValue)
{
sql.AppendFormat(" AND Status={0} ", (int)chaXun.Status.Value);
}
if (chaXun.LeiXings != null && chaXun.LeiXings.Count > 0)
{
sql.AppendFormat(" AND LeiXing IN({0}) ", GetSqlIn(chaXun.LeiXings));
}
}
#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.MXiaoXiInfo();
info.BiaoTi = rdr["BiaoTi"].ToString();
info.ChuLiRenId = rdr["ChuLiRenId"].ToString();
if (!rdr.IsDBNull(rdr.GetOrdinal("ChuLiTime")))
{
info.ChuLiTime = rdr.GetDateTime(rdr.GetOrdinal("ChuLiTime"));
}
info.FaChuGongSiId = rdr["FaChuGongSiId"].ToString();
info.FaChuRenId = rdr["FaChuRenId"].ToString();
info.FaChuTime = rdr.GetDateTime(rdr.GetOrdinal("FaChuTime"));
info.GuanLianId = rdr["GuanLianId"].ToString();
info.JieShouGongSiId = rdr["JieShouGongSiId"].ToString();
info.JieShouRenId = rdr["JieShouRenId"].ToString();
info.LeiXing = (EyouSoft.Model.XiaoXiLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing"));
info.NeiRong = rdr["NeiRong"].ToString();
info.Status = (EyouSoft.Model.XiaoXiStatus)rdr.GetInt32(rdr.GetOrdinal("Status"));
info.XiaoXiId = rdr["XiaoXiId"].ToString();
items.Add(info);
}
}
return(items);
}
/// <summary>
/// 设置订单状态，返回1成功，其它失败
/// </summary>
/// <param name="dingDanId">订单编号</param>
/// <param name="status">订单状态</param>
/// <param name="caoZuoRenId">操作人编号</param>
/// <returns></returns>
public int SheZhiStatus(string dingDanId, EyouSoft.Model.DingDanStatus status, string caoZuoRenId)
{
if (string.IsNullOrEmpty(dingDanId) || string.IsNullOrEmpty(caoZuoRenId))
{
return(0);
}
var info = GetInfo(dingDanId);
if (info == null)
{
return(-1);
}
if (info.Status == EyouSoft.Model.DingDanStatus.计划采购)
{
return(-2);
}
var buKeQuXiaoStatus = new[] { EyouSoft.Model.DingDanStatus.供应商发货完成, EyouSoft.Model.DingDanStatus.采购商确认收货 };
if (status == EyouSoft.Model.DingDanStatus.取消采购 && buKeQuXiaoStatus.Contains(info.Status))
{
return(-3);
}
int dalRetCode = dal.SheZhiStatus(dingDanId, status, caoZuoRenId, DateTime.Now);
#region 消息处理
if (dalRetCode == 1)
{
var xiaoXiInfo = new EyouSoft.Model.MXiaoXiInfo();
xiaoXiInfo.BiaoTi = string.Empty;
xiaoXiInfo.ChuLiRenId = string.Empty;
xiaoXiInfo.ChuLiTime = null;
xiaoXiInfo.FaChuGongSiId = string.Empty;
xiaoXiInfo.FaChuRenId = caoZuoRenId;
xiaoXiInfo.FaChuTime = DateTime.Now;
xiaoXiInfo.GuanLianId = dingDanId;
xiaoXiInfo.JieShouGongSiId = string.Empty;
xiaoXiInfo.JieShouRenId = string.Empty;
xiaoXiInfo.LeiXing = EyouSoft.Model.XiaoXiLeiXing.None;
xiaoXiInfo.NeiRong = string.Empty;
xiaoXiInfo.Status = EyouSoft.Model.XiaoXiStatus.未读;
xiaoXiInfo.XiaoXiId = string.Empty;
if (status == EyouSoft.Model.DingDanStatus.供应商完成报价)
{
xiaoXiInfo.BiaoTi = "待确认报价";
xiaoXiInfo.FaChuGongSiId = info.GysId;
xiaoXiInfo.JieShouGongSiId = info.CgsId;
xiaoXiInfo.LeiXing = EyouSoft.Model.XiaoXiLeiXing.采购商待确认报价;
xiaoXiInfo.NeiRong = "您有一个采购单报价信息需要确认，采购单号：" + info.CaiGouDanHao + "。";
}
if (status == EyouSoft.Model.DingDanStatus.采购商确认报价)
{
xiaoXiInfo.BiaoTi = "待发货";
xiaoXiInfo.FaChuGongSiId = info.CgsId;
xiaoXiInfo.JieShouGongSiId = info.GysId;
xiaoXiInfo.LeiXing = EyouSoft.Model.XiaoXiLeiXing.供应商待发货;
xiaoXiInfo.NeiRong = "您有一个采购单需要发货，采购单号：" + info.CaiGouDanHao + "。";
}
if (status == EyouSoft.Model.DingDanStatus.供应商发货完成)
{
xiaoXiInfo.BiaoTi = "待收货";
xiaoXiInfo.FaChuGongSiId = info.GysId;
xiaoXiInfo.JieShouGongSiId = info.CgsId;
xiaoXiInfo.LeiXing = EyouSoft.Model.XiaoXiLeiXing.采购商待确认收货;
xiaoXiInfo.NeiRong = "您有一个采购单供应商已发货，待收货确认，采购单号：" + info.CaiGouDanHao + "。";
}
BXiaoXi.XiaoXi_C(xiaoXiInfo);
}
#endregion
if (dalRetCode == 1)
{
var logInfo = new EyouSoft.Model.MCaoZuoLogInfo();
logInfo.BiaoTi = "设置订单状态";
logInfo.NeiRong = "设置订单状态，订单编号：" + info.DingDanId + "，订单状态：" + status + "。";
logInfo.GuanLianId = info.DingDanId;
BCaoZuoLog.Log_C(logInfo);
}
return(dalRetCode);
}
