public bool DeleteSingleVolumn(InvVolumeApp invVolumn)
{
this.dict.Clear();
this.dict.Add("LBDM", invVolumn.TypeCode);
this.dict.Add("JQSH", ShareMethods.GetVolumnStartNum(invVolumn));
this.dict.Add("JZZH", ShareMethods.GetVolumnEndNum(invVolumn));
if (this.baseDao.updateSQL("aisino.Fwkp.Fplygl.JPInfo.DeleteSingle", this.dict) != 1)
{
return(false);
}
return(true);
}
public string GetSpecificFormat(InvVolumeApp invVolume)
{
this.dict.Clear();
this.dict.Add("LBDM", invVolume.TypeCode);
this.dict.Add("JQSH", ShareMethods.GetVolumnStartNum(invVolume));
this.dict.Add("JZZH", ShareMethods.GetVolumnEndNum(invVolume));
DataTable table = this.baseDao.querySQLDataTable("aisino.Fwkp.Fplygl.JPInfo.GetSpecificFormat", this.dict);
string str = string.Empty;
if ((table != null) && (table.Rows.Count > 0))
{
DataRow row = table.Rows[0];
str = row["JPGG"].ToString();
}
return(str);
}
private DataTable InitialTableData(List <InvVolumeApp> invVols, List <string> formats)
{
DataTable table = this.CreateTableHeader();
for (int i = 0; i < invVols.Count; i++)
{
DataRow row = table.NewRow();
row["LBDM"] = invVols[i].TypeCode;
row["JQSH"] = Convert.ToString(ShareMethods.GetVolumnStartNum(invVols[i])).PadLeft(8, '0');
row["JZZH"] = Convert.ToString(ShareMethods.GetVolumnEndNum(invVols[i])).PadLeft(8, '0');
row["LGZS"] = invVols[i].BuyNumber.ToString();
row["LGRQ"] = invVols[i].BuyDate.ToString("yyyy-MM-dd");
row["JPGG"] = formats[i];
table.Rows.Add(row);
}
return(table);
}
public bool InsertSingleVolumn(InvVolumeApp invVolumn, string formatCode)
{
this.dict.Clear();
this.dict.Add("LBDM", invVolumn.TypeCode);
this.dict.Add("JQSH", ShareMethods.GetVolumnStartNum(invVolumn));
this.dict.Add("JZZH", ShareMethods.GetVolumnEndNum(invVolumn));
this.dict.Add("LGZS", invVolumn.BuyNumber);
this.dict.Add("QSHM", invVolumn.HeadCode);
this.dict.Add("SYZS", invVolumn.Number);
this.dict.Add("KPXE", 0);
this.dict.Add("LGRQ", invVolumn.BuyDate);
this.dict.Add("JPGG", formatCode);
if (this.baseDao.updateSQL("aisino.Fwkp.Fplygl.JPInfo.InsertSingle", this.dict) != 1)
{
return(false);
}
return(true);
}
public SetFormat(List <InvVolumeApp> invVols, string defaultFormat = "NEW76mmX177mm")
{
this.jpxxDal = BLLFactory.CreateInstant <ILYGL_JPXX>("LYGL_JPXX");
this.InitializeWindow();
this.Text = "增值税普通发票(卷票)规格设置";
this.btnSetUpdate.Text = "设置";
this.btnSyn.Visible = false;
DataTable table = this.CreateTableHeader();
foreach (InvVolumeApp app in invVols)
{
DataRow row = table.NewRow();
row["LBDM"] = app.TypeCode;
row["JQSH"] = Convert.ToString(ShareMethods.GetVolumnStartNum(app)).PadLeft(8, '0');
row["JZZH"] = Convert.ToString(ShareMethods.GetVolumnEndNum(app)).PadLeft(8, '0');
row["LGZS"] = app.BuyNumber.ToString();
row["LGRQ"] = app.BuyDate.ToString("yyyy-MM-dd");
row["JPGG"] = defaultFormat;
table.Rows.Add(row);
}
this.csdgVolumns.DataSource = table;
}