/// <summary>
/// 기본정보 조회
/// </summary>
public void SetFormData()
{
Biz_Bsc_Kpi_Info objBSC = new Biz_Bsc_Kpi_Info(this.IEstTermRefID, this.IKpiRefID);
lblKpiCode.Text = objBSC.Ikpi_code;
lblKpiName.Text = objBSC.Ikpi_name;
txtCalcFormMs.Text = objBSC.Icalc_form_ms;
txtCalcFormTs.Text = objBSC.Icalc_form_ts;
Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query(this.IKpiRefID, this.IDiCode);
this.IDiCode = objQry.IDicode;
txtDiCode.Text = objQry.IDicode;
this.IVersionNo = 1; //objQry.IVersion_No; -- 차후에 버젼관리 연결
txtField_Ss.Text = objQry.IResult_Field_Al;
txtCondition_SS.Text = objQry.IResult_Where_Al;
txtField_Ms.Text = objQry.IResult_Field_Ms;
txtCondition_Ms.Text = objQry.IResult_Where_Ms;
txtField_Ts.Text = objQry.IResult_Field_Ts;
txtCondition_Ts.Text = objQry.IResult_Where_Ts;
txtQUERY_AL.Text = objQry.IQuery_Al;
txtQUERY_MS.Text = objQry.IQuery_Ms;
txtQUERY_TS.Text = objQry.IQuery_Ts;
this.IisValidQuery = objQry.IIsvalid_Query;
if (this.IVersionNo > 0)
{
Biz_Bsc_Interface_Dicode objCode = new Biz_Bsc_Interface_Dicode(this.IDiCode, gUserInfo.Emp_Ref_ID);
txtDiName.Text = objCode.IName;
this.IType = "U";
this.SetColumnList();
}
else
{
txtDiCode.Text = "";
txtDiName.Text = "";
this.IDiCode = "";
this.IType = "A";
}
//int iTxrUser = gUserInfo.Emp_Ref_ID;
//Biz_Bsc_Interface_Dicode objBSC = new Biz_Bsc_Interface_Dicode(this.IDiCode, iTxrUser);
//txtDICODE.Text = objBSC.IDicode;
//txtDINAME.Text = objBSC.IName;
//txtDEFINITION.Text = objBSC.IDefinition;
//lblUseYN.Text = objBSC.IUse_Yn;
//txtDICODE.BackColor = Color.WhiteSmoke;
//txtDICODE.ReadOnly = true;
//this.IType = (objBSC.IUse_Yn=="Y") ? "U" : "R";
//Biz_Bsc_Interface_Column objCol = new Biz_Bsc_Interface_Column();
//DataTable dtRtn = objCol.GetColumnInfoPerDicode(this.IDiCode, iTxrUser);
//ugrdDIColumn.Clear();
//ugrdDIColumn.DataSource = dtRtn.DefaultView;
//ugrdDIColumn.DataBind();
this.SetButton();
}
/// <summary>
/// 생성쿼리 검증
/// </summary>
public void SetQueryValidate()
{
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
string sSYmd = objTerm.GetStartEstMonth();
string sCYmd = objTerm.GetReleasedMonth();
decimal dRtnVal = 0;
string sRtnMsg = "";
bool bIsSuccess = false;
this.IisValidQuery = "Y";
Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query();
// 인터페이스 리스트
DataSet rDs = objQry.GetInterfaceData(txtQUERY_AL.Text, sCYmd, out sRtnMsg, out bIsSuccess);
lblSuccessAl.Text = sRtnMsg;
lblSuccessAl.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red;
if (!bIsSuccess)
{
this.IisValidQuery = "N";
}
// 당월실적 쿼리결과
dRtnVal = objQry.GetInterfaceResultMs(txtQUERY_MS.Text, sCYmd, out sRtnMsg, out bIsSuccess);
lblSuccessMs.Text = sRtnMsg;
lblSuccessMs.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red;
if (!bIsSuccess)
{
this.IisValidQuery = "N";
}
// 누적실적 쿼리결과
dRtnVal = objQry.GetInterfaceResultTs(txtQUERY_TS.Text, sSYmd, sCYmd, out sRtnMsg, out bIsSuccess);
lblSuccessTs.Text = sRtnMsg;
lblSuccessTs.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red;
if (!bIsSuccess)
{
this.IisValidQuery = "N";
}
}
/// <summary>
/// 지표상세정보 조회
/// </summary>
public void setKpiData()
{
if (ddlEstTermInfo.Items.Count < 1)
{
PageUtility.AlertMessage("등록된 평가기간이 없습니다.");
return;
}
Biz_Bsc_Interface_Kpi_Query objBSC = new Biz_Bsc_Interface_Kpi_Query();
DataSet rDs = objBSC.GetQueryMappingStatus
(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)
, this.IDiCode
, txtKPICode.Text
, txtKPIName.Text
, txtChamName.Text
, ""
, "Y"
, PageUtility.GetByValueDropDownList(ddlIS_SET_QUERY));
ugrdKpiList.Clear();
ugrdKpiList.DataSource = rDs;
ugrdKpiList.DataBind();
}
public void SetInterfaceGrid()
{
Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query(this.IKpiRefID, "");
this.IDiCode = objQry.IDicode;
if (this.IDiCode == "")
{
ltrScript.Text = JSHelper.GetAlertScript("정의된 Interface가 없습니다.", false);
return;
}
Biz_Bsc_Interface_Column objCol = new Biz_Bsc_Interface_Column();
DataSet rDs = objCol.GetAllList(this.IDiCode, gUserInfo.Emp_Ref_ID);
int iRow = 0;
string sUseYn = "N";
string sColKey = "";
string sColName = "";
int iDPoints = 0;
int iGridWith = 0;
UltraGridColumn ugCol;
if (rDs.Tables.Count > 0)
{
iRow = rDs.Tables[0].Rows.Count;
if (iRow > 0)
{
ugCol = new UltraGridColumn();
ugCol.Key = "TRX_DATE";
ugCol.BaseColumnName = "TRX_DATE";
ugCol.Header.Caption = "발생일자";
ugCol.Width = Unit.Pixel(100);
ugCol.AllowUpdate = AllowUpdate.Yes;
ugCol.DataType = "System.String";
ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Left;
ugrdInterface.Columns.Add(ugCol);
for (int i = 0; i < iRow; i++)
{
sUseYn = rDs.Tables[0].Rows[i]["USE_YN"].ToString();
sColKey = rDs.Tables[0].Rows[i]["COLUMN_ID"].ToString();
sColName = rDs.Tables[0].Rows[i]["COLUMN_ALIAS"].ToString();
iDPoints = Convert.ToInt32(rDs.Tables[0].Rows[i]["DECIMAL_POINTS"].ToString());
iGridWith = Convert.ToInt32(rDs.Tables[0].Rows[i]["GRID_WIDTH"].ToString());
if (sUseYn == "Y")
{
if (sColKey.Substring(0, 7) == "SVALUES")
{
ugCol = new UltraGridColumn();
ugCol.Key = sColKey;
ugCol.BaseColumnName = sColKey;
ugCol.Header.Caption = sColName;
ugCol.Width = Unit.Pixel(iGridWith);
ugCol.DataType = "System.String";
ugCol.AllowUpdate = AllowUpdate.Yes;
ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Left;
ugrdInterface.Columns.Add(ugCol);
}
else
{
ugCol = new UltraGridColumn();
ugCol.Key = sColKey;
ugCol.BaseColumnName = sColKey;
ugCol.Header.Caption = sColName;
ugCol.Width = Unit.Pixel(iGridWith);
ugCol.AllowUpdate = AllowUpdate.Yes;
ugCol.DataType = "System.Double";
ugCol.Format = "#,###,###,###,###,###,###,##0" + this.GetFormatPoints(iDPoints);
ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Right;
ugrdInterface.Columns.Add(ugCol);
}
}
}
}
}
string sRtnMsg = "";
bool bIsSuccess = false;
decimal dRtnVal = 0;
DataSet rDsQry = objQry.GetInterfaceData(this.IKpiRefID, this.IYMD, out sRtnMsg, out bIsSuccess);
ugrdInterface.Clear();
ugrdInterface.DataSource = rDsQry;
ugrdInterface.DataBind();
//dRtnVal = objQry.GetInterfaceResultMs(this.IKpiRefID, this.IYMD, out sRtnMsg, out bIsSuccess);
//txtResult_Ms.Text = (bIsSuccess) ? dRtnVal.ToString() : "0";
//dRtnVal = objQry.GetInterfaceResultTs(this.IKpiRefID, this.IYMD.Substring(0,4)+"01", this.IYMD, out sRtnMsg, out bIsSuccess);
//txtResult_Ts.Text = (bIsSuccess) ? dRtnVal.ToString() : "0";
}
public void ExportExcelFormat()
{
Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query(this.IKpiRefID, "");
DataSet rDsQry = objQry.GetInterfaceData(this.IKpiRefID, this.IYMD, out sRtnMsg, out bIsSuccess);
int iCntCol = 0;
if (rDsQry.Tables.Count > 0)
{
if (rDsQry.Tables[0].Rows.Count > 0)
{
iCntCol = rDsQry.Tables[0].Columns.Count;
}
else
{
iCntCol = 0;
}
}
ExcelEngine xlsEngine = new ExcelEngine();
IApplication xlsApp = xlsEngine.Excel;
IWorkbook xlsBook = xlsEngine.Excel.Workbooks.Create(1);
IWorksheet xlsSheet = xlsBook.Worksheets[0];
try
{
int iCol = WebCommon.GetExcelColumnCount();
for (int i = iCol; i > iCntCol; i--)
{
xlsSheet.ShowColumn(i, false);
}
Biz_Bsc_Interface_Column objCol = new Biz_Bsc_Interface_Column();
string sColNm = "";
for (int i = 0; i < iCntCol; i++)
{
sColNm = rDsQry.Tables[0].Columns[i].ColumnName;
objCol = new Biz_Bsc_Interface_Column(this.IDiCode, sColNm, gUserInfo.Emp_Ref_ID);
if (i == 0)
{
xlsSheet.Range[1, i + 1].Text = sColNm;
xlsSheet.Range[2, i + 1].Text = "발생일자";
xlsSheet.Range[2, i + 1].ColumnWidth = 10;
}
else
{
xlsSheet.Range[1, i + 1].Text = objCol.IColumn_Id;
xlsSheet.Range[2, i + 1].Text = objCol.IColumn_Alias;
xlsSheet.Range[2, i + 1].ColumnWidth = (objCol.IGrid_Width / 9);
xlsSheet.Columns[i].AutofitColumns();
xlsSheet.Columns[i].AutofitRows();
}
//switch (rDsQry.Tables[0].Columns[i].DataType.Name.ToLower())
//{
// case "decimal":
// string sChar = WebCommon.GetExcelColumnName(i);
// string sRange = sChar + "3:" + sChar + "10000";
// IDataValidation dvColumn = xlsSheet.Range[sRange].DataValidation;
// xlsSheet.Range[sRange].Text = "";
// xlsSheet.Range[sRange].NumberFormat = "#,###,###,###,###,###,###,###,###,###,##0.0######";
// xlsSheet.Range[sRange].AutofitColumns();
// dvColumn.AllowType = ExcelDataType.Decimal;
// dvColumn.CompareOperator = ExcelDataValidationComparisonOperator.Between;
// dvColumn.FirstFormula = System.Decimal.MinValue.ToString();
// dvColumn.SecondFormula = System.Decimal.MaxValue.ToString();
// dvColumn.ShowErrorBox = true;
// dvColumn.ErrorBoxText = "Enter Value between " + System.Decimal.MinValue.ToString() + " to " + System.Decimal.MaxValue.ToString();
// dvColumn.ErrorBoxTitle = "ERROR";
// dvColumn.PromptBoxText = "Data Validation using Condition for Numbers";
// dvColumn.ShowPromptBox = true;
// break;
// default:
// break;
//}
}
string sFileName = "InterfaceData" + "_" + this.IKpiRefID + "_" + this.IYMD + ".xls";
xlsSheet.ShowRow(1, false);
//Saving the workbook to disk.
xlsBook.SaveAs(sFileName, ExcelSaveType.SaveAsXLS, Response, ExcelDownloadType.PromptDialog);
}
catch (Exception e)
{
ltrScript.Text = JSHelper.GetAlertScript(e.Message);
}
finally
{
xlsEngine.ThrowNotSavedOnDestroy = false;
xlsEngine.Dispose();
}
//Entering text inside the Cells
//sheet.Range["A1:D1"].Text = "This is the Long Text";
//sheet.Range["E1"].Text = "This is the Long Text";
//sheet.Range["A2:A5"].Text = "This is the Long Text using Autofit Columns and Rows";
////AutoFit Applied to a Range
//sheet.Range["A1:D1"].AutofitColumns();
//sheet.Range["A2:A5"].AutofitRows();
////AutoFit applied to a Single Column
//sheet.AutofitColumn(5);
////AutoFit applied to a Single Row
//sheet.AutofitRow(1);
////Saving the workbook to disk.
//workbook.SaveAs("Sample.xls", ExcelSaveType.SaveAsXLS, Response, ExcelDownloadType.PromptDialog);
////No exception will be thrown if there are unsaved workbooks.
//excelEngine.ThrowNotSavedOnDestroy = false;
//excelEngine.Dispose();
}
/// <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);
}
