Example #1
0
        //public decimal GetCacheSKByProject(int projectid)
        //{
        //   List<DDShouKuan> ddShouKuans = db.DDShouKuan.Where(d => d.SKFangShi == "现金" && d.ProjectID == projectid && d.SKState != "InValid").ToList();
        //    return ddShouKuans.Sum(d => d.SKMoney);
        //}
        //public decimal GetBankSKByProject(int projectid)
        //{
        //    List<DDShouKuan> ddShouKuans = db.DDShouKuan.Where(d => d.SKFangShi != "现金" && d.ProjectID == projectid && d.SKState != "InValid").ToList();
        //    return ddShouKuans.Sum(d => d.SKMoney);
        //}
        public DDShouKuan UpdateSingle(int id, DDShouKuanReq data)
        {
            DDShouKuan model = db.DDShouKuan.Find(id);

            SetDDShouKuan(model, data);
            db.SaveChanges();
            return(model);
        }
Example #2
0
        /// <summary>
        /// 设置model,如果不为空就设置,如果为空则和之前一样
        /// </summary>
        /// <param name="target"></param>
        /// <param name="source"></param>
        /// <returns></returns>
        public DDShouKuan SetDDShouKuan(DDShouKuan model, DDShouKuanReq data)
        {
            if (data.HeTongID != null)
            {
                model.HeTongID = data.HeTongID.Value;
            }
            if (!string.IsNullOrEmpty(data.HeTongNumber))
            {
                model.HeTongNumber = data.HeTongNumber;
            }
            if (!string.IsNullOrEmpty(data.HeTongName))
            {
                model.HeTongName = data.HeTongName;
            }
            if (data.KhID != null)
            {
                model.KhID = data.KhID.Value;
            }
            if (!string.IsNullOrEmpty(data.KhName))
            {
                model.KhName = data.KhName;
            }
            if (!string.IsNullOrEmpty(data.SKName))
            {
                model.SKName = data.SKName;
            }
            if (data.SKMoney != null)
            {
                model.SKMoney = data.SKMoney.Value;
            }
            if (!string.IsNullOrEmpty(data.SKPayOnlieNumber))
            {
                model.SKPayOnlieNumber = data.SKPayOnlieNumber;
            }
            if (data.SKDateTime != null && data.SKDateTime != DateTime.MinValue &&
                data.SKDateTime != SqlDateTime.MinValue.Value)
            {
                model.SKDateTime = data.SKDateTime.Value;
            }
            //if (!string.IsNullOrEmpty(data.SKInfos))
            model.SKInfos = data.SKInfos;
            if (!string.IsNullOrEmpty(data.ServerMsg))
            {
                model.ServerMsg = data.ServerMsg;
            }
            if (data.projectid != null)
            {
                model.ProjectID = data.projectid.Value;
            }
            if (!string.IsNullOrEmpty(data.optName))
            {
                model.optName = data.optName;
            }
            if (data.optDateTime != null && data.optDateTime != DateTime.MinValue &&
                data.optDateTime != SqlDateTime.MinValue.Value)
            {
                model.optDateTime = data.optDateTime.Value;
            }

            if (!string.IsNullOrEmpty(data.SKClass))
            {
                model.SKClass = data.SKClass;
            }
            if (!string.IsNullOrEmpty(data.SKState))
            {
                model.SKState = data.SKState;
            }
            if (!string.IsNullOrEmpty(data.SKFangShi))
            {
                model.SKFangShi = data.SKFangShi;
            }
            if (!string.IsNullOrEmpty(data.SKNumber))
            {
                model.SKNumber = data.SKNumber;
            }
            if (data.JiaoGeId != null)
            {
                model.JiaoGeId = data.JiaoGeId.Value;
            }

            return(model);
        }