コード例 #1
0
        public int Add(QPS.NEW.Model.Enterprise model)
        {
            int checkUsername = -1;

            enterprise_   = model;
            checkUsername = Convert.ToInt32(
                sqlHelper_.GetSingle("select count(*) from Enterprise where Username=@username",
                                     CommandType.Text,
                                     new System.Data.SqlClient.SqlParameter[] {
                new System.Data.SqlClient.SqlParameter("@username", enterprise_.Username)
            }
                                     )
                );
            if (checkUsername != 0)
            {
                throw new Exception("Error:用户名已经存在");
            }
            else
            {
                string[]       filedName = new string[50];
                string[]       paramName = new string[50];
                SqlParameter[] sqlParams = new SqlParameter[50];
                int            Count     = 0;



                if (model.Username != null)
                {
                    filedName[Count] = "Username";
                    paramName[Count] = "@" + filedName[Count];
                    sqlParams[Count] = new SqlParameter(paramName[Count], model.Username);
                    Count++;
                }
                if (model.Password != null)
                {
                    filedName[Count] = "Password";
                    paramName[Count] = "@" + filedName[Count];
                    string md5Pwd = MD5Helper.Encode(model.Password);
                    sqlParams[Count] = new SqlParameter(paramName[Count], md5Pwd);
                    Count++;
                }
                if (model.Nickname != null)
                {
                    filedName[Count] = "Nickname";
                    paramName[Count] = "@" + filedName[Count];
                    sqlParams[Count] = new SqlParameter(paramName[Count], model.Nickname);
                    Count++;
                }
                if (model.Phone != null)
                {
                    filedName[Count] = "Phone";
                    paramName[Count] = "@" + filedName[Count];
                    sqlParams[Count] = new SqlParameter(paramName[Count], model.Phone);
                    Count++;
                }
                if (model.Address != null)
                {
                    filedName[Count] = "Address";
                    paramName[Count] = "@" + filedName[Count];
                    sqlParams[Count] = new SqlParameter(paramName[Count], model.Address);
                    Count++;
                }
                if (model.Mail != null)
                {
                    filedName[Count] = "Mail";
                    paramName[Count] = "@" + filedName[Count];
                    sqlParams[Count] = new SqlParameter(paramName[Count], model.Mail);
                    Count++;
                }
                if (model.IfChecked != -999)
                {
                    filedName[Count] = "IfChecked";
                    paramName[Count] = "@" + filedName[Count];
                    sqlParams[Count] = new SqlParameter(paramName[Count], model.IfChecked);
                    Count++;
                }


                StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into Enterprise(");
                for (int i = 0; i < Count; i++)
                {
                    strSql.Append(filedName[i]);
                    if (i != Count - 1)
                    {
                        strSql.Append(",");
                    }
                }
                strSql.Append(")values(");
                for (int i = 0; i < Count; i++)
                {
                    strSql.Append(paramName[i]);
                    if (i != Count - 1)
                    {
                        strSql.Append(",");
                    }
                }
                strSql.Append(")");



                int res = -1;
                res = sqlHelper_.ExecuteCommand(
                    strSql.ToString(),
                    CommandType.Text,
                    sqlParams
                    );

                if (res != 1)
                {
                    throw new Exception("Error:写入数据库失败");
                }
            }
            return(1);
        }
コード例 #2
0
        public int Add(QPS.NEW.Model.Users model)
        {
            int checkUsername = -1;
            int res           = -1;

            user_         = model;
            checkUsername = Convert.ToInt32(
                sqlHelper_.GetSingle("select count(*) from TUsers where UserName=@username",
                                     CommandType.Text,
                                     new System.Data.SqlClient.SqlParameter[] {
                new System.Data.SqlClient.SqlParameter("@username", user_.Username)
            }
                                     )
                );
            if (checkUsername != 0)
            {
                return(-1);
            }
            else
            {
                string[]       filedName = new string[50];
                string[]       paramName = new string[50];
                SqlParameter[] sqlParams = new SqlParameter[50];
                int            Count     = 0;

                int userId = Convert.ToInt32(sqlHelper_.GetSingle(
                                                 "select Max(UserID) from TUsers",
                                                 CommandType.Text,
                                                 new SqlParameter[]
                {
                    new SqlParameter("@username", model.Username)
                }
                                                 )) + 1;

                filedName[Count] = "UserID";
                paramName[Count] = "@" + filedName[Count];
                sqlParams[Count] = new SqlParameter(paramName[Count], userId);
                Count++;

                if (model.Username != null)
                {
                    filedName[Count] = "UserName";
                    paramName[Count] = "@" + filedName[Count];

                    sqlParams[Count] = new SqlParameter(paramName[Count], model.Username);
                    Count++;
                }
                if (model.Password != null)
                {
                    filedName[Count] = "Pass";
                    paramName[Count] = "@" + filedName[Count];
                    string md5Pwd = MD5Helper.Encode(model.Password);
                    sqlParams[Count] = new SqlParameter(paramName[Count], md5Pwd);
                    Count++;
                }
                if (model.Nickname != null)
                {
                    filedName[Count] = "NickName";
                    paramName[Count] = "@" + filedName[Count];
                    sqlParams[Count] = new SqlParameter(paramName[Count], model.Nickname);
                    Count++;
                }

                StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into TUsers(");
                for (int i = 0; i < Count; i++)
                {
                    strSql.Append(filedName[i]);
                    if (i != Count - 1)
                    {
                        strSql.Append(",");
                    }
                }
                strSql.Append(")values(");
                for (int i = 0; i < Count; i++)
                {
                    strSql.Append(paramName[i]);
                    if (i != Count - 1)
                    {
                        strSql.Append(",");
                    }
                }
                strSql.Append(")");

                res = sqlHelper_.ExecuteCommand(
                    strSql.ToString(),
                    CommandType.Text,
                    sqlParams
                    );

                if (res != 1)
                {
                    return(-2);
                }
                else
                {
                    // 初始化数组
                    for (int i = 0; i < 50; i++)
                    {
                        filedName[i] = null;
                        paramName[i] = null;
                        sqlParams[i] = null;
                    }
                    Count = 0;

                    filedName[Count] = "UserID";
                    paramName[Count] = "@" + filedName[Count];
                    sqlParams[Count] = new SqlParameter(paramName[Count], userId);
                    Count++;

                    if (model.Phone != null)
                    {
                        filedName[Count] = "PhoneNum";
                        paramName[Count] = "@" + filedName[Count];
                        sqlParams[Count] = new SqlParameter(paramName[Count], model.Phone);
                        Count++;
                    }

                    if (model.Usertype != -999)
                    {
                        filedName[Count] = "UserType";
                        paramName[Count] = "@" + filedName[Count];
                        sqlParams[Count] = new SqlParameter(paramName[Count], model.Usertype);
                        Count++;
                    }

                    strSql = new StringBuilder();
                    strSql.Append("insert into TUserInfo(");
                    for (int i = 0; i < Count; i++)
                    {
                        strSql.Append(filedName[i]);
                        if (i != Count - 1)
                        {
                            strSql.Append(",");
                        }
                    }
                    strSql.Append(")values(");
                    for (int i = 0; i < Count; i++)
                    {
                        strSql.Append(paramName[i]);
                        if (i != Count - 1)
                        {
                            strSql.Append(",");
                        }
                    }
                    strSql.Append(")");



                    res = -1;
                    res = sqlHelper_.ExecuteCommand(
                        strSql.ToString(),
                        CommandType.Text,
                        sqlParams
                        );

                    if (res != 1)
                    {
                        return(-2);
                    }

                    if (model.Mail != null)
                    {
                        res = -1;

                        res = sqlHelper_.ExecuteCommand(
                            "insert into Web_Users(UserID,Email,Phone,Address)values(@userid,@email,@phone,@address)",
                            CommandType.Text,
                            new SqlParameter[]
                        {
                            new SqlParameter("@userid", userId),
                            new SqlParameter("@email", model.Mail),
                            new SqlParameter("@phone", model.Phone),
                            new SqlParameter("@address", model.Address)
                        }
                            );
                        if (res != 1)
                        {
                            return(-2);
                        }
                    }
                }
            }
            return(1);
        }