/// <summary>
/// 建立变量（Param）与事件（Event）间的联系
/// </summary>
private void LinkParamEvent(){
try
{
int paNum = m_paramtable.ParamsNum;
for (int i = 0; i < paNum; i++)
{
CParam pa = m_paramtable[i];
foreach (string strEv in pa.linkEvents)
{
//如果CParam关联的Event不存在，则异常
if (!m_events.ContainsKey(strEv))
throw new Exception("Event " + strEv + " is not exist");
//如果pa关联的Event暂时未添加到m_relationEP中
if (!m_relationEP.ContainsKey(strEv))
{
m_relationEP.Add(strEv, new List<string>());
}
//建立事件（strEv）与变量（pa）之间的联系
m_relationEP[strEv].Add(pa.name);
m_events[strEv].paramlist[pa.name] = pa;
m_events[strEv].paramsApp_res[pa.name] = pa.linkEventsApp_res[strEv];
}
}
}
catch(Exception e)
{
Trace.WriteLine(e.Message);
}
}
private void BtnQryManhole_Click(object sender, EventArgs e)
{
CHeader Header = new CHeader(UserInfo.UserID, "A1002A", "XtraPLH", "00000", "");
DataTable Data = new DataTable("PlhInfo");
DataColumn colProjectCd = new DataColumn("project_cd", typeof(string));
Data.Columns.Add(colProjectCd);
DataRow Dr = Data.NewRow();
Dr["project_cd"] = ProjectInfo.ProjectCD;
Data.Rows.Add(Dr);
//Project 정보를 담은 ...
CParam Param = new CParam(Data);
using (DataSet ds = CTransfer.QryData(Header, Param.GetDataSet()))
{
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
DataTable rcvData = ds.Tables["Table"];
gridControl1.DataSource = rcvData;
}
}
/// <summary>
/// 添加一个变量
/// </summary>
/// <param name="par">添加的新变量</param>
public void AppendParam(CParam par){
try
{
//1. 添加变量到变量列表
m_paramtable.AppendParam(par);
//2. 建立变量与事件之间的联系
foreach(string strev in par.linkEvents)
{
//2.1 判断包含变量的事件是否存在
if (!m_events.ContainsKey(strev))
throw new Exception("Event " + strev + " is not exist");
//2.2 如果par关联的事件还未添加到m_relationEP
if (!m_relationEP.ContainsKey(strev))
{
m_relationEP.Add(strev, new List<string>());
}
//2.3 建立par与事件之间的关联
m_relationEP[strev].Add(par.name);
}
}
catch(Exception e)
{
Trace.WriteLine(e.Message);
}
}
/// <summary>
/// 프로젝트 리스트를 조회한다.
/// </summary>
private void QrySectionList()
{
CHeader Header = new CHeader(UserInfo.UserID, "A0110A", "XtraQrySection", "00000", "");
DataTable data = new DataTable("section_list");
DataColumn colSectionGroupCd = new DataColumn("section_group_cd", typeof(string));
DataColumn colSectionGroupNm = new DataColumn("section_group_nm", typeof(string));
data.Columns.Add(colSectionGroupCd);
data.Columns.Add(colSectionGroupNm);
DataRow Dr = data.NewRow();
Dr["section_group_cd"] = edtGroupCd.Text;
Dr["section_group_nm"] = edtGroupNm.Text;
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
DataTable Data = ds.Tables["Table"];
gridControl1.DataSource = Data;
}
/// <summary>
/// 자재및 장비 TreeList 정보를 조회한다.
/// </summary>
private void QryData()
{
CHeader Header = new CHeader(UserInfo.UserID, "A0111D", "XtraQryProject", "00000", "");
DataTable data = new DataTable("item_list");
DataColumn colItemParent = new DataColumn("item_parent", typeof(string));
data.Columns.Add(colItemParent);
DataRow Dr = data.NewRow();
Dr["item_parent"] = "test";
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
DataTable Data = ds.Tables["Table"];
treeList1.DataSource = Data;
}
/// <summary>
/// 대분류 정보를 lookup Editor에 출력
/// </summary>
private void LoadMngrGb()
{
CHeader Header = new CHeader(UserInfo.UserID, "A0111A", "XtraMngrTp", "00000", "");
DataTable data = new DataTable("section_list");
DataColumn colSectionGroupNm = new DataColumn("mngr_gb_nm", typeof(string));
data.Columns.Add(colSectionGroupNm);
DataRow Dr = data.NewRow();
Dr["mngr_gb_nm"] = "";
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
DataTable Data = ds.Tables["Table"];
lookUpMngrGb.Properties.DataSource = Data;
}
private void QrySectionList()
{
try
{
CHeader Header = new CHeader(UserInfo, "A0120A", "XtraQrySection", "00000", "");
DataTable data = new DataTable("section_list");
DataColumn colSectionGroupCd = new DataColumn("section_group_cd", typeof(string));
data.Columns.Add(colSectionGroupCd);
DataRow Dr = data.NewRow();
Dr["section_group_cd"] = lookupGroup.GetColumnValue("section_group_cd");
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
DataTable Data = ds.Tables["Table"];
gridControl1.DataSource = Data;
}
catch (Exception ex)
{
throw ex;
}
}
private void AddTreeNode(string strTreeNode)
{
try
{
CHeader Header = new CHeader(UserInfo.UserID, "A0111F", "XtraItemDlg", "00000", "");
DataTable data = new DataTable("item_list");
DataColumn colItemParent = new DataColumn("parent", typeof(string));
DataColumn colItemitem = new DataColumn("item_name", typeof(string));
data.Columns.Add(colItemParent);
data.Columns.Add(colItemitem);
DataRow Dr = data.NewRow();
Dr["parent"] = treeList1.FocusedNode["item_key"].ToString();
Dr["item_name"] = strTreeNode;
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
if (Dt.Rows[0]["err_cd"].ToString() != "00000")
{
XtraMessageBox.Show("서버 저장중 오류가 발생했습니다.재 조회후 다시 처리 합시다.");
return;
}
else
{
/*
* 정상처리 된 후 TreeNode를 추가한다.
*/
QryData();
}
}
catch (Exception err)
{
string strMsg = string.Format("{0}[{1}]", "서버 저장중 오류가 발생했습니다. 재 조회후 다시 처리 합시다.", err.Message.ToString());
XtraMessageBox.Show(strMsg);
return;
}
}
/// <summary>
/// 신규 중분류를 등록한다.
/// </summary>
private void InsertSection()
{
try
{
CHeader Header = new CHeader(UserInfo.UserID, "A0113B", "XtraMngrCd", "00000", "");
DataTable data = new DataTable("section_list");
DataColumn colSectionMngrGb = new DataColumn("mngr_gb", typeof(Int32));
DataColumn colSectionMngrTp = new DataColumn("mngr_tp", typeof(Int32));
DataColumn colSectionMngrCdNm = new DataColumn("mngr_cd_nm", typeof(string));
DataColumn colSectionUnitTp = new DataColumn("unit_tp", typeof(string));
DataColumn colSectionUnit = new DataColumn("unit", typeof(double));
data.Columns.Add(colSectionMngrGb);
data.Columns.Add(colSectionMngrTp);
data.Columns.Add(colSectionMngrCdNm);
data.Columns.Add(colSectionUnitTp);
data.Columns.Add(colSectionUnit);
DataRow Dr = data.NewRow();
//Dr.ItemArray = gridView1.GetFocusedDataRow().ItemArray.Clone() as object[];
Dr["mngr_gb"] = gridView1.GetFocusedDataRow()["mngr_gb"];
Dr["mngr_tp"] = gridView1.GetFocusedDataRow()["mngr_tp"];
Dr["mngr_cd_nm"] = gridView1.GetFocusedDataRow()["mngr_cd_nm"];
Dr["unit_tp"] = gridView1.GetFocusedDataRow()["unit_tp"];
Dr["unit"] = gridView1.GetFocusedDataRow()["unit"];
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.InsertData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
if (itemErrCd.Caption == "00000")
{
//DataTable dt1 = ds.Tables["Table"];
//edtGroupCd.Text = dt1.Rows[0]["cnt"].ToString();
QrySectionList();
}
}
catch (Exception ex)
{
throw ex;
}
//DataTable Data = ds.Tables["Table"];
//gridControl1.DataSource = Data;
}
private void btnSavePipeTool_Click(object sender, EventArgs e)
{
if (m_strFileName.Trim() == "")
{
XtraMessageBox.Show("PIPE TOOLS 파일이 없습니다.");
return;
}
CPipetools pipetoolsData = new CPipetools(ProjectInfo.ProjectCD, Path.GetFileNameWithoutExtension(m_strFileName), sheetPipeTools);
pipetoolsData.LoadDataTools();
try
{
pipetoolsData.m_dt_line.TableName = "pipetool";
pipetoolsData.m_dt_지장물.TableName = "pipetool_g";
pipetoolsData.m_dt_포장.TableName = "pipetool_pavement";
}
catch (Exception ex)
{
itemErrCd.Caption = "ERROR";
itemErrMsg.Caption = ex.Message;
throw;
}
CHeader Header = new CHeader(UserInfo.UserID, "A1301A", "XtraPlH", "00000", "");
//Project 정보를 담은 ...
CParam Param = new CParam(pipetoolsData.m_dt_line);
Param.AddDataTable(pipetoolsData.m_dt_지장물);
Param.AddDataTable(pipetoolsData.m_dt_포장);
using (DataSet ds = CTransfer.InsertData(Header, Param.GetDataSet()))
{
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
if (Dt.Rows[0]["err_cd"].ToString() == "00000")
{
QryMaxerInput();
}
}
}
public string get_equip_info(string wfe_id)
{
WorkFlows wfsd = new WorkFlows();
Mission db_miss = wfsd.GetWFEntityMissions(Convert.ToInt16(wfe_id)).Last();//获取该实体最后一个任务
WorkFlow_Entity wfe = wfsd.GetWorkFlowEntity(Convert.ToInt16(wfe_id));
//CWorkFlow wf = new CWorkFlow();
WorkFlows wfs = new WorkFlows();
UI_MISSION ui = new UI_MISSION();
ui.WE_Entity_Ser = wfe.WE_Ser;
ui.WE_Event_Desc = db_miss.Miss_Desc;
ui.WE_Event_Name = db_miss.Event_Name;
ui.WE_Name = db_miss.Miss_Name;
ui.Mission_Url = ""; //历史任务的页面至空
ui.Miss_Id = db_miss.Miss_Id;
List <Mission_Param> mis_pars = wfsd.GetMissParams(db_miss.Miss_Id); //获取当前任务参数
foreach (var par in mis_pars)
{
CParam cp = new CParam();
cp.type = par.Param_Type;
cp.name = par.Param_Name;
cp.value = par.Param_Value;
cp.description = par.Param_Desc;
ui.Miss_Params[cp.name] = cp.value;
ui.Miss_ParamsDesc[cp.name] = cp.description;
}
List <EquipListModel> EquipList = Zz_Equips(ui.Miss_Params["Zz_Name"].ToString());
List <object> miss_obj = new List <object>();
int i = 1;
foreach (var item in EquipList)
{
object m = new
{
index = i,
Equip_Id = item.Equip_Id,
Equip_GyCode = item.Equip_GyCode,
Equip_Code = item.Equip_Code,
Equip_Type = item.Equip_Type,
Equip_Specialty = item.Equip_Specialty,
Equip_ABCMark = item.Equip_ABCMark
};
miss_obj.Add(m);
i++;
}
string str = JsonConvert.SerializeObject(miss_obj);
return("{" + "\"data\": " + str + "}");
}
private void LoadMngrTp()
{
if (lookUpMngrGb.Properties.DataSource is null)
{
itemErrCd.Caption = "ERROR";
itemErrMsg.Caption = "대분류 선택을 확인하세요 (null)";
return;
}
if (lookUpMngrGb.Text == "NO DATA")
{
itemErrCd.Caption = "ERROR";
itemErrMsg.Caption = "대분류 선택을 확인하세요 (no data)";
return;
}
CHeader Header = new CHeader(UserInfo.UserID, "A0112A", "XtraMngrCd", "00000", "");
DataTable data = new DataTable("section_list");
DataColumn colMngrGb = new DataColumn("mngr_gb", typeof(Int32));
DataColumn colMngrTpNm = new DataColumn("mngr_tp_nm", typeof(string));
data.Columns.Add(colMngrGb);
data.Columns.Add(colMngrTpNm);
DataRow Dr = data.NewRow();
Dr["mngr_gb"] = Convert.ToInt32(lookUpMngrGb.GetColumnValue("mngr_gb").ToString());
Dr["mngr_tp_nm"] = "";
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
DataTable Data = ds.Tables["Table"];
lookUpMngrTp.Properties.DataSource = Data;
}
private void InsertSection()
{
try
{
CHeader Header = new CHeader(UserInfo.UserID, "A0110B", "XtraQrySection", "00000", "");
DataTable data = new DataTable("section_list");
DataColumn colSectionGroupCd = new DataColumn("section_group_cd", typeof(string));
DataColumn colSectionGroupNm = new DataColumn("section_group_nm", typeof(string));
data.Columns.Add(colSectionGroupCd);
data.Columns.Add(colSectionGroupNm);
DataRow Dr = data.NewRow();
Dr.ItemArray = gridView1.GetFocusedDataRow().ItemArray.Clone() as object[];
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.InsertData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
if (itemErrCd.Caption == "00000")
{
DataTable dt1 = ds.Tables["Table"];
edtGroupCd.Text = dt1.Rows[0]["cnt"].ToString();
QrySectionList();
}
}
catch (Exception ex)
{
throw ex;
}
//DataTable Data = ds.Tables["Table"];
//gridControl1.DataSource = Data;
}
/// <summary>
/// 获取某一工作流实体的历史任务
/// </summary>
/// <param name="entity_id">工作流实体ID</param>
/// <returns></returns>
public static List <UI_MISSION> GetHistoryMissions(int entity_id)
{
List <UI_MISSION> his_miss = new List <UI_MISSION>();
WorkFlows wfs = new WorkFlows();
List <Mission> db_miss = wfs.GetWFEntityMissions(entity_id);
WorkFlow_Entity wfe = wfs.GetWorkFlowEntity(entity_id);
//恢复工作流实体
CWorkFlow wf = new CWorkFlow();
XmlDocument doc = new XmlDocument();
doc.LoadXml(Encoding.Default.GetString(wfe.WE_Binary));
wf.EntityID = wfe.WE_Id;
wf.InstFromXmlNode(doc.DocumentElement);
foreach (var mi in db_miss)
{
UI_MISSION ui_mi = new UI_MISSION();
ui_mi.WE_Entity_Id = entity_id;
ui_mi.WE_Entity_Ser = wfe.WE_Ser;
ui_mi.WE_Event_Desc = mi.Miss_Desc;
ui_mi.WE_Event_Name = mi.Event_Name;
ui_mi.WE_Name = mi.Miss_Name;
ui_mi.Mission_Url = ""; //历史任务的页面至空
ui_mi.Miss_Id = mi.Miss_Id;
List <Mission_Param> mis_pars = wfs.GetMissParams(mi.Miss_Id);
foreach (var par in mis_pars)
{
CParam cp = new CParam();
cp.type = par.Param_Type;
cp.name = par.Param_Name;
cp.value = par.Param_Value;
cp.description = par.Param_Desc;
ui_mi.Miss_Params[cp.name] = cp.value;
ui_mi.Miss_ParamsAppRes[cp.name] = wf.paramstable[cp.name].linkEventsApp_res[ui_mi.WE_Event_Name];
ui_mi.Miss_ParamsDesc[cp.name] = cp.description;//xwm modified
}
his_miss.Add(ui_mi);
}
return(his_miss);
}
/// <summary>
/// 프로젝트 리스트를 조회한다.
/// </summary>
private void QrySectionList()
{
try
{
CHeader Header = new CHeader(UserInfo.UserID, "A0113A", "XtraMngrCd", "00000", "");
DataTable data = new DataTable("section_list");
DataColumn colMngrGb = new DataColumn("mngr_gb", typeof(Int32));
DataColumn colMngrTp = new DataColumn("mngr_tp", typeof(Int32));
DataColumn colMngrCdNm = new DataColumn("mngr_cd_nm", typeof(string));
data.Columns.Add(colMngrGb);
data.Columns.Add(colMngrTp);
data.Columns.Add(colMngrCdNm);
DataRow Dr = data.NewRow();
Dr["mngr_gb"] = Convert.ToInt32(lookUpMngrGb.GetColumnValue("mngr_gb").ToString());
Dr["mngr_tp"] = Convert.ToInt32(lookUpMngrTp.GetColumnValue("mngr_tp").ToString());
Dr["mngr_cd_nm"] = edtMngrCdNm.Text;
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
DataTable Data = ds.Tables["Table"];
gridControl1.DataSource = Data;
}
catch (Exception ex)
{
itemErrCd.Caption = "ERROR";
itemErrMsg.Caption = ex.Message;
}
}
private void QryMassCalc()
{
if (xtraTabControl2.SelectedTabPage.Text == "토적표")
{
CHeader Header = new CHeader(UserInfo.UserID, "A1003A", "XtraPLH", "00000", "");
DataTable Data = new DataTable("PlhInfo");
DataColumn colProjectCd = new DataColumn("project_cd", typeof(string));
Data.Columns.Add(colProjectCd);
DataRow Dr = Data.NewRow();
Dr["project_cd"] = ProjectInfo.ProjectCD;
Data.Rows.Add(Dr);
//Project 정보를 담은 ...
CParam Param = new CParam(Data);
using (DataSet ds = CTransfer.QryData(Header, Param.GetDataSet()))
{
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
DataTable rcvData = ds.Tables["Table"];
gridControl3.DataSource = rcvData;
}
}
}
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
public static void Main()
{
const bool DEBUG = false;
CParam Param = new CParam();
int Choice = 0;
bool Result = false;
byte SavedColor = 7;
string OutputDir = CAbc.EMPTY;
string ScroogeDir = CAbc.EMPTY;
string ServerName = CAbc.EMPTY;
string DataBase = CAbc.EMPTY;
string LogFileName = CAbc.EMPTY;
string UnsolverBillsCmdText = CAbc.EMPTY;
int UnsolvedBillsExists = 0;
string[] Titles = { "ОТКРЫТИЕ ДНЯ", "ЗАКРЫТИЕ ДНЯ" };
string[] LogFileNames = { "dayopen.log", "dayclose.log" };
string NOW_STR = CCommon.StrD(CCommon.Today(), 10, 10).Substring(6)
+ CCommon.StrD(CCommon.Today(), 10, 10).Substring(2, 4)
+ CCommon.StrD(CCommon.Today(), 10, 10).Substring(0, 2);
Err.LogToConsole();
CConsole.Clear();
CCommon.Print(" Оболочка открытия и закрытия дня в `Скрудже`. Версия 3.13 от 02.10.2018г.", "");
if (DEBUG)
{
Mode = 1;
}
else
if (CCommon.IsEmpty(Param["Mode"]))
{
CCommon.Print("Не указан режим работы программы !");
}
else
{
switch (Param["Mode"].ToUpper())
{
case "OPEN": {
Mode = 1;
break;
}
case "CLOSE": {
Mode = 2;
break;
}
default: {
CCommon.Print("Неверно указан режим работы программы !");
break;
}
}
}
if ((Mode != 1) && (Mode != 2))
{
return;
}
if ((Mode == 2) && (!CCommon.DirExists("Z:\\")))
{
SavedColor = CConsole.BoxColor;
CConsole.BoxColor = CConsole.RED * 16 + CConsole.WHITE;
CConsole.ShowBox("", "Не подключен Z:\\", "");
CConsole.ClearKeyboard();
CConsole.ReadChar();
CConsole.BoxColor = SavedColor;
CConsole.Clear();
CConsole.ShowCursor();
}
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
// Запрос пользователю на ввод даты дня, который открывается или закрывается
while (DayDate == 0)
{
switch (Mode)
{
case 1: {
CCommon.Write("Какую дату открываем ? ( " + NOW_STR.Replace("/", ".") + " ) ");
break;
}
default: {
CCommon.Write("Какую дату закрываем ? ( " + NOW_STR.Replace("/", ".") + " ) ");
break;
}
}
Answer = CCommon.Input().Trim();
if (Answer == "")
{
DayDate = CCommon.Today();
}
else
{
DayDate = CCommon.GetDate(Answer);
}
}
// - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Scrooge2Config = new CScrooge2Config();
if (!Scrooge2Config.IsValid)
{
CCommon.Print(Scrooge2Config.ErrInfo);
return;
}
ScroogeDir = (string)Scrooge2Config["Root"];
OutputDir = (string)Scrooge2Config["Output"];
ServerName = (string)Scrooge2Config["Server"];
DataBase = (string)Scrooge2Config["DataBase"];
if (ScroogeDir == null)
{
CCommon.Print(" Не найдена переменная `Root` в настройках `Скрудж-2` ");
return;
}
if (ServerName == null)
{
CCommon.Print(" Не найдена переменная `Server` в настройках `Скрудж-2` ");
return;
}
if (DataBase == null)
{
CCommon.Print(" Не найдена переменная `Database` в настройках `Скрудж-2` ");
return;
}
CCommon.Print(" Беру настройки `Скрудж-2` здесь : " + ScroogeDir);
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
ConnectionString = "Server=" + ServerName
+ ";Database=" + DataBase
+ ";Integrated Security=TRUE;";
Connection = new CConnection(ConnectionString);
if (Connection.IsOpen())
{
CCommon.Print(" Сервер " + ServerName);
CCommon.Print(" База " + DataBase + CAbc.CRLF);
}
else
{
CCommon.Print(CAbc.CRLF + " Ошибка подключения к серверу !");
return;
}
System.Console.Title = " " + Titles[Mode - 1] + " | " + ServerName + "." + DataBase;
Command = new CCommand(Connection);
int IsFullAccess = ( int )CCommon.IsNull(Command.GetScalar(" select dbo.Fn_IsFullAccess( DEFAULT ) "), (int)0);
string InfNBU_OutPath = ( string )CCommon.IsNull(Command.GetScalar(" exec dbo.Mega_Day_Open;5 @Mode=2 ; "), (string)CAbc.EMPTY);
if (Mode == 2)
{
// Записываю в историю логин пользователя, который закрывает день
Command.Execute(" exec dbo.Mega_Day_Close;12 @DayDate = " + DayDate.ToString() + " , @UserCode = '" + UserCode + "' ");
// Проверка : имеются ли непроведенные документы ?
UnsolverBillsCmdText = " If Exists ( select 1 from dbo.Mega_SV_WaitingBills with (NoLock) where (DayDate=" + DayDate.ToString() + " ) and ((PermitFlag & 255 )!=255) and ((ProcessFlag & 3)!=3) ) select Convert(Integer,1) else select Convert(Integer,0) ";
UnsolvedBillsExists = ( int )CCommon.IsNull(Command.GetScalar(UnsolverBillsCmdText), (int)0);
}
Command.Close();
Connection.Close();
if (IsFullAccess < 1)
{
CCommon.Print(CAbc.CRLF + " Для работы программы пользователю необходим полный доступ в Скрудже !");
return;
}
InfNBU_OutPath = InfNBU_OutPath.Trim();
if (InfNBU_OutPath.Length == 0)
{
Err.Print(CCommon.Now().ToString() + "Ошибка определения выходного каталога для ОДБ." + CAbc.CRLF + CAbc.CRLF);
}
if (UnsolvedBillsExists == 1)
{
SavedColor = CConsole.BoxColor;
CConsole.BoxColor = CConsole.RED * 16 + CConsole.WHITE;
CConsole.ShowBox("", "Имеются непpоведенные документы", "", " Пpоведите их или удалите !", "");
CConsole.ClearKeyboard();
CConsole.ReadChar();
CConsole.BoxColor = SavedColor;
CConsole.Clear();
CConsole.ShowCursor();
}
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
if (OutputDir != null)
{
OutputDir = ScroogeDir + "\\" + OutputDir.Trim();
if (!CCommon.DirExists(OutputDir))
{
CCommon.MkDir(OutputDir);
}
if (CCommon.DirExists(OutputDir))
{
OutputDir += "\\" + CCommon.StrD(DayDate, 8, 8).Replace("/", "").Replace(".", "");
if (!CCommon.DirExists(OutputDir))
{
CCommon.MkDir(OutputDir);
}
if (!CCommon.DirExists(OutputDir))
{
OutputDir = ScroogeDir + "\\";
}
}
LogFileName = OutputDir + "\\" + LogFileNames[Mode - 1];
}
else
{
LogFileName = ScroogeDir + "\\" + LogFileNames[Mode - 1];
}
Err.LogTo(LogFileName);
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
// Основной цикл программы
do
{
System.Console.Title = " " + Titles[Mode - 1] + " " + CCommon.StrD(DayDate, 8, 8) + " | " + ServerName + "." + DataBase;
string[] FilesForMEDOC = CCommon.GetFileList(InfNBU_OutPath + "\\@*.*");
if (FilesForMEDOC != null)
{
if (FilesForMEDOC.Length > 0)
{
CConsole.GetBoxChoice(
""
, "В каталоге " + InfNBU_OutPath
, "Найдены файлы для налоговой @*.*"
, "Не забудьте их отправить!"
, ""
);
}
}
if (!LoadHistory(Mode))
{
Err.Print(CCommon.Now().ToString() + "Ошибка получения с сервера истории работы программы !");
}
Choice = CConsole.GetMenuChoice(MenuNames);
if (Choice > 0)
{
Err.Print(CCommon.Now().ToString() + "\t< " + MenuNames[Choice - 1] + " ( " + UserCode + " ) " + CAbc.CRLF);
if (!SaveHistory(Mode, Choice))
{
Err.Print("Ошибка сохранения на сервере истории работы программы !");
}
switch (MenuKinds[Choice - 1].Trim().ToUpper())
{
case "EXE.COPY": {
Result = StartExeCopy(
MacroSubstitution(MenuCommands[Choice - 1])
, MacroSubstitution(
DateSubstitution(
MenuParams[Choice - 1]
)
)
);
break;
}
case "SQL.CMD": {
Result = StartSqlCmd(
DateSubstitution(
MenuCommands[Choice - 1]
)
);
break;
}
case "SQL.RS": {
Result = StartSqlRS(
DateSubstitution(
MenuCommands[Choice - 1]
)
);
break;
}
case "SQL.ROUTINE": {
Result = StartSqlRoutine(
DateSubstitution(
MenuCommands[Choice - 1]
)
);
break;
}
case "EXC": {
Result = StartExc(ScroogeDir
, MacroSubstitution(
DateSubstitution(
MenuCommands[Choice - 1]
)
)
);
break;
}
case "URL.IE": {
Result = StartUrl(
DateSubstitution(
MenuCommands[Choice - 1]
)
);
break;
}
default: {
break;
}
}
Err.Print(CCommon.Now().ToString() + "\t " + MenuNames[Choice - 1] + " ( " + Result.ToString() + " ) > " + CAbc.CRLF);
}
} while (Choice != 0);
}
/// <summary>
/// 执行工作流创建工作
/// </summary>
protected override void __processing()
{
//Trace.WriteLine(string.Format("Creating WorkFlow {0}", m_workFlow.name));
foreach (var rp in (List <TimerCreateWFPa>)m_run_params)
{
if (rp.wf_timer != null)
{ //创建工作流
CWorkFlow wf = new CWorkFlow();
wf.InstFromXmlNode(m_workFlow.WriteToXmlNode());
//修改定时器
foreach (var ti in rp.wf_timer)
{
try
{
DateTime?dt = null;
if (ti.Value["ExactTime"] != "")
{
dt = DateTime.Parse(ti.Value["ExactTime"]);
}
wf.events[ti.Key].TimeOutProperty.SetAttribute("exact_time", dt);
TimeSpan?ts = null;
if (ti.Value["OffsetTime"] != "")
{
ts = TimeSpan.Parse(ti.Value["OffsetTime"]);
}
wf.events[ti.Key].TimeOutProperty.SetAttribute("offset_time", ts);
wf.events[ti.Key].TimeOutProperty.SetAttribute("time_start", ti.Value["TimeStart"]);
wf.events[ti.Key].TimeOutProperty.SetAttribute("action", ti.Value["Action"]);
wf.events[ti.Key].TimeOutProperty.SetAttribute("call_back", ti.Value["CallBack"]);
}
catch
{
continue;
}
}
//更新工作流变量
foreach (var pp in ((Dictionary <string, string>)(rp.wf_params)))
{
try
{
CParam pa = wf.paramstable[pp.Key];
pa.value = pp.Value;
if (pp.Key == "Zz_Name" || pp.Key == "ZzName" || pp.Key == "Pqname" || pp.Key == "Equip_GyCode")
{
wf.description = wf.description + "(" + pp.Value + ")";
}
}
catch
{
continue;
}
}
//创建工作流
wf.CreateEntityBySelf();
//
//回调
AfterCreate(wf.EntityID);
((List <int>)m_run_result).Add(wf.EntityID);
//工作流开始工作
wf.Start((IDictionary <string, string>)(rp.wf_record));
}
}
}
/// <summary>
/// Drop 하기 전에 이벤트를 처리한다.
/// 아이템 밑에 아이템은 불가
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void TreeList1_BeforeDropNode(object sender, DevExpress.XtraTreeList.BeforeDropNodeEventArgs e)
{
Console.WriteLine("aaaa");
if (treeList1.FindNodeByID(e.DestinationNode.Id)["node_tp"].ToString() == "2")
{
XtraMessageBox.Show("아이템은 하위 정보를 가질 수 없습니다. Node를 생성하세요");
e.Cancel = true;
return;
}
int parent_key, item_key;
try
{
parent_key = Convert.ToInt16(treeList1.FindNodeByID(e.DestinationNode.Id)["item_key"]);
item_key = Convert.ToInt16(treeList1.FindNodeByID(e.SourceNode.Id)["item_key"]);
CHeader Header = new CHeader(UserInfo.UserID, "A0111E", "XtraItemDlg", "00000", "");
DataTable data = new DataTable("item_list");
DataColumn colItemParent = new DataColumn("parent", typeof(int));
DataColumn colItemitem = new DataColumn("item_key", typeof(int));
data.Columns.Add(colItemParent);
data.Columns.Add(colItemitem);
DataRow Dr = data.NewRow();
Dr["parent"] = parent_key;
Dr["item_key"] = item_key;
data.Rows.Add(Dr);
CParam Param = new CParam(data);
DataSet ds = CTransfer.QryData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
if (Dt.Rows[0]["err_cd"].ToString() != "00000")
{
XtraMessageBox.Show("서버 저장중 오류가 발생했습니다.재 조회후 다시 처리 합시다.");
e.Cancel = true;
return;
}
}
catch (Exception err)
{
string strMsg = string.Format("{0}[{1}]", "서버 저장중 오류가 발생했습니다. 재 조회후 다시 처리 합시다.", err.Message.ToString());
XtraMessageBox.Show(strMsg);
e.Cancel = true;
return;
}
}
public string JdcConfirm_submitsignal(string json1)
{
JObject item = (JObject)JsonConvert.DeserializeObject(json1);
string flowname = item["Flow_Name"].ToString();
A6dot2Managment WM = new A6dot2Managment();
FileItem file = new FileItem();
int Equip_Id = 0;
Dictionary <string, string> signal = new Dictionary <string, string>();
//new input paras
signal["JdcConfirm_Result"] = item["JdcConfirm_Result"].ToString();
signal["JdcSupplement"] = item["JdcSupplement"].ToString();
//上传到File_Info
if (signal["JdcConfirm_Result"] == "通过")
{
//向File_Info里写文件信息
WorkFlows wfsd = new WorkFlows();
List <Mission> db_miss = wfsd.GetWFEntityMissions(Convert.ToInt32(flowname));//获取该实体的所有任务
for (int i = 0; i < db_miss.Count; i++)
{
if (db_miss[i].Miss_Desc == "可靠性工程师修改再上传")
{
UI_MISSION ui_mi = new UI_MISSION();
ui_mi.WE_Entity_Id = Convert.ToInt32(flowname);
ui_mi.WE_Event_Desc = db_miss[i].Miss_Desc;
ui_mi.WE_Event_Name = db_miss[i].Event_Name;
ui_mi.WE_Name = db_miss[i].Miss_Name;
ui_mi.Mission_Url = ""; //历史任务的页面至空
ui_mi.Miss_Id = db_miss[i].Miss_Id;
List <Mission_Param> mis_pars = wfsd.GetMissParams(db_miss[i].Miss_Id);//获取当前任务参数
foreach (var par in mis_pars)
{
CParam cp = new CParam();
cp.type = par.Param_Type;
cp.name = par.Param_Name;
cp.value = par.Param_Value;
cp.description = par.Param_Desc;
ui_mi.Miss_Params[cp.name] = cp.value;
// ui_mi.Miss_ParamsAppRes[cp.name] = wf.paramstable[cp.name].linkEventsApp_res[ui_mi.WE_Event_Name];
ui_mi.Miss_ParamsDesc[cp.name] = cp.description;//xwm modified
}
Equip_Id = WM.GetEquipIdBySbCode(ui_mi.Miss_Params["Equip_Code"].ToString());
string[] File_AllName = ui_mi.Miss_Params["ModifyOperInstruc"].ToString().Split(new char[] { '$' });
file.fileName = File_AllName[0];
file.fileNamePresent = File_AllName[1];
file.ext = Path.GetExtension(ui_mi.Miss_Params["ModifyOperInstruc"].ToString());
file.updateTime = DateTime.Now.ToString();
file.Mission_Id = db_miss[i].Miss_Id;
file.WfEntity_Id = Convert.ToInt32(flowname);
//file.Self_Catalog_Catalog_Id = 28;
file.path = @"/Upload/A3dot3";
bool res = WM.AddNewFile(28, file);
break;
}
}
//通过上传时间找到刚才上传到File_Info的文件的File_Id
int File_Id = WM.GetFileIdByUpdateTime(Convert.ToDateTime(file.updateTime));
//调用File.cs里的AttachtoEuip使连接表产生数据，让设备与操作规程勾连,需要用到Equip_Id和File_Id
bool les = WM.AttachtoEuipAndFile(File_Id, Equip_Id);
}
Dictionary <string, string> record = new Dictionary <string, string>();
record["username"] = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
record["time"] = DateTime.Now.ToString();
CWFEngine.SubmitSignal(Convert.ToInt32(flowname), signal, record);
return("/A6dot1/Index");
}
static void Main()
{
const bool DEBUG = false;
CParam Param = new CParam();
int Mode = 0; // 1=today, 2=chk_via; 3=chk_misc ; 4=copy for MStat
int PrevDate = 0;
int DayDate = __.Today();
int NextDate = __.Today() - 1;
string LogFileName = CAbc.EMPTY;
//string REQUEST_GET_BRC_CONNECTIONSTRING = " select 'Server='+Ltrim(Rtrim([Server]))+';Database='+Ltrim(Rtrim([Base]))+';Integrated Security=TRUE;' from dbo.sv_Branchs with (NoLock) where kind=3";
string REQUEST_GET_BRANCH_KIND = " select BranchKind from dbo.vMega_Common_MyBankInfo with ( NoLock ) ";
if (DEBUG)
{
Mode = 4;
}
else
{
switch (Param["MODE"].Trim().ToUpper())
{
case "TODAY": {
Mode = 1;
break;
}
case "CHK_VIA": {
Mode = 2;
break;
}
case "CHK_MISC": {
Mode = 3;
break;
}
case "COPY4MSTAT": {
Mode = 4;
break;
}
case "CHK_ISCARD": {
Chk_ISCard();
return;
}
default: {
Mode = 0;
break;
}
}
}
if (Param["DAYDATE"].Trim() != CAbc.EMPTY)
{
if (__.CInt(Param["DAYDATE"].Trim()) > 0)
{
DayDate = __.CInt(Param["DAYDATE"].Trim());
}
}
if (Param["NEXTDATE"].Trim() != CAbc.EMPTY)
{
if (__.CInt(Param["NEXTDATE"].Trim()) > 0)
{
NextDate = __.CInt(Param["NEXTDATE"].Trim());
}
}
if (Mode == 0)
{
__.Print("Не задан режим работы !");
return;
}
// -------------------------------------------------------
CScrooge2Config Scrooge2Config = new CScrooge2Config();
if (!Scrooge2Config.IsValid)
{
CCommon.Print(Scrooge2Config.ErrInfo);
return;
}
ScroogeDir = (string)Scrooge2Config["Root"].Trim();
DayOutDir = (string)Scrooge2Config["Output"].Trim();
ScroogeOut = ScroogeDir + "\\" + DayOutDir;
ServerName = (string)Scrooge2Config["Server"].Trim();
DataBase = (string)Scrooge2Config["DataBase"].Trim();
if (ScroogeDir == null)
{
CCommon.Print(" Не найдена переменная `Root` в настройках `Скрудж-2` ");
return;
}
if (ServerName == null)
{
CCommon.Print(" Не найдена переменная `Server` в настройках `Скрудж-2` ");
return;
}
if (DataBase == null)
{
CCommon.Print(" Не найдена переменная `Database` в настройках `Скрудж-2` ");
return;
}
CCommon.Print(" Беру настройки `Скрудж-2` здесь : " + ScroogeDir);
__.Print(" Сервер : " + ServerName);
__.Print(" База данных : " + DataBase + CAbc.CRLF);
ConnectionString = "Server=" + ServerName
+ ";Database=" + DataBase
+ ";Integrated Security=TRUE;"
;
// - - - - - - - - - - - - - - - - - - - - - - - - - - - -
if (DayOutDir != null)
{
DayOutDir = ScroogeDir + "\\" + DayOutDir.Trim();
if (!CCommon.DirExists(DayOutDir))
{
CCommon.MkDir(DayOutDir);
}
if (CCommon.DirExists(DayOutDir))
{
DayOutDir += "\\" + CCommon.StrD(DayDate, 8, 8).Replace("/", "").Replace(".", "");
if (!CCommon.DirExists(DayOutDir))
{
CCommon.MkDir(DayOutDir);
}
if (!CCommon.DirExists(DayOutDir))
{
DayOutDir = ScroogeDir + "\\";
}
}
LogFileName = DayOutDir + "\\" + "dayopen.log";
}
else
{
LogFileName = ScroogeDir + "\\" + "dayopen.log";
}
Err.LogTo(LogFileName);
// --------------------------------------------------------------
Connection = new CConnection(ConnectionString);
if (!Connection.IsOpen())
{
__.Print(" Ошибка подключения к серверу !");
return;
}
Command = new CCommand(Connection);
__.Print("Определяю режим банк\\филиал.");
int BranchKind = ( int )CCommon.IsNull(Command.GetScalar(REQUEST_GET_BRANCH_KIND), -1);
if (BranchKind == -1)
{
__.Print(" Ошибка выполнения команды на сервере !");
}
else
if (BranchKind != 0)
{
MainBank = false;
}
/* Выборка адреса БД БРЦ
* if ( MainBank ) {
* __.Print("Вычитываю адрес БД БРЦ.");
* BrcConnStr = ( string ) CCommon.IsNull( Command.GetScalar( REQUEST_GET_BRC_CONNECTIONSTRING ) , CAbc.EMPTY );
* }
*/
__.Print("Определяю дату предыдущего рабочего дня.");
PrevDate = ( int )CCommon.IsNull(Command.GetScalar(" exec dbo.Mega_Day_Close;2 " + DayDate.ToString()), (int)0);
if (PrevDate == 0)
{
__.Print(" Ошибка определения даты предыдущего рабочего дня !");
return;
}
else
{
__.Print("Предыдущий рабочий день - " + __.StrD(PrevDate, 8, 8));
}
switch (Mode)
{
case 4: {
CopyXML4Mebius(NextDate, "");
// CopyXML4Mebius( NextDate , "kv" ); // Это перекладывание киевских отчетов очетов отключено 18 июля 2019г.
return;
}
}
Command.Close();
Connection.Close();
// ------------------------------------------------------
switch (Mode)
{
case 1: {
Today(PrevDate, DayDate);
break;
}
case 2: {
Chk_VIA(PrevDate
, (__.Month(DayDate) != __.Month(PrevDate))
);
break;
}
case 3: {
Chk_Misc(PrevDate, DayDate);
break;
}
default: {
__.Print("Неверно указан режим работы !");
break;
}
}
}
static void Main()
{
const bool DEBUG = false
;
string ScroogeDir = CAbc.EMPTY
, ServerName = CAbc.EMPTY
, DataBase = CAbc.EMPTY
, ConnectionString = CAbc.EMPTY
;
int UserId = 0
, GroupId = 0
, BranchId = 0
, DateFrom = 0
, DateInto = 0
;
// - - - - - - - - - - - - - - - - - - - - - - - - - - - -
CParam Param = new CParam();
if (!DEBUG)
{
if (__.ParamCount() < 2)
{
PrintAboutMe();
return;
}
}
if (!CCommon.IsEmpty(Param["UserId"]))
{
UserId = __.CInt(Param["UserId"]);
}
if (!CCommon.IsEmpty(Param["GroupId"]))
{
UserId = __.CInt(Param["GroupId"]);
}
if (!CCommon.IsEmpty(Param["BranchId"]))
{
BranchId = __.CInt(Param["BranchId"]);
}
if (!CCommon.IsEmpty(Param["DateInto"]))
{
DateInto = __.GetDate(Param["DateInto"]);
}
if (!CCommon.IsEmpty(Param["DateFrom"]))
{
DateFrom = CCommon.GetDate(Param["DateFrom"]);
}
if ((DateFrom == 0) && (DateInto != 0))
{
DateFrom = DateInto;
}
if (DateInto == 0)
{
__.Print("Ошибка : не задана отчетная дата !");
return;
}
if ((BranchId == 0) && (UserId == 0) && (GroupId == 0))
{
__.Print("Ошибка : не заданы условия построения отчета !");
return;
}
// - - - - - - - - - - - - - - - - - - - - - - - - - - - -
CConsole.Color = CConsole.GRAY;
CConsole.Clear();
CCommon.Print("", " Построение выписок в формате Скрудж-2. Версия 1.01 от 13.10.2017г.", "");
CScrooge2Config Scrooge2Config = new CScrooge2Config();
if (!Scrooge2Config.IsValid)
{
CCommon.Print(Scrooge2Config.ErrInfo);
return;
}
ScroogeDir = (string)Scrooge2Config["Root"].Trim();
ServerName = (string)Scrooge2Config["Server"];
DataBase = (string)Scrooge2Config["DataBase"];
if (ScroogeDir == null)
{
CCommon.Print(" Не найдена переменная `Root` в настройках `Скрудж-2` ");
return;
}
if (ServerName == null)
{
CCommon.Print(" Не найдена переменная `Server` в настройках `Скрудж-2` ");
return;
}
if (DataBase == null)
{
CCommon.Print(" Не найдена переменная `Database` в настройках `Скрудж-2` ");
return;
}
CCommon.Print(" Беру настройки `Скрудж-2` здесь : " + ScroogeDir);
__.Print(" Сервер : " + ServerName);
__.Print(" База данных : " + DataBase + CAbc.CRLF);
ConnectionString = "Server=" + ServerName
+ ";Database=" + DataBase
+ ";Integrated Security=TRUE;";
// - - - - - - - - - - - - - - - - - - - - - - - - - - - -
System.Console.Title = " Выписка в формате Скрудж-2 | " + ServerName + "." + DataBase;
CSc2Extract Sc2Extract = new CSc2Extract();
if (Sc2Extract.Open(ConnectionString))
{
Sc2Extract.Path = __.GetCurDir();
Sc2Extract.DateFrom = DateFrom;
Sc2Extract.DateInto = DateInto;
Sc2Extract.CbMode = false;
Sc2Extract.CoolSum = false;
Sc2Extract.ApartFile = true;
Sc2Extract.NeedPrintMsg = true;
Sc2Extract.OverMode = 2;
Sc2Extract.BranchId = BranchId;
Sc2Extract.GroupId = GroupId;
Sc2Extract.UserId = UserId;
Sc2Extract.Build();
Sc2Extract.Close();
__.Print("Выписки построены.", "Для продолжения нажмите Enter...");
CConsole.ClearKeyboard();
CConsole.Flash();
CConsole.ReadChar();
}
}
static void Main()
{
string ScroogeDir = CAbc.EMPTY;
string ServerName = CAbc.EMPTY;
string DataBase = CAbc.EMPTY;
string ConnectionString = CAbc.EMPTY;
if (!DEBUG)
{
if (__.ParamCount() < 2)
{
PrintAboutMe();
return;
}
}
// - - - - - - - - - - - - - - - - - - - - - - - - - - - -
CCommon.Print("", " Построитель сальдовок для Фонда Гарантирования. Версия 1.03 от 12.03.2018г.", "");
CScrooge2Config Scrooge2Config = new CScrooge2Config();
if (!Scrooge2Config.IsValid)
{
CCommon.Print(Scrooge2Config.ErrInfo);
return;
}
ScroogeDir = (string)Scrooge2Config["Root"];
ServerName = (string)Scrooge2Config["Server"];
DataBase = (string)Scrooge2Config["DataBase"];
if (ScroogeDir == null)
{
CCommon.Print(" Не найдена переменная `Root` в настройках `Скрудж-2` ");
return;
}
if (ServerName == null)
{
CCommon.Print(" Не найдена переменная `Server` в настройках `Скрудж-2` ");
return;
}
if (DataBase == null)
{
CCommon.Print(" Не найдена переменная `Database` в настройках `Скрудж-2` ");
return;
}
CCommon.Print(" Беру настройки `Скрудж-2` здесь : " + ScroogeDir);
__.Print(" Сервер : " + ServerName);
__.Print(" База данных : " + DataBase + CAbc.CRLF);
ConnectionString = "Server=" + ServerName
+ ";Database=" + DataBase
+ ";Integrated Security=TRUE;"
;
Connection = new CConnection(ConnectionString);
if (!Connection.IsOpen())
{
CCommon.Print(" Ошибка подключения к источнику данных !");
return;
}
// - - - - - - - - - - - - - - - - - - - - - - - - - - - -
string TODAY_STR = CCommon.StrD(CCommon.Today(), 10, 10).Substring(6)
+ CCommon.StrD(CCommon.Today(), 10, 10).Substring(2, 4)
+ CCommon.StrD(CCommon.Today(), 10, 10).Substring(0, 2);
CParam Param = new CParam();
if (!__.IsEmpty(Param["DEBUG"]))
{
DEBUG = true;
}
bool NeedCorrection = ((Param["COR"]).ToUpper() == "Y");
string Date;
if (__.IsEmpty(Param["DATE"]))
{
Date = TODAY_STR;
}
else
{
Date = (Param["DATE"]);
}
string DateStr = Date.Trim().Replace(",", "").Replace(".", "").Replace("/", "");
if (!__.IsEmpty(Param["SEP"]))
{
switch (Param["SEP"].ToUpper()[0])
{
case 'C': {
MetaData[0] = 44;
break;
}
case 'S': {
MetaData[0] = 59;
break;
}
case 'T': {
MetaData[0] = 9;
break;
}
default: {
__.Print("Указан неизвестный разделитель полей.");
break;
}
}
}
if (__.IsEmpty(Param["MODE"]))
{
__.Print("Не указано `mode` - какой отчет строить .");
}
else
{
switch (Param["MODE"].ToUpper().Trim())
{
case "N63": {
WriteDataToCsv(
"exec dbo.Mega_Report_SaldoFGV;2 '" + Date
+ "','2903'"
+ (NeedCorrection ? ",1" : "")
, DateStr + "-63.csv"
);
break;
}
case "N64": {
WriteDataToCsv(
"exec dbo.Mega_Report_SaldoFGV;2 '" + Date
+ "','2620,2622,2625,2628,2630,2635,2638,2903,3320,3328,3330,3338,3340,3348'"
+ (NeedCorrection ? ",1" : "")
, DateStr + ".csv"
);
break;
}
case "N65": {
WriteDataToCsv(
"exec dbo.Mega_Report_SaldoFGV;2 '" + Date
+ "','2600,2602,2603,2604,2605,2608,2610,2615,2618'"
+ (NeedCorrection ? ",1" : "")
, DateStr + "-65.csv"
);
break;
}
default: {
__.Print("Указан неправильный код отчета.");
break;
}
}
}
if (DEBUG)
{
WriteDataToCsv(
"exec dbo.Mega_Report_SaldoFGV;2 '2015.12.01','2903',1"
, "20160801-63.csv"
);
}
Connection.Close();
__.Print("Готово.");
return;
}
public static CReturnData LoadData(CParam param)
{
CReturnData result = new CReturnData();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
if (!UserAcc.UserExpired())
{
result.incData = new cDataInc();
result.lstComplaint = new List <cComplaint>();
result.lstStatus = new List <sysGlobalClass.T_TEPI_Workflow>();
int nIndID = SystemFunction.GetIntNullToZero(param.sIndID);
int nOprtID = SystemFunction.GetIntNullToZero(param.sOprtID);
int nFacID = SystemFunction.GetIntNullToZero(param.sFacID);
result.hdfPRMS = SystemFunction.GetPermission_EPI_FROMS(nIndID, nFacID) + "";
string sYear = param.sYear;
var itemPrdInc = db.mTProductIndicator.FirstOrDefault(w => w.IDIndicator == 1);
result.incData.ProductID = itemPrdInc.ProductID;
result.incData.sUnit = itemPrdInc.sUnit;
result.incData.sProductName = itemPrdInc.ProductName;
result.incData.nUnitID = 66;
result.incData.sTarget = "";
#region EPI_FORM
var itemEPI_FORM = db.TEPI_Forms.FirstOrDefault(w => w.sYear == sYear && w.IDIndicator == nIndID && w.OperationTypeID == nOprtID && w.FacilityID == nFacID);
if (itemEPI_FORM != null)
{
var itemDataComplaint = db.TComplaint_Product.FirstOrDefault(w => w.FormID == itemEPI_FORM.FormID);
#region Data Indicator
if (itemDataComplaint != null)
{
var itemUnit = db.mTUnit.FirstOrDefault(w => w.UnitID == itemDataComplaint.UnitID);
result.incData.nUnitID = itemDataComplaint.UnitID;
result.incData.sUnit = itemUnit != null ? itemUnit.UnitName : result.incData.sUnit;
result.incData.sTarget = itemDataComplaint.Target;
result.incData.M1 = itemDataComplaint.M1;
result.incData.M2 = itemDataComplaint.M2;
result.incData.M3 = itemDataComplaint.M3;
result.incData.M4 = itemDataComplaint.M4;
result.incData.M5 = itemDataComplaint.M5;
result.incData.M6 = itemDataComplaint.M6;
result.incData.M7 = itemDataComplaint.M7;
result.incData.M8 = itemDataComplaint.M8;
result.incData.M9 = itemDataComplaint.M9;
result.incData.M10 = itemDataComplaint.M10;
result.incData.M11 = itemDataComplaint.M11;
result.incData.M12 = itemDataComplaint.M12;
result.incData.IsCheckM1 = itemDataComplaint.IsCheckM1;
result.incData.IsCheckM2 = itemDataComplaint.IsCheckM2;
result.incData.IsCheckM3 = itemDataComplaint.IsCheckM3;
result.incData.IsCheckM4 = itemDataComplaint.IsCheckM4;
result.incData.IsCheckM5 = itemDataComplaint.IsCheckM5;
result.incData.IsCheckM6 = itemDataComplaint.IsCheckM6;
result.incData.IsCheckM7 = itemDataComplaint.IsCheckM7;
result.incData.IsCheckM8 = itemDataComplaint.IsCheckM8;
result.incData.IsCheckM9 = itemDataComplaint.IsCheckM9;
result.incData.IsCheckM10 = itemDataComplaint.IsCheckM10;
result.incData.IsCheckM11 = itemDataComplaint.IsCheckM11;
result.incData.IsCheckM12 = itemDataComplaint.IsCheckM12;
}
#endregion
#region Data Complaint
result.lstComplaint = db.TComplaint.Where(w => w.FormID == itemEPI_FORM.FormID).Select(s => new cComplaint
{
nComplaintID = s.nComplaintID,
nComplaintTypeID = s.nComplaintTypeID,
ComplaintDate = s.ComplaintDate.HasValue ? s.ComplaintDate.Value : (DateTime?)null,
sIssueBy = s.sIssueBy,
sSubject = s.sSubject,
nComplaintByID = s.nComplaintByID,
sComplaintByOther = s.sComplaintByOther,
sDetail = s.sDetail,
sCorrectiveAction = s.sCorrectiveAction,
sStatus = s.sStatus,
nMonth = s.ComplaintDate.HasValue ? s.ComplaintDate.Value.Month : 0,
IsDel = false,
IsNew = false,
IsSubmited = true,
IsShow = true,
}).ToList();
result.lstComplaint.ForEach(f =>
{
f.sIssueDate = f.ComplaintDate.HasValue ? f.ComplaintDate.Value.ToString("dd/MM/yyyy") : "";
f.ComplaintDate = null;
});
var lstFileComplaint = db.TComplaint_File.Where(w => w.FormID == itemEPI_FORM.FormID).ToList();
var lstImpact = db.TComplaint_Impact.Where(w => w.FormID == itemEPI_FORM.FormID).ToList();
foreach (var itemComplaint in result.lstComplaint)
{
itemComplaint.lstImpact = new List <TComplaint_Impact>();
itemComplaint.lstImpact = lstImpact.Where(w => w.nComplaintID == itemComplaint.nComplaintID).Select(s => new TComplaint_Impact
{
nImpactTypeID = s.nImpactTypeID,
sOther = s.sOther
}).ToList();
itemComplaint.lstFile = new List <sysGlobalClass.FuncFileUpload.ItemData>();
itemComplaint.lstFile = lstFileComplaint.Where(w => w.nComplaintID == itemComplaint.nComplaintID).Select(s => new sysGlobalClass.FuncFileUpload.ItemData
{
ID = s.nFileID,
FileName = s.sFileName,
SaveToFileName = s.sSysFileName,
SaveToPath = s.sPath,
url = s.sPath + s.sSysFileName,
IsNewFile = false,
IsCompleted = true,
sDelete = "N",
sDescription = s.sDescription,
}).ToList();
}
#endregion
#region Status Month
result.lstStatus = db.TEPI_Workflow.Where(w => w.FormID == itemEPI_FORM.FormID).Select(s => new sysGlobalClass.T_TEPI_Workflow {
nMonth = s.nMonth, nStatusID = s.nStatusID
}).ToList();
#endregion
}
else
{
for (int i = 1; i <= 12; i++)
{
result.lstStatus.Add(new sysGlobalClass.T_TEPI_Workflow {
nMonth = i, nStatusID = 0
});
}
result.incData.sTarget = "";
result.incData.M1 = "";
result.incData.M2 = "";
result.incData.M3 = "";
result.incData.M4 = "";
result.incData.M5 = "";
result.incData.M6 = "";
result.incData.M7 = "";
result.incData.M8 = "";
result.incData.M9 = "";
result.incData.M10 = "";
result.incData.M11 = "";
result.incData.M12 = "";
result.incData.IsCheckM1 = "N";
result.incData.IsCheckM2 = "N";
result.incData.IsCheckM3 = "N";
result.incData.IsCheckM4 = "N";
result.incData.IsCheckM5 = "N";
result.incData.IsCheckM6 = "N";
result.incData.IsCheckM7 = "N";
result.incData.IsCheckM8 = "N";
result.incData.IsCheckM9 = "N";
result.incData.IsCheckM10 = "N";
result.incData.IsCheckM11 = "N";
result.incData.IsCheckM12 = "N";
}
#endregion
result.Status = SystemFunction.process_Success;
}
else
{
result.Status = SystemFunction.process_SessionExpired;
}
return(result);
}
public string A8ActiveList(string WorkFlow_Name)
{
string username = (Session["User"] as EquipModel.Entities.Person_Info).Person_Name;
string WE_Status = "0";
string query_list = "distinct E.WE_Ser, E.WE_Id, R.username";
string query_condition = "E.W_Name='" + WorkFlow_Name + "' and E.WE_Status='" + WE_Status + "' and R.username is not null";
string record_filter = "username is not null";
DataTable dt = CWFEngine.QueryAllInformation(query_list, query_condition, record_filter);
List <Gxqmodel> Gmlist = new List <Gxqmodel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Gxqmodel Gm = new Gxqmodel();
Gm.WE_Id = Convert.ToInt16(dt.Rows[i]["WE_Id"]);
Gm.WE_Ser = dt.Rows[i]["WE_Ser"].ToString();
Gmlist.Add(Gm);
}
List <A8Model> Hm = new List <A8Model>();
ERPInfoManagement erp = new ERPInfoManagement();
foreach (var item in Gmlist)
{
A8Model h = new A8Model();
Dictionary <string, object> paras = new Dictionary <string, object>();
paras["Equip_GyCode"] = null;
paras["Job_Order"] = null; //通过工单找通知单号
paras["Zz_Name"] = null;
paras["Job_Name"] = null; //计划名称
UI_WFEntity_Info wfei = CWFEngine.GetWorkFlowEntityWithParams(item.WE_Id, paras);
h.zz_name = paras["Zz_Name"].ToString();
h.sb_gycode = paras["Equip_GyCode"].ToString();
h.job_order = paras["Job_Order"].ToString();
h.plan_name = paras["Job_Name"].ToString();
GD_InfoModal res = erp.getGD_Modal_GDId(paras["Job_Order"].ToString());
if (res != null)
{
h.notice_order = res.GD_Notice_Id;
}
h.gd_state = "检修中";
WorkFlows wfsd = new WorkFlows();
Mission db_missA8dot2 = wfsd.GetWFEntityMissions(item.WE_Id).Last();
//写if而不写else if是因为13.1和8.2是断开的，跳转8.2仍满足db_miss.Miss_Desc == "专业团队审核"
if (db_missA8dot2.Miss_Desc == "检修单位按计划建立工单，完善工序、组件")
{
if (res != null)
{
h.gd_state = res.GD_State;
}
}
else if (db_missA8dot2.Miss_Desc == "检修计划提报")
{
if (res != null)
{
h.gd_state = res.GD_State;
}
}
else if (db_missA8dot2.Miss_Desc == "现场工程师审核工单")
{
if (res != null)
{
h.gd_state = res.GD_State;
}
}
else if (db_missA8dot2.Miss_Desc == "专业团队审1")
{
if (res != null)
{
h.gd_state = res.GD_State;
}
}
else if (db_missA8dot2.Miss_Desc == "可靠性工程师审1")
{
if (res != null)
{
h.gd_state = res.GD_State;
}
}
else if (db_missA8dot2.Miss_Desc == "机动处计划科审2")
{
if (res != null)
{
h.gd_state = res.GD_State;
}
}
else if (db_missA8dot2.Miss_Desc == "物资处采购，填写到货时间")
{
h.gd_state = "物资采购中";
}
else if (db_missA8dot2.Miss_Desc == "物资处确认到货并通知检修单位")
{
h.gd_state = "物资已到货";
}
else if (db_missA8dot2.Miss_Desc == "检修单位上传检修方案" || db_missA8dot2.Miss_Desc == "专业团队审批" || db_missA8dot2.Miss_Desc == "检修单位填写检修内容及关键工序，关联作业指导书" || db_missA8dot2.Miss_Desc == "可靠性工程师审批")
{
h.gd_state = "检修方案制定与审判";
}
else if (db_missA8dot2.Miss_Desc == "现场工程师确认是否可实施计划")
{
UI_MISSION ui = new UI_MISSION();
List <Mission_Param> mis_pars = wfsd.GetMissParams(db_missA8dot2.Miss_Id);//获取当前任务参数
foreach (var par in mis_pars)
{
CParam cp = new CParam();
ui.Miss_Params[cp.name] = cp.value;
}
if (ui.Miss_Params["ZzConfirmPlan_Result"].ToString() == "是")
{
h.gd_state = "检修计划实施中";
}
else if (ui.Miss_Params["ZzConfirmPlan_Result"].ToString() == "否")
{
h.gd_state = "检修计划延期";
}
}
else if (db_missA8dot2.Miss_Desc == "检修单位确认施工完毕，上传交工资料")
{
h.gd_state = "处理完成";
}
h.Data_Src = "待定";
h.detail = "待定";
Hm.Add(h);
}
List <object> or = new List <object>();
for (int i = 0; i < Hm.Count; i++)
{
object o = new
{
index = i + 1,
equip_gycode = Hm[i].sb_gycode,
job_order = Hm[i].job_order,
notice_order = Hm[i].notice_order,
gd_state = Hm[i].gd_state,
datasrc = Hm[i].Data_Src,
detail = Hm[i].detail,
zzname = Hm[i].zz_name,
planname = Hm[i].plan_name
};
or.Add(o);
}
string str = JsonConvert.SerializeObject(or);
return("{" + "\"data\": " + str + "}");
}
private void InsertData()
{
try
{
DataTable chkTable = (DataTable)gridControl3.DataSource;
if (chkTable == null)
{
MessageBox.Show("데이터가 없습니다.");
return;
}
CHeader Header = new CHeader(UserInfo, "A1003B", "XtraQrySection", "00000", "");
DataTable data = new DataTable("section_list");
DataColumn colProjectCd = new DataColumn("project_cd", typeof(string));
DataColumn colKey = new DataColumn("key", typeof(Int32));
DataColumn colyoungsu_m2 = new DataColumn("yongsu_m2", typeof(double));
DataColumn col보도블럭_석분_m2 = new DataColumn("보도블럭_석분_m2", typeof(double));
DataColumn col덧씌우기_asp_m = new DataColumn("덧씌우기_asp_m", typeof(double));
DataColumn col덧씌우기_asp_con_m = new DataColumn("덧씌우기_asp_con_m", typeof(double));
data.Columns.Add(colProjectCd);
data.Columns.Add(colKey);
data.Columns.Add(colyoungsu_m2);
data.Columns.Add(col보도블럭_석분_m2);
data.Columns.Add(col덧씌우기_asp_m);
data.Columns.Add(col덧씌우기_asp_con_m);
//DataRow Dr = data.NewRow();
//Dr["section_group_cd"] = lookupGroup.GetColumnValue("section_group_cd");
//Dr["section_id"] = edtSectionId.Text;
//Dr["section_id_nm"] = edtSectionIdNm.Text;
//Dr["asphalt1"] = edtAsphalt1.Text;
//Dr["asphalt2"] = edtAsphalt2.Text;
//Dr["complay"] = edtCompLay.Text;
//Dr["mixlay"] = edtMixLay.Text;
//Dr["desc"] = edtDesc.Text;
DataRow Dr = data.NewRow();
Dr["project_cd"] = ProjectInfo.ProjectCD;
Dr["key"] = advBandedGridView1.GetFocusedDataRow()["key"];
Dr["yongsu_m2"] = advBandedGridView1.GetFocusedDataRow()["yongsu_m2"];
Dr["보도블럭_석분_m2"] = advBandedGridView1.GetFocusedDataRow()["보도블럭_석분_m2"];
Dr["덧씌우기_asp_m"] = advBandedGridView1.GetFocusedDataRow()["덧씌우기_asp_m"];
Dr["덧씌우기_asp_con_m"] = advBandedGridView1.GetFocusedDataRow()["덧씌우기_asp_con_m"];
//Dr.ItemArray = advBandedGridView1.GetFocusedDataRow().ItemArray.Clone() as object[];
data.Rows.Add(Dr);
//data.Rows.Add(.);
CParam Param = new CParam(data);
DataSet ds = CTransfer.InsertData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
///정상등록된 경우만 최종 결과값을 재 조회한다.
if (Dt.Rows[0]["err_cd"].ToString() == "00000")
{
//QryList();
}
// DataTable Data = ds.Tables["Table"];
// gridControl1.DataSource = Data;
}
catch (Exception ex)
{
throw ex;
}
}
private void InsertData()
{
try
{
DataTable chkTable = (DataTable)gridControl1.DataSource;
if (chkTable == null)
{
MessageBox.Show("데이터가 없습니다.");
return;
}
CHeader Header = new CHeader(UserInfo, "A0120B", "XtraQrySection", "00000", "");
DataTable data = new DataTable("section_list");
DataColumn colSectionGroupCd = new DataColumn("section_group_cd", typeof(string));
DataColumn colSectionId = new DataColumn("section_id", typeof(string));
DataColumn colSectionNm = new DataColumn("section_id_nm", typeof(string));
DataColumn colAsphalt1 = new DataColumn("asphalt1", typeof(double));
DataColumn colAsphalt2 = new DataColumn("asphalt2", typeof(double));
DataColumn colComplay = new DataColumn("complay", typeof(double));
DataColumn colMixlay = new DataColumn("mixlay", typeof(double));
DataColumn colDesc = new DataColumn("desc", typeof(string));
data.Columns.Add(colSectionGroupCd);
data.Columns.Add(colSectionId);
data.Columns.Add(colSectionNm);
data.Columns.Add(colAsphalt1);
data.Columns.Add(colAsphalt2);
data.Columns.Add(colComplay);
data.Columns.Add(colMixlay);
data.Columns.Add(colDesc);
//DataRow Dr = data.NewRow();
//Dr["section_group_cd"] = lookupGroup.GetColumnValue("section_group_cd");
//Dr["section_id"] = edtSectionId.Text;
//Dr["section_id_nm"] = edtSectionIdNm.Text;
//Dr["asphalt1"] = edtAsphalt1.Text;
//Dr["asphalt2"] = edtAsphalt2.Text;
//Dr["complay"] = edtCompLay.Text;
//Dr["mixlay"] = edtMixLay.Text;
//Dr["desc"] = edtDesc.Text;
DataRow Dr = data.NewRow();
Dr.ItemArray = gridView1.GetFocusedDataRow().ItemArray.Clone() as object[];
Dr["section_group_cd"] = lookupGroup.GetColumnValue("section_group_cd");
data.Rows.Add(Dr);
//data.Rows.Add(.);
CParam Param = new CParam(data);
DataSet ds = CTransfer.InsertData(Header, Param.GetDataSet());
DataTable Dt = ds.Tables["eror_dt"];
itemErrCd.Caption = Dt.Rows[0]["err_cd"].ToString();
itemErrMsg.Caption = Dt.Rows[0]["err_msg"].ToString();
///정상등록된 경우만 최종 결과값을 재 조회한다.
if (Dt.Rows[0]["err_cd"].ToString() == "00000")
{
QrySectionList();
}
// DataTable Data = ds.Tables["Table"];
// gridControl1.DataSource = Data;
}
catch (Exception ex)
{
throw ex;
}
}
