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