We recently did a Jiwa6 database upgrade to Jiwa 7.0.175. In Jiwa6 for Debtors we had custom field for delivery day where user set a weekday from a drop down list.
- Code: Select all
GridObject.Col = Col
GridObject.Row = Row
GridObject.TypeComboBoxList = "None" & vbtab & "Monday" & vbtab & "Tuesday" & vbtab & "Wednesday" & vbtab & "Thursday" & vbtab & "Friday" & vbtab & "Saturday" & vbtab & "Sunday" & vbtab & "Daily"
End Sub
After migration we created same custom field in Jiwa7 and implemented drop down.
- Code: Select all
#region "CustomFieldPlugin"
public class CustomFieldPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldPlugin
{
public override object InitializeLifetimeService()
{
// returning null here will prevent the lease manager
// from deleting the Object.
return null;
}
public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue)
{
if (CustomField.PluginCustomField.Name.Equals(CustomFieldsFromV6.Debtor_DeliveryDay))
{
FarPoint.Win.Spread.CellType.ComboBoxCellType salesChannelEditor = GridObject.ActiveSheet.Cells[Row, Col].CellType as FarPoint.Win.Spread.CellType.ComboBoxCellType;
salesChannelEditor.EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData;
salesChannelEditor.ItemData = new string[] { "0", "1", "2", "3", "4", "5", "6", "7", "8" };
salesChannelEditor.Items = new string[] { "None", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday", "Daily" };
}
}
Issue we are facing is, since we created new custom field, we have to re-assign custom field values using sql script. Is there better approach to do this that would match custom field data automatically ?
Thanks.