public void BindLinesToPost()
{
Cursor.Current = Cursors.WaitCursor;
ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service itemSev = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service();
itemSev.Url = WebServiceInstants.GetURL(ServiceType.ItemJournalDailyLossQH);
itemSev.Credentials = nc;
ItemJournalDailyLossQH.ItemJournalDailyLossQH[] itemArray = itemSev.ReadMultiple(BatchName, null, null, 0);
ArrayList values = new ArrayList();
for (int i = 0; i < itemArray.Length; i++)
{
if (!(values.Contains(itemArray[i].Staff_Dimension_Code)))
{
if (itemArray[i].Staff_Dimension_Code != null)
{
values.Add(itemArray[i].Staff_Dimension_Code);
}
}
}
for (int j = 0; j < values.Count; j++)
{
cboDailyLPost.Items.Add(values[j].ToString());
}
Cursor.Current = Cursors.Default;
}
private void BindToPost()
{
ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service sev = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service();
sev.Credentials = nc;
sev.Url = WebServiceInstants.GetURL(ServiceType.ItemJournalDailyLossQH);
ItemJournalDailyLossQH.ItemJournalDailyLossQH[] journal = sev.ReadMultiple("DEFAULT", null, null, 0);
for (int i = 0; i < journal.Length; i++)
{
Object[] array = new Object[5];
array[0] = journal[i].Item_No;
array[1] = journal[i].Location_Code;
array[2] = journal[i].Bin_Code;
array[3] = journal[i].Entry_Type;
array[4] = journal[i].Quantity;
dtpost.Rows.Add(array);
}
}
private void menuItem1_Click(object sender, EventArgs e)
{
if (GrdDailyLoss == null)
{
MessageBox.Show("There is no record to register!");
}
else
{
Cursor.Current = Cursors.WaitCursor;
try
{
decimal countotal = 0;
bool flagtemp = false;
string itemtemp;
string locationtemp;
string bincodetemp;
ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service dlservice = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service();
dlservice.Url = WebServiceInstants.GetURL(ServiceType.ItemJournalDailyLossQH);
dlservice.Credentials = nc;
QHSalesReceivableSetup.QHSalesReceivableSetup_Service qhsalesev = new QHMobile.QHSalesReceivableSetup.QHSalesReceivableSetup_Service();
qhsalesev.Credentials = nc;
qhsalesev.Url = WebServiceInstants.GetURL(ServiceType.QHSalesReceivableSetup);
QHSalesReceivableSetup.QHSalesReceivableSetup[] qhsaleGet = qhsalesev.ReadMultiple(null, null, 0);
for (int i = 0; i < dl_array.Count; i++)
{
ItemJournalDailyLossQH.ItemJournalDailyLossQH dl = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH();
dlservice.Create(qhsaleGet[0].Change_Size_Batch, ref dl); // Actual value should be DOA
dl.Posting_Date = DateTime.Now;
if (dl_array[i].entrytype.Equals("Positive Adjmt."))
{
dl.Entry_Type = ItemJournalDailyLossQH.Entry_Type.Positive_Adjmt;
}
else if (dl_array[i].entrytype.Equals("Negative Adjmt."))
{
dl.Entry_Type = ItemJournalDailyLossQH.Entry_Type.Negative_Adjmt;
}
dl.Entry_TypeSpecified = true;
dl.Item_No = dl_array[i].itemno;
dl.Quantity = Convert.ToInt32(dl_array[i].quantity);
dl.Location_Code = dl_array[i].location;
//dl.Posting_Date = dl_array[i].postdate;
dl.Staff_Dimension_Code = staffdim;
dl.Bin_Code = dl_array[i].bincode;
dlservice.Update(qhsaleGet[0].Change_Size_Batch, ref dl);
}
//// to adjust ////
ArrayList tnk = new ArrayList();
for (int i = 0; i < dl_array.Count; i++)
{
if ((dl_array[i].EmptyTank == true) && (dl_array[i].entrytype.Equals("Negative Adjmt.")))
{
if (i == 0)
{
tnk.Add(dl_array[i].bincode);
}
else
{
if (!tnk.Contains(dl_array[i].bincode))
{
tnk.Add(dl_array[i].bincode);
}
}
}
}
for (int j = 0; j < tnk.Count; j++)
{
countotal = 0;
flagtemp = false;
itemtemp = "";
locationtemp = "";
bincodetemp = "";
for (int k = 0; k < dl_array.Count; k++)
{
if ((dl_array[k].EmptyTank == true) && (dl_array[k].entrytype.Equals("Negative Adjmt.")))
{
if (tnk[j].ToString().Equals(dl_array[k].bincode))
{
itemtemp = dl_array[k].itemno;
countotal = countotal + Convert.ToDecimal(dl_array[k].quantity);
locationtemp = dl_array[k].location;
bincodetemp = dl_array[k].bincode;
if (dl_array[k].EmptyTank == true)
{
flagtemp = true;
}
}
}
}
//QHBinContent.QHBinContent_Service qhsev = new QHMobile.QHBinContent.QHBinContent_Service();
//qhsev.Credentials = nc;
//qhsev.Url = WebServiceInstants.GetURL(ServiceType.QHBinContent);
//List<QHBinContent.QHBinContent_Filter> filterArr = new List<QHMobile.QHBinContent.QHBinContent_Filter>();
//QHBinContent.QHBinContent_Filter binfilter = new QHMobile.QHBinContent.QHBinContent_Filter();
//binfilter.Field = QHMobile.QHBinContent.QHBinContent_Fields.Bin_Code;
//binfilter.Criteria = bincodetemp;
////QHBinContent.QHBinContent_Filter Qtyfilter = new QHMobile.QHBinContent.QHBinContent_Filter();
////Qtyfilter.Field = QHMobile.QHBinContent.QHBinContent_Fields.Quantity_Base;
////Qtyfilter.Criteria = "<>0";
//QHBinContent.QHBinContent_Filter itemFilter = new QHMobile.QHBinContent.QHBinContent_Filter();
//itemFilter.Field = QHMobile.QHBinContent.QHBinContent_Fields.Item_No;
//itemFilter.Criteria = itemtemp;
//filterArr.Add(binfilter);
////filterArr.Add(Qtyfilter);
//filterArr.Add(itemFilter);
//QHBinContent.QHBinContent[] qhbincon = qhsev.ReadMultiple(filterArr.ToArray(), null, 5);
if (flagtemp == true) //qhbincon[0].Quantity_Base < countotal ||
{
// qhfun.TankAdj_NAV(itemtemp, packworksheet, locationtemp, bincodetemp, countotal, flagtemp);
//qhfun.TankAdj_NAV(itemtemp, packworksheet, locationtemp, bincodetemp, countotal);
QHEmptyTank.QHEmptyTank_Service qhempty = new QHMobile.QHEmptyTank.QHEmptyTank_Service();
qhempty.Url = WebServiceInstants.GetURL(ServiceType.QHEmptyTank);
qhempty.Credentials = nc;
QHEmptyTank.QHEmptyTank qhcheck = qhempty.Read(bincodetemp);
if (qhcheck == null)
{
QHEmptyTank.QHEmptyTank qhtnk = new QHMobile.QHEmptyTank.QHEmptyTank();
qhtnk.Bin_Code = bincodetemp;
qhempty.Create(ref qhtnk);
qhtnk.Batch_Name = qhsaleGet[0].Change_Size_Batch;
qhtnk.Item_No = itemtemp;
qhtnk.Location_Code = locationtemp;
qhempty.Update(ref qhtnk);
}
}
//else if (qhbincon[0].Quantity - qhbincon[0].PDA_Inv_Pick_Quantity < countotal)
//{
// QH_Functions.QH_Functions qhfun = new QHMobile.QH_Functions.QH_Functions();
// qhfun.Url = WebServiceInstants.GetURL(ServiceType.QH_Functions);
// qhfun.Credentials = nc;
// decimal updatecount = countotal - (qhbincon[0].Quantity - qhbincon[0].PDA_Inv_Pick_Quantity);
// qhfun.InsertIJLPositiveAdjustment(itemtemp, "", locationtemp, bincodetemp, updatecount);
// //qhfun.TankAdj_NAV(itemtemp, "", locationtemp, bincodetemp, countotal, flagtemp);
//}
}
//// to adjust ////
CompactSQL comsql = new CompactSQL();
comsql.deleteRecord("ChangeSize");
MessageBox.Show("Submitted.");
this.Close();
DailyLossTS dilts = new DailyLossTS(staffname, staffdim, stafflevel);
dilts.Show();
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex);
}
Cursor.Current = Cursors.Default;
//DailyLossTS dts = new DailyLossTS(staffname, staffdim, stafflevel);
}
}
private void menuItem1_Click(object sender, EventArgs e)
{
if (GrdDailyLoss.DataSource == null)
{
MessageBox.Show("There is no record to register!");
}
else
{
Cursor.Current = Cursors.WaitCursor;
try
{
decimal countotal = 0;
bool flagtemp = false;
string itemtemp;
string locationtemp;
string bincodetemp;
ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service dlservice = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service();
dlservice.Url = WebServiceInstants.GetURL(ServiceType.ItemJournalDailyLossQH);
dlservice.Credentials = nc;
for (int i = 0; i < array_daily.Count; i++)
{
if (array_daily[i].lineNum.Equals("") || array_daily[i].lineNum == 0)
{
ItemJournalDailyLossQH.ItemJournalDailyLossQH dl = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH();
dlservice.Create("DOA", ref dl); // Actual value should be DOA
ItemJournalDailyLossQH.ItemJournalDailyLossQH dlupdate = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH();
dlupdate = dlservice.Read("DOA", dl.Line_No);
//added by Hsu 23 april 2013//
array_daily[i].lineNum = dl.Line_No;
// added by Hsu 23 april 2013 //
dlupdate.Posting_Date = Convert.ToDateTime(array_daily[i].postingDate);
dlupdate.Posting_DateSpecified = true;
dlupdate.Entry_Type = ItemJournalDailyLossQH.Entry_Type.Negative_Adjmt;
dlupdate.Entry_TypeSpecified = true;
dlupdate.Item_No = array_daily[i].itemno;
st = DateTime.Now.ToString("ddMMyyyy");
dlupdate.Document_No = st;
//dlservice.Update("DOA", ref dlupdate);
dlupdate.Quantity = Convert.ToInt32(array_daily[i].quantity);
dlupdate.Location_Code = array_daily[i].location;
dlupdate.Staff_Dimension_Code = staffdim;
dlupdate.Bin_Code = array_daily[i].bincode;
dlservice.Update("DOA", ref dlupdate);
//array_daily.RemoveAt(i);
}
CompactSQL comsql = new CompactSQL();
comsql.DeleteOneRecord(array_daily[i].sqlLineNum, "DailyLoss");
}
//// to adjust ////
ArrayList tnk = new ArrayList();
for (int i = 0; i < array_daily.Count; i++)
{
if (i == 0)
{
tnk.Add(array_daily[i].bincode);
}
else
{
if (!tnk.Contains(array_daily[i].bincode))
{
tnk.Add(array_daily[i].bincode);
}
}
}
for (int j = 0; j < tnk.Count; j++)
{
countotal = 0;
flagtemp = false;
itemtemp = "";
locationtemp = "";
bincodetemp = "";
for (int k = 0; k < array_daily.Count; k++)
{
if (tnk[j].ToString().Equals(array_daily[k].bincode))
{
itemtemp = array_daily[k].itemno;
countotal = countotal + Convert.ToDecimal(array_daily[k].quantity);
locationtemp = array_daily[k].location;
bincodetemp = array_daily[k].bincode;
if (array_daily[k].emptyTank == true)
{
flagtemp = true;
}
}
}
if (flagtemp == true) //qhbincon[0].Quantity_Base < countotal ||
{
QHEmptyTank.QHEmptyTank_Service qhempty = new QHMobile.QHEmptyTank.QHEmptyTank_Service();
qhempty.Url = WebServiceInstants.GetURL(ServiceType.QHEmptyTank);
qhempty.Credentials = nc;
QHEmptyTank.QHEmptyTank qhcheck = qhempty.Read(bincodetemp);
if (qhcheck == null)
{
QHEmptyTank.QHEmptyTank qhtnk = new QHMobile.QHEmptyTank.QHEmptyTank();
qhtnk.Bin_Code = bincodetemp;
qhempty.Create(ref qhtnk);
qhtnk.Batch_Name = "DOA";
qhtnk.Item_No = itemtemp;
qhtnk.Location_Code = locationtemp;
qhempty.Update(ref qhtnk);
}
}
}
//// to adjsut ////
//CompactSQL comsql = new CompactSQL();
//comsql.deleteRecord("DailyLoss");
MessageBox.Show("Submitted.");
Cursor.Current = Cursors.Default;
GrdDailyLoss.DataSource = null;
this.Close();
DailyLoss dlf = new DailyLoss(username, staffdim, userlevel);
dlf.Show();
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex);
Cursor.Current = Cursors.Default;
}
}
}
private void btnFind_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
dtPost.Clear();
GrdPost.DataSource = null;
ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service itemSev = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service();
itemSev.Url = WebServiceInstants.GetURL(ServiceType.ItemJournalDailyLossQH);
itemSev.Credentials = nc;
List <ItemJournalDailyLossQH.ItemJournalDailyLossQH_Filter> FilterArray = new List <QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Filter>();
ItemJournalDailyLossQH.ItemJournalDailyLossQH_Filter filterStaff = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Filter();
filterStaff.Field = QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Fields.Staff_Dimension_Code;
filterStaff.Criteria = cboDailyLPost.SelectedItem.ToString();
FilterArray.Add(filterStaff);
itemArray = itemSev.ReadMultiple(BatchName, FilterArray.ToArray(), null, 0);
//DateTime[] dateToCompare = new DateTime[itemArray.Length];
//for (int j = 0; j < itemArray.Length; j++)
//{
// dateToCompare[j] = itemArray[j].Posting_Date;
//}
//Array.Sort(dateToCompare);
//for (int k = 0; k < dateToCompare.Length; k++)
//{
for (int i = 0; i < itemArray.Length; i++)
{
//DateTime compare1 = dateToCompare[k];
//DateTime compare2 = itemArray[i].Posting_Date;
//if (dateToCompare[k].Equals(itemArray[i].Posting_Date))
//{
Object[] array = new Object[9];
array[0] = itemArray[i].Line_No;
array[1] = itemArray[i].Item_No;
array[2] = itemArray[i].Description;
array[3] = itemArray[i].Entry_Type;
array[4] = itemArray[i].Quantity;
array[5] = itemArray[i].Location_Code;
array[6] = itemArray[i].Bin_Code;
array[7] = itemArray[i].Staff_Dimension_Code;
array[8] = itemArray[i].Posting_Date;
dtPost.Rows.Add(array);
// }
}
// }
GrdPost.DataSource = dtPost;
lblcountforpost.Text = dtPost.Rows.Count.ToString();
Cursor.Current = Cursors.Default;
}
private void btnSaveUpdate_Click(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service Sev = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Service();
Sev.Url = WebServiceInstants.GetURL(ServiceType.ItemJournalDailyLossQH);
Sev.Credentials = nc;
ItemJournalDailyLossQH.ItemJournalDailyLossQH update = Sev.Read(BatchName, Convert.ToInt32(txtLine.Text.Trim()));
update.Bin_Code = txtBin.Text.Trim();
update.Quantity = Convert.ToInt32(txtQty.Text.Trim());
update.Staff_Dimension_Code = txtStaffCode.Text.Trim();
Sev.Update(BatchName, ref update);
GrdPost.DataSource = null;
dtPost.Clear();
List <ItemJournalDailyLossQH.ItemJournalDailyLossQH_Filter> FilterArray = new List <QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Filter>();
ItemJournalDailyLossQH.ItemJournalDailyLossQH_Filter filterStaff = new QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Filter();
filterStaff.Field = QHMobile.ItemJournalDailyLossQH.ItemJournalDailyLossQH_Fields.Staff_Dimension_Code;
filterStaff.Criteria = cboDailyLPost.SelectedItem.ToString();
FilterArray.Add(filterStaff);
itemArray = Sev.ReadMultiple(BatchName, FilterArray.ToArray(), null, 0);
for (int i = 0; i < itemArray.Length; i++)
{
Object[] array = new Object[9];
array[0] = itemArray[i].Line_No;
array[1] = itemArray[i].Item_No;
array[2] = itemArray[i].Description;
array[3] = itemArray[i].Entry_Type;
array[4] = itemArray[i].Quantity;
array[5] = itemArray[i].Location_Code;
array[6] = itemArray[i].Bin_Code;
array[7] = itemArray[i].Staff_Dimension_Code;
array[8] = itemArray[i].Posting_Date;
dtPost.Rows.Add(array);
//Object[] array = new Object[9];
}
GrdPost.DataSource = dtPost;
lblcountforpost.Text = dtPost.Rows.Count.ToString();
Cursor.Current = Cursors.Default;
MessageBox.Show("Successfully Updated!");
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex);
}
}