public List<Model_总账> GetTotalFee(string subject_id, bool WithoutBalance)
{
string WhereParm = "";
if (WithoutBalance)
{
WhereParm = " COMMENTS <> '承上年结余' AND ";
}
List<Model_总账> list = new List<Model_总账>();
string id = subject_id.Split('\t')[0];
string name = subject_id.Split('\t')[1];
string sql = "select strftime(op_time),VOUCHER_NUMS,COMMENTS,DEBIT,CREDIT,total(FEE*mark) from "
+ DBTablesName.T_FEE + " where " + WhereParm + " delete_mark=0 and subject_id='" + id + "' group by period order by op_time";
DataSet ds = new DataSet();
decimal fee = 0;
ds = db.Query(sql);
if (ds != null)
{
DataTable dt = ds.Tables[0];
int count = 0;
foreach (DataRow d in dt.Rows)
{
Model_总账 m = new Model_总账();
if (!string.IsNullOrEmpty(d[0].ToString()))
{
string date = d[0].ToString().Split(' ')[0];
m.年 = date.Split('-')[0];
m.月 = date.Split('-')[1];
m.日 = date.Split('-')[2];
}
m.号数 = d[1].ToString();
m.摘要 = d[2].ToString();
m.借方金额 = d[3].ToString();
m.贷方金额 = d[4].ToString();
decimal.TryParse(d[5].ToString(), out fee);
m.余额 = fee.ToString();
m.借或贷 = GetMark(fee);
string temp = string.Empty;
List<string> _list = new List<string>();
_list = ut.Turn(m.贷方金额, 12);
m.贷方金额1 = _list[0];
m.贷方金额2 = _list[1];
m.贷方金额3 = _list[2];
m.贷方金额4 = _list[3];
m.贷方金额5 = _list[4];
m.贷方金额6 = _list[5];
m.贷方金额7 = _list[6];
m.贷方金额8 = _list[7];
m.贷方金额9 = _list[8];
m.贷方金额10 = _list[9];
m.贷方金额11 = _list[10];
m.贷方金额12 = _list[11];
_list = ut.Turn(m.借方金额, 12);
m.借方金额1 = _list[0];
m.借方金额2 = _list[1];
m.借方金额3 = _list[2];
m.借方金额4 = _list[3];
m.借方金额5 = _list[4];
m.借方金额6 = _list[5];
m.借方金额7 = _list[6];
m.借方金额8 = _list[7];
m.借方金额9 = _list[8];
m.借方金额10 = _list[9];
m.借方金额11 = _list[10];
m.借方金额12 = _list[11];
_list.Clear();
_list = ut.Turn(m.余额, 12);
m.余额1 = _list[0];
m.余额2 = _list[1];
m.余额3 = _list[2];
m.余额4 = _list[3];
m.余额5 = _list[4];
m.余额6 = _list[5];
m.余额7 = _list[6];
m.余额8 = _list[7];
m.余额9 = _list[8];
m.余额10 = _list[9];
m.余额11 = _list[10];
m.余额12 = _list[11];
_list.Clear();
list.Add(m);
count++;
}
}
return list;
}
private void Button_总账查询_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(TextBox_科目及单位名称.Text))
{
MessageBoxCommon.Show("请选择科目");
TextBox_科目及单位名称.Focus();
return;
}
else
{
string a = TextBox_科目及单位名称.Text.ToString();
List<Model_总账> lm;
if (a.Substring(0, 1) == "4" || a.Substring(0, 1) == "5")
{
lm = vmk.GetTotalFee(a, true);
}
else
{
lm = vmk.GetTotalFee(a);
}
this.DataGrid_总账.ItemsSource = lm;
if (lm.Count > 1)
{
this.Label_总账年.Content = lm[1].年 + "年";
}
else
{
Model_总账 m = new Model_总账();
m.摘要 = "查询不到数据！";
lm.Add(m);
}
this.DataGrid_总账.ItemsSource = lm;
}
}
