public static dsConfig.dtNotesRow LoadNode(int id) { dsConfig ds = new dsConfig(); //HUYNC:Đọc từ database lên. LoadTableNoteBook(ds); //ds.ReadXml(GlobalVars.ConfigFile); dsConfig.dtNotesRow dr = ds.dtNotes.FindByIdMsg(id); return dr; }
public static List<int> GetNoteIDs() { dsConfig ds = new dsConfig(); //HUYNC:Đọc từ database lên. LoadTableNoteBook(ds); //ds.ReadXml(GlobalVars.ConfigFile); List<int> ret = new List<int>(); foreach (dsConfig.dtNotesRow dr in ds.dtNotes.Rows) ret.Add(dr.IdMsg); return ret; }
public static void Delete(int id) { dsConfig ds = new dsConfig(); //HUYNC:Đọc từ database lên. LoadTableNoteBook(ds); //ds.ReadXml(GlobalVars.ConfigFile); dsConfig.dtNotesRow dr = ds.dtNotes.FindByIdMsg(id); if (dr != null) { dr.Delete(); //HUYNC:Lưu xuống database SaveTableNoteBook(ds); //ds.WriteXml(GlobalVars.ConfigFile, System.Data.XmlWriteMode.WriteSchema); } }
public static void SaveNode(dsConfig.dtNotesRow dr) { dsConfig ds = new dsConfig(); //HUYNC:Đọc từ database lên. LoadTableNoteBook(ds); //ds.ReadXml(GlobalVars.ConfigFile); dsConfig.dtNotesRow dr_orig = ds.dtNotes.FindByIdMsg(dr.IdMsg); if (dr_orig != null) { foreach ( DataColumn col in ds.dtNotes.Columns) dr_orig[col.ColumnName] = dr[col.ColumnName]; //HUYNC:Lưu xuông database SaveTableNoteBook(ds); //ds.WriteXml(GlobalVars.ConfigFile, System.Data.XmlWriteMode.WriteSchema); } }
public static int AddNode(dsConfig.dtNotesRow dr) { dsConfig ds = new dsConfig(); //HUYNC:Đọc từ database lên. LoadTableNoteBook(ds); //ds.ReadXml(GlobalVars.ConfigFile); dsConfig.dtNotesRow dr_new = ds.dtNotes.NewdtNotesRow(); foreach (DataColumn col in ds.dtNotes.Columns) if(!col.AutoIncrement) dr_new[col.ColumnName] = dr[col.ColumnName]; ds.dtNotes.Rows.Add(dr_new); //HUYNC:Lưu xuống database SaveTableNoteBook(ds); //ds.WriteXml(GlobalVars.ConfigFile, System.Data.XmlWriteMode.WriteSchema); return dr_new.IdMsg; }
private static void LoadTableNoteBook(dsConfig config) { DbCommand command = DABase.getDatabase().GetSQLStringCommand("SELECT * FROM FW_NOTE_BOOK WHERE USERID=" + FrameworkParams.currentUser.id); DataSet ds = DABase.getDatabase().LoadDataSet(command, "FW_NOTE_BOOK"); if (ds != null) { foreach (DataRow dr in ds.Tables[0].Rows) config.Tables[0].ImportRow(dr); } else { throw new Exception("Thiếu bảng FW_NOTE_BOOK"); } }
private static void SaveTableNoteBook(dsConfig config) { config.Tables[0].TableName = "FW_NOTE_BOOK"; DABase.getDatabase().UpdateTable(config.Tables[0].DataSet, "FW_NOTE_BOOK"); }
private void UpdateUIFromDR(dsConfig.dtNotesRow dr) { try { richTextBox1.Rtf = dr.Message; Opacity = dr.Opacity; Location = new Point(dr.X, dr.Y); Size = new Size(dr.Width, dr.Height); BackColor = Color.FromArgb(dr.TitlebarColor); richTextBox1.BackColor = Color.FromArgb(dr.BgColor); richTextBox1.ForeColor = Color.FromArgb(dr.FontColor); richTextBox1.Font = DeserializeFont(dr.Font); txtTitle.ForeColor = Color.FromArgb(dr.TitleFontColor); txtTitle.Font = DeserializeFont(dr.TitleFont); switch (dr.FlagImage) { case "BlueFlag": picFlag.Image = global::ProtocolVN.Framework.Win.Properties.Resources.BlueFlag; break; case "RedFlag": picFlag.Image = global::ProtocolVN.Framework.Win.Properties.Resources.RedFlag; break; case "GreenFlag": picFlag.Image = global::ProtocolVN.Framework.Win.Properties.Resources.GreenFlag; break; case "GoalFlag": picFlag.Image = global::ProtocolVN.Framework.Win.Properties.Resources.GoalFlag; break; case "Bulb": picFlag.Image = global::ProtocolVN.Framework.Win.Properties.Resources.Bulb; break; default: picFlag.Image = global::ProtocolVN.Framework.Win.Properties.Resources.BlueFlag; break; } txtTitle.Text = dr.Title; } catch { } }
private void UpdateDRFromUI(dsConfig.dtNotesRow dr) { dr.Message = richTextBox1.Rtf; dr.Opacity = Opacity; dr.X = Location.X; dr.Y = Location.Y; dr.Width = Size.Width; dr.Height = Size.Height; dr.TitlebarColor = BackColor.ToArgb(); dr.BgColor = richTextBox1.BackColor.ToArgb(); dr.FontColor = richTextBox1.ForeColor.ToArgb(); dr.Font = SerializeFont(richTextBox1.Font); dr.FlagImage = picFlag.Tag.ToString(); dr.TitleFontColor = txtTitle.ForeColor.ToArgb(); dr.TitleFont = SerializeFont(txtTitle.Font); dr.Title = txtTitle.Text; dr.UserId = FrameworkParams.currentUser.id; dr.id = DABase.getDatabase().GetID("G_FW_ID"); }