62,073
社区成员
发帖
与我相关
我的任务
分享
public void main()
{
int beginNo = 0;//开始号码段
int endNo = 1000000;//结束号码段
var taxNoteTable = GetNoteTable(beginNo,endNo);
InsertCancelTaxNote(taxNoteTable,beginNo,endNo);//插入作废发票号
}
private DataTable GetNoteTable(int beginNo, int endNo)
{
throw new NotImplementedException();
}
private void InsertCancelTaxNote(DataTable taxNoteTable,int beginNo,int endNo)
{
var preNoteID = beginNo;//存储前一次发票编号
var newrowList=new List<DataRow>();//暂存新增的表行
var tablCount = taxNoteTable.Rows.Count;
var index = 0;
foreach (DataRow row in taxNoteTable.Rows)
{
index++;
var currentTaxNo = (int) row["发表编号字段名"];
for (int i = preNoteID + 1; i < currentTaxNo; i++) //判断是否有不存在的发票编号,如果有则表示是作废的
{
var newrow = taxNoteTable.NewRow();
newrow["发表编号字段名"] = i;
newrow["备注字段名"] = "作废";
newrowList.Add(newrow);
}
preNoteID = currentTaxNo;
if (index==tablCount)//判断是否是最后一条数据,如果是最后一条则用endNo再判断一次。
{
for (int i = preNoteID + 1; i < endNo; i++) //判断是否有不存在的发票编号,如果有则表示是作废的
{
var newrow = taxNoteTable.NewRow();
newrow["发表编号字段名"] = i;
newrow["备注字段名"] = "作废";
newrowList.Add(newrow);
}
}
}
}
public void main()
{
int beginNo = 0;//开始号码段
int endNo = 1000000;//结束号码段
var taxNoteTable = GetNoteTable(beginNo,endNo);
InsertCancelTaxNote(taxNoteTable,beginNo,endNo);
}
private DataTable GetNoteTable(int beginNo, int endNo)
{
throw new NotImplementedException();
}
private void InsertCancelTaxNote(DataTable taxNoteTable,int beginNo,int endNo)
{
var preNoteID = beginNo;//存储前一次发票编号
var newrowList=new List<DataRow>();//暂存新增的表行
foreach (DataRow row in taxNoteTable.Rows)
{
var currentTaxNo = (int) row["发表编号字段名"];
for (int i = preNoteID + 1; i < currentTaxNo; i++) //判断是否有不存在的发票编号,如果有则表示是作废的
{
var newrow = taxNoteTable.NewRow();
newrow["发表编号字段名"] = i;
newrow["备注字段名"] = "作废";
newrowList.Add(newrow);
}
preNoteID = currentTaxNo;
}
}