public string AccountingForQueryGYD(String StartFph, int Number)
{
List <AccountingInfo> accList = new List <AccountingInfo>();
string comm = @"SELECT top {1} kprq,fph,( SELECT SUM(kpje)
FROM yx_t_ddfpgxb
WHERE fpid = a.id
) AS je FROM yx_t_fpxxb AS a
WHERE FPH>='{0}'
ORDER BY fph";
comm = String.Format(comm, StartFph, Number);
nrWebClass.LiLanzDAL dal = new nrWebClass.LiLanzDAL("14204");
using (IDataReader reader = dal.ExecuteReader(comm))
{
while (reader.Read())
{
AccountingInfo acc = new AccountingInfo();
acc.Rq = DateTime.Parse(reader[0].ToString());
acc.Fph = reader[1].ToString();
acc.Je = Decimal.Parse(reader[2].ToString());
accList.Add(acc);
}
}
XmlSerializer serializer = new XmlSerializer(typeof(List <AccountingInfo>));
StringWriter textWriter = new StringWriter();
serializer.Serialize(textWriter, accList);
return(textWriter.ToString());
}
public string AccountingForQuery(String StartFph, int Number, string filter)
{
List <AccountingInfo> accList = new List <AccountingInfo>();
string comm = @"select top {0} a.kprq,a.pjh,a.hsje,a.sje,a.hsje-a.sje as bhsje,a.khmc,
case when a.djbs=1 and djzt=0 then '未开票' when a.djbs=1 and djzt=1 then '正常填开' when a.djbs=0 then '作废' end as fpzt,
case a.pjlx when 11 then '普通发票' when 12 then '增值税专用发票' end as pjlx,djbs,djzt
from zw_t_pjxxb a
inner join zw_t_pjkcd b
on a.rkid=b.id
{1}
where b.tzid=1
order by pjh";
string SqlFilter = "";
if (StartFph != "")
{
SqlFilter = String.Format(@" and a.pjh>={0} ", StartFph);
}
if (filter != "")
{
SqlFilter += filter;
}
comm = String.Format(comm, Number, SqlFilter);
nrWebClass.LiLanzDAL dal = new nrWebClass.LiLanzDAL();
using (IDataReader reader = dal.ExecuteReader(comm))
{
while (reader.Read())
{
AccountingInfo acc = new AccountingInfo();
acc.Rq = DateTime.Parse(reader[0].ToString());
acc.Fph = reader[1].ToString();
acc.Je = Decimal.Parse(reader[2].ToString());
acc.Amount = Decimal.Parse(reader[4].ToString());
acc.DutyFee = Decimal.Parse(reader[3].ToString());
if (reader["djbs"].ToString() == "1")
{
if (reader["djzt"].ToString() == "1")
{
acc.Status = 1;
}
else
{
acc.Status = 0;
}
}
else
{
acc.Status = 2;
}
accList.Add(acc);
}
}
XmlSerializer serializer = new XmlSerializer(typeof(List <AccountingInfo>));
StringWriter textWriter = new StringWriter();
serializer.Serialize(textWriter, accList);
return(textWriter.ToString());
}