예제 #1
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(MobileSoft.Model.System.Tb_System_Corp model)
 {
     dal.Add(model);
 }
예제 #2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(MobileSoft.Model.System.Tb_System_Corp model)
 {
     dal.Update(model);
 }
예제 #3
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <MobileSoft.Model.System.Tb_System_Corp> DataTableToList(DataTable dt)
        {
            List <MobileSoft.Model.System.Tb_System_Corp> modelList = new List <MobileSoft.Model.System.Tb_System_Corp>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                MobileSoft.Model.System.Tb_System_Corp model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new MobileSoft.Model.System.Tb_System_Corp();
                    //model.CorpSID=dt.Rows[n]["CorpSID"].ToString();
                    if (dt.Rows[n]["CorpID"].ToString() != "")
                    {
                        model.CorpID = int.Parse(dt.Rows[n]["CorpID"].ToString());
                    }
                    if (dt.Rows[n]["RegType"].ToString() != "")
                    {
                        model.RegType = int.Parse(dt.Rows[n]["RegType"].ToString());
                    }
                    if (dt.Rows[n]["RegMode"].ToString() != "")
                    {
                        model.RegMode = int.Parse(dt.Rows[n]["RegMode"].ToString());
                    }
                    model.CorpName       = dt.Rows[n]["CorpName"].ToString();
                    model.CorpShortName  = dt.Rows[n]["CorpShortName"].ToString();
                    model.CorpTypeName   = dt.Rows[n]["CorpTypeName"].ToString();
                    model.Province       = dt.Rows[n]["Province"].ToString();
                    model.City           = dt.Rows[n]["City"].ToString();
                    model.Borough        = dt.Rows[n]["Borough"].ToString();
                    model.Street         = dt.Rows[n]["Street"].ToString();
                    model.CommName       = dt.Rows[n]["CommName"].ToString();
                    model.LoginCode      = dt.Rows[n]["LoginCode"].ToString();
                    model.LoginPassWD    = dt.Rows[n]["LoginPassWD"].ToString();
                    model.PwdQuestion    = dt.Rows[n]["PwdQuestion"].ToString();
                    model.PwdAnswer      = dt.Rows[n]["PwdAnswer"].ToString();
                    model.CorpAddress    = dt.Rows[n]["CorpAddress"].ToString();
                    model.CorpPost       = dt.Rows[n]["CorpPost"].ToString();
                    model.CorpDeputy     = dt.Rows[n]["CorpDeputy"].ToString();
                    model.CorpLinkMan    = dt.Rows[n]["CorpLinkMan"].ToString();
                    model.CorpMobileTel  = dt.Rows[n]["CorpMobileTel"].ToString();
                    model.CorpWorkedTel  = dt.Rows[n]["CorpWorkedTel"].ToString();
                    model.CorpFax        = dt.Rows[n]["CorpFax"].ToString();
                    model.CorpEmail      = dt.Rows[n]["CorpEmail"].ToString();
                    model.CorpWeb        = dt.Rows[n]["CorpWeb"].ToString();
                    model.AdminUserName  = dt.Rows[n]["AdminUserName"].ToString();
                    model.AdminSex       = dt.Rows[n]["AdminSex"].ToString();
                    model.AdminUserTel   = dt.Rows[n]["AdminUserTel"].ToString();
                    model.AdminUserEmail = dt.Rows[n]["AdminUserEmail"].ToString();
                    model.DBServer       = dt.Rows[n]["DBServer"].ToString();
                    model.DBName         = dt.Rows[n]["DBName"].ToString();
                    model.DBUser         = dt.Rows[n]["DBUser"].ToString();
                    model.DBPwd          = dt.Rows[n]["DBPwd"].ToString();
                    if (dt.Rows[n]["RegDate"].ToString() != "")
                    {
                        model.RegDate = DateTime.Parse(dt.Rows[n]["RegDate"].ToString());
                    }
                    if (dt.Rows[n]["BranchNum"].ToString() != "")
                    {
                        model.BranchNum = int.Parse(dt.Rows[n]["BranchNum"].ToString());
                    }
                    if (dt.Rows[n]["CommNum"].ToString() != "")
                    {
                        model.CommNum = int.Parse(dt.Rows[n]["CommNum"].ToString());
                    }
                    if (dt.Rows[n]["IsDelete"].ToString() != "")
                    {
                        model.IsDelete = int.Parse(dt.Rows[n]["IsDelete"].ToString());
                    }
                    model.ImgLogo1   = dt.Rows[n]["ImgLogo1"].ToString();
                    model.ImgLogo2   = dt.Rows[n]["ImgLogo2"].ToString();
                    model.SysDir     = dt.Rows[n]["SysDir"].ToString();
                    model.SysVersion = dt.Rows[n]["SysVersion"].ToString();
                    model.QQ         = dt.Rows[n]["QQ"].ToString();
                    model.StoreImage = dt.Rows[n]["StoreImage"].ToString();
                    if (dt.Rows[n]["VSPID"].ToString() != "")
                    {
                        model.VSPID = int.Parse(dt.Rows[n]["VSPID"].ToString());
                    }
                    if (dt.Rows[n]["CorpSynchCode"].ToString() != "")
                    {
                        model.CorpSynchCode = new Guid(dt.Rows[n]["CorpSynchCode"].ToString());
                    }
                    if (dt.Rows[n]["SynchFlag"].ToString() != "")
                    {
                        model.SynchFlag = int.Parse(dt.Rows[n]["SynchFlag"].ToString());
                    }
                    model.LogoImgUrl = dt.Rows[n]["LogoImgUrl"].ToString();
                    if (dt.Rows[n]["CorpSort"].ToString() != "")
                    {
                        model.CorpSort = int.Parse(dt.Rows[n]["CorpSort"].ToString());
                    }
                    if (dt.Rows[n]["IsRecommend"].ToString() != "")
                    {
                        model.IsRecommend = int.Parse(dt.Rows[n]["IsRecommend"].ToString());
                    }
                    model.RecommendIndex = dt.Rows[n]["RecommendIndex"].ToString();
                    if (dt.Rows[n]["ActualCommSnum"].ToString() != "")
                    {
                        model.ActualCommSnum = int.Parse(dt.Rows[n]["ActualCommSnum"].ToString());
                    }
                    model.ContractMemo = dt.Rows[n]["ContractMemo"].ToString();
                    if (dt.Rows[n]["MobileSnum"].ToString() != "")
                    {
                        model.MobileSnum = int.Parse(dt.Rows[n]["MobileSnum"].ToString());
                    }
                    if (dt.Rows[n]["ActualMobileSnum"].ToString() != "")
                    {
                        model.ActualMobileSnum = int.Parse(dt.Rows[n]["ActualMobileSnum"].ToString());
                    }
                    model.CallVersion = dt.Rows[n]["CallVersion"].ToString();
                    if (dt.Rows[n]["IsValidCode"].ToString() != "")
                    {
                        model.IsValidCode = int.Parse(dt.Rows[n]["IsValidCode"].ToString());
                    }
                    if (dt.Rows[n]["IsFees"].ToString() != "")
                    {
                        model.IsFees = int.Parse(dt.Rows[n]["IsFees"].ToString());
                    }
                    if (dt.Rows[n]["ContractBeginDate"].ToString() != "")
                    {
                        model.ContractBeginDate = DateTime.Parse(dt.Rows[n]["ContractBeginDate"].ToString());
                    }
                    if (dt.Rows[n]["ContractEndDate"].ToString() != "")
                    {
                        model.ContractEndDate = DateTime.Parse(dt.Rows[n]["ContractEndDate"].ToString());
                    }
                    if (dt.Rows[n]["UseBeginDate"].ToString() != "")
                    {
                        model.UseBeginDate = DateTime.Parse(dt.Rows[n]["UseBeginDate"].ToString());
                    }
                    if (dt.Rows[n]["UseEndDate"].ToString() != "")
                    {
                        model.UseEndDate = DateTime.Parse(dt.Rows[n]["UseEndDate"].ToString());
                    }
                    if (dt.Rows[n]["AllowanceDate"].ToString() != "")
                    {
                        model.AllowanceDate = DateTime.Parse(dt.Rows[n]["AllowanceDate"].ToString());
                    }
                    model.YiZhiFuNum     = dt.Rows[n]["YiZhiFuNum"].ToString();
                    model.YiZhiFuKey     = dt.Rows[n]["YiZhiFuKey"].ToString();
                    model.YiJiFuHuoBanId = dt.Rows[n]["YiJiFuHuoBanId"].ToString();
                    model.YiJiFuNum      = dt.Rows[n]["YiJiFuNum"].ToString();
                    model.YiJiFuKey      = dt.Rows[n]["YiJiFuKey"].ToString();
                    modelList.Add(model);
                }
            }
            return(modelList);
        }