public bool SaveSPCCalcModelData(byte[] param)
{
bool bReturn = true;
try
{
BISTel.eSPC.Data.Server.Modeling.SPCModelData spcModelData = new BISTel.eSPC.Data.Server.Modeling.SPCModelData();
spcModelData.ParentSQLHandler = this;
base.BeginTrans();
bReturn = spcModelData.SaveSpecCalcData(param);
if (base.ErrorMessage.Length > 0)
{
this.RollBack();
return(false);
}
this.Commit();
if (bReturn)
{
LinkedList llstParam = new LinkedList();
llstParam.SetSerialData(param);
if (llstParam.Contains(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID))
{
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, llstParam[Definition.CONDITION_KEY_MODEL_CONFIG_RAWID].ToString());
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, llstParam[COLUMN.MAIN_YN].ToString());
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
//수정했을 경우 Server로 변경에 대한 Inform을 준다.
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
}
}
catch (Exception ex)
{
BISTel.PeakPerformance.Client.CommonLibrary.LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex);
base.RollBack();
return(false);
}
finally
{
this.Close();
}
return(bReturn);
}
public DataSet DeleteSPCModelConfig(byte[] param)
{
DataSet dsReturn = new DataSet();
try
{
LinkedList llstParam = new LinkedList();
llstParam.SetSerialData(param);
ArrayList arrTemp = (ArrayList)llstParam[Definition.CONDITION_KEY_MODEL_CONFIG_RAWID];
BISTel.eSPC.Data.Server.Modeling.SPCModelData spcModelData = new BISTel.eSPC.Data.Server.Modeling.SPCModelData();
dsReturn = spcModelData.DeleteSPCModelConfig(param);
string sConfigRawID = "";
for (int i = 0; i < arrTemp.Count; i++)
{
sConfigRawID += ";" + arrTemp[i].ToString().Trim();
}
if (sConfigRawID.Length > 0)
{
sConfigRawID = sConfigRawID.Substring(1);
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_RAWID, _ComUtil.NVL(llstParam[Definition.CONDITION_KEY_MODEL_RAWID]));
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, sConfigRawID);
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "remove");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
}
catch
{
}
finally
{
}
return(dsReturn);
}
public bool SaveSPCModelSpecData(byte[] param)
{
bool bResult = true;
string sMainConfigRawID = "";
string sSubConfigRawID = "";
BISTel.eSPC.Data.Server.Modeling.SPCModelData spcModelData = new BISTel.eSPC.Data.Server.Modeling.SPCModelData();
try
{
bResult = spcModelData.SaveSPCModelSpecData(param);
if (bResult)
{
LinkedList llstParam = new LinkedList();
llstParam.SetSerialData(param);
ArrayList arrRawID = new ArrayList();
ArrayList arrMainYN = new ArrayList();
if (llstParam.Contains(COLUMN.RAWID))
{
arrRawID = (ArrayList)llstParam[COLUMN.RAWID];
}
if (llstParam.Contains(COLUMN.MAIN_YN))
{
arrMainYN = (ArrayList)llstParam[COLUMN.MAIN_YN];
}
if (arrRawID.Count == arrMainYN.Count)
{
for (int i = 0; i < arrMainYN.Count; i++)
{
if (arrMainYN[i].ToString() == Definition.VARIABLE_Y)
{
sMainConfigRawID += ";" + arrRawID[i].ToString();
}
else
{
sSubConfigRawID += ";" + arrRawID[i].ToString();
}
}
}
if (sMainConfigRawID.Length > 0)
{
sMainConfigRawID = sMainConfigRawID.Substring(1);
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, sMainConfigRawID);
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_Y);
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
if (sSubConfigRawID.Length > 0)
{
sSubConfigRawID = sSubConfigRawID.Substring(1);
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, sSubConfigRawID);
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
}
}
catch (Exception ex)
{
BISTel.PeakPerformance.Client.CommonLibrary.LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex);
}
return(bResult);
}
public DataSet CopyModelInfo(byte[] param)
{
DataSet dsReturn = null;
try
{
BISTel.eSPC.Data.Server.Modeling.SPCModelData spcModelData = new BISTel.eSPC.Data.Server.Modeling.SPCModelData();
spcModelData.ParentSQLHandler = this;
LinkedList llstTotalConfigInfo = new LinkedList();
LinkedList llstParam = null;
llstTotalConfigInfo.SetSerialData(param);
ArrayList arrMainTargetRawid = new ArrayList();
ArrayList arrSubTargetRawid = new ArrayList();
base.BeginTrans();
for (int i = 0; i < llstTotalConfigInfo.Count; i++)
{
llstParam = (LinkedList)llstTotalConfigInfo[i];
string sUserID = llstParam[Definition.DynamicCondition_Condition_key.USER_ID].ToString();
string sourceConfigRawID = llstParam[Definition.COPY_MODEL.SOURCE_MODEL_CONFIG_RAWID].ToString();
string targetConfigRawID = llstParam[Definition.COPY_MODEL.TARGET_MODEL_CONFIG_RAWID].ToString();
string mainYN = llstParam[Definition.CONDITION_KEY_MAIN_YN].ToString();
if (mainYN == "Y")
{
arrMainTargetRawid.Add(targetConfigRawID);
}
else
{
arrSubTargetRawid.Add(targetConfigRawID);
}
bool hasSubconfigs = Convert.ToBoolean(llstParam[Definition.CONDITION_KEY_HAS_SUBCONFIG].ToString());
dsReturn = spcModelData.CopyModelInfo(llstParam);
if (base.ErrorMessage.Length > 0 || DSUtil.GetResultSucceed(dsReturn) == 0)
{
this.RollBack();
return(dsReturn);
}
}
//modified by enkim Gemini P3-3816
//string subConfigRawIDs = "";
//if (mainYN.Equals(Definition.VARIABLE_Y) && hasSubconfigs)
//{
// dsReturn = spcModelData.ModifySPCSubModelForCopy(llstParam, ref subConfigRawIDs);
// if (subConfigRawIDs.Length > 0)
// {
// subConfigRawIDs = subConfigRawIDs.Substring(1);
// }
//}
//modified end
this.Commit();
if (arrMainTargetRawid.Count > 0)
{
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, arrMainTargetRawid[0].ToString());
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, "Y");
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
//수정했을 경우 Server로 변경에 대한 Inform을 준다.
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
if (arrSubTargetRawid.Count > 0)
{
string subConfigRawIDs = "";
for (int i = 0; i < arrSubTargetRawid.Count; i++)
{
subConfigRawIDs += ";" + arrSubTargetRawid[i].ToString();
}
if (subConfigRawIDs.Length > 0)
{
subConfigRawIDs = subConfigRawIDs.Substring(1);
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, subConfigRawIDs);
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, "N");
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
//수정했을 경우 Server로 변경에 대한 Inform을 준다.
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
}
//modified by enkim Gemini P3-3816
//if (mainYN.Equals(Definition.VARIABLE_Y) && hasSubconfigs)
//{
// llstCondition = new LinkedList();
// llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, subConfigRawIDs);
// llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
// llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
// //수정했을 경우 Server로 변경에 대한 Inform을 준다.
// msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
// msgBussiness.SetSPCModel(llstCondition.GetSerialData());
//}
//modified end
}
catch (Exception ex)
{
BISTel.PeakPerformance.Client.CommonLibrary.LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex);
base.RollBack();
}
finally
{
this.Close();
}
return(dsReturn);
}
public DataSet SaveSPCModelData(byte[] param)
{
string configRawID = "";
DataSet dsReturn = new DataSet();
bool _isGroup = false;
string comment = "";
string changedItems = "";
string groupRawid = null;
try
{
BISTel.eSPC.Data.Server.Modeling.SPCModelData spcModelData = new BISTel.eSPC.Data.Server.Modeling.SPCModelData();
spcModelData.ParentSQLHandler = this;
LinkedList llstParam = new LinkedList();
llstParam.SetSerialData(param);
bool useComma = false;
if (llstParam[Definition.VARIABLE_USE_COMMA] is bool)
{
useComma = (bool)llstParam[Definition.VARIABLE_USE_COMMA];
}
string sUserID = llstParam[Definition.CONDITION_KEY_USER_ID].ToString();
ConfigMode configMode = (ConfigMode)llstParam[Definition.CONDITION_KEY_CONFIG_MODE];
DataTable dtModel = (DataTable)llstParam[TABLE.MODEL_MST_SPC];
DataTable dtConfig = (DataTable)llstParam[TABLE.MODEL_CONFIG_MST_SPC];
DataTable dtConfigOpt = (DataTable)llstParam[TABLE.MODEL_CONFIG_OPT_MST_SPC];
DataTable dtContext = (DataTable)llstParam[TABLE.MODEL_CONTEXT_MST_SPC];
DataTable dtRule = (DataTable)llstParam[TABLE.MODEL_RULE_MST_SPC];
DataTable dtRuleOpt = (DataTable)llstParam[TABLE.MODEL_RULE_OPT_MST_SPC];
DataTable dtAutoCalc = (DataTable)llstParam[TABLE.MODEL_AUTOCALC_MST_SPC];
string _sMainYN = "";
string sConfigRawid = "";
string srefConfigRawid = "";
bool bOnlyMain = false;
bool bOnlyMainGroup = false;
if (llstParam[Definition.CONDITION_KEY_MAIN_YN] != null)
{
_sMainYN = llstParam[Definition.CONDITION_KEY_MAIN_YN].ToString();
}
bool _hasSubconfigs = Convert.ToBoolean(llstParam[Definition.CONDITION_KEY_HAS_SUBCONFIG].ToString());
if (llstParam.Contains(COLUMN.GROUP_YN))
{
_isGroup = true;
}
if (llstParam.Contains(COLUMN.GROUP_RAWID))
{
groupRawid = llstParam[COLUMN.GROUP_RAWID].ToString();
}
base.BeginTrans();
switch (configMode)
{
case ConfigMode.CREATE_MAIN:
case ConfigMode.SAVE_AS:
case ConfigMode.CREATE_MAIN_FROM:
dsReturn = spcModelData.CreateSPCModel(configMode, sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, ref srefConfigRawid, groupRawid, useComma);
break;
case ConfigMode.CREATE_SUB:
dsReturn = spcModelData.CreateSPCModel(configMode, sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, ref srefConfigRawid, groupRawid, useComma);
break;
case ConfigMode.MODIFY:
case ConfigMode.ROLLBACK:
if (llstParam.Contains(COLUMN.SAVE_COMMENT))
{
comment = llstParam[COLUMN.SAVE_COMMENT].ToString();
}
if (llstParam.Contains(COLUMN.CHANGED_ITEMS))
{
changedItems = llstParam[COLUMN.CHANGED_ITEMS].ToString();
}
List <string> lstChangedMasterColList = (List <string>)llstParam["CHANGED_MASTER_COL_LIST"];
dsReturn = spcModelData.ModifySPCModel(sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, lstChangedMasterColList, comment, changedItems, groupRawid, useComma);
break;
case ConfigMode.DEFAULT:
dsReturn = spcModelData.SaveDefaultConfig(sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, useComma);
break;
}
if (base.ErrorMessage.Length > 0 || DSUtil.GetResultSucceed(dsReturn) == 0)
{
this.RollBack();
return(dsReturn);
}
if (configMode.Equals(ConfigMode.MODIFY) || configMode.Equals(ConfigMode.ROLLBACK))
{
configRawID = dtConfig.Rows[0][COLUMN.RAWID].ToString();
}
if ((configMode.Equals(ConfigMode.MODIFY) || configMode.Equals(ConfigMode.ROLLBACK)) && _sMainYN.Equals(Definition.VARIABLE_Y) &&
_hasSubconfigs)
{
if (llstParam.Contains("ONLY_MAIN"))
{
if (llstParam["ONLY_MAIN"].ToString() == Definition.VARIABLE_Y)
{
bOnlyMain = true;
}
}
if (llstParam.Contains("ONLY_MAIN_GROUP"))
{
if (llstParam["ONLY_MAIN_GROUP"].ToString() == Definition.VARIABLE_Y)
{
bOnlyMainGroup = true;
}
}
if (!bOnlyMain)
{
dsReturn = spcModelData.ModifySPCSubModel(configRawID, dtRule, dtRuleOpt, sUserID, ref sConfigRawid);
if (sConfigRawid.Length > 0)
{
sConfigRawid = sConfigRawid.Substring(1);
}
}
dsReturn = spcModelData.ModifySPCSubModelContext(configRawID, dtContext, sUserID, bOnlyMainGroup, groupRawid);
if (_isGroup) //기존 Sub 전체 삭제.
{
bool bResult = spcModelData.DeleteSPCModelConfig(sConfigRawid);
if (!bResult)
{
base.RollBack();
}
}
}
this.Commit();
// Increase version
CommonData commonData = new CommonData();
switch (configMode)
{
case ConfigMode.CREATE_MAIN:
case ConfigMode.CREATE_MAIN_FROM:
case ConfigMode.SAVE_AS:
case ConfigMode.CREATE_SUB:
this.BeginTrans();
foreach (string query in commonData.GetIncreaseVersionQuery(srefConfigRawid.ToString()))
{
this.Query(query);
}
this.Commit();
break;
case ConfigMode.MODIFY:
case ConfigMode.ROLLBACK:
this.BeginTrans();
foreach (DataRow dr in dtConfig.Rows)
{
foreach (string query in commonData.GetIncreaseVersionQuery(dr[COLUMN.RAWID].ToString()))
{
this.Query(query);
}
}
if (!bOnlyMain && _sMainYN.Equals(Definition.VARIABLE_Y) && _hasSubconfigs)
{
//modified by enkim 2012.05.18 SPC-739
//IncreaseVersionOfSubConfigs(sConfigRawid.Split(';'));
bool bResultTmp = spcModelData.IncreaseVersionOfSubConfigs(configRawID);
//modified end SPC-739
}
this.Commit();
break;
}
if (configMode.Equals(ConfigMode.MODIFY) || configMode.Equals(ConfigMode.ROLLBACK))
{
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, configRawID);
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, _sMainYN);
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
//수정했을 경우 Server로 변경에 대한 Inform을 준다.
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
if ((configMode.Equals(ConfigMode.MODIFY) || configMode.Equals(ConfigMode.ROLLBACK)) && _sMainYN.Equals(Definition.VARIABLE_Y) && _hasSubconfigs)
{
if (!_isGroup)
{
if (!bOnlyMain)
{
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, sConfigRawid);
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
//수정했을 경우 Server로 변경에 대한 Inform을 준다.
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
}
else
{
if (!bOnlyMain)
{
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, sConfigRawid);
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "remove");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
//수정했을 경우 Server로 변경에 대한 Inform을 준다.
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
}
}
if (configMode.Equals(ConfigMode.CREATE_MAIN) || configMode.Equals(ConfigMode.SAVE_AS) || configMode.Equals(ConfigMode.CREATE_MAIN_FROM))
{
if (srefConfigRawid.Length > 0)
{
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, srefConfigRawid);
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_Y);
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "add");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
}
if (configMode.Equals(ConfigMode.CREATE_SUB))
{
if (srefConfigRawid.Length > 0)
{
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, srefConfigRawid);
llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N);
llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "add");
llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[COLUMN.USER_ID].ToString());
Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness();
msgBussiness.SetSPCModel(llstCondition.GetSerialData());
}
}
}
catch (Exception ex)
{
BISTel.PeakPerformance.Client.CommonLibrary.LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex);
base.RollBack();
}
finally
{
this.Close();
}
return(dsReturn);
}