private void InsertNewOrg(DataTable dtOrg)
        {
            foreach (DataRow row in dtOrg.Rows)
            {
                string strId         = row["Index"].ToString();
                string strName       = row["Name"].ToString();
                string strManager    = row["ManagerName"].ToString();
                string strManagerTel = row["ManagerTel"].ToString();
                string strAddress    = row["Address"].ToString();

                if (OrgBll.IsNameExist(strName))
                {
                    continue;
                }

                GlareSysEfDbAndModels.OrgInfo org = new GlareSysEfDbAndModels.OrgInfo()
                {
                    Address    = strAddress,
                    CreateDt   = DateTime.Now,
                    Id         = 0,
                    IsDel      = 0,
                    ManageName = strManager,
                    ManageTel  = strManagerTel,
                    Name       = strName,
                    UpdateDt   = DateTime.Now
                };
            }
        }
Example #2
0
        private void InsertProject(DataTable dtProject)
        {
            foreach (DataRow row in dtProject.Rows)
            {
                string strId         = row["Index"].ToString();
                string strName       = row["Name"].ToString();
                string strManager    = row["ManagerName"].ToString();
                string strManagerTel = row["ManagerTel"].ToString();
                string strAddress    = row["Address"].ToString();
                string strRefOrg     = row["RefGroupName"].ToString();

                if (GroupBll.IsNameExist(strName))
                {
                    continue;
                }

                GlareSysEfDbAndModels.OrgInfo org = new GlareSysEfDbAndModels.OrgInfo()
                {
                    Address    = strAddress,
                    CreateDt   = DateTime.Now,
                    Id         = 0,
                    IsDel      = 0,
                    ManageName = strManager,
                    ManageTel  = strManagerTel,
                    Name       = strName,
                    UpdateDt   = DateTime.Now
                };
                string strError;
                OrgBll.AddAOrg(ref org, out strError);
            }

            MemCfgInfo.MemDbMgr.Get().Load();
        }