/// <summary> /// 获取账套数据的方法 /// </summary> /// <returns>一个账套数据集合</returns> public Model_账套 GetData() { sql = "select * from " + DBTablesName.T_BOOKS + " where id='" + CommonInfo.账薄号 + "'"; DataTable dt = db.Query(sql).Tables[0]; DataRow dr = dt.Rows[0]; Model_账套 m = new Model_账套(); m.ID = dr[0].ToString(); m.账套名称 = dr[1].ToString(); m.启用期间 = dr[3].ToString(); m.创建日期字符串 = dr[4].ToString(); m.会计制度 = dr[5].ToString(); m.当前期 = Convert.ToInt32(dr[6].ToString()); return m; }
/// <summary> /// 更新账套名称方法 /// </summary> /// <param name="m">传入的账套</param> /// <param name="type">0:更新账套名称,1:进行删除</param> /// <returns></returns> public bool UpdateBookName(Model_账套 m,int type) { string _sql = string.Empty; switch (type) { case 0: _sql = " set book_name='" + m.账套名称 + "'"; break; case 1: _sql = " set delete_mark=1"; break; } sql = "update " + DBTablesName.T_BOOKS + _sql + " where id='" + CommonInfo.账薄号 + "'"; return db.Excute(sql); }
private void Button_账套修改_Click(object sender, RoutedEventArgs e) { Model_账套 m = new Model_账套(); m.账套名称 = TextBox_账套名称.Text.Trim(); bool flag = vmb.UpdateBookName(m, 0); if (flag) { mrc.日志 = "账套名称由" + xr.ReadXML("账套信息") + "修改为" + m.账套名称; vmr.Insert(mrc); MessageBoxCommon.Show("修改账套名称成功,重启程序生效!"); xw.WriteXML("账套信息", m.账套名称); } else { MessageBoxCommon.Show("修改账套名称失败!"); } }
private void Expander_账套管理_Expanded(object sender, RoutedEventArgs e) { this.Expander_修改密码.IsExpanded = false; this.Expander_权限.IsExpanded = false; Model_账套 m = new Model_账套(); m = vmb.GetData(); TextBox_账套名称.Text = m.账套名称; TextBox_制度.Text = m.会计制度; TextBox_启用期间.Text = m.启用期间; TextBox_创建时间.Text = m.创建日期字符串; }
public List<Model_账套> GetComboBox_账套() { List<Model_账套> list = new List<Model_账套>(); Model_账套 def = new Model_账套(); def.ID = "0"; def.账套名称 = "新建账套"; list.Add(def); sql = "select id,book_name from t_books where delete_mark=0 order by create_date desc"; ds = db.Query(sql); if (ds != null) { DataTable dt = db.Query(sql).Tables[0]; foreach(DataRow d in dt.Rows) { Model_账套 m = new Model_账套(); m.ID = d[0].ToString(); m.账套名称 = d[1].ToString(); list.Add(m); } } return list; }