private void LastSelectedMatrixRow_Select(SAPbouiCOM.Form oForm)
{
oMatrix = (SAPbouiCOM.Matrix)oForm.Items.Item("mtx1_DUMY").Specific;
if (gDeliverySelect > 0)
{
if (oMatrix.VisualRowCount >= gDeliverySelect)
{
if (!oMatrix.IsRowSelected(gDeliverySelect))
oMatrix.SelectRow(gDeliverySelect, true, false);
}
}
}
public virtual void ET_mtx2_DUMY_AFClick(ItemEvent pVal)
{
oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
oMatrix = ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx2_DUMY").Specific));
// ADD YOUR ACTION CODE HERE ...
if (pVal.Row > 0)
{
//1. 콜리스트를 선택하면 배달코드를 찾아 자동으로 선택되도록 한다.
oMatrix.SelectRow(pVal.Row, true, false);
// 1-1 콜리스트 선택된 것에서 배달코드를 찾는다.
string strDeliveryCode = FN.GetMatirxCellValue(ref oMatrix, "U_DELVCD", pVal.Row);
SAPbouiCOM.Matrix oMatrix1 = (SAPbouiCOM.Matrix)(oForm.Items.Item("mtx1_DUMY").Specific);
// 2. 배달코드로 배송리스트에서 메트릭스의 행을 찾는다.
var obj_Deliver = from row in gDs.Tables[oForm.UniqueID + "_Deliver"].AsEnumerable()
where row.Field<string>("DELVCD") == strDeliveryCode
select new
{
vIDX = row.Field<Int32>("IDX")
};
oMatrix1.SelectRow(obj_Deliver.Take(1).SingleOrDefault().vIDX +1, true, false);
sFindTY = "F";
}
if (oForm.Settings.MatrixUID != pVal.ItemUID)
{
oForm.Freeze(true);
oForm.Settings.MatrixUID = pVal.ItemUID;
oMatrix.AutoResizeColumns();
oMatrix = ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx1_DUMY").Specific));
oMatrix.AutoResizeColumns();
oForm.Freeze(false);
}
}
private bool DeleteMatrixRows_CALL(string pDeliveryCode)
{
bool bRtnValue = true;
System.Data.DataRow[] findRows = null;
string strIdx = string.Empty;
int iBtnValue = -1;
try
{
oMatrix = (SAPbouiCOM.Matrix)oForm.Items.Item("mtx2_ORIG").Specific;
findRows = gDs.Tables[oForm.UniqueID + "_Call"].Select(string.Format(" DELVCD = '{0}' ", pDeliveryCode));
// 1. 메트릭스 삭제대상 삭제 적용
if (findRows.Count() > 0)
{
iBtnValue = B1Connections.theAppl.MessageBox("상담이력이 존재 합니다. 삭제하시겠습니까?", 1, "&Yes", "&No", "");
if (iBtnValue == 1)
{
foreach (System.Data.DataRow dr in findRows)
{
//삭제할것들 선택한다.
strIdx = dr["IDX"].ToString();
oMatrix.SelectRow(int.Parse(strIdx) + 1, true, true);
gDs.Tables[oForm.UniqueID + "_Call"].Rows.Remove(dr);
}
// 선택된 Rows를 삭제한다.
int iSelectIdx = 0;
while (iSelectIdx != -1)
{
iSelectIdx = oMatrix.GetNextSelectedRow(0, BoOrderType.ot_SelectionOrder);
if (iSelectIdx != -1)
oMatrix.DeleteRow(iSelectIdx);
}
if (findRows.Count() > 0)
oMatrix.FlushToDataSource();
}
else
bRtnValue = false;
}
}
catch (Exception)
{
bRtnValue = false;
throw;
}
finally
{
findRows = null;
}
return bRtnValue;
}
public virtual bool ET_mtx_BFClick(ItemEvent pVal)
{
oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
oMatrix = ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx").Specific));
// ADD YOUR ACTION CODE HERE ...
try
{
if (pVal.Row > 0)
{
if (oMatrix.VisualRowCount >= pVal.Row)
{
if (oMatrix.IsRowSelected(pVal.Row) != true)
{
oMatrix.SelectRow(pVal.Row, true, false);
}
}
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText(ex.Message, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
}
return true;
}
public virtual void ET_mtx1_DUMY_AFClick(ItemEvent pVal)
{
oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
oMatrix = ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx1_DUMY").Specific));
// ADD YOUR ACTION CODE HERE ...
if (pVal.Row > 0)
{
oMatrix.SelectRow(pVal.Row, true, false);
gDeliverySelect = pVal.Row;
}
if (oForm.Settings.MatrixUID != pVal.ItemUID)
{
oForm.Freeze(true);
oForm.Settings.MatrixUID = pVal.ItemUID;
oMatrix.AutoResizeColumns();
oMatrix = ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx2_DUMY").Specific));
oMatrix.AutoResizeColumns();
oForm.Freeze(false);
}
}
public override void etAfterActClick(ref ItemEvent pVal, ref bool BubbleEvent)
{
base.etAfterActClick(ref pVal, ref BubbleEvent);
if (pVal.ItemUID == "btFinal")
{
int confirm = oApplication.MessageBox("Are you sure you want to post stock?", 2, "Yes", "No");
if (confirm == 1)
{
int postingStatus = -1;
int trsnsferResult = -1;
int selRow = mtSelRow(mtDocs);
if (selRow > 0)
{
string strCode = Convert.ToString(dtDoc.GetValue("OT", selRow - 1));
string dn = Convert.ToString(dtDoc.GetValue("DE", selRow - 1));
string docType = Convert.ToString(dtDoc.GetValue("DT", selRow - 1));
if (docType == "Offer for Inspection")
{
string strProdNum = "SELECT \"U_B1_QA_INSP_PN\" FROM \"OIGN\" WHERE \"DocEntry\" ='" + dn + "'";
System.Data.DataTable dtProdNum = Program.objHrmsUI.getDataTable(strProdNum, "ProdNum");
if (dtProdNum != null && dtProdNum.Rows.Count > 0)
{
if (dtProdNum.Rows[0]["U_B1_QA_INSP_PN"] != DBNull.Value && Convert.ToInt32(dtProdNum.Rows[0]["U_B1_QA_INSP_PN"]) > 0)
{
postingStatus = ReleaseInspaction(dn);
}
}
}
else
{
postingStatus = PostTransfer(strCode, dn);
}
string strDocCode = strCode + "-" + dn;
if (strCode.Trim() != "" && postingStatus != -1)
{
string strInsert = "UPDATE \"@B1_QA_DOC\" SET \"U_Date\" = '" + DateTime.Now.ToString("yyyyMMdd") + "' , \"U_Final\"='Y' , \"U_WTRentry\" = '" + postingStatus + "' WHERE \"Code\" = '" + strDocCode + "'";
Program.objHrmsUI.ExecQuery(strInsert, "Finalllizing Inspaction");
}
}
//
_iniForm();
getDocs();
}
}
if (pVal.ItemUID == "btPrint")
{
SAPbouiCOM.Menus mnus = oApplication.Menus;
if (mnus.Exists(printMenuId) && printMenuId != "")
{
int selRow = mtSelRow(mtDocs);
string strCode = Convert.ToString(dtDoc.GetValue("OT", selRow - 1));
string dn = Convert.ToString(dtDoc.GetValue("DE", selRow - 1));
mnus.Item(printMenuId).Activate();
SAPbouiCOM.Form prmForm = oApplication.Forms.ActiveForm;
EditText objType = (SAPbouiCOM.EditText)prmForm.Items.Item("1000003").Specific;
EditText DocKey = (SAPbouiCOM.EditText)prmForm.Items.Item("1000009").Specific;
SAPbouiCOM.Button ok = (SAPbouiCOM.Button)prmForm.Items.Item("1").Specific;
// SAPbouiCOM.Button cancel = (SAPbouiCOM.Button)prmForm.Items.Item("2").Specific;
objType.Value = strCode;
DocKey.Value = dn;
prmForm.ActiveItem = ok.Item.UniqueID;
objType.Item.Enabled = false;
// DocKey.Item.Enabled = false;
ok.Item.Click();
// prmForm.Select();
// cancel.Item.Click();
}
else
{
oApplication.MessageBox("Please upload \"Inspection Report\" in production report menu");
}
}
if (pVal.ItemUID == "txAtt")
{
try
{
// txAtt.ClickPicker();
System.Diagnostics.Process.Start(dtHead.GetValue("Att", 0).ToString());
}
catch (Exception ex)
{
string errmsg = ex.Message;
}
}
if (pVal.ItemUID == btAtt.Item.UniqueID)
{
string strFileName = Program.objHrmsUI.addAttacment("");
if (strFileName != "")
{
dtHead.SetValue("Att", 0, strFileName);
int selRow = mtSelRow(mtDocs);
string strCode = Convert.ToString(dtDoc.GetValue("OT", selRow - 1));
string dn = Convert.ToString(dtDoc.GetValue("DE", selRow - 1));
string strDocCode = strCode + "-" + dn;
string strInsert = "UPDATE \"@B1_QA_DOC\" SET \"U_Att\" = '" + strFileName + "' WHERE \"Code\" = '" + strDocCode + "'";
Program.objHrmsUI.ExecQuery(strInsert, "Finalllizing Inspaction");
}
}
if (pVal.ItemUID == "1000001")
{
string RC = Convert.ToString(dtHead.GetValue("RC", 0));
string SBC = Convert.ToString(dtHead.GetValue("SBC", 0));
string strCode = RC + "-" + SBC;
saveReport(strCode);
}
if (pVal.ItemUID == mtDocs.Item.UniqueID && pVal.Row > 0 && pVal.Row <= mtDocs.RowCount)
{
mtDocs.SelectRow(pVal.Row, true, false);
int selRow = pVal.Row;
if (selRow > 0)
{
string strCode = Convert.ToString(dtDoc.GetValue("OT", selRow - 1));
string dn = Convert.ToString(dtDoc.GetValue("DE", selRow - 1));
string tbl = Convert.ToString(dtDoc.GetValue("Tbl", selRow - 1));
if (strCode.Trim() != "")
{
string strDocCode = strCode + "-" + dn;
string strExist = "SELECT * from \"@B1_QA_DOC\" where \"Code\" = '" + strDocCode + "'";
System.Data.DataTable dtExist = Program.objHrmsUI.getDataTable(strExist, "DocDetExist");
if (dtExist.Rows.Count == 0)
{
string strInsert = "INSERT INTO \"@B1_QA_DOC\" (\"Code\",\"Name\",\"U_ObjType\",\"U_DocEntry\",\"U_Date\")";
strInsert += " VALUES ('" + strDocCode + "','" + strDocCode + "','" + strCode + "','" + dn + "','" + DateTime.Now.ToString("yyyyMMdd") + "')";
Program.objHrmsUI.ExecQuery(strInsert, "Rpt Doc Entry into UDT");
}
else
{
dtHead.SetValue("Att", 0, dtExist.Rows[0]["U_Att"].ToString());
}
getRows(tbl, dn);
}
}
else
{
oApplication.MessageBox("Please select a document before inspaction");
}
}
if (pVal.ItemUID == mtDocRows.Item.UniqueID && pVal.Row > 0 && pVal.Row <= mtDocRows.RowCount)
{
mtDocRows.SelectRow(pVal.Row, true, false);
int selRow = pVal.Row;// mtSelRow(mtDocRows);
if (selRow > 0)
{
string strCode = Convert.ToString(dtRow.GetValue("ItemCode", selRow - 1));
string MM = Convert.ToString(dtRow.GetValue("MM", selRow - 1));
string OBT = Convert.ToString(dtRow.GetValue("OBT", selRow - 1));
string LN = Convert.ToString(dtRow.GetValue("LN", selRow - 1));
string ItemCode = Convert.ToString(dtRow.GetValue("ItemCode", selRow - 1));
string Qty = Convert.ToString(dtRow.GetValue("Quantity", selRow - 1));
int DocselRow = mtSelRow(mtDocs);
string DE = Convert.ToString(dtDoc.GetValue("DE", DocselRow - 1));
dtHead.SetValue("RC", 0, OBT + "-" + DE + "-" + LN);
dtHead.SetValue("MM", 0, MM);
dtHead.SetValue("OBT", 0, OBT);
dtHead.SetValue("LN", 0, LN);
dtHead.SetValue("DE", 0, DE);
dtHead.SetValue("Qty", 0, Qty);
dtHead.SetValue("ItemCode", 0, ItemCode);
if (strCode.Trim() != "")
{
getAttributes(strCode);
fillSerilaOrBatch(Qty, DE, LN, OBT, MM);
}
}
else
{
oApplication.MessageBox("Please select an item before inspaction");
}
}
if (pVal.ItemUID == mtSB.Item.UniqueID && pVal.Row > 0 && pVal.Row <= mtSB.RowCount)
{
mtSB.SelectRow(pVal.Row, true, false);
int selRow = pVal.Row;// mtSelRow(mtSB);
if (selRow > 0)
{
string RC = Convert.ToString(dtHead.GetValue("RC", 0));
string MM = Convert.ToString(dtHead.GetValue("MM", 0));
string OBT = Convert.ToString(dtHead.GetValue("OBT", 0));
string LN = Convert.ToString(dtHead.GetValue("LN", 0));
string DE = Convert.ToString(dtHead.GetValue("DE", 0));
string ItemCode = Convert.ToString(dtHead.GetValue("ItemCode", 0));
string Qty = Convert.ToString(dtHead.GetValue("Qty", 0));
string strCode = Convert.ToString(dtSB.GetValue("Code", selRow - 1));
string strQty = Convert.ToString(dtSB.GetValue("Qty", selRow - 1));
dtHead.SetValue("SBC", 0, strCode);
getReport(RC + "-" + strCode, OBT, DE, LN, MM, strQty, ItemCode, strCode);
}
}
}
public override void etAfterClick(ref SAPbouiCOM.ItemEvent pVal, ref bool BubbleEvent)
{
base.etAfterClick(ref pVal, ref BubbleEvent);
if (pVal.ItemUID == opG.Item.UniqueID || pVal.ItemUID == opI.Item.UniqueID)
{
if (opI.Selected)
{
txCode.ChooseFromListUID = "cflCode";
txCode.ChooseFromListAlias = "CardCode";
}
else
{
txCode.ChooseFromListUID = "cflGroup";
txCode.ChooseFromListAlias = "ItmsGrpCod";
}
getCodes();
}
if (pVal.ItemUID == btAdd.Item.UniqueID)
{
string code = Convert.ToString(dtHead.GetValue("Code", 0));
string name = Convert.ToString(dtHead.GetValue("Name", 0));
string codeType = opG.Selected ? "Group" : "Item";
string strCode = Program.objHrmsUI.getMaxId("@B1_QA_ATTR_CODES", "Code").ToString();
if (code != "")
{
string strInsert = "INSERT INTO \"@B1_QA_ATTR_CODES\" (\"Code\",\"Name\",\"U_Descr\",\"U_CodeType\") VALUES ('" + strCode + "','" + code + "','" + name + "','" + codeType + "')";
Program.objHrmsUI.ExecQuery(strInsert, "Insert New Code");
dtHead.SetValue("Code", 0, "");
dtHead.SetValue("Name", 0, "");
getCodes();
}
else
{
oApplication.MessageBox("Please select Code");
}
}
if (pVal.ItemUID == btAddA.Item.UniqueID)
{
int selListRow = mtSelRow(mtList);
string IGcode = Convert.ToString(dtList.GetValue("Code", selListRow - 1));
string codeType = opG.Selected ? "Group" : "Item";
int selRow = mtSelRow(mtA);
if (selRow > 0)
{
string strCode = Convert.ToString(dtA.GetValue("Code", selRow - 1));
string strNCode = Program.objHrmsUI.getMaxId("@B1_QA_CODES_ATTR", "Code").ToString();
string strInsert = "INSERT INTO \"@B1_QA_CODES_ATTR\" (\"Code\",\"Name\",\"U_IGCode\") VALUES ('" + strNCode + "','" + strCode + "','" + IGcode + "')";
Program.objHrmsUI.ExecQuery(strInsert, "Insert New Code");
getCodesAttr(IGcode);
}
else
{
oApplication.MessageBox("Please select Code");
}
}
if (pVal.ItemUID == btDelA.Item.UniqueID)
{
int selListRow = mtSelRow(mtList);
string IGcode = Convert.ToString(dtList.GetValue("Code", selListRow - 1));
string codeType = opG.Selected ? "Group" : "Item";
int selRow = mtSelRow(mtS);
if (selRow > 0)
{
string strCode = Convert.ToString(dtS.GetValue("Code", selRow - 1));
string strInsert = "DELETE FROM \"@B1_QA_CODES_ATTR\" WHERE \"Name\" = '" + strCode + "' AND \"U_IGCode\" = '" + IGcode + "'";
Program.objHrmsUI.ExecQuery(strInsert, "REMOVE Code");
getCodesAttr(IGcode);
}
else
{
oApplication.MessageBox("Please select Code");
}
}
if (pVal.ItemUID == mtList.Item.UniqueID && pVal.Row > 0 && pVal.Row <= mtList.RowCount)
{
mtList.SelectRow(pVal.Row, true, false);
int selRow = pVal.Row;// mtSelRow(mtList);
if (selRow > 0)
{
string strCode = Convert.ToString(dtList.GetValue("Code", selRow - 1));
if (strCode.Trim() != "")
{
getCodesAttr(strCode);
}
}
else
{
oApplication.MessageBox("Please select rule to delete");
}
}
if ((pVal.ItemUID == mtA.Item.UniqueID) && pVal.Row > 0 && pVal.Row <= mtA.RowCount)
{
mtA.SelectRow(pVal.Row, true, false);
}
if ((pVal.ItemUID == mtS.Item.UniqueID) && pVal.Row > 0 && pVal.Row <= mtS.RowCount)
{
mtS.SelectRow(pVal.Row, true, false);
}
}
public virtual void ET_mtx_AFClick(ItemEvent pVal) {
oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
oMatrix = ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx").Specific));
// ADD YOUR ACTION CODE HERE ...
oDB_M = oForm.DataSources.DBDataSources.Item("@KIS_FI0020M_HRD");
oDB_1 = oForm.DataSources.DBDataSources.Item("@KIS_FI00201_HRD");
if (pVal.Row != 0)
{
oMatrix.SelectRow(pVal.Row, true, false);
SelectRow = pVal.Row -1;
if (oDB_1.GetValue("U_STATUS", pVal.Row-1).ToString() == "Y")
{
oForm.Items.Item("btnTR").Enabled = false;
oForm.Items.Item("btnCAN").Enabled = true;
}
else
{
oForm.Items.Item("btnTR").Enabled = true;
oForm.Items.Item("btnCAN").Enabled = false;
}
}
}
public virtual void ET_mtx_AFClick(ItemEvent pVal)
{
oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
oMatrix = ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx").Specific));
// ADD YOUR ACTION CODE HERE ...
if (pVal.Row > 0)
{
oMatrix.SelectRow(pVal.Row, true, false);
gRow = pVal.Row;
}
}
public override void etAfterClick(ref SAPbouiCOM.ItemEvent pVal, ref bool BubbleEvent)
{
base.etAfterClick(ref pVal, ref BubbleEvent);
if (pVal.ItemUID == btAdd.Item.UniqueID)
{
string code = Convert.ToString(dtHead.GetValue("Code", 0));
string name = Convert.ToString(dtHead.GetValue("Name", 0));
if (code != "")
{
string strInsert = "INSERT INTO \"@B1_QA_OUSR\" (\"Code\" , \"Name\") VALUES ('" + code + "','" + name + "')";
Program.objHrmsUI.ExecQuery(strInsert, "Insert New Code");
dtHead.SetValue("Code", 0, "");
dtHead.SetValue("Name", 0, "");
getCodes();
}
else
{
oApplication.MessageBox("Please select Code");
}
}
if (pVal.ItemUID == btAddA.Item.UniqueID)
{
int selListRow = mtSelRow(mtList);
string IGcode = Convert.ToString(dtList.GetValue("Code", selListRow - 1));
int selRow = mtSelRow(mtA);
if (selRow > 0)
{
string strCode = Convert.ToString(dtA.GetValue("Code", selRow - 1));
string strNCode = Program.objHrmsUI.getMaxId("@B1_QA_OUSR_OT", "Code").ToString();
string strInsert = "INSERT INTO \"@B1_QA_OUSR_OT\" (\"Code\",\"Name\",\"U_ObjType\",\"U_UsrCode\") VALUES ('" + strNCode + "','" + strCode + "','" + strCode + "','" + IGcode + "')";
Program.objHrmsUI.ExecQuery(strInsert, "Insert New Code");
getCodesAttr(IGcode);
}
else
{
oApplication.MessageBox("Please select Code");
}
}
if (pVal.ItemUID == btAddW.Item.UniqueID)
{
int selListRow = mtSelRow(mtList);
string IGcode = Convert.ToString(dtList.GetValue("Code", selListRow - 1));
int selRow = mtSelRow(mtAW);
if (selRow > 0)
{
string strCode = Convert.ToString(dtAW.GetValue("Code", selRow - 1));
string strNCode = Program.objHrmsUI.getMaxId("@B1_QA_OUSR_WHS", "Code").ToString();
string strInsert = "INSERT INTO \"@B1_QA_OUSR_WHS\" (\"Code\",\"Name\",\"U_WHS\",\"U_UsrCode\") VALUES ('" + strNCode + "','" + strCode + "','" + strCode + "','" + IGcode + "')";
Program.objHrmsUI.ExecQuery(strInsert, "Insert New WHS");
getCodesAttr(IGcode);
}
else
{
oApplication.MessageBox("Please select Code");
}
}
if (pVal.ItemUID == btDelA.Item.UniqueID)
{
int selListRow = mtSelRow(mtList);
string IGcode = Convert.ToString(dtList.GetValue("Code", selListRow - 1));
int selRow = mtSelRow(mtS);
if (selRow > 0)
{
string strCode = Convert.ToString(dtS.GetValue("Code", selRow - 1));
string strInsert = "DELETE FROM \"@B1_QA_OUSR_OT\" WHERE \"Name\" = '" + strCode + "' AND \"U_UsrCode\" = '" + IGcode + "'";
Program.objHrmsUI.ExecQuery(strInsert, "REMOVE Code");
getCodesAttr(IGcode);
}
else
{
oApplication.MessageBox("Please select Code");
}
}
if (pVal.ItemUID == btDelW.Item.UniqueID)
{
int selListRow = mtSelRow(mtList);
string IGcode = Convert.ToString(dtList.GetValue("Code", selListRow - 1));
int selRow = mtSelRow(mtSW);
if (selRow > 0)
{
string strCode = Convert.ToString(dtSW.GetValue("Code", selRow - 1));
string strInsert = "DELETE FROM \"@B1_QA_OUSR_WHS\" WHERE \"Name\" = '" + strCode + "' AND \"U_UsrCode\" = '" + IGcode + "' ";
Program.objHrmsUI.ExecQuery(strInsert, "REMOVE Code");
getCodesAttr(IGcode);
}
else
{
oApplication.MessageBox("Please select Code");
}
}
if (pVal.ItemUID == mtList.Item.UniqueID && pVal.Row > 0 && pVal.Row <= mtList.RowCount)
{
mtList.SelectRow(pVal.Row, true, false);
int selRow = pVal.Row;// mtSelRow(mtList);
if (selRow > 0)
{
string strCode = Convert.ToString(dtList.GetValue("Code", selRow - 1));
if (strCode.Trim() != "")
{
getCodesAttr(strCode);
}
}
else
{
oApplication.MessageBox("Please select rule to delete");
}
}
if (pVal.ItemUID == mtS.Item.UniqueID && pVal.Row > 0 && pVal.Row <= mtS.RowCount)
{
mtS.SelectRow(pVal.Row, true, false);
}
if (pVal.ItemUID == mtA.Item.UniqueID && pVal.Row > 0 && pVal.Row <= mtA.RowCount)
{
mtA.SelectRow(pVal.Row, true, false);
}
if (pVal.ItemUID == mtSW.Item.UniqueID && pVal.Row > 0 && pVal.Row <= mtSW.RowCount)
{
mtSW.SelectRow(pVal.Row, true, false);
}
if (pVal.ItemUID == mtAW.Item.UniqueID && pVal.Row > 0 && pVal.Row <= mtAW.RowCount)
{
mtAW.SelectRow(pVal.Row, true, false);
}
}
public virtual void ET_mtx1_AFClick(ItemEvent pVal) {
oForm = B1Connections.theAppl.Forms.Item(pVal.FormUID);
oMatrix = ((SAPbouiCOM.Matrix)(oForm.Items.Item("mtx1").Specific));
// ADD YOUR ACTION CODE HERE ...
try
{
if (pVal.Row > 0 )
{
if (oMatrix.VisualRowCount > 0)
{
oMatrix.SelectRow(pVal.Row, true, false);
}
SetHeaderValues();
}
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText(ex.Message, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
}
}
/// <summary>
/// 지정된 문서를 DBDatasource로 다시 로드 합니다.
/// </summary>
/// <param name="KeyValue">문서번호(DocEntry)</param>
private void SetFormLoadFromDBDatasource()
{
oForm.Freeze(true);
try
{
string cboPUBLICA = oForm.DataSources.UserDataSources.Item("cboPUBLICA").Value;
string cboYEAR = oForm.DataSources.UserDataSources.Item("cboYEAR").Value;
string cboMONTH = oForm.DataSources.UserDataSources.Item("cboMONTH").Value;
oForm.Mode = BoFormMode.fm_OK_MODE;
SAPbouiCOM.Conditions oCons = new SAPbouiCOM.Conditions();
SAPbouiCOM.DBDataSource oKIS_SD0170T_HRD = (SAPbouiCOM.DBDataSource)oForm.DataSources.DBDataSources.Item("@KIS_SD0170T_HRD");
SAPbouiCOM.Condition oCon = null;
oCon = oCons.Add();
oCon.Alias = "U_PUBLICA";
oCon.Operation = BoConditionOperation.co_EQUAL;
oCon.CondVal = cboPUBLICA;
oCon.Relationship = BoConditionRelationship.cr_AND;
oCon = oCons.Add();
oCon.Alias = "U_YEAR";
oCon.Operation = BoConditionOperation.co_EQUAL;
oCon.CondVal = cboYEAR;
if (string.IsNullOrEmpty(cboMONTH) == false)
{
oCon.Relationship = BoConditionRelationship.cr_AND;
oCon = oCons.Add();
oCon.Alias = "U_MONTH";
oCon.Operation = BoConditionOperation.co_EQUAL;
oCon.CondVal = cboMONTH;
}
oKIS_SD0170T_HRD.Query(oCons);
oMatrix = oForm.Items.Item("mtx1").Specific;
oMatrix.LoadFromDataSource();
//월 데이터
if (string.IsNullOrEmpty(cboMONTH)==false)
{
FN.SetItemEnable(oForm, "btnADD", true);
}
oCon = null;
oCons = null;
oKIS_SD0170T_HRD = null;
/* 아래 코드부터는 ET_AFFormDataLoad 이벤트와 동일하게 설정해준다.*/
if (oMatrix.VisualRowCount>0)
{
oMatrix.SelectRow(1, true, false);
}
SetHeaderValues();
}
catch (Exception ex)
{
B1Connections.theAppl.StatusBar.SetText(ex.Message, BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
}
finally
{
oForm.Freeze(false);
}
}