public static bool GetItemInfor(CSIContext SrcContext, ref string Item, ref string Desc, ref string UM, ref string Qty, ref bool LotTracked, ref bool SNTracked)
{
try
{
CSIItems SLItem = new CSIItems(SrcContext);
SLItem.UseAsync(false);
SLItem.AddProperty("Item");
SLItem.AddProperty("Description");
SLItem.AddProperty("UM");
SLItem.AddProperty("LotTracked");
SLItem.AddProperty("SerialTracked");
SLItem.AddProperty("DerQtyOnHand");
SLItem.SetFilter(string.Format("Item = N'{0}'", Item));
SLItem.LoadIDO();
if (SLItem.CurrentTable.Rows.Count <= 0)
{
return(false);
}
Item = SLItem.GetCurrentPropertyValueOfString("Item");
Desc = SLItem.GetCurrentPropertyValueOfString("Description");
UM = SLItem.GetCurrentPropertyValueOfString("UM");
Qty = string.Format("{0:n}", SLItem.GetCurrentPropertyValueOfDecimal("DerQtyOnHand"));
LotTracked = SLItem.GetCurrentPropertyValueOfBoolean("LotTracked");
SNTracked = SLItem.GetCurrentPropertyValueOfBoolean("SerialTracked");
SLItem = null;
return(true);
}catch (Exception Ex)
{
WriteErrorLog(Ex);
return(false);
}
}
public static bool GetNextLotSp(CSIContext SrcContext, string Item, string Prefix, ref string Message, ref string Key, string Site = "")
{
try
{
CSIItems item = new CSIItems(SrcContext);
item.UseAsync(false);
string strParmeters = "";
strParmeters = CSIBaseInvoker.BuildXMLParameters(strParmeters, Item);
strParmeters = CSIBaseInvoker.BuildXMLParameters(strParmeters, Prefix);
strParmeters = CSIBaseInvoker.BuildXMLParameters(strParmeters, Message, true);
strParmeters = CSIBaseInvoker.BuildXMLParameters(strParmeters, Key, true);
bool rtn = item.InvokeMethod("FetchNextLotSp", ref strParmeters);
if (rtn)
{
Message = CSIBaseInvoker.GetXMLParameters(strParmeters, 2);
Key = CSIBaseInvoker.GetXMLParameters(strParmeters, 3);
return(true);
}
else
{
return(false);
}
}
catch (Exception Ex)
{
WriteErrorLog(Ex);
return(false);
}
}
public static bool GetReason(CSIContext SrcContext, ref string ReasonCode, string ReasonClass, ref string ReasonDescription)
{
try
{
CSIReasons SLReason = new CSIReasons(SrcContext);
SLReason.UseAsync(false);
SLReason.AddProperty("ReasonCode");
SLReason.AddProperty("ReasonClass");
SLReason.AddProperty("Description");
SLReason.SetFilter(string.Format("ReasonCode = N'{0}' And ReasonClass = N'{1}'", ReasonCode, ReasonClass));
SLReason.SetOrderBy("ReasonCode");
SLReason.SetRecordCap(1);
SLReason.LoadIDO();
if (SLReason.CurrentTable.Rows.Count <= 0)
{
return(false);
}
ReasonCode = SLReason.GetCurrentPropertyValueOfString("ReasonCode");
ReasonDescription = SLReason.GetCurrentPropertyValueOfString("Description");
SLReason = null;
return(true);
}
catch (Exception Ex)
{
WriteErrorLog(Ex);
return(false);
}
}
public static bool GetPoNumInfor(CSIContext SrcContext, ref string PoNum, ref string Line, ref string Release, ref string Type, ref string Customer
, ref string Item, ref string ItemDesc, ref string UM, ref string QtyOrdered, ref string QtyReceived, ref string QtyToBeReceived, ref bool LotTracked, ref bool SNTracked)
{
try
{
CSIPoItems SLPoItem = new CSIPoItems(SrcContext);
SLPoItem.UseAsync(false);
SLPoItem.AddProperty("PoNum");
SLPoItem.AddProperty("PoLine");
SLPoItem.AddProperty("PoRelease");
SLPoItem.AddProperty("PoType");
SLPoItem.AddProperty("QtyOrdered");
SLPoItem.AddProperty("QtyReceived");
SLPoItem.AddProperty("PoVendNum");
SLPoItem.AddProperty("Item");
SLPoItem.AddProperty("Description");
SLPoItem.AddProperty("UM");
SLPoItem.AddProperty("ItmLotTracked");
SLPoItem.AddProperty("ItmSerialTracked");
SLPoItem.SetFilter(string.Format("PoNum = N'{0}' AND Stat IN (N'O', N'F')", PoNum));
if (!string.IsNullOrEmpty(Line))
{
SLPoItem.SetFilter(string.Format("PoNum = N'{0}' AND PoLine = {1} AND Stat IN (N'O', N'F') ", PoNum, Line));
if (!string.IsNullOrEmpty(Release) | !Release.Equals("0"))
{
SLPoItem.SetFilter(string.Format("PoNum = N'{0}' AND PoLine = {1} AND PoRelease = {2} AND Stat IN (N'O', N'F')", PoNum, Line, Release));
}
}
SLPoItem.SetOrderBy("PoNum,PoLine,PoRelease");
SLPoItem.SetRecordCap(1);
SLPoItem.LoadIDO();
if (SLPoItem.CurrentTable.Rows.Count <= 0)
{
return(false);
}
PoNum = SLPoItem.GetCurrentPropertyValueOfString("PoNum");
Line = SLPoItem.GetCurrentPropertyValueOfString("PoLine");
Release = SLPoItem.GetCurrentPropertyValueOfString("PoRelease");
Customer = SLPoItem.GetCurrentPropertyValueOfString("PoVendNum");
Item = SLPoItem.GetCurrentPropertyValueOfString("Item");
ItemDesc = SLPoItem.GetCurrentPropertyValueOfString("Description");
UM = SLPoItem.GetCurrentPropertyValueOfString("UM");
QtyOrdered = string.Format("{0:n}", SLPoItem.GetCurrentPropertyValueOfDecimal("QtyOrdered"));
QtyReceived = string.Format("{0:n}", SLPoItem.GetCurrentPropertyValueOfDecimal("QtyReceived"));
QtyToBeReceived = string.Format("{0:n}", SLPoItem.GetCurrentPropertyValueOfDecimal("QtyOrdered") - SLPoItem.GetCurrentPropertyValueOfDecimal("QtyReceived"));
LotTracked = SLPoItem.GetCurrentPropertyValueOfBoolean("ItmLotTracked");
SNTracked = SLPoItem.GetCurrentPropertyValueOfBoolean("ItmSerialTracked");
SLPoItem = null;
return(true);
}catch (Exception Ex)
{
WriteErrorLog(Ex);
return(false);
}
}
public static bool GetJobInfor(CSIContext SrcContext, ref string Job, ref string Suffix, ref string Desc, ref string Item, ref string ItemDesc, ref string ItemUM
, ref string QtyReleased, ref string QtyComplete, ref string QtyRequired, ref bool LotTracked, ref bool SNTracked)
{
try
{
CSIJobs SLJob = new CSIJobs(SrcContext);
SLJob.UseAsync(false);
SLJob.AddProperty("Job");
SLJob.AddProperty("Suffix");
SLJob.AddProperty("Description");
SLJob.AddProperty("Item");
SLJob.AddProperty("ItemUM");
SLJob.AddProperty("ItemDescription");
SLJob.AddProperty("QtyReleased");
SLJob.AddProperty("QtyComplete");
SLJob.AddProperty("ItemLotTracked");
SLJob.AddProperty("ItemSerialTracked");
if (string.IsNullOrEmpty(Suffix))
{
Suffix = "0";
}
SLJob.SetFilter(string.Format("Job = N'{0}' And Suffix = {1}", Job, Suffix));
SLJob.LoadIDO();
if (SLJob.CurrentTable.Rows.Count <= 0)
{
return(false);
}
Job = SLJob.GetCurrentPropertyValueOfString("Job");
Suffix = SLJob.GetCurrentPropertyValueOfInteger("Suffix").ToString("0000");
Desc = SLJob.GetCurrentPropertyValueOfString("Description");
Item = SLJob.GetCurrentPropertyValueOfString("Item");
ItemDesc = SLJob.GetCurrentPropertyValueOfString("ItemDescription");
ItemUM = SLJob.GetCurrentPropertyValueOfString("ItemUM");
QtyReleased = string.Format("{0:n}", SLJob.GetCurrentPropertyValueOfString("QtyReleased"));
QtyComplete = string.Format("{0:n}", SLJob.GetCurrentPropertyValueOfString("QtyComplete"));
QtyRequired = string.Format("{0:n}", (SLJob.GetCurrentPropertyValueOfDecimal("QtyReleased") - SLJob.GetCurrentPropertyValueOfDecimal("QtyComplete")).ToString());
LotTracked = SLJob.GetCurrentPropertyValueOfBoolean("ItemLotTracked");
SNTracked = SLJob.GetCurrentPropertyValueOfBoolean("ItemSerialTracked");
SLJob = null;
return(true);
}catch (Exception Ex)
{
WriteErrorLog(Ex);
return(false);
}
}
public override int NextTransNum(CSIContext SrcContext = null)
{
if (SrcContext is null)
{
SrcContext = this.CSISystemContext;
}
int TransNum = base.NextTransNum();
CSIDcjits dcjits = new CSIDcjits(SrcContext);
dcjits.AddProperty("TransNum");
dcjits.SetOrderBy("TransNum Desc");
dcjits.RecordCap = 1;
dcjits.UseAsync(false);
dcjits.LoadIDO();
if (dcjits.CurrentTable.Rows.Count > 0)
{
TransNum = dcjits.GetCurrentPropertyValueOfInteger("TransNum") + 1;
}
return(TransNum);
}
public static bool GetItemLocInfor(CSIContext SrcContext, string Item, string Whse, ref string Loc, ref string LocDescription, ref string Qty)
{
try
{
CSIItemLocs SLItemLoc = new CSIItemLocs(SrcContext);
SLItemLoc.UseAsync(false);
SLItemLoc.AddProperty("Items");
SLItemLoc.AddProperty("Loc");
SLItemLoc.AddProperty("LocDescription");
SLItemLoc.AddProperty("QtyOnHand");
SLItemLoc.AddProperty("Whse");
SLItemLoc.AddProperty("Rank");
if (string.IsNullOrEmpty(Loc))
{
SLItemLoc.SetFilter(string.Format("Item = N'{0}' AND Whse = N'{1}'", Item, Whse));
}
else
{
SLItemLoc.SetFilter(string.Format("Item = N'{0}' AND Whse = N'{1}' And Loc = N'{2}'", Item, Whse, Loc));
}
SLItemLoc.SetOrderBy("Rank");
SLItemLoc.SetRecordCap(1);
SLItemLoc.LoadIDO();
if (SLItemLoc.CurrentTable.Rows.Count <= 0)
{
return(false);
}
Loc = SLItemLoc.GetCurrentPropertyValueOfString("Loc");
LocDescription = SLItemLoc.GetCurrentPropertyValueOfString("LocDescription");
Qty = string.Format("{0:n}", SLItemLoc.GetCurrentPropertyValueOfDecimal("QtyOnHand"));
SLItemLoc = null;
return(true);
}
catch (Exception Ex)
{
WriteErrorLog(Ex);
return(false);
}
}
public static bool GetItemInfor(CSIContext SrcContext, string Job, string Suffix, string OperNum, ref string Item, ref string Desc, ref string UM, ref string ReqQty, ref bool LotTracked, ref bool SNTracked)
{
try
{
CSIJobmatls SLJobmatl = new CSIJobmatls(SrcContext);
SLJobmatl.UseAsync(false);
SLJobmatl.AddProperty("Job");
SLJobmatl.AddProperty("Suffix");
SLJobmatl.AddProperty("OperNum");
SLJobmatl.AddProperty("Sequence");
SLJobmatl.AddProperty("Item");
SLJobmatl.AddProperty("Description");
SLJobmatl.AddProperty("DerQtyConv");
SLJobmatl.AddProperty("UM");
SLJobmatl.AddProperty("DerLoc");
SLJobmatl.AddProperty("DerLot");
SLJobmatl.AddProperty("DerItemLotTracked");
SLJobmatl.AddProperty("DerItemSerialTracked");
SLJobmatl.SetFilter(string.Format("Job = N'{0}' And Suffix = N'{1}' And OperNum = N'{2}' And Item = N'{3}'", Job, Suffix, OperNum, Item));
SLJobmatl.SetOrderBy("Job,Suffix,OperNum,Sequence");
SLJobmatl.LoadIDO();
if (SLJobmatl.CurrentTable.Rows.Count <= 0)
{
return(false);
}
Item = SLJobmatl.GetCurrentPropertyValueOfString("Item");
Desc = SLJobmatl.GetCurrentPropertyValueOfString("Description");
UM = SLJobmatl.GetCurrentPropertyValueOfString("UM");
ReqQty = string.Format("{0:n}", SLJobmatl.GetCurrentPropertyValueOfString("QtyReceived"));
LotTracked = SLJobmatl.GetCurrentPropertyValueOfBoolean("DerItemLotTracked");
SNTracked = SLJobmatl.GetCurrentPropertyValueOfBoolean("DerItemSerialTracked");
SLJobmatl = null;
return(true);
}catch (Exception Ex)
{
WriteErrorLog(Ex);
return(false);
}
}
public static bool GetOperationInfor(CSIContext SrcContext, string Job, string Suffix, ref string OperNum, ref string Wc, ref string QtyReceived)
{
try
{
CSIJobRoutes SLJobRoute = new CSIJobRoutes(SrcContext);
SLJobRoute.UseAsync(false);
SLJobRoute.AddProperty("Job");
SLJobRoute.AddProperty("Suffix");
SLJobRoute.AddProperty("OperNum");
SLJobRoute.AddProperty("Wc");
SLJobRoute.AddProperty("QtyReceived");
if (string.IsNullOrEmpty(OperNum))
{
SLJobRoute.SetFilter(string.Format("Job = N'{0}' And Suffix = N'{1}'", Job, Suffix));
}
else
{
SLJobRoute.SetFilter(string.Format("Job = N'{0}' And Suffix = N'{1}' And OperNum = N'{2}'", Job, Suffix, OperNum));
}
SLJobRoute.SetOrderBy("OperNum Desc");
SLJobRoute.LoadIDO();
if (SLJobRoute.CurrentTable.Rows.Count <= 0)
{
return(false);
}
OperNum = SLJobRoute.GetCurrentPropertyValueOfString("OperNum");
Wc = SLJobRoute.GetCurrentPropertyValueOfString("Wc");
QtyReceived = SLJobRoute.GetCurrentPropertyValueOfString("QtyReceived");
SLJobRoute = null;
return(true);
}catch (Exception Ex)
{
WriteErrorLog(Ex);
return(false);
}
}
public CSILotLocs(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLLotLocs";
}
public CSILocations(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLLocations";
}
public CSIUserLocals(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLUserLocals";
}
public CSIItemLocs(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLItemLocs";
}
public CSIEmployees(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLEmployees";
}
public CSIUserNames(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "UserNames";
}
public ModuleAction(CSIContext SrcContext = null) : base(SrcContext)
{
}
public CSIParms(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLParms";
}
public CSICoItems(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLCoitems";
}
public CSIJobmatls(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLJobmatls";
}
public CSIJobRoutes(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLJobRoutes";
}
public virtual int NextTransNum(CSIContext SrcContext = null)
{
return(1);
}
public CSIDcBase(CSIContext SrcContext = null) : base(SrcContext)
{
}
public CSIDcjits(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLDcjits";
}
public ModuleDeck(CSIContext SrcContext = null) : base(SrcContext)
{
Modules = BuildModulesByLicense();
}
public CSITrnitems(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLTrnitems";
}
public CSIReasons(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLReasons";
}
public static bool GetTransferLineInfor(CSIContext SrcContext, ref string TrnNum, ref string TrnLine, ref string Item, ref string ItemDesc, ref string UM, ref string TrnLoc, ref bool InvUseExistingSerials
, ref string QtyReq, ref string QtyShipped, ref string QtyReceived, ref string QtyRequired, ref bool FromLotTracked, ref bool FromSNTracked, ref bool ToLotTracked, ref bool ToSNTracked, ref bool FobFromSite)
{
string FromSite, ToSite;
try
{
CSITrnitems SLTrnitem = new CSITrnitems(SrcContext);
SLTrnitem.UseAsync(false);
SLTrnitem.AddProperty("TrnNum");
SLTrnitem.AddProperty("TrnLine");
SLTrnitem.AddProperty("TrnLoc");
SLTrnitem.AddProperty("Item");
SLTrnitem.AddProperty("ItDescription");
SLTrnitem.AddProperty("UM");
SLTrnitem.AddProperty("QtyReq");
SLTrnitem.AddProperty("QtyShipped");
SLTrnitem.AddProperty("QtyReceived");
SLTrnitem.AddProperty("ToItLotTracked");
SLTrnitem.AddProperty("ToItSerialTracked");
SLTrnitem.AddProperty("InvUseExistingSerials");
SLTrnitem.AddProperty("TraFromSite");
SLTrnitem.AddProperty("TraToSite");
SLTrnitem.AddProperty("ToFobSite");
if (string.IsNullOrEmpty(TrnLine))
{
TrnLine = "1";
}
SLTrnitem.SetFilter(string.Format("TrnNum = N'{0}' And TrnLine = {1}", TrnNum, TrnLine));
SLTrnitem.LoadIDO();
if (SLTrnitem.CurrentTable.Rows.Count <= 0)
{
return(false);
}
TrnNum = SLTrnitem.GetCurrentPropertyValueOfString("TrnNum");
TrnLine = SLTrnitem.GetCurrentPropertyValueOfString("TrnLine");
TrnLoc = SLTrnitem.GetCurrentPropertyValueOfString("TrnLoc");
Item = SLTrnitem.GetCurrentPropertyValueOfString("Item");
ItemDesc = SLTrnitem.GetCurrentPropertyValueOfString("ItDescription");
UM = SLTrnitem.GetCurrentPropertyValueOfString("UM");
QtyReq = string.Format("{0:n}", SLTrnitem.GetCurrentPropertyValueOfString("QtyReq"));
QtyShipped = string.Format("{0:n}", SLTrnitem.GetCurrentPropertyValueOfString("QtyShipped"));
QtyReceived = string.Format("{0:n}", SLTrnitem.GetCurrentPropertyValueOfString("QtyReceived"));
FromSite = SLTrnitem.GetCurrentPropertyValueOfString("TraFromSite");
ToSite = SLTrnitem.GetCurrentPropertyValueOfString("TraToSite");
if (SrcContext.Site == FromSite)
{
//ship from site
QtyRequired = string.Format("{0:n}", (SLTrnitem.GetCurrentPropertyValueOfDecimal("QtyReq") - SLTrnitem.GetCurrentPropertyValueOfDecimal("QtyShipped")).ToString());
}
if (SrcContext.Site == FromSite)
{
//receive to site
QtyRequired = string.Format("{0:n}", (SLTrnitem.GetCurrentPropertyValueOfDecimal("QtyShipped") - SLTrnitem.GetCurrentPropertyValueOfDecimal("QtyReceived")).ToString());
}
FromLotTracked = SLTrnitem.GetCurrentPropertyValueOfBoolean("FromItLotTracked");
FromSNTracked = SLTrnitem.GetCurrentPropertyValueOfBoolean("FromItSerialTracked");
ToLotTracked = SLTrnitem.GetCurrentPropertyValueOfBoolean("ToItLotTracked");
ToSNTracked = SLTrnitem.GetCurrentPropertyValueOfBoolean("ToItSerialTracked");
InvUseExistingSerials = SLTrnitem.GetCurrentPropertyValueOfBoolean("InvUseExistingSerials");
FobFromSite = SLTrnitem.GetCurrentPropertyValueOfString("TraFromSite") == SLTrnitem.GetCurrentPropertyValueOfString("TraFobSite");
SLTrnitem = null;
return(true);
}catch (Exception Ex)
{
WriteErrorLog(Ex);
return(false);
}
}
protected override void OnCreate(Bundle bundle)
{
try
{
base.OnCreate(bundle);
if (CSISystemContext == null)
{
CSISystemContext = new CSIContext();
}
CSISystemContext.ReadConfigurations();
SetContentView(Resource.Layout.CSIMain);
ModulePage = FindViewById <ViewPager>(Resource.Id.ModulePage);
// Instantiate the deck of flash cards:
Modules = new ModuleDeck(CSISystemContext);
// Instantiate the adapter and pass in the deck of flash cards:
DeckAdapter = new ModuleDeckAdapter(SupportFragmentManager, Modules, this);
// Find the ViewPager and plug in the adapter:
ModulePage.Adapter = DeckAdapter;
ModulePage.PageSelected += (o, e) => { GetModuleDeck(); };
MoudleButton[0] = FindViewById <TextView>(Resource.Id.MoudleButton1);
MoudleButton[1] = FindViewById <TextView>(Resource.Id.MoudleButton2);
MoudleButton[2] = FindViewById <TextView>(Resource.Id.MoudleButton3);
MoudleButton[3] = FindViewById <TextView>(Resource.Id.MoudleButton4);
MoudleButton[0].Visibility = ViewStates.Gone;
MoudleButton[1].Visibility = ViewStates.Gone;
MoudleButton[2].Visibility = ViewStates.Gone;
MoudleButton[3].Visibility = ViewStates.Gone;
int usedPosition = 0;
for (int index = 0; index < Modules.NumModules; index++)
{
if (Modules[index].Visible)
{
MoudleButton[usedPosition].Visibility = ViewStates.Visible;
MoudleButton[usedPosition].Text = Modules[index].ModuleName;
Modules[index].DisplayPosition = usedPosition;
MoudleButton[usedPosition].Tag = usedPosition;
usedPosition++;
}
}
MoudleButton[0].Click += (o, e) => { SetModuleDeck(int.Parse(MoudleButton[0].Tag.ToString())); };
MoudleButton[1].Click += (o, e) => { SetModuleDeck(int.Parse(MoudleButton[1].Tag.ToString())); };
MoudleButton[2].Click += (o, e) => { SetModuleDeck(int.Parse(MoudleButton[2].Tag.ToString())); };
MoudleButton[3].Click += (o, e) => { SetModuleDeck(int.Parse(MoudleButton[3].Tag.ToString())); };
SetModuleDeck(CSISystemContext.CurrentPageIndex);
GetModuleDeck();
//Show SignIn
if (string.IsNullOrEmpty(CSISystemContext.CSIWebServerName))
{
ShowSettingsDialog();
}
else
{
if (string.IsNullOrEmpty(CSISystemContext.Token))
{
ShowSignInDialog();
}
}
//Task startupWork = new Task(() => { ShowSignInDialog(); });
//startupWork.Start();
}
catch (Exception Ex) {
WriteErrorLog(Ex);
}
}
public CSIWhses(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLWhses";
}
public CSISerials(CSIContext SrcContext = null) : base(SrcContext)
{
IDOName = "SLSerials";
}
