MVC（增加）

Models：

  public static string AddList(string Username,int RoleID, string EMail, string Tel, string Phone, DateTime Creater, int  IsApproved)   //存储过程
        {
            string ret = "";
            StringBuilder strsql1 = new StringBuilder();
            strsql1.Append(" declare @fEntryID int ");
            strsql1.Append(" set @Username=isnull(@Username,'') ");
            strsql1.Append(" set @RoleID=isnull(@RoleID,0) ");
            strsql1.Append(" set @EMail=isnull(@EMail,'') ");
            strsql1.Append(" set @Tel=isnull(@Tel,'') ");
            strsql1.Append(" set @Phone=isnull(@Phone,'') ");
            strsql1.Append(" set @Creater=isnull(@Creater,'') ");
            strsql1.Append(" set @IsApproved=isnull(@IsApproved,1) ");
            strsql1.Append(" declare @UserID int ");
            strsql1.Append(" select @UserID=max(UserID) from [Lab_Users]");
            strsql1.Append(" set @UserID=isnull(@UserID,0) ");
            strsql1.Append(" if  @UserID=0 ");
            strsql1.Append("begin ");
            strsql1.Append(" set @UserID=1 ");
            strsql1.Append(" end ");
            strsql1.Append(" else begin ");
            strsql1.Append(" set @UserID=@UserID+1 ");
            strsql1.Append(" end ");

            strsql1.Append(" insert into dbo.Lab_Users(UserID,Username,RoleID,EMail,Tel,Phone,Creater,IsApproved) ") ;
            strsql1.Append("values(@UserID,@Username,@RoleID,@EMail,@Tel,@Phone,@Creater,@IsApproved ) ");
            strsql1.Append(" set @fEntryID=@@identity ");
            strsql1.Append(" if @@ERROR=0 ");
            strsql1.Append(" select '成功'+cast(@fEntryID as varchar) as mc ");
            SqlParameter[] parameters ={
                                     
                                        new SqlParameter("@Username",SqlDbType.NVarChar,50),
                                        new SqlParameter("@RoleID",SqlDbType.Int,4),
                                        new SqlParameter("@EMail",SqlDbType.NVarChar,50),
                                        new SqlParameter("@Tel",SqlDbType.NVarChar,50),
                                        new SqlParameter("@Phone",SqlDbType.NVarChar,50),
                                        new SqlParameter("@Creater",SqlDbType.DateTime),
                                        new SqlParameter("@IsApproved",SqlDbType.Int),
                                         };
            parameters[0].Value =Username;
            parameters[1].Value = RoleID;
            parameters[2].Value = EMail;
            parameters[3].Value = Tel;
            parameters[4].Value = Phone;
            parameters[5].Value = Creater;
            parameters[6].Value =IsApproved;
            DataTable dt = DBHelperSQLLab.ExecuteDataTable(strsql1.ToString(), parameters);
            if (dt.Rows.Count > 0)
            {
                ret = StrUtils.GetString(dt.Rows[0]["mc"]);
            }
            return ret;
        }

Controller：

 public HttpResponseMessage AddUsers([FromBody]SubLabUsers tc)//增加
        {
            string ret = SubLabUsers.AddList(tc.Username,tc.RoleID,tc.EMail,tc.Tel,tc.Phone,tc.Creater,tc.IsApproved);
            return new HttpResponseMessage(HttpStatusCode.OK)
            {
                Content = new StringContent(ret, System.Text.Encoding.UTF8, "text/plain")
            };
        }

界面：

private void bt_Add_Click(object sender, EventArgs e)
        {
            string s="成功";
            string username = tb_Username.Text;
            string Rolename = cb_Role.Text;
            if(Rolename=="管理员")
                 RoleID=1;
            if(Rolename=="普通用户")
                 RoleID=2;
            string Email = tb_Email.Text;
            string Tel = tb_Tel.Text;
            string Phone = tb_Phone.Text;
            string state=cb_state.Text;
            if(state=="有效")
               IsAproved=1;
            if(state=="无效")
                IsAproved=0;
            DateTime t=System.DateTime.Now.Date;
            string strurl = ConfigurationSettings.AppSettings["AddUsers"];
            var content = new FormUrlEncodedContent(new Dictionary<string ,string>()
             {
                                    {"Username",username},
                                    {"RoleID",RoleID.ToString()},
                                    {"EMail",Email},
                                    {"Tel",Tel},
                                    {"Phone",Phone},
                                    {"Creater",t.ToString()},
                                    {"IsApproved",IsAproved.ToString()},
              });
            string ret = AppConfig.PostApp(strurl, content);
                            if (ret.IndexOf("成功") == -1)
                            {
                                s += ret;
                            }
            MessageBox.Show(s);
        }