protected override void WfAfterPrint(StiReport pStiReport)
{
string updateSql = "";
List <SqlParameter> sqlParmList = null;
try
{
var masterList = pStiReport.DataStore["Master"].Data as List <Master>;
List <string> gfa01List = (from o in masterList
group o by o.gfa01 into g
select g.First().gfa01
).ToList()
;
updateSql = @"UPDATE gfa_tb
SET gfaprno=gfaprno+1
WHERE gfa01=@gfa01
";
foreach (string gfa01 in gfa01List)
{
sqlParmList = new List <SqlParameter>();
sqlParmList.Add(new SqlParameter("@gfa01", gfa01));
BoGla.OfExecuteNonquery(updateSql, sqlParmList.ToArray());
}
}
catch (Exception ex)
{
WfShowErrorMsg(ex.Message);
}
}
