public void QueryData(CTable tb)
{
lastQuery = tb;
ArrayList itemsList = submitCommand(tb);
if (itemsList == null)
{
return;
}
itemsSourceGrid = null;
itemsSourceGrid = new ObservableCollection <MBaseModel>();
int idx = 0;
foreach (CTable o in itemsList)
{
MMasterRef v = new MMasterRef(o);
v.RowIndex = idx;
itemsSourceGrid.Add(v);
idx++;
}
lsvMain.ItemsSource = itemsSourceGrid;
//rowCount = CUtil.StringToInt(lastObjectReturned.GetFieldValue("EXT_RECORD_COUNT"));
CUtil.LoadChunkNavigateCombo(cboNavigate, lastObjectReturned, tb.GetFieldValue("EXT_CHUNK_NO"));
}
private void cmdExcel_Click(object sender, RoutedEventArgs e)
{
if (!CHelper.ValidateComboBox(lblReportName, cboReport, false))
{
return;
}
MMasterRef mr = (MMasterRef)cboReport.SelectedItem;
if (mr == null)
{
return;
}
CBaseReport paginator = (CBaseReport)reports[mr.MasterID];
if (paginator == null)
{
return;
}
if (!paginator.IsNewVersion())
{
return;
}
CExcelRenderer excel = paginator.GetExcelRenderer();
WinProgressRenderer w = new WinProgressRenderer(excel);
w.Show();
}
private void cmdAdd_Click(object sender, RoutedEventArgs e)
{
if (!CHelper.VerifyAccessRight("GENERAL_MASTER_ADD"))
{
return;
}
Boolean result = CHelper.ValidateComboBox(lbl, cbo, false);
if (!result)
{
return;
}
MMasterRef v = (MMasterRef)cbo.SelectedItem;
String caption = CLanguage.getValue("add");
CWinLoadParam param = new CWinLoadParam();
param.Caption = caption;
param.GenericType = v.MasterID;
param.Mode = "A";
param.ParentItemSources = (ObservableCollection <MBaseModel>)lsvMain.ItemsSource;
Boolean isOK = FactoryWindow.ShowWindow("WinAddEditMasterRef", param);
if (isOK)
{
refreshMasterRef();
rowCount = rowCount + 1;
//lblTotal.Content = CUtil.FormatInt(rowCount.ToString());
}
}
private void cmdRun_Click(object sender, RoutedEventArgs e)
{
if (!CHelper.ValidateComboBox(lblReportName, cboReport, false))
{
return;
}
MMasterRef mr = (MMasterRef)cboReport.SelectedItem;
if (mr == null)
{
return;
}
WinReportParam w = new WinReportParam(mr);
w.Title = mr.Optional;
w.ShowDialog();
if (w.IsDone)
{
CBaseReport paginator = w.Paginator;
docViewer.Document = paginator.GetFixedDocument();
CUtil.LoadPageNavigateCombo(cboPageNo, paginator.PageCount);
reports[mr.MasterID] = paginator;
}
}
private void cboMappingType_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
MMasterRef m = (MMasterRef)cboMappingType.SelectedItem;
if (m == null)
{
return;
}
if (t.Equals("IP"))
{
if (m.MasterID.Equals("1"))
{
initPriceByQuantityCombo();
}
}
else if (t.Equals("DISCOUNT"))
{
if (m.MasterID.Equals("0"))
{
initDiscountByQuantityCombo();
}
else
{
//1 Amount
initDiscountByAmountCombo();
}
}
}
private void cboReport_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
MMasterRef mr = (MMasterRef)cboReport.SelectedItem;
if (mr == null)
{
docViewer.Document = null;
CUtil.LoadPageNavigateCombo(cboPageNo, 0);
return;
}
CBaseReport paginator = (CBaseReport)reports[mr.MasterID];
if (paginator == null)
{
docViewer.Document = null;
CUtil.LoadPageNavigateCombo(cboPageNo, 0);
return;
}
docViewer.Document = paginator.GetFixedDocument();
CUtil.LoadPageNavigateCombo(cboPageNo, paginator.PageCount);
}
private static void addReport(ReportGroupEnum grp, String key, String className, CTable dat)
{
String prefix = "Onix.ClientCenter.Reports.";
String fqName = prefix + className;
MMasterRef mr = new MMasterRef(new CTable(""));
mr.Code = key;
mr.Description = className;
mr.DescriptionEng = fqName;
mr.Optional = CLanguage.getValue(key);
ArrayList arr = null;
if (!reports.ContainsKey(grp))
{
arr = new ArrayList();
reports.Add(grp, arr);
}
else
{
arr = (ArrayList)reports[grp];
}
extends.Add(key, dat);
arr.Add(mr);
mr.MasterID = arr.Count.ToString();
}
private void LoadData()
{
isInLoadData = true;
this.Title = Caption;
dtFromDate.Focus();
vw.CreateDefaultValue();
CUtil.EnableForm(false, this);
if (Mode.Equals("E"))
{
CTable m = getDocInfoWrapper();
if (m != null)
{
vw.SetDbObject(m);
vw.InitAuxilaryDocItem();
vw.InitPaymentCriteria();
String tmp = vw.EntityAddressID;
vw.InitEntityAddresses();
vw.EntityAddressID = tmp;
tmp = vw.EntityBankAccountID;
vw.InitEntityBankAccounts();
vw.EntityBankAccountID = tmp;
vw.AddressObj = CUtil.MasterIDToObject(vw.EntityAddresses, vw.EntityAddressID);
vw.NotifyAllPropertiesChanged();
}
}
else if (Mode.Equals("A"))
{
vw.DocumentDate = DateTime.Now;
vw.VatPct = CGlobalVariable.GetGlobalVariableValue("VAT_PERCENTAGE");
vw.VatType = CGlobalVariable.GetGlobalVariableValue("DEFAULT_VAT_TYPE_PERCHASE");
vw.NoteWidthCm = "10.00";
vw.NoteHeightCm = "7.00";
vw.NoteTopCm = "12.00";
vw.NoteLeftCm = "1.00";
vw.IsNoteStick = false;
ObservableCollection <MMasterRef> branches = CMasterReference.Instance.Branches;
if (branches.Count > 1)
{
MMasterRef b = branches[1];
cboBranch.SelectedObject = b;
}
vw.IsPoInvoiceRefByItem = true;
}
vw.IsModified = false;
isInLoadData = false;
CUtil.EnableForm(true, this);
}
protected override MBaseModel createObject()
{
MMasterRef mv = new MMasterRef(new CTable(""));
mv.RefType = loadParam.GenericType;
return(mv);
}
private void addItem(ObservableCollection <MMasterRef> coll, String id, String caption)
{
MMasterRef m = new MMasterRef(new CTable(""));
m.MasterID = id;
m.Description = caption;
coll.Add(m);
}
private void cboTheme_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
ComboBox cbo = (ComboBox)sender;
MMasterRef m = (MMasterRef)cbo.SelectedItem;
if (m != null)
{
CThemes.SetTheme(m.Description);
CConfig.SetTheme(m.MasterID);
}
}
public WinAddEditSassProject(String mode)
{
Mode = mode;
ObservableCollection <MMasterRef> projectGroups = CMasterReference.Instance.ProjectGroups;
projectGroupMap = CUtil.ObserableCollectionToHash(projectGroups, "Code");
projectGroup = (MMasterRef)projectGroupMap["SASS"];
InitializeComponent();
}
protected String ObjectToIndex(MBaseModel obj)
{
if (obj == null)
{
return("");
}
MMasterRef mr = (MMasterRef)obj;
return(mr.MasterID);
}
public String GetCurrentText()
{
MMasterRef mr = (MMasterRef)lsvFilter.SelectedItem;
if (mr == null)
{
return("");
}
return(mr.Code);
}
private void updateObject()
{
MPackagePrice v = (MPackagePrice)ProductSelected;
if (v == null)
{
return;
}
v.ServiceObj = null;
v.ItemObj = null;
v.ItemCategoryObj = null;
if (lkupItem.SelectedObject != null)
{
if (lkupItem.Lookup == LookupSearchType2.ServiceLookup)
{
MService svc = (MService)lkupItem.SelectedObject;
v.ServiceObj = svc;
v.SelectionType = "1";
v.Code = svc.ServiceCode;
v.Name = svc.ServiceName;
}
else if (lkupItem.Lookup == LookupSearchType2.InventoryItemLookup)
{
MInventoryItem itm = (MInventoryItem)lkupItem.SelectedObject;
v.ItemObj = itm;
v.SelectionType = "2";
v.Code = itm.ItemCode;
v.Name = itm.ItemNameThai;
}
else if (lkupItem.Lookup == LookupSearchType2.ItemCategoryLookup)
{
MItemCategory cat = (MItemCategory)lkupItem.SelectedObject;
v.ItemCategoryObj = cat;
v.SelectionType = "3";
v.Code = cat.ItemCategoryID;
v.Name = cat.CategoryName;
}
else if (lkupItem.Lookup == LookupSearchType2.ServiceTypeLookup)
{
MMasterRef svt = (MMasterRef)lkupItem.SelectedObject;
v.ServiceTypeObj = svt;
v.SelectionType = "4";
v.Code = svt.Code;
v.Name = svt.Description;
}
}
}
public MVVirtialDirectory() : base(new CTable(""))
{
constructCategories();
departmentDir.Category = "1";
departmentDir.ParentDirectoryID = "";
positionDir.Category = "2";
positionDir.ParentDirectoryID = "";
currentCategory = (MMasterRef)categories[0];
setCurrentProperties();
}
public static CBaseReport GetReportObject(MMasterRef mr)
{
String clssName = (String)mr.DescriptionEng;
CBaseReport rp = (CBaseReport)Activator.CreateInstance(Type.GetType(clssName));
rp.SetReportObject(mr);
CTable o = (CTable)extends[mr.Code];
rp.SetExtraParam(o);
return(rp);
}
private void constructCategories()
{
MMasterRef mr1 = new MMasterRef(new CTable(""));
mr1.MasterID = "1";
mr1.Description = CLanguage.getValue("department");
categories.Add(mr1);
MMasterRef mr2 = new MMasterRef(new CTable(""));
mr2.MasterID = "2";
mr2.Description = CLanguage.getValue("position");
categories.Add(mr2);
}
public static void LoadReportName(ReportGroupEnum grp, ComboBox cbo)
{
List <MMasterRef> items = new List <MMasterRef>();
MMasterRef v = new MMasterRef(new CTable(""));
items.Add(v);
ArrayList arr = CReportFactory.GetReportArray(grp);
foreach (MMasterRef mr in arr)
{
items.Add(mr);
}
cbo.ItemsSource = items;
}
public static void UpdateExtendedParam(MMasterRef mr, CTable prm)
{
CTable o = (CTable)extends[mr.Code];
if (o == null)
{
return;
}
foreach (CField f in o.GetTableFields())
{
String nm = f.getName();
String v = f.getValue();
prm.SetFieldValue(nm, v);
}
}
private static void updateGui(UProductFinalDiscountSelection control, MPackageFinalDiscount v)
{
if (v == null)
{
return;
}
MPackageFinalDiscount o = new MPackageFinalDiscount(v.GetDbObject().Clone());
control.cbxEnable.IsChecked = o.EnabledFlag.Equals("Y");
int selectionType = CUtil.StringToInt(o.SelectionType);
control.cboSelectionType.SelectedIndex = selectionType - 1;
MMasterRef mr = CUtil.MasterIDToObject(CMasterReference.Instance.ProductSpecificSelectionTypes, o.SelectionType);
if (mr != null)
{
//control.cboSelectionType.SelectedItem = mr;
if (mr.MasterID.Equals("1"))
{
control.lkupItem.Lookup = LookupSearchType2.ServiceLookup;
control.lkupItem.SelectedObject = o.ServiceObj;
}
else if (mr.MasterID.Equals("2"))
{
control.lkupItem.Lookup = LookupSearchType2.InventoryItemLookup;
control.lkupItem.SelectedObject = o.ItemObj;
}
else
{
control.lkupItem.Lookup = LookupSearchType2.ServiceLookup;
control.lkupItem.SelectedObject = o.ServiceObj;
}
}
control.txtQuantity.Text = o.Quantity;
v.ExtFlag = "I";
if (v.PackageFinalDiscountID.Equals(""))
{
v.ExtFlag = "A";
}
}
private void populateData(CTable data)
{
String refundStatus = data.GetFieldValue("REFUND_STATUS");
MMasterRef mr = (MMasterRef)refundHash[refundStatus];
String refundDesc = CLanguage.getValue("NotSelected");
if (mr != null)
{
refundDesc = mr.Description;
}
data.SetFieldValue("REFUND_STATUS_DESC", refundDesc);
String paymentType = data.GetFieldValue("PAYMENT_TYPE");
String paymentDesc = ((MMasterRef)paymentTypeHash[paymentType]).Description;
data.SetFieldValue("PAYMENT_TYPE_DESC", paymentDesc);
}
private void cboBank_GotFocus(object sender, RoutedEventArgs e)
{
MCheque mv = (MCheque)vw;
if (loadParam.GenericType.Equals("1"))
{
return;
}
MMasterRef cb = mv.ChequeBankObj;
MMasterRef accBank = mv.BankObj;
MMasterRef bank = new MMasterRef(new CTable(""));
bank.MasterID = cb.MasterID;
bank.Code = cb.Code;
bank.Description = cb.Description;
mv.BankObj = bank;
}
public override Tuple <CTable, ObservableCollection <MBaseModel> > QueryData()
{
(model as MMasterRef).RefType = refType;
items = OnixWebServiceAPI.GetMasterRefList(model.GetDbObject());
lastObjectReturned = OnixWebServiceAPI.GetLastObjectReturned();
itemSources.Clear();
int idx = 0;
foreach (CTable o in items)
{
MMasterRef v = new MMasterRef(o);
v.RowIndex = idx;
itemSources.Add(v);
idx++;
}
Tuple <CTable, ObservableCollection <MBaseModel> > tuple = new Tuple <CTable, ObservableCollection <MBaseModel> >(lastObjectReturned, itemSources);
return(tuple);
}
public static void LoadTheme(ComboBox cbo, Boolean allowEmpty, String id)
{
CTable obj = new CTable("MASTER_REF");
List <MMasterRef> items = new List <MMasterRef>();
int idx = 0;
int selectedIndex = 0;
int themeIndex = CProductFilter.GetThemeIndex();
if (allowEmpty)
{
MMasterRef v = new MMasterRef(null);
v.RowIndex = idx;
items.Add(v);
idx++;
}
for (int i = themeIndex; i <= themeIndex; i++)
{
MMasterRef v = new MMasterRef(new CTable("MASTER_REF"));
v.MasterID = i.ToString();
v.Description = ThemeToString(i);
v.RowIndex = idx;
items.Add(v);
if (v.MasterID.Equals(id))
{
selectedIndex = idx;
}
idx++;
}
cbo.ItemsSource = items;
cbo.SelectedIndex = selectedIndex;
}
private void cboSelectionType_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
UPostGiftBuySelection control = this;
if (control.OnChanged != null)
{
control.OnChanged(control, null);
}
ComboBox cbo = sender as ComboBox;
if (lkupItem != null)
{
lkupItem.Lookup = LookupSearchType2.ServiceLookup;
lkupItem.SelectedObject = null;
}
MMasterRef mr = (MMasterRef)cbo.SelectedItem;
if (mr == null)
{
return;
}
if (mr.MasterID.Equals("1"))
{
lkupItem.Lookup = LookupSearchType2.ServiceLookup;
}
else if (mr.MasterID.Equals("2"))
{
lkupItem.Lookup = LookupSearchType2.InventoryItemLookup;
}
lkupItem.SelectedObject = null;
updateObject();
}
private void cmdPrint_Click(object sender, RoutedEventArgs e)
{
if (!CHelper.ValidateComboBox(lblReportName, cboReport, false))
{
return;
}
MMasterRef mr = (MMasterRef)cboReport.SelectedItem;
if (mr == null)
{
return;
}
CBaseReport paginator = (CBaseReport)reports[mr.MasterID];
if (paginator == null)
{
return;
}
//docViewer.Print();
PrintDialog dialog = new PrintDialog();
dialog.PrintQueue = LocalPrintServer.GetDefaultPrintQueue();
dialog.PrintTicket = dialog.PrintQueue.DefaultPrintTicket;
dialog.PrintTicket.PageOrientation = paginator.GetPageOrientation();
bool?result = dialog.ShowDialog();
if (result == true)
{
FixedDocument fd = paginator.GetFixedDocument();
dialog.PrintDocument(fd.DocumentPaginator, "");
}
}
private void correctItem()
{
Hashtable typehash = new Hashtable();
Hashtable cathash = new Hashtable();
Hashtable uomhash = new Hashtable();
Hashtable typehashPre = CUtil.ObserableCollectionToHash(CMasterReference.Instance.ItemTypes, "Description");
Hashtable uomhashPre = CUtil.ObserableCollectionToHash(CMasterReference.Instance.Uoms, "Description");
int cnt = 0;
foreach (CTable o in inventoryItems)
{
MInventoryItem mi = new MInventoryItem(o);
//en.Note = String.Format("META|{0}|{1}|{2}|{3}|{4}|{5}",
// en.ItemUOMName,
// en.ItemCategoryName,
// en.ItemTypeName,
// en.Temp2,
// en.Temp3,
// en.Temp4
// );
string source = mi.Note;
string[] stringSeparators = new string[] { "|" };
string[] results = source.Split(stringSeparators, StringSplitOptions.None);
if (results.Length < 7)
{
continue;
}
String uomName = results[1];
String catName = results[2];
String typeName = results[3];
#region UOM
if (uomhashPre.ContainsKey(uomName))
{
MMasterRef mr = (MMasterRef)uomhashPre[uomName];
mi.ItemUOM = mr.MasterID;
}
else if (uomhash.ContainsKey(uomName))
{
String uomID = (String)uomhash[uomName];
mi.ItemUOM = uomID;
}
else
{
MMasterRef uom = new MMasterRef(new CTable(""));
uom.RefType = ((int)MasterRefEnum.MASTER_UOM).ToString();
uom.Code = uomName;
uom.Description = uomName;
CTable nuom = OnixWebServiceAPI.SubmitObjectAPI("CreateMasterRef", uom.GetDbObject());
uom.SetDbObject(nuom);
uomhash.Add(uomName, uom.MasterID);
mi.ItemUOM = uom.MasterID;
}
#endregion
#region Type
if (typehashPre.ContainsKey(typeName))
{
MMasterRef mr = (MMasterRef)typehashPre[typeName];
mi.ItemType = mr.MasterID;
}
else if (typehash.ContainsKey(typeName))
{
String typeID = (String)typehash[typeName];
mi.ItemType = typeID;
}
else
{
MMasterRef typ = new MMasterRef(new CTable(""));
typ.RefType = ((int)MasterRefEnum.MASTER_ITEM_TYPE).ToString();
typ.Code = typeName;
typ.Description = typeName;
//CTable ntyp = OnixWebServiceAPI.CreateMasterRef(typ.GetDbObject());
CTable ntyp = OnixWebServiceAPI.SubmitObjectAPI("CreateMasterRef", typ.GetDbObject());
typ.SetDbObject(ntyp);
typehash.Add(typeName, typ.MasterID);
mi.ItemType = typ.MasterID;
}
#endregion
#region Category
mi.ItemCategory = "7";
//if (cathash.ContainsKey(catName))
//{
// String catID = (String)cathash[catName];
// mi.ItemCategory = catID;
//}
//else
//{
// MItemCategory cat = new MItemCategory(new CTable(""));
// cat.CategoryName = catName;
// cat.ParentID = "";
// //CTable ncat = OnixWebServiceAPI.CreateItemCategory(cat.GetDbObject());
// CTable ncat = OnixWebServiceAPI.SubmitObjectAPI("CreateItemCategory", cat.GetDbObject());
// cat.SetDbObject(ncat);
// cathash.Add(catName, cat.ItemCategoryID);
// mi.ItemCategory = cat.ItemCategoryID;
//}
#endregion
OnixWebServiceAPI.SubmitObjectAPI("UpdateInventoryItem", mi.GetDbObject());
cnt++;
importStatusUpdate(cnt, inventoryItems.Count);
}
importStatusUpdate(cnt, inventoryItems.Count);
}
public void SetReportObject(MMasterRef dat)
{
reportObj = dat;
}
private void getFilterTextFromServer(String key, String text)
{
ArrayList arr = null;
CUtil.EnableForm(false, this);
if ((nameSpace == TextSearchNameSpace.ApChequeNS) || (nameSpace == TextSearchNameSpace.ArChequeNS))
{
MMasterRef bank = extraParam as MMasterRef;
MCheque cheque = new MCheque(new CTable(""));
cheque.ChequeNo = key;
cheque.BankID = bank.MasterID;
cheque.ChequeStatus = "1";
//cheque.Direction = "1";
//if (nameSpace == TextSearchNameSpace.ApChequeNS)
//{
// cheque.Direction = "2";
//}
arr = OnixWebServiceAPI.GetChequeList(cheque.GetDbObject());
}
else if (nameSpace == TextSearchNameSpace.MicroServiceCodeNS)
{
MMasterRef mr = new MMasterRef(new CTable(""));
mr.Code = key;
mr.Description = nameSpace.ToString();
arr = OnixWebServiceAPI.GetListAPI("SassGetSearchTextList", "SEARCH_TEXT_LIST", mr.GetDbObject());
}
else
{
MMasterRef mr = new MMasterRef(new CTable(""));
mr.Code = key;
mr.Description = nameSpace.ToString();
mr.RefType = ((int)mrType).ToString();
CTable t = mr.GetDbObject();
arr = OnixWebServiceAPI.GetSearchTextList(t);
}
CUtil.EnableForm(true, this);
if (arr == null)
{
return;
}
ArrayList filters = new ArrayList();
foreach (CTable o in arr)
{
MMasterRef m;
if ((nameSpace == TextSearchNameSpace.ApChequeNS) || (nameSpace == TextSearchNameSpace.ArChequeNS))
{
MCheque c = new MCheque(o);
m = new MMasterRef(new CTable(""));
m.Code = c.ChequeNo;
m.Description = c.PayeeName;
m.DescriptionEng = c.ChequeAmountFmt;
}
else
{
m = new MMasterRef(o);
}
filters.Add(m);
}
dicts.Add(key, filters);
createFilterArray(text, filters);
}
