首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 开发语言 > 编程 >

where并排条件

2012-11-04 
where并列条件/// 合同标的总和/// /summary/// param namecontractId合同Id/param/// param na

where并列条件
/// 合同标的总和
        /// </summary>
        /// <param name="contractId">合同Id</param>
        /// <param name="userId">用户Id</param>
        /// <returns>合同标的总和</returns>
        /// <remarks>jun.2011.08.03</remarks>
        public string GetSubjectMatterSum(string contractId, int userId)
        {
            try
            {
                WCMSDATA wd = DataEntity.Initializes();
                var query = from sub in wd.WOO_CONT_SUBJECTMATTER
                            where (sub.CONTRACT_ID == Convert.ToInt32(contractId) || sub.CONTRACT_ID == (0 - userId))
                            select sub.FINAL_AMOUNT_MONEY;
                return query.Sum().ToString();
            }
            catch (Exception e)
            {
                WooLogger.Error(e.ToString());
                return String.Empty;
            }
        }

热点排行