示例#1
0
        public static void SetAnnex(string prjId, string prjCompletedId, List <string> annexAddress, string type)
        {
            if (string.IsNullOrEmpty(prjId))
            {
                throw new Exception("竣工管理准备项目设置目录参数 prjId 不能为空或空字符串");
            }
            if (string.IsNullOrEmpty(prjCompletedId))
            {
                throw new Exception("竣工管理准备项目设置目录参数 prjCompletedId 不能为空或空字符串");
            }
            if (string.IsNullOrEmpty(type))
            {
                throw new Exception("竣工管理准备项目设置目录参数 type 不能为空或空字符串");
            }
            CompletedAnnex annex = new CompletedAnnex();

            if (type == "add")
            {
                annex.Add(prjId, prjCompletedId, annexAddress);
            }
            else
            {
                if (type != "edit")
                {
                    throw new Exception("竣工管理准备项目设置目录参数 type 值只能是add或edit");
                }
                annex.Update(prjId, prjCompletedId, annexAddress);
            }
        }
示例#2
0
        public static List <string> GetAnnexAddress(string prjId, string prjCompletedId)
        {
            CompletedAnnex annex    = new CompletedAnnex();
            string         detailId = annex.GetDetailId(prjId, prjCompletedId);

            return(annex.GetAnnex(detailId));
        }
示例#3
0
        public static int GetFilesCount(string prjId, string prjCompletedId)
        {
            string        detailId       = new CompletedAnnex().GetDetailId(prjId, prjCompletedId);
            string        inParameterSql = DBHelper.GetInParameterSql(new CompletedAnnex().GetAnnex(detailId).ToArray());
            StringBuilder builder        = new StringBuilder();

            builder.AppendFormat("SELECT COUNT(*) FROM F_FileInfo WHERE ParentId IN ({0}) AND FileType='0' AND IsValid='0'", inParameterSql);
            return(int.Parse(SqlHelper.ExecuteScalar(CommandType.Text, builder.ToString(), new SqlParameter[0]).ToString()));
        }
示例#4
0
        public static DataTable GetFilesName(string prjId, string prjCompletedId)
        {
            string        detailId       = new CompletedAnnex().GetDetailId(prjId, prjCompletedId);
            string        inParameterSql = DBHelper.GetInParameterSql(new CompletedAnnex().GetAnnex(detailId).ToArray());
            StringBuilder builder        = new StringBuilder();

            builder.AppendFormat("SELECT FileName,FileNewName FROM F_FileInfo WHERE ParentId IN ({0}) AND FileType='0' AND IsValid='0'", inParameterSql);
            return(SqlHelper.ExecuteQuery(CommandType.Text, builder.ToString(), new SqlParameter[0]));
        }
示例#5
0
 public static string GetFirstAnnexAddress(string prjId, string prjCompletedId)
 {
     using (pm2Entities entities = new pm2Entities())
     {
         string detailId = new CompletedAnnex().GetDetailId(prjId, prjCompletedId);
         return((from m in entities.PT_Prj_Completed_Annex
                 orderby m.AnnexAddress
                 where m.PT_Prj_Completed_Detail.ID == detailId
                 select m.AnnexAddress).FirstOrDefault <string>());
     }
 }
示例#6
0
        public static bool ExistAnnexAddress(string prjId, string prjCompletedId)
        {
            bool flag = false;

            using (pm2Entities entities = new pm2Entities())
            {
                string detailId = new CompletedAnnex().GetDetailId(prjId, prjCompletedId);
                if (!string.IsNullOrEmpty((from m in entities.PT_Prj_Completed_Annex
                                           where m.PT_Prj_Completed_Detail.ID == detailId
                                           select m.ID).FirstOrDefault <string>()))
                {
                    flag = true;
                }
            }
            return(flag);
        }
示例#7
0
 private void Update(string prjId, string prjCompletedId, List <string> annexAddress)
 {
     if (annexAddress != null)
     {
         using (pm2Entities entities = new pm2Entities())
         {
             string detailId = new CompletedAnnex().GetDetailId(prjId, prjCompletedId);
             if (detailId != "")
             {
                 List <string> list = this.GetAnnex(detailId);
                 using (List <string> .Enumerator enumerator = list.GetEnumerator())
                 {
                     string address;
                     while (enumerator.MoveNext())
                     {
                         address = enumerator.Current;
                         if (!annexAddress.Contains(address))
                         {
                             PT_Prj_Completed_Annex entity = (from m in entities.PT_Prj_Completed_Annex
                                                              where (m.PT_Prj_Completed_Detail.ID == detailId) && (m.AnnexAddress == address)
                                                              select m).FirstOrDefault <PT_Prj_Completed_Annex>();
                             if (entity != null)
                             {
                                 entities.DeleteObject(entity);
                             }
                         }
                     }
                 }
                 PT_Prj_Completed_Detail detail = (from m in entities.PT_Prj_Completed_Detail
                                                   where m.ID == detailId
                                                   select m).FirstOrDefault <PT_Prj_Completed_Detail>();
                 if (detail != null)
                 {
                     CompletedAnnex annex2 = new CompletedAnnex();
                     foreach (string str in annexAddress)
                     {
                         if (!list.Contains(str))
                         {
                             annex2.AddSingle(detail, str, entities);
                         }
                     }
                 }
                 entities.SaveChanges();
             }
         }
     }
 }
示例#8
0
 private void Add(string prjId, string prjCompletedId, List <string> annexAddress)
 {
     if (annexAddress != null)
     {
         using (pm2Entities entities = new pm2Entities())
         {
             Guid prjGuid = new Guid(prjId);
             PT_Prj_Completed_Detail detail = (from m in entities.PT_Prj_Completed_Detail
                                               where (m.PrjGuid == prjGuid) && (m.PT_Prj_Completed.ID == prjCompletedId)
                                               select m).FirstOrDefault <PT_Prj_Completed_Detail>();
             if (detail != null)
             {
                 CompletedAnnex annex = new CompletedAnnex();
                 foreach (string str in annexAddress)
                 {
                     annex.AddSingle(detail, str, entities);
                 }
                 entities.SaveChanges();
             }
         }
     }
 }