private void GetUD01Data(string key1, string key2, string key3, string key4, string key5)
{
if ((this._Key1UD01 != key1) || (this._Key2UD01 != key2) || (this._Key3UD01 != key3) || (this._Key4UD01 != key4) || (this._Key5UD01 != key5))
{
// Build where clause for search.
string whereClause = "Key1 = \'" + key1 + "\' And Key2 = \'" + key2 + "\' And Key3 = \'" + key3 + "\' And Key4 = \'" + key4 + "\'";
System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);
whereClauses.Add("UD01", whereClause);
// Call the adapter search.
SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);
this._ud01Adapter.InvokeSearch(searchOptions);
if ((this._ud01Adapter.UD01Data.UD01.Rows.Count > 0))
{
this._edvUD01.Row = 0;
}
else
{
this._edvUD01.Row = -1;
}
// Notify that data was updated.
this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));
// Set key fields to their new values.
this._Key1UD01 = key1;
this._Key2UD01 = key2;
this._Key3UD01 = key3;
this._Key4UD01 = key4;
this._Key5UD01 = key5;
}
}
private void GetCustXPrtData(string part)
{
if (this._part != part)
{
// Build where clause for search.
string whereClause = "PartNum = '" + part + "'";
System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);
whereClauses.Add("CustXPrt", whereClause);
// Call the adapter search.
SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);
this.cxad.InvokeSearch(searchOptions);
if ((this.cxad.CustomerPartXRefData.CustXPrt.Rows.Count > 0))
{
this._edvCustXPrt.Row = 0;
}
else
{
this._edvCustXPrt.Row = -1;
}
// Notify that data was updated.
this._edvCustXPrt.Notify(new EpiNotifyArgs(this.oTrans, this._edvCustXPrt.Row, this._edvCustXPrt.Column));
// Set key fields to their new values.
this._part = part;
}
}
private void btnNextID_Click(object sender, System.EventArgs args)
{
// ** Place Event Handling Code Here **
this.custAdapter = new CustomerAdapter(this.oTrans);
this.custAdapter.BOConnect();
this.custDataView = (EpiDataView)(this.oTrans.EpiDataViews["Customer"]);
DataRow currentCustomer = this.custDataView.CurrentDataRow;
// Add Prefix
string custID = formatNewID(currentCustomer["Name"].ToString());
// Set Suffix
int custSuffix = 1; // 001
// Iterate until suffix exists with prefix
do
{
string whereClause = "CustID = \'" + custID + custSuffix.ToString("D3") + "\'";
System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);
whereClauses.Add("Customer", whereClause);
SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);
this.custAdapter.InvokeSearch(searchOptions);
if ((this.custAdapter.CustomerData.Customer.Rows.Count > 0))
{
custSuffix++;
}
} while(this.custAdapter.CustomerData.Customer.Rows.Count > 0);
// Set new custID
string newCustID = custID + custSuffix.ToString("D3");
//MessageBox.Show("New CustID: " + newCustID);
et_newCustID = ((EpiTextBox)csm.GetNativeControlReference("eb06f6cc-8342-4610-8c12-bdfb93e78f8d"));
et_newCustID.Text = newCustID;
}
private void btnCopyVehicles_Click(object sender, System.EventArgs args)
{
txtCopyPart = ((EpiTextBox)csm.GetNativeControlReference("d74c3905-a49e-42f4-a48d-e2a6a8b79379"));
txtCopyRev = ((EpiTextBox)csm.GetNativeControlReference("31cbeabb-4107-4626-ae5d-66897b75a8d8"));
EpiDataView epiViewPartRev = ((EpiDataView)(this.oTrans.EpiDataViews["PartRev"]));
DataRow dataRowPartRev = epiViewPartRev.CurrentDataRow;
string partNum;
string revisionNum;
if ((dataRowPartRev != null))
{
partNum = dataRowPartRev["PartNum"].ToString();
revisionNum = dataRowPartRev["RevisionNum"].ToString();
if (txtCopyPart.Text == partNum && txtCopyRev.Text == revisionNum)
{
MessageBox.Show("Cannot copy from same Part Revision");
}
else if (txtCopyPart.Text == "" || txtCopyRev.Text == "")
{
MessageBox.Show("Choose a Part Revision");
}
else
{
DialogResult dialogResult = EpiMessageBox.Show("Are you sure you want to copy vehicles?", "Cancel", MessageBoxButtons.YesNo);
if ((dialogResult == DialogResult.Yes))
{
try {
// Set UD100Adapter
UD100Adapter ud100Adapter = new UD100Adapter(PartForm);
ud100Adapter.BOConnect();
Hashtable whereClauses = new Hashtable(1);
string whereClause = "ChildKey1 <> '' AND ChildKey2 <> ''";
whereClauses.Add("UD100A", whereClause);
SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);
ud100Adapter.InvokeSearch(searchOptions);
// Delete all current PartRev's vehicles
DataRow[] deleteRows = ud100Adapter.UD100Data.UD100A.Select("ChildKey1 = \'" + partNum + "\' and ChildKey2 = \'" + revisionNum + "\'");
for (int i = 0; (i < deleteRows.Length); i++)
{
ud100Adapter.Delete(deleteRows[i]);
}
// Copy all selected PartRev's vehicles
DataRow[] copyRows = ud100Adapter.UD100Data.UD100A.Select("ChildKey1 = \'" + txtCopyPart.Text + "\' and ChildKey2 = \'" + txtCopyRev.Text + "\'");
for (int i = 0; (i < copyRows.Length); i++)
{
CreateChild(copyRows[i]["Brand_c"].ToString(), copyRows[i]["Model_c"].ToString(), copyRows[i]["Year_c"].ToString(), copyRows[i]["Length_c"].ToString(), copyRows[i]["Height_c"].ToString());
}
ud100Adapter.Update();
ud100Adapter.Dispose();
MessageBox.Show("Completed");
} catch (Exception e) {
MessageBox.Show(e.ToString());
}
}
}
}
}
private void CheckData(int CheckLevel)
{
//Last, current, next CheckColumn CheckRightGroup check is True or false
string LastLevel, CurLevel, CurUserLevel, NextLevel, GroupName, isCheck = "=1", isUnCheck = "=0";
int TotalCheckRows = 0; //All Quoted Rows
Boolean ck = false; //defalt check status to set
if (CheckLevel == 1)
{
LastLevel = "1";
CurLevel = "Checked1_c";
CurUserLevel = "Checked1By_c";
NextLevel = "Checked2_c";
GroupName = "Quote";
}
else if (CheckLevel == 2)
{
LastLevel = "Checked1_c";
CurLevel = "Checked2_c";
CurUserLevel = "Checked2By_c";
NextLevel = "Checked3_c";
GroupName = "QA";
}
else
{
LastLevel = "Checked2_c";
CurLevel = "Checked3_c";
CurUserLevel = "Checked3By_c";
NextLevel = "0";
GroupName = "Admin";
}
try
{
EpiDataView edvUser = (EpiDataView)oTrans.EpiDataViews["CallContextClientData"];
string UserId = edvUser.dataView[edvUser.Row]["CurrentUserId"].ToString();
if (!HaveRight(UserId, GroupName))
{
ExceptionBox.Show(new System.Exception("no right to check!"));
return;
}
//get the view data
EpiDataView edv = (EpiDataView)(oTrans.EpiDataViews["V_QuoteUpdateInfoCGVer1_1View3"]);
if (edv.dataView.Count > 0)
{
// Get the Quoted data from QuoteHed
QuoteAdapter qa = new QuoteAdapter(this.oTrans);
qa.BOConnect();
string whereClause = " Quoted = 1 ";
System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);
whereClauses.Add("QuoteHed", whereClause);
SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);
qa.InvokeSearch(searchOptions);
TotalCheckRows = qa.QuoteData.Tables["QuoteHed"].Rows.Count;
//check or uncheck [checked rows = max rows ,then uncheck. checked rows != max rows, then check]
DataRow[] RowsCur = qa.QuoteData.QuoteHed.Select(CurLevel + isCheck);
if (RowsCur.Length != TotalCheckRows)
{
ck = true;
}
//check cur row, last level must be checked.
//uncheck cur row, the next level must be unchecked
DataRow[] RowsPrevious = ck ? qa.QuoteData.QuoteHed.Select(LastLevel + isCheck) : qa.QuoteData.QuoteHed.Select(NextLevel + isUnCheck);
if (RowsPrevious.Length == TotalCheckRows)
{
//check the data in SQL
for (int i = 0; i < qa.QuoteData.Tables["QuoteHed"].Rows.Count; i++)
{
qa.QuoteData.Tables["QuoteHed"].Rows[i][CurLevel] = ck;
qa.QuoteData.Tables["QuoteHed"].Rows[i][CurUserLevel] = UserId;
}
qa.Update();
qa.Dispose();
// Check the data on the interface
for (int i = 0; i < edv.dataView.Count; i++)
{
edv.dataView[i]["QuoteHed_" + CurLevel] = ck;
}
edv.Notify(new EpiNotifyArgs(this.oTrans, edv.Row, edv.Column));
}
else
{
ExceptionBox.Show(new System.Exception(ck ? "check the last level please!" : "uncheck the next level please!"));
}
}
else
{
ExceptionBox.Show(new System.Exception("no row can be checked or unchecked!"));
}
}
catch (System.Exception ex)
{
ExceptionBox.Show(ex);
}
}