コード例 #1
0
ファイル: PrjsctManager.cs プロジェクト: scaperow/-V2.0
        /// <summary>
        /// 更新标段信息
        /// </summary>
        /// <param name="ProjectInfo"></param>
        /// <returns></returns>
        public Boolean UpdatePrjsctInfo(Prjsct PrjstInfo)
        {
            Boolean Result = false;

            try
            {
                //工程结构树
                StringBuilder Sql_Select = new StringBuilder();
                // 增加查询条件 Scdel=0  2013-10-17
                Sql_Select.Append("select Id,Description,PegFrom,PegTo,Price,Scts_1 from sys_engs_SectionInfo where Scdel=0 and ID ='");
                Sql_Select.Append(PrjstInfo.Index);
                Sql_Select.Append("'");

                DataTable Data = GetDataTable(Sql_Select.ToString());
                if (Data != null && Data.Rows.Count > 0)
                {
                    DataRow Row = Data.Rows[0];
                    Row["Description"] = PrjstInfo.PrjsctName;
                    Row["PegFrom"]     = PrjstInfo.PegFrom;
                    Row["PegTo"]       = PrjstInfo.PegTo;
                    Row["Scts_1"]      = DateTime.Now.ToString();
                }

                object r = Update(Data);
                Result = (Convert.ToInt32(r) == 1);

                ProjectManager project = new ProjectManager();
                project.SyncSysTree(PrjstInfo.PrjsctCode, PrjstInfo.PrjsctName, "@tenders", PrjstInfo.OrderID, false);
            }
            catch
            { }

            return(Result);
        }
コード例 #2
0
        public Boolean SelectOrginfo(Orginfo OrgInfo)
        {
            Boolean Result = false;

            StringBuilder Sql_Select = new StringBuilder();

            //增加查询条件  Scdel=0     2013-10-17
            Sql_Select.Append("Select Id,NodeCode,NodeType,RalationID From sys_engs_Tree Where Scdel=0 and RalationID='");
            Sql_Select.Append(OrgInfo.Index);
            Sql_Select.Append("'");

            DataTable Data = GetDataTable(Sql_Select.ToString());

            if (Data != null)
            {
                DataRow Row = Data.NewRow();
                Row["ID"]         = Guid.NewGuid().ToString();
                Row["NodeCode"]   = OrgInfo.DepCode;
                Row["NodeType"]   = OrgInfo.DepType;
                Row["RalationID"] = OrgInfo.Index;
                Data.Rows.Add(Row);
            }

            try
            {
                object r = Update(Data);
                Result = (Convert.ToInt32(r) == 1);
            }
            catch
            { }

            OrgInfo.OrderID = OrgInfo.DepCode;
            ProjectManager project = new ProjectManager();

            project.SyncSysTree(OrgInfo.DepCode, OrgInfo.DepName, OrgInfo.DepType, OrgInfo.OrderID, false);

            return(Result);
        }
コード例 #3
0
ファイル: PrjFolderManager.cs プロジェクト: scaperow/-V2.0
        public Boolean UpdatePrjFolder(PrjFolder FolderInfo)
        {
            Boolean Result = false;

            try
            {
                //工程结构树
                StringBuilder Sql_Select = new StringBuilder();
                //增加查询条件  Scdel=0  2013-10-17
                Sql_Select.Append("Select Id,Description,ItemType,Scts_1 From  sys_engs_ItemInfo Where Scdel=0 and Id='");
                Sql_Select.Append(FolderInfo.Index);
                Sql_Select.Append("'");

                DataTable Data = GetDataTable(Sql_Select.ToString());
                if (Data != null && Data.Rows.Count > 0)
                {
                    DataRow Row = Data.Rows[0];
                    Row["Description"] = FolderInfo.FolderName;
                    Row["ItemType"]    = FolderInfo.FolderType;

                    //增加条件  Scts_1=Getdate()  2013-10-17
                    Row["Scts_1"] = DateTime.Now.ToString();
                }

                object r = Update(Data);
                Result = (Convert.ToInt32(r) == 1);

                ProjectManager project = new ProjectManager();
                project.SyncSysTree(FolderInfo.FolderCode, FolderInfo.FolderName, "@folder", FolderInfo.OrderID, false);
            }
            catch (Exception ex)
            {
                logger.Error("UpdatePrjFolder异常:" + ex.Message);
            }

            return(Result);
        }
コード例 #4
0
ファイル: PrjsctManager.cs プロジェクト: scaperow/-V2.0
        /// <summary>
        /// 删除标段信息
        /// </summary>
        /// <param name="PrjsctCode"></param>
        /// <returns></returns>
        public Boolean DeletePrjsctInfo(string PrjsctCode, string PrjsctId)
        {
            Boolean Result = false;

            List <string> SheetList = ProjectCatlogManager.GetModuleTables(PrjsctCode);

            IDbConnection DbConnection = GetConntion();
            Transaction   Transaction  = new Transaction(DbConnection);

            try
            {
                List <String> sql_Commands = new List <string>();

                //工程结构树
                StringBuilder Sql_Delete = new StringBuilder();
                //增加字段Scts_1,Scdel 之后 删除操作只做伪删除,用于数据同步     2013-10-17
                //Sql_Delete.Append("Delete From sys_engs_Tree Where NodeCode like '");
                //Sql_Delete.Append(PrjsctCode);
                //Sql_Delete.Append("%'");
                Sql_Delete.Append("Update sys_engs_Tree Set Scts_1=Getdate(),Scdel=1 Where NodeCode like '");
                Sql_Delete.Append(PrjsctCode);
                Sql_Delete.Append("%'");

                sql_Commands.Add(Sql_Delete.ToString());

                //标段相关数据
                Sql_Delete = new StringBuilder();
                //增加字段Scts_1,Scdel 之后 删除操作只做伪删除,用于数据同步     2013-10-17
                //Sql_Delete.Append("Delete From sys_engs_SectionInfo Where ID  = '");
                //Sql_Delete.Append(PrjsctId);
                //Sql_Delete.Append("'");
                Sql_Delete.Append("Update sys_engs_SectionInfo Set Scts_1=Getdate(),Scdel=1 Where ID  = '");
                Sql_Delete.Append(PrjsctId);
                Sql_Delete.Append("'");

                sql_Commands.Add(Sql_Delete.ToString());

                //处理相关模板表的数据
                foreach (String SheetName in SheetList)
                {
                    Sql_Delete = new StringBuilder();
                    Sql_Delete.Append("Delete From ");
                    Sql_Delete.Append(SheetName);
                    Sql_Delete.Append(" where SCPT like '");
                    Sql_Delete.Append(PrjsctCode);
                    Sql_Delete.Append("%'");

                    sql_Commands.Add(Sql_Delete.ToString());
                }

                object r    = ExcuteCommands(sql_Commands.ToArray(), Transaction);
                int[]  ints = (int[])r;
                for (int i = 0; i < ints.Length; i++)
                {
                    if (i != 0)
                    {
                        Result = Result & (Convert.ToInt32(ints[i]) == 1);
                    }
                    else
                    {
                        Result = (Convert.ToInt32(ints[i]) == 1);
                    }
                }

                if (Result)
                {
                    Transaction.Commit();
                }
                else
                {
                    Transaction.Rollback();
                }
            }
            catch
            {
                Transaction.Rollback();
            }
            ProjectManager project = new ProjectManager();

            project.SyncSysTree(PrjsctCode, "", "@tenders", "", true);

            return(Result);
        }
コード例 #5
0
ファイル: PrjsctManager.cs プロジェクト: scaperow/-V2.0
        /// <summary>
        /// 新建标段信息
        /// </summary>
        /// <param name="PrjstInfo"></param>
        /// <returns></returns>
        public Boolean NewPrjstInfo(Prjsct PrjstInfo)
        {
            Boolean Result = false;

            IDbConnection DbConnection = GetConntion();
            Transaction   Transaction  = new Transaction(DbConnection);

            try
            {
                //工程结构树
                StringBuilder Sql_Select = new StringBuilder();
                //增加查询条件  Scdel=0  2013-10-17
                Sql_Select.Append("Select ID,NodeCode,NodeType,RalationID From sys_engs_Tree Where Scdel=0 and RalationID='");
                Sql_Select.Append(PrjstInfo.Index);
                Sql_Select.Append("'");

                DataTable Data = GetDataTable(Sql_Select.ToString());
                if (Data != null && Data.Rows.Count == 0)
                {
                    DataRow Row = Data.NewRow();
                    Row["ID"]         = Guid.NewGuid().ToString();
                    Row["NodeCode"]   = PrjstInfo.PrjsctCode;
                    Row["NodeType"]   = "@tenders";
                    Row["RalationID"] = PrjstInfo.Index;
                    Data.Rows.Add(Row);
                }

                object r = Update(Data, Transaction);
                Result = (Convert.ToInt32(r) == 1);

                //处理标段表
                Sql_Select = new StringBuilder();
                // 增加查询条件 Scdel=0  2013-10-17
                Sql_Select.Append("select ID,Description,PegFrom,PegTo,Price from sys_engs_SectionInfo where Scdel=0 and ID ='");
                Sql_Select.Append(PrjstInfo.Index);
                Sql_Select.Append("'");

                Data = GetDataTable(Sql_Select.ToString());
                if (Data != null && Data.Rows.Count == 0)
                {
                    DataRow Row = Data.NewRow();
                    Row["ID"]          = PrjstInfo.Index;
                    Row["Description"] = PrjstInfo.PrjsctName;
                    Row["PegFrom"]     = PrjstInfo.PegFrom;
                    Row["PegTo"]       = PrjstInfo.PegTo;
                    Data.Rows.Add(Row);
                }

                r      = Update(Data, Transaction);
                Result = Result & (Convert.ToInt32(r) == 1);

                if (Result)
                {
                    Transaction.Commit();
                }
                else
                {
                    Transaction.Rollback();
                }
            }
            catch
            {
                Transaction.Rollback();
            }
            PrjstInfo.OrderID = PrjstInfo.PrjsctCode;
            ProjectManager project = new ProjectManager();

            project.SyncSysTree(PrjstInfo.PrjsctCode, PrjstInfo.PrjsctName, "@tenders", PrjstInfo.OrderID, false);

            return(Result);
        }
コード例 #6
0
        public Boolean UpdateOrginfo(Orginfo OrgInfo)
        {
            Boolean Result = false;

            IDbConnection DbConnection = GetConntion();
            Transaction   Transaction  = new Transaction(DbConnection);

            try
            {
                //单位信息表
                StringBuilder Sql_Select = new StringBuilder();
                //增加查询条件  Scdel=0  2013-10-17
                Sql_Select.Append("Select Id,Description,DepType,DepAbbrev,ConstructionCompany From sys_engs_CompanyInfo where Scdel=0 and Id='");
                Sql_Select.Append(OrgInfo.Index);
                Sql_Select.Append("'");

                DataTable Data = GetDataTable(Sql_Select.ToString());
                if (Data != null && Data.Rows.Count > 0)
                {
                    DataRow Row = Data.Rows[0];
                    Row["Description"]         = OrgInfo.DepName;
                    Row["DepType"]             = OrgInfo.DepType;
                    Row["DepAbbrev"]           = OrgInfo.DepAbbrev;
                    Row["ConstructionCompany"] = OrgInfo.ConstructionCompany;
                }

                object r = Update(Data, Transaction);
                Result = (Convert.ToInt32(r) == 1);

                Sql_Select = new StringBuilder();
                //增加查询条件  Scdel=0     2013-10-17
                Sql_Select.Append("Select Id,NodeCode,NodeType,RalationID From sys_engs_Tree Where Scdel=0 and RalationID='");
                Sql_Select.Append(OrgInfo.Index);
                Sql_Select.Append("'");

                Data = GetDataTable(Sql_Select.ToString());
                if (Data != null && Data.Rows.Count > 0)
                {
                    DataRow Row = Data.Rows[0];
                    Row["NodeType"] = OrgInfo.DepType;
                }

                r      = Update(Data, Transaction);
                Result = (Convert.ToInt32(r) == 1);

                if (Result)
                {
                    Transaction.Commit();
                }
                else
                {
                    Transaction.Rollback();
                }
            }
            catch
            {
                Transaction.Rollback();
            }
            ProjectManager project = new ProjectManager();

            project.SyncSysTree(OrgInfo.DepCode, OrgInfo.DepName, OrgInfo.DepType, OrgInfo.OrderID, false);

            return(Result);
        }
コード例 #7
0
ファイル: PrjFolderManager.cs プロジェクト: scaperow/-V2.0
        public Boolean DeletePrjFolder(string FolderCode, string FolderId)
        {
            Boolean       Result    = false;
            List <string> SheetList = ProjectCatlogManager.GetModuleTables(FolderCode);

            IDbConnection Connection  = GetConntion();
            Transaction   Transaction = new Transaction(Connection);
            Boolean       flag        = false;

            try
            {
                List <string> sql_Commands = new List <string>();

                //工程结构树
                StringBuilder Sql_Delete = new StringBuilder();
                //增加字段Scts_1,Scdel 之后 删除操作只做伪删除,用于数据同步     2013-10-17
                //Sql_Delete.Append("Delete From sys_engs_Tree Where NodeCode like '");
                //Sql_Delete.Append(FolderCode);
                //Sql_Delete.Append("%'");
                Sql_Delete.Append("Update sys_engs_Tree Set Scts_1=Getdate(),Scdel=1 Where NodeCode like '");
                Sql_Delete.Append(FolderCode);
                Sql_Delete.Append("%'");

                sql_Commands.Add(Sql_Delete.ToString());

                if (FolderId != "")
                {
                    //删除机组
                    Sql_Delete = new StringBuilder();
                    //增加查询条件  Scdel=0  2013-10-17
                    //Sql_Delete.Append("Delete From sys_engs_ItemInfo Where Id = '");
                    //Sql_Delete.Append(FolderId);
                    //Sql_Delete.Append("'");
                    Sql_Delete.Append("update sys_engs_ItemInfo Set Scts_1=Getdate(),Scdel=1 Where Id = '");
                    Sql_Delete.Append(FolderId);
                    Sql_Delete.Append("'");

                    sql_Commands.Add(Sql_Delete.ToString());
                }

                //处理相关模板表的数据
                var deleteSql = string.Format("UPDATE sys_document SET Status = 0 where TestRoomCode = '" + FolderCode + "'");
                sql_Commands.Add(deleteSql);

                if (String.IsNullOrEmpty(FolderCode))
                {
                    return(false);
                }
                object r    = ExcuteCommands(sql_Commands.ToArray(), Transaction);
                int[]  ints = (int[])r;
                for (int i = 0; i < ints.Length; i++)
                {
                    if (i != 0)
                    {
                        Result = Result & (Convert.ToInt32(ints[i]) == 1);
                    }
                    else
                    {
                        Result = (Convert.ToInt32(ints[i]) == 1);
                    }
                }

                if (Result)
                {
                    Transaction.Commit();
                    flag = true;
                }
                else
                {
                    Transaction.Rollback();
                }
            }
            catch
            {
                Transaction.Rollback();
            }
            if (flag)
            {
                try
                {
                    //PXJZDataManager pxjz = new PXJZDataManager();
                    //pxjz.DeleteByTestRoomCode(FolderCode);

                    ProjectManager project = new ProjectManager();
                    project.SyncSysTree(FolderCode, "", "@folder", "", true);
                }
                catch
                {
                }
            }
            return(Result);
        }
コード例 #8
0
ファイル: PrjFolderManager.cs プロジェクト: scaperow/-V2.0
        public Boolean NewPrjFolder(PrjFolder FolderInfo)
        {
            Boolean Result = false;

            IDbConnection Connection  = GetConntion();
            Transaction   Transaction = new Transaction(Connection);
            Boolean       flag        = false;

            try
            {
                //工程结构树
                StringBuilder Sql_Nodes = new StringBuilder();
                //增加查询条件  Scdel=0  2013-10-17
                Sql_Nodes.Append("Select Id,NodeCode,NodeType,RalationID From sys_engs_Tree Where Scdel=0 and RalationID='");
                Sql_Nodes.Append(FolderInfo.Index);
                Sql_Nodes.Append("'");

                StringBuilder Sql_Items = new StringBuilder();
                //增加查询条件  Scdel=0  2013-10-17
                Sql_Items.Append("Select Id,Description,ItemType From  sys_engs_ItemInfo Where Scdel=0 and Id='");
                Sql_Items.Append(FolderInfo.Index);
                Sql_Items.Append("'");

                List <string> sql_Commands = new List <string>();
                sql_Commands.Add(Sql_Nodes.ToString());
                sql_Commands.Add(Sql_Items.ToString());

                DataSet dataset = GetDataSet(sql_Commands.ToArray());
                if (dataset != null)
                {
                    DataTable TableNodes = dataset.Tables["sys_engs_Tree"];
                    DataTable TableItems = dataset.Tables["sys_engs_ItemInfo"];

                    if (TableNodes != null && TableNodes.Rows.Count == 0)
                    {
                        DataRow Row = TableNodes.NewRow();
                        Row["ID"]         = Guid.NewGuid().ToString();
                        Row["NodeCode"]   = FolderInfo.FolderCode;
                        Row["NodeType"]   = "@folder";
                        Row["RalationID"] = FolderInfo.Index;
                        TableNodes.Rows.Add(Row);
                    }

                    if (TableItems != null && TableItems.Rows.Count == 0)
                    {
                        DataRow Row = TableItems.NewRow();
                        Row["ID"]          = FolderInfo.Index;
                        Row["Description"] = FolderInfo.FolderName;
                        Row["ItemType"]    = "@folder";
                        TableItems.Rows.Add(Row);
                    }

                    object r = Update(dataset, Transaction);
                    Result = (Convert.ToInt32(r) == 1);

                    if (Result)
                    {
                        Transaction.Commit();
                        flag = true;
                    }
                    else
                    {
                        Transaction.Rollback();
                    }
                }
            }
            catch
            {
                Transaction.Rollback();
            }
            if (flag)
            {
                try
                {
                    //PXJZDataManager pxjz = new PXJZDataManager();
                    //pxjz.NewByTestRoom(FolderInfo.FolderCode, FolderInfo.Index);

                    FolderInfo.OrderID = FolderInfo.FolderCode;
                    ProjectManager project = new ProjectManager();
                    project.SyncSysTree(FolderInfo.FolderCode, FolderInfo.FolderName, "@folder", FolderInfo.OrderID, false);
                }
                catch
                {
                }
            }
            return(Result);
        }