private void UpdateMsgTimer_Tick(object sender, EventArgs e) { SqlDataReader SqlDataReader_O; String SqlRequest_st = "SELECT MAX(MsgID) FROM Msg"; UInt32 DBMaxID_UL, ListMaxID_UL; if (mDBManager_O != null && mDBManager_O.mConnected_b) { SqlDataReader_O = mDBManager_O.Select(SqlRequest_st); while (SqlDataReader_O.Read()) { if (UInt32.TryParse(SqlDataReader_O[0].ToString(), out DBMaxID_UL)) { ListMaxID_UL = DBListViewMsg.GetMaxID(); if (ListMaxID_UL < DBMaxID_UL) { DBListViewMsg.Refresh(); NewMessage(); } else if (ListMaxID_UL != DBMaxID_UL) { DBListViewMsg.Refresh(); } } else { DBListViewMsg.Refresh(); } } SqlDataReader_O.Close(); } }
private void ToolStripBtnDelete_Click(object sender, EventArgs e) { List <UInt32> ItemsID_UL = DBListViewMsg.GetSelectedItemsID(); UpdateMsgTimer.Enabled = false; if (mDBManager_O != null && mDBManager_O.mConnected_b) { for (int i = 0; i < ItemsID_UL.Count; i++) { mDBManager_O.mStoredProcedureManager_O.STPROC_DeleteMsg(ItemsID_UL[i]); } } UpdateMsgTimer.Enabled = true; }
public HomeUC(DatabaseManager DBManager_O) { InitializeComponent(); mDBManager_O = DBManager_O; List <String> TableField_ST = new List <String>(); List <String> ColumnHeaderName_ST = new List <String>(); List <int> ColumnHeaderDefaultSize_i = new List <int>(); List <HorizontalAlignment> TextAlign_O = new List <HorizontalAlignment>(); TableField_ST.Add("PersNom"); TableField_ST.Add("Msg"); TableField_ST.Add("MsgID"); ColumnHeaderName_ST.Add("Expéditeur"); ColumnHeaderName_ST.Add("Message"); ColumnHeaderDefaultSize_i.Add(100); ColumnHeaderDefaultSize_i.Add(DBListViewMsg.Width - 100); TextAlign_O.Add(HorizontalAlignment.Left); TextAlign_O.Add(HorizontalAlignment.Left); DBListViewMsg.Initialize(mDBManager_O, "MsgSelectPop", TableField_ST, 2, ColumnHeaderName_ST, ColumnHeaderDefaultSize_i, TextAlign_O); DBListViewMsg.ListTitle = "Messages"; DBListViewMsg.AllowMultipleSelecion = true; DBListViewMsg.AddToolStripBtn(ToolStripBtnDelete); FormMsgToolStrip.Visible = false; // Initialize db list view com job DbListViewComJobs.ListTitle = "Sélection des jobs"; List <String> mComJobTableField_ST = new List <String>(); List <String> mComJobColumnHeaderName_ST = new List <String>(); List <int> mComJobColumnHeaderDefaultSize_i = new List <int>(); List <HorizontalAlignment> mComJobTextAlign_O = new List <HorizontalAlignment>(); // Define column DB fields mComJobTableField_ST = new List <String>(); mComJobTableField_ST.Add("NumRefInterne"); mComJobTableField_ST.Add("LibelleCmd"); mComJobTableField_ST.Add("NumCmdClient"); mComJobTableField_ST.Add("ClientNom"); mComJobTableField_ST.Add("NumOrdre"); mComJobTableField_ST.Add("JobLib"); mComJobTableField_ST.Add("Qte"); mComJobTableField_ST.Add("NumPlan"); mComJobTableField_ST.Add("DelaiPromis"); mComJobTableField_ST.Add("JobStatusLib"); mComJobTableField_ST.Add("DateEncod"); // Unshown elements mComJobTableField_ST.Add("ComJobID"); // Define column headers text mComJobColumnHeaderName_ST = new List <string>(); mComJobColumnHeaderName_ST.Add("Num cmd int"); mComJobColumnHeaderName_ST.Add("Libellé cmd"); mComJobColumnHeaderName_ST.Add("Num cmd client"); mComJobColumnHeaderName_ST.Add("Nom client"); mComJobColumnHeaderName_ST.Add("# job"); mComJobColumnHeaderName_ST.Add("Job libellé"); mComJobColumnHeaderName_ST.Add("Qte"); mComJobColumnHeaderName_ST.Add("Num plan"); mComJobColumnHeaderName_ST.Add("Délai"); mComJobColumnHeaderName_ST.Add("Statut"); mComJobColumnHeaderName_ST.Add("Date encodage"); // Define column headers objects mComJobTextAlign_O = new List <HorizontalAlignment>(); for (int i = 0; i < mComJobColumnHeaderName_ST.Count; i++) { if (i == 4 || i == 6) { mComJobTextAlign_O.Add(HorizontalAlignment.Center); } else { mComJobTextAlign_O.Add(HorizontalAlignment.Left); } } mComJobColumnHeaderDefaultSize_i = new List <int>(); mComJobColumnHeaderDefaultSize_i.Add(100); mComJobColumnHeaderDefaultSize_i.Add(100); mComJobColumnHeaderDefaultSize_i.Add(150); mComJobColumnHeaderDefaultSize_i.Add(150); mComJobColumnHeaderDefaultSize_i.Add(50); mComJobColumnHeaderDefaultSize_i.Add(600); mComJobColumnHeaderDefaultSize_i.Add(50); mComJobColumnHeaderDefaultSize_i.Add(100); mComJobColumnHeaderDefaultSize_i.Add(100); mComJobColumnHeaderDefaultSize_i.Add(100); mComJobColumnHeaderDefaultSize_i.Add(100); DbListViewComJobs.Initialize(mDBManager_O, "ComJobSelectPop", mComJobTableField_ST, 11, mComJobColumnHeaderName_ST, mComJobColumnHeaderDefaultSize_i, mComJobTextAlign_O); ControlStyle.SetFrameHeaderStyle(this); ControlStyle.SetFrameHeaderStyle(this.splitContainer1); }