/// <summary>
/// Query 저장
/// </summary>
public void TrxFormData()
{
if (!this.ValidateForm())
{
return;
}
Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query();
objQry.IKpi_Ref_Id = this.IKpiRefID;
objQry.IDicode = this.IDiCode;
objQry.IVersion_No = 1; //this.IVersionNo; -- 차후버젼관리 연결
objQry.IActive_Yn = "Y";
objQry.IResult_Field_Al = txtField_Ss.Text;
objQry.IResult_Where_Al = txtCondition_SS.Text;
objQry.IResult_Field_Ms = txtField_Ms.Text;
objQry.IResult_Where_Ms = txtCondition_Ms.Text;
objQry.IResult_Field_Ts = txtField_Ts.Text;
objQry.IResult_Where_Ts = txtCondition_Ts.Text;
objQry.IQuery_Al = txtQUERY_AL.Text;
objQry.IQuery_Ms = txtQUERY_MS.Text;
objQry.IQuery_Ts = txtQUERY_TS.Text;
objQry.IIsvalid_Query = this.IisValidQuery;
objQry.IModify_Reason = "";
int iRtnRow = 0;
if (this.IType == "A")
{
iRtnRow = objQry.InsertData
(objQry.IKpi_Ref_Id
, objQry.IDicode
, objQry.IVersion_No
, objQry.IActive_Yn
, objQry.IResult_Field_Al
, objQry.IResult_Where_Al
, objQry.IResult_Field_Ms
, objQry.IResult_Where_Ms
, objQry.IResult_Field_Ts
, objQry.IResult_Where_Ts
, objQry.IQuery_Al
, objQry.IQuery_Ms
, objQry.IQuery_Ts
, objQry.IIsvalid_Query
, objQry.IModify_Reason
, gUserInfo.Emp_Ref_ID);
}
else if (this.IType == "U")
{
iRtnRow = objQry.UpdateData
(objQry.IKpi_Ref_Id
, objQry.IDicode
, objQry.IVersion_No
, objQry.IActive_Yn
, objQry.IResult_Field_Al
, objQry.IResult_Where_Al
, objQry.IResult_Field_Ms
, objQry.IResult_Where_Ms
, objQry.IResult_Field_Ts
, objQry.IResult_Where_Ts
, objQry.IQuery_Al
, objQry.IQuery_Ms
, objQry.IQuery_Ts
, objQry.IIsvalid_Query
, objQry.IModify_Reason
, gUserInfo.Emp_Ref_ID);
}
else if (this.IType == "D")
{
iRtnRow = objQry.DeleteData
(objQry.IKpi_Ref_Id
, objQry.IDicode
, objQry.IVersion_No
, gUserInfo.Emp_Ref_ID);
}
ltrScript.Text = JSHelper.GetAlertScript(objQry.Transaction_Message, false);
}
