/// <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; } }