Page 1 of 1

Unlock freight grid grdCartage

PostPosted: Wed Jan 12, 2022 1:57 pm
by DannyC
I'm wanting to allow edits of grdCartage for snaps > 1 on Ship Complete orders.

I just can't find the right code to unlock the cells. This is what I have tried so far.
Code: Select all
public void Setup(JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm JiwaForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin)
{
   if (JiwaForm is JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm)
   {
      JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm soForm = (JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm)JiwaForm;
      soForm.SalesOrder.ReadEnd += Attkey_SOReadEnd;
   }
}

private void Attkey_SOReadEnd(object sender, System.EventArgs e)
{
   JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder salesOrder = (JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder)sender;
   if (salesOrder.BillType == JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.SalesOrderBillTypes.e_SalesOrderShipWhenComplete &&
      salesOrder.CurrentHistoryNo > 1 &&
      salesOrder.SalesOrderStatus != JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.SalesOrderStatuses.e_SalesOrderClosed)
   {
      JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm soForm = (JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm)salesOrder.Client;
      soForm.grdCartage.Enabled = true;         //doesn't work
      soForm.grdCartage.LockRow(-1, false);      //doesn't work
      soForm.grdCartage.ActiveSheet.RowHeader.Cells[0,1].Locked = false;     //doesn't work
      soForm.grdCartage.ActiveSheet.RowHeader.Cells[1,1].Locked = false;
      soForm.grdCartage.ActiveSheet.RowHeader.Cells[2,1].Locked = false;
   }
}

Re: Unlock freight grid grdCartage  Topic is solved

PostPosted: Wed Jan 12, 2022 3:25 pm
by Mike.Sheen
We normally would use LockColumn to lock or unlock cells of a grid - What made you go down the LockRow and RowHeader path?

To unlock the Ex GST column of the first cartage grid row:
Code: Select all
soForm.grdCartage.LockColumn(false, "ExGST", 0);

Re: Unlock freight grid grdCartage

PostPosted: Wed Jan 12, 2022 3:47 pm
by DannyC
What made you go down the LockRow and RowHeader path?

Dunno. Just taking pot shots at anything that might work.

I tried your code but couldn't get it to work.

Then I added in a messagebox just to be sure I was entering the code block. No dice there either.
Then I flippin' realised my plugin wasn't enabled! :oops:

All good now. Maybe some of those attempts I made earlier might've worked if the plugin was actually firing but not going back to find out. It works & that's all I care. Thanks again Mike.