예제 #1
0
    private string GetParentCustNumByCustNum(string code)
    {
        string returnV = "";

        try
        {
            CustomerAdapter adapterCustomer = new CustomerAdapter(this.oTrans);
            adapterCustomer.BOConnect();
            adapterCustomer.GetByCustID(code, false);


            if (adapterCustomer.CustomerData.Customer.Rows.Count == 1)
            {
                DataRow rRow = adapterCustomer.CustomerData.Customer[adapterCustomer.CustomerData.Customer.Rows.Count - 1];
                if (rRow != null)
                {
                    returnV = rRow["CustNum"].ToString();
                }
            }
            adapterCustomer.Dispose();
        }
        catch (Exception ex)
        {
            //ExceptionBox.Show(ex);
            return("");
        }

        return(returnV);
    }
예제 #2
0
    private void CustCnt_AfterFieldChange(object sender, DataColumnChangeEventArgs args)
    {
        // ** Argument Properties and Uses **
        // args.Row["FieldName"]
        // args.Column, args.ProposedValue, args.Row
        // Add Event Handler Code
        EpiDataView edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"]));

        System.Data.DataRow edvCustomerRow = edvCustomer.CurrentDataRow;
        string custID = edvCustomerRow["CustID"].ToString();


        CustomerAdapter custAdapter = new CustomerAdapter(this.oTrans);

        custAdapter.BOConnect();
        custAdapter.GetByCustID(custID, false);
        DataRow row = custAdapter.CustomerData.Customer[0];

        int primB = int.Parse(row["PrimBCon"].ToString());
        int primP = int.Parse(row["PrimPCon"].ToString());
        int primS = int.Parse(row["PrimSCon"].ToString());

        string leadType = "";
        bool   warning  = false;

        switch (args.Column.ColumnName)
        {
        case "PrimaryBilling":
            if (primB != 0 && args.ProposedValue.ToString() == "True")
            {
                warning  = true;
                leadType = "billing";
            }
            break;

        case "PrimaryPurchasing":
            if (primP != 0 && args.ProposedValue.ToString() == "True")
            {
                warning  = true;
                leadType = "purchasing";
            }
            break;

        case "PrimaryShipping":
            if (primS != 0 && args.ProposedValue.ToString() == "True")
            {
                warning  = true;
                leadType = "shipping";
            }
            break;
        }

        if (warning)
        {
            DialogResult dialogResult = EpiMessageBox.Show("There exists another contact for " + leadType + "\nContinue?", "Cancel", MessageBoxButtons.YesNo);
            if ((dialogResult == DialogResult.No))
            {
                oTrans.Undo();
            }
        }
    }