/// <summary>
/// 没读过的通知行数
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public int GetNewMessageCount(int userId)
{
string sql = string.Format("select COUNT(*) Id from Notice");
int count = Convert.ToInt32(m_dbo.ExecuteScalar(sql));
string sqls = string.Format("select COUNT(*) Id from NoticeRecord where UserId={0}", userId);
int counts = Convert.ToInt32(m_dbo.ExecuteScalar(sqls));
return(count - counts);
}
/// <summary>
/// 获取账期时间
/// </summary>
/// <returns></returns>
public object GetAccountExpire(int OrderId, int ComId)
{
string sql = string.Format(@"declare @FeedBackFinishTime datetime= getdate();
declare @CreditDays int= 0;
select @FeedBackFinishTime=FeedBackFinishTime from OrderStatus where OrderId={0};
select @CreditDays=CreditDays from Customer where ComId={1}
select dateadd(day,@CreditDays,@FeedBackFinishTime) as [Time]", OrderId, ComId);
return(m_dbo.ExecuteScalar(sql));
}
/// <summary>
///
/// </summary>
/// <param name="OrderId"></param>
/// <returns></returns>
public bool IsBoxOrder(int OrderId)
{
string sql = string.Format("select COUNT(Id) from OrderBox where OrderId={0}", OrderId);
object o = m_dbo.ExecuteScalar(sql);
try
{
int count = Convert.ToInt32(o);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
public int DetailCount(int orderId)
{
string sql = string.Format(" select count(*) from OrderDetail where OrderId={0}", orderId);
object o = m_dbo.ExecuteScalar(sql);
try
{
return(Convert.ToInt32(o));
}
catch
{
return(0);
}
}
/// <summary>
/// 判断汇总单是否已拆单
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public bool NeedToPurchaseStatus(int Id)
{
string sql = string.Format("select Status from NeedToPurchase where Id={0};", Id);
object o = m_dbo.ExecuteScalar(sql);
int i = Convert.ToInt32(o.ToString());
if (i == 0)
{
return(true);
}
else
{
return(false);
}
}
