コード例 #1
0
    protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
    {
        if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
        {
            String value = null;
            switch (e.CommandName)
            {
            case ("alpha"):
            {
                value = string.Format("{0}%", e.CommandArgument);
                break;
            }

            case ("NoFilter"):
            {
                value = "%";
                break;
            }
            }
            ObjectDataSource1.SelectParameters["LastName"].DefaultValue = value;
            ObjectDataSource1.DataBind();
            RadGrid1.Rebind();
        }
        else if (e.CommandName == "QuickUpdate")
        {
            string UserName, Role;
            var    oUser = new User();

            foreach (GridDataItem item in RadGrid1.Items)
            {
                UserName = item.GetDataKeyValue("UserName").ToString();
                Role     = ((RadComboBox)item.FindControl("ddlRole")).SelectedValue;

                oUser.ChangeRole(UserName, Role);
            }
        }
        else if (e.CommandName == "DeleteSelected")
        {
            var oAddressBook1 = new AddressBook1();
            var oUser         = new User();

            string errorList = "", UserName = "";

            foreach (GridDataItem item in RadGrid1.SelectedItems)
            {
                try
                {
                    var AddressBookID = item.GetDataKeyValue("AddressBookID").ToString();
                    UserName = item["UserName"].Text;
                    oAddressBook1.AddressBook1Delete(AddressBookID);
                    oUser.UserDelete(UserName);
                }
                catch (Exception ex)
                {
                    lblError.Text = ex.Message;
                    if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
                    {
                        errorList += ", " + UserName;
                    }
                }
            }
            if (!string.IsNullOrEmpty(errorList))
            {
                e.Canceled = true;
                string strAlertMessage = "Tài khoản <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang có đơn hàng .<br /> Xin xóa đơn hàng hoặc sử dụng chức năng khoá tài khoản.";
                lblError.Text = strAlertMessage;
            }
            RadGrid1.Rebind();
        }
        else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
        {
            try
            {
                var command = e.CommandName;
                var row     = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;

                var DistrictID = ((RadComboBox)row.FindControl("ddlDistrict")).SelectedValue;
                var ProvinceID = ((RadComboBox)row.FindControl("ddlProvince")).SelectedValue;
                var RoleName   = ((RadComboBox)row.FindControl("ddlRole")).SelectedValue;
                var UserName   = ((RadTextBox)row.FindControl("txtUserName")).Text;
                var IsPrimary  = "True";
                var CountryID  = "1";

                var oUser = new User();


                if (e.CommandName == "PerformInsert")
                {
                    var insertParams = ObjectDataSource1.InsertParameters;

                    insertParams["CountryID"].DefaultValue  = CountryID;
                    insertParams["ProvinceID"].DefaultValue = ProvinceID;
                    insertParams["DistrictID"].DefaultValue = DistrictID;
                    insertParams["RoleName"].DefaultValue   = RoleName;
                    insertParams["IsPrimary"].DefaultValue  = IsPrimary;
                    oUser.ChangeRole(UserName, RoleName);
                }
                else
                {
                    var updateParams = ObjectDataSource1.UpdateParameters;

                    updateParams["CountryID"].DefaultValue  = CountryID;
                    updateParams["ProvinceID"].DefaultValue = ProvinceID;
                    updateParams["DistrictID"].DefaultValue = DistrictID;
                    updateParams["RoleName"].DefaultValue   = RoleName;
                    updateParams["IsPrimary"].DefaultValue  = IsPrimary;
                    oUser.ChangeRole(UserName, RoleName);
                }
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message;
            }
        }
    }