/// <summary>
/// 更新账表分户账和账表明细账
/// </summary>
private void UpdateZbInfo(bool execPermission)
{
if (execPermission)
{
ZbfhzModel zbfhz = new ZbfhzModel();
ZbmxzModel zbmxz = new ZbmxzModel();
zbmxz.Zh = model.Skrzh;
int iBs = db2Operation.GetCountByZh(zbmxz);
zbmxz.Bc = (iBs + 1).ToString();
zbmxz.Fse = model.Je;
zbmxz.Yhls = Encoding.Default.GetString(bhsszfMsg.Yhls);
zbmxz.Pjhm = model.Pch;
zbmxz.Jdbz = "2";
zbmxz.Ywlx = "1";
zbmxz.Dfzh = model.Fkrzh;
zbmxz.Dfhm = model.Fkrmc;
zbmxz.Zxjsh = model.Fkrzh;
zbmxz.Rqrq = db2Operation.GetDjrqrq();
zbfhz.Yhzh = zbmxz.Zh;
zbfhz.Bs = zbmxz.Bc;
zbfhz.Hm = model.Skrmc;
db2Operation.UpateZbfhzAndZbmxz(zbmxz, zbfhz);
}
}
/// <summary>
/// 更新账表分户账和账表明细账
/// </summary>
private void UpdateZbInfo(bool execPermission, string[] lineArray)
{
if (execPermission)
{
ZbfhzModel zbfhz = new ZbfhzModel();
ZbmxzModel zbmxz = new ZbmxzModel();
zbmxz.Zh = lineArray[5];
int iBs = db2Operation.GetCountByZh(zbmxz);
zbmxz.Bc = (iBs + 1).ToString();
zbmxz.Fse = lineArray[3];
Random radom = new Random();
zbmxz.Yhls = BasicOperation.GenerateLongBankSerialNum(radom.Next(99));
zbmxz.Yhls = model.Pch;
zbmxz.Pjhm = lineArray[10];
zbmxz.Jdbz = "2";
zbmxz.Ywlx = "1";
zbmxz.Dfzh = lineArray[2];
zbmxz.Dfhm = lineArray[3];
zbmxz.Zxjsh = lineArray[1];
zbmxz.Rqrq = db2Operation.GetDjrqrq();
zbfhz.Yhzh = zbmxz.Zh;
zbfhz.Bs = zbmxz.Bc;
zbfhz.Hm = lineArray[6];
db2Operation.UpateZbfhzAndZbmxz(zbmxz, zbfhz);
}
}
/// <summary>
///更新zbfhz和zbmxz
/// </summary>
/// <param name="lineArray"></param>
/// <returns></returns>
public int UpateZbfhzAndZbmxz(ZbmxzModel zbmxz, ZbfhzModel zbfhz)
{
//账表明细账
int iBs = GetCountByZh(zbmxz);
if (iBs == -1)
{
return(-1);
}
else
{
string cmd = zbmxz.ToInsertString();
ExecuteDB2Update(cmd);
}
//账表分户账
int num = GetCountByZh(zbfhz);
if (num == -1)
{
return(-1);
}
if (num == 0)
{
ExecuteDB2Update(zbfhz.ToInsertString());
}
else
{
ExecuteDB2Update(zbfhz.ToUpdateString());
}
return(0);
}
/// <summary>
/// 根据日切日期查询zbmxz结果集
/// </summary>
/// <param name="rqrq">日切日期</param>
/// <returns></returns>
public List <ZbmxzModel> GetZbmxzByRqrq(string rqrq)
{
List <ZbmxzModel> list = new List <ZbmxzModel>();
ZbmxzModel zbmxz;
string cmdString = "select * from zbmxz where djrq >= '" + rqrq + "'";
this.Open();
try
{
db2Cmd = new DB2Command(cmdString, this.db2Conn);
DB2DataReader dr = db2Cmd.ExecuteReader();
while (dr.Read())
{
zbmxz = new ZbmxzModel();
zbmxz.Bc = dr.GetInt32(1).ToString();
zbmxz.Zh = dr.GetString(2);
zbmxz.Jyrq = dr.GetDate(3).ToShortDateString();
zbmxz.Jysj = dr.GetDateTime(4).ToLongTimeString();
zbmxz.Fse = dr.GetDecimal(5).ToString();
zbmxz.Ye = dr.GetDecimal(6).ToString();
zbmxz.Yhls = dr.GetString(7);
zbmxz.Pjhm = dr.GetString(8);
zbmxz.Jdbz = dr.GetString(9);
zbmxz.Ywlx = dr.GetString(10);
zbmxz.Dfzh = dr.GetString(11);
zbmxz.Dfhm = dr.GetString(12);
zbmxz.Zxjsh = dr.GetString(13);
list.Add(zbmxz);
}
}
catch (Exception ex)
{
LogHelper.WriteLogException("Execute sql command error in Db2Operation.GetZbmxzByRqrq()", ex);
throw;
}
finally
{
this.Close();
}
return(list);
}
/// <summary>
/// 查询zbmxz中某账号的笔数
/// </summary>
/// <param name="zbmxz">zbmxz实体</param>
/// <returns>某账号对应的记录数</returns>
public int GetCountByZh(ZbmxzModel zbmxz)
{
return(this.ExecuteCountQuery(zbmxz.ToCountStringByZh()));
}
