示例#1
0
        public void getUserMsg(string[] strMsg)
        {
            model.users userMd = new model.users();                   //用户资料信息
            userMd.userName  = strMsg[0].ToString();                  //用户名称
            userMd.Id        = Convert.ToInt32(strMsg[1].ToString()); //用户ID
            userMd.personaId = Convert.ToInt32(strMsg[4].ToString()); //角色ID

            us.User = userMd;
        }
        /// <summary>
        /// 删除用户
        /// </summary>
        /// <returns></returns>
        public string del(int id)
        {
            string s = string.Empty;

            try
            {
                model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
                model.users p = (from c in context.users where c.Id == id select c).FirstOrDefault();
                //context.users.DeleteOnSubmit(p);
                context.users.DeleteOnSubmit(p);
                context.SubmitChanges();
                s = "删除成功!";
            }
            catch (Exception ex)
            {
                s = "删除失败!";
            }
            return(s);
        }
        //public List<model.users> getUsers(IDataParameter[] ipara, string procName)
        //{
        //    List<model.users> list = new List<model.users>();
        //    DataTable dt = Select(ipara, procName);
        //    list = DataRowToModel(dt.Rows);
        //    return list;
        //}


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public List <model.users> DataRowToModel(DataRowCollection rowCollection)
        {
            List <model.users> list = new List <model.users>();

            foreach (DataRow row in rowCollection)
            {
                model.users modelMd = new model.users();
                //foreach (var item in modelMd.GetType().GetProperties())
                //{
                //    string name = item.Name;
                //}
                if (row != null)
                {
                    if (row["Id"] != null && row["Id"].ToString() != "")
                    {
                        modelMd.Id = int.Parse(row["Id"].ToString());
                    }
                    if (row["personaId"] != null && row["personaId"].ToString() != "")
                    {
                        modelMd.personaId = int.Parse(row["personaId"].ToString());
                    }
                    if (row["userName"] != null)
                    {
                        modelMd.userName = row["userName"].ToString();
                    }
                    if (row["userPwd"] != null)
                    {
                        modelMd.userPwd = row["userPwd"].ToString();
                    }
                    if (row["userRealName"] != null)
                    {
                        modelMd.userRealName = row["userRealName"].ToString();
                    }
                    if (row["userSex"] != null && row["userSex"].ToString() != "")
                    {
                        modelMd.userSex = int.Parse(row["userSex"].ToString());
                    }
                    if (row["UserPhone"] != null)
                    {
                        modelMd.UserPhone = row["UserPhone"].ToString();
                    }
                    if (row["UserAddress"] != null)
                    {
                        modelMd.UserAddress = row["UserAddress"].ToString();
                    }
                    if (row["UserEmail"] != null)
                    {
                        modelMd.UserEmail = row["UserEmail"].ToString();
                    }
                    if (row["userIndex"] != null && row["userIndex"].ToString() != "")
                    {
                        modelMd.userIndex = int.Parse(row["userIndex"].ToString());
                    }
                    if (row["UserManage"] != null && row["UserManage"].ToString() != "")
                    {
                        modelMd.UserManage = int.Parse(row["UserManage"].ToString());
                    }
                    if (row["UserId"] != null && row["UserId"].ToString() != "")
                    {
                        modelMd.UserId = int.Parse(row["UserId"].ToString());
                    }
                    if (row["Def1"] != null)
                    {
                        modelMd.Def1 = row["Def1"].ToString();
                    }
                    if (row["Def2"] != null)
                    {
                        modelMd.Def2 = row["Def2"].ToString();
                    }
                    if (row["Def3"] != null)
                    {
                        modelMd.Def3 = row["Def3"].ToString();
                    }
                    if (row["Def4"] != null)
                    {
                        modelMd.Def4 = row["Def4"].ToString();
                    }
                    if (row["Def5"] != null)
                    {
                        modelMd.Def5 = row["Def5"].ToString();
                    }
                }

                list.Add(modelMd);
            }

            return(list);
        }