/// <summary>
/// 插入发票信息
/// </summary>
/// <returns></returns>
public static int InsertInvoiceInfo(InvoiceInfo info)
{
int result = 0;
List<string> lt = new List<string>();
if (info != null)
{
string sqlStr = string.Format("INSERT INTO B_InvoiceInfo([InvoiceCode],[InvoiceNumber],[InvoiceDate] ,[CheckCode] ,[MachineNumber],[GName],[GIdentificationCode] ,[GAddressPhone] " +
",[GBankAccount] ,[PasswordArea] ,[TotalPriceB] ,[TotalPriceS],[XName] ,[XIdentificationCode] ,[XAddressPhone],[XBankAccount] ,[InspectionTimes] ,[InspectionTime] ,[Remark]"+
" ,[InvoiceProvince] ,[InvoiceType]) " +
"VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}')", info.InvoiceCode, info.InvoiceNumber,
info.InvoiceDate, info.CheckCode, info.MachineNumber, info.GName, info.GIdentificationCode, info.GAddressPhone,
info.GBankAccount, info.PasswordArea, info.TotalPriceB, info.TotalPriceS, info.XName, info.XIdentificationCode,
info.XAddressPhone, info.XBankAccount, info.InspectionTimes, info.InspectionTime, info.Remark,info.InvoiceProvince,info.InvoiceType);
lt.Add(sqlStr);
foreach (InvoiceSubInfo subInfo in info.SubInfo)
{
string sqlStr1 = string.Format("INSERT INTO B_InvoiceSubInfo([InvoiceCode],[InvoiceNumber],[CheckCode],[MachineNumber] ,[NO] ,[GoodsName] ,[SpecificationModel] ,[Unit]" +
",[Quantity],[UnitPrice],[Money],[TaxRate],[Tax] ,[Total],[TotalTax]) " +
"VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')", subInfo.InvoiceCode, subInfo.InvoiceNumber,
subInfo.CheckCode, subInfo.MachineNumber, subInfo.NO, subInfo.GoodsName, subInfo.SpecificationModel, subInfo.Unit,
subInfo.Quantity, subInfo.UnitPrice, subInfo.Money, subInfo.TaxRate, subInfo.Tax, subInfo.Total, subInfo.TotalTax);
lt.Add(sqlStr1);
}
try
{
result = Maticsoft.DBUtility.DbHelperSQL.ExecuteSqlTran(lt);
}
catch (Exception)
{
result = -1;
}
}
return result;
}
/// <summary>
/// 判断发票名称是否正确
/// </summary>
/// <returns></returns>
public static DataSet JudgeInvoiceInfoName(InvoiceInfo info)
{
DataSet ds = null;
try
{
string strSql = "SELECT * FROM [CascoInvoice ].[dbo].[W_CompanyInfo] WHERE CompanyName='" + info.GName + "'";
ds = Maticsoft.DBUtility.DbHelperSQL.Query(strSql);
}
catch (Exception)
{
ds = null;
}
return ds;
}
/// <summary>
/// 获取发票信息
/// </summary>
/// <returns></returns>
public static DataSet JudgeInvoiceInfo(InvoiceInfo info)
{
DataSet ds = null;
try
{
string strSql = "SELECT * FROM [CascoInvoice ].[dbo].[B_InvoiceInfo] WHERE InvoiceCode='" + info.InvoiceCode + "' and InvoiceNumber='" + info.InvoiceNumber + "'";
ds = Maticsoft.DBUtility.DbHelperSQL.Query(strSql);
}
catch (Exception)
{
ds = null;
}
return ds;
}
public void ProcessRequest(HttpContext context)
{
string json = "";
string operatorID = context.Request.LogonUserIdentity.Name;
if (context.Request["method"] != null)
{
try
{
switch (context.Request.QueryString["method"])
{
case "checkMethod":
InvoiceInfo info = new InvoiceInfo();
#region 数据
if (context.Request.Form["pData[InvoiceProvince]"] != null)
{
info.InvoiceProvince = context.Request.Form["pData[InvoiceProvince]"];
}
if (context.Request.Form["pData[djsys]"] != null)
{
info.Djsys = context.Request.Form["pData[djsys]"];
}
if (context.Request.Form["pData[InvoiceType]"] != null)
{
info.InvoiceType = context.Request.Form["pData[InvoiceType]"];
}
if (context.Request.Form["pData[InvoiceCode]"] != null)
{
info.InvoiceCode = context.Request.Form["pData[InvoiceCode]"];
}
if (context.Request.Form["pData[InvoiceNumber]"] != null)
{
info.InvoiceNumber = context.Request.Form["pData[InvoiceNumber]"];
}
if (context.Request.Form["pData[InvoiceDate]"] != null)
{
info.InvoiceDate = context.Request.Form["pData[InvoiceDate]"];
}
if (context.Request.Form["pData[CheckCode]"] != null)
{
info.CheckCode = context.Request.Form["pData[CheckCode]"];
}
if (context.Request.Form["pData[MachineNumber]"] != null)
{
info.MachineNumber = context.Request.Form["pData[MachineNumber]"];
}
if (context.Request.Form["pData[GName]"] != null)
{
info.GName = context.Request.Form["pData[GName]"];
}
if (context.Request.Form["pData[GIdentificationCode]"] != null)
{
info.GIdentificationCode = context.Request.Form["pData[GIdentificationCode]"];
}
if (context.Request.Form["pData[GAddressPhone]"] != null)
{
info.GAddressPhone = context.Request.Form["pData[GAddressPhone]"];
}
if (context.Request.Form["pData[GBankAccount]"] != null)
{
info.GBankAccount = context.Request.Form["pData[GBankAccount]"];
}
if (context.Request.Form["pData[PasswordArea]"] != null)
{
info.PasswordArea = context.Request.Form["pData[PasswordArea]"];
}
if (context.Request.Form["pData[TotalPriceB]"] != null)
{
info.TotalPriceB = context.Request.Form["pData[TotalPriceB]"];
}
if (context.Request.Form["pData[TotalPriceS]"] != null)
{
info.TotalPriceS = context.Request.Form["pData[TotalPriceS]"];
}
if (context.Request.Form["pData[XName]"] != null)
{
info.XName = context.Request.Form["pData[XName]"];
}
if (context.Request.Form["pData[XIdentificationCode]"] != null)
{
info.XIdentificationCode = context.Request.Form["pData[XIdentificationCode]"];
}
if (context.Request.Form["pData[XAddressPhone]"] != null)
{
info.XAddressPhone = context.Request.Form["pData[XAddressPhone]"];
}
if (context.Request.Form["pData[XBankAccount]"] != null)
{
info.XBankAccount = context.Request.Form["pData[XBankAccount]"];
}
if (context.Request.Form["pData[InspectionTimes]"] != null)
{
info.InspectionTimes = context.Request.Form["pData[InspectionTimes]"];
}
if (context.Request.Form["pData[InspectionTime]"] != null)
{
info.InspectionTime = context.Request.Form["pData[InspectionTime]"];
}
if (context.Request.Form["pData[Remark]"] != null)
{
info.Remark = context.Request.Form["pData[Remark]"];
}
info.OperatorID = context.Request.LogonUserIdentity.Name;
#endregion
List <InvoiceSubInfo> LsubInfo = new List <InvoiceSubInfo>();
if (context.Request.Form["pData[InvoiceSubInfo][0][InvoiceCode]"] != null)
{
for (int i = 0; i < 100; i++)
{
InvoiceSubInfo subInfo = new InvoiceSubInfo();
#region 子数据
if (string.IsNullOrEmpty(context.Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceCode]"]))
{
break;
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceCode]"] != null)
{
subInfo.InvoiceCode = context.Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceCode]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceNumber]"] != null)
{
subInfo.InvoiceNumber = context.Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceNumber]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][CheckCode]"] != null)
{
subInfo.CheckCode = context.Request.Form["pData[InvoiceSubInfo][" + i + "][CheckCode]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][MachineNumber]"] != null)
{
subInfo.MachineNumber = context.Request.Form["pData[InvoiceSubInfo][" + i + "][MachineNumber]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][NO]"] != null)
{
subInfo.NO = i.ToString();
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][GoodsName]"] != null)
{
subInfo.GoodsName = context.Request.Form["pData[InvoiceSubInfo][" + i + "][GoodsName]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][SpecificationModel]"] != null)
{
subInfo.SpecificationModel = context.Request.Form["pData[InvoiceSubInfo][" + i + "][SpecificationModel]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][Unit]"] != null)
{
subInfo.Unit = context.Request.Form["pData[InvoiceSubInfo][" + i + "][Unit]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][Quantity]"] != null)
{
subInfo.Quantity = context.Request.Form["pData[InvoiceSubInfo][" + i + "][Quantity]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][UnitPrice]"] != null)
{
subInfo.UnitPrice = context.Request.Form["pData[InvoiceSubInfo][" + i + "][UnitPrice]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][Money]"] != null)
{
subInfo.Money = context.Request.Form["pData[InvoiceSubInfo][" + i + "][Money]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][TaxRate]"] != null)
{
subInfo.TaxRate = context.Request.Form["pData[InvoiceSubInfo][" + i + "][TaxRate]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][Tax]"] != null)
{
subInfo.Tax = context.Request.Form["pData[InvoiceSubInfo][" + i + "][Tax]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][Total]"] != null)
{
subInfo.Total = context.Request.Form["pData[InvoiceSubInfo][" + i + "][Total]"];
}
if (context.Request.Form["pData[InvoiceSubInfo][" + i + "][TotalTax]"] != null)
{
subInfo.TotalTax = context.Request.Form["pData[InvoiceSubInfo][" + i + "][TotalTax]"];
}
#endregion
LsubInfo.Add(subInfo);
}
info.SubInfo = LsubInfo;
}
if (info.InvoiceCode != "")
{
DataSet ds = DataOperate.JudgeInvoiceInfo(info);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
json += "{success:'false',inf:'发票重复',plus:'";
NetLog.WriteTextLog(operatorID, "【查验发票】", "【发票重复】：" + info.InvoiceNumber);
DataView dv = ds.Tables[0].DefaultView;
foreach (DataRowView rowview in dv)
{
for (int i = 0; i < dv.Table.Columns.Count; i++)
{
json += rowview[i] + ",";
}
}
json = json.Remove(json.Length - 1, 1);
json += "'}";
json = json.Replace("\\", " ");
}
else
{
if (info.InvoiceType == "01")
{
DataSet dss = DataOperate.JudgeInvoiceInfoYN(info);
if (dss != null && dss.Tables[0].Rows.Count > 0)
{
int result = DataOperate.InsertInvoiceInfo(info);
if (result > 0)
{
json = "{success:'true',inf:'发票校验成功'}";
}
else
{
json = "{success:'false',inf:'发票数据存储出错'}";
}
}
else
{
json = "{success:'false',inf:'发票名称有误'}";
}
}
else
{
//DataSet dsss = DataOperate.JudgeInvoiceInfoName(info);
//if (dsss != null && dsss.Tables[0].Rows.Count > 0)
//{
int result = DataOperate.InsertInvoiceInfo(info);
if (result > 0)
{
json = "{success:'true',inf:'发票校验成功'}";
}
else
{
json = "{success:'false',inf:'发票数据存储出错'}";
}
//}
//else
//{
// json = "{success:'false',inf:'发票名称有误'}";
//}
}
}
}
break;
case "matchMethod":
string fpdm = "";
string fphm = "";
string kprq = "";
string operateTime = "";
string OperatorID = context.Request.LogonUserIdentity.Name;
if (context.Request.Form["pData[fpdm]"] != null)
{
fpdm = context.Request.Form["pData[fpdm]"];
}
if (context.Request.Form["pData[fphm]"] != null)
{
fphm = context.Request.Form["pData[fphm]"];
}
if (context.Request.Form["pData[kprq]"] != null)
{
kprq = context.Request.Form["pData[kprq]"];
}
if (context.Request.Form["pData[operateTime]"] != null)
{
operateTime = context.Request.Form["pData[operateTime]"];
}
if (fpdm != "" && fphm != "" && kprq != "")
{
DataSet ds = DataOperate.JudgeIsMatch(fpdm, fphm, kprq);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
json += "{success:'false',inf:'发票重复',plus:'";
NetLog.WriteTextLog(operatorID, "【查验发票】", "【发票重复】：" + fphm);
DataView dv = ds.Tables[0].DefaultView;
foreach (DataRowView rowview in dv)
{
for (int i = 0; i < dv.Table.Columns.Count; i++)
{
json += rowview[i] + ",";
}
}
json = json.Remove(json.Length - 1, 1);
json += "'}";
json = json.Replace("\\", " ");
}
else
{
int result = DataOperate.InsertOnlyMatch(fpdm, fphm, kprq, operateTime, OperatorID);
if (result > 0)
{
json = "{success:'true',inf:'发票保存成功'}";
}
else
{
json = "{success:'false',inf:'发票数据存储出错'}";
}
}
}
else
{
}
break;
case "netLog":
NetLog.WriteTextLog(operatorID, "【查验发票】", "【" + context.Request.Form["pData[msg]"] + "】：" + context.Request.Form["pData[fpdm]"]);
break;
}
}
catch (Exception ex)
{
json = ex.Message;
}
context.Response.Write(json);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string json = "";
if (Request.Form.Count > 20)
{
InvoiceInfo info = new InvoiceInfo();
#region 数据
if (Request.Form["pData[InvoiceProvince]"] != null)
{
info.InvoiceProvince = Request.Form["pData[InvoiceProvince]"];
}
if (Request.Form["pData[InvoiceType]"] != null)
{
info.InvoiceType = Request.Form["pData[InvoiceType]"];
}
if (Request.Form["pData[InvoiceCode]"] != null)
{
info.InvoiceCode = Request.Form["pData[InvoiceCode]"];
}
if (Request.Form["pData[InvoiceNumber]"] != null)
{
info.InvoiceNumber = Request.Form["pData[InvoiceNumber]"];
}
if (Request.Form["pData[InvoiceDate]"] != null)
{
info.InvoiceDate = Request.Form["pData[InvoiceDate]"];
}
if (Request.Form["pData[CheckCode]"] != null)
{
info.CheckCode = Request.Form["pData[CheckCode]"];
}
if (Request.Form["pData[MachineNumber]"] != null)
{
info.MachineNumber = Request.Form["pData[MachineNumber]"];
}
if (Request.Form["pData[GName]"] != null)
{
info.GName = Request.Form["pData[GName]"];
}
if (Request.Form["pData[GIdentificationCode]"] != null)
{
info.GIdentificationCode = Request.Form["pData[GIdentificationCode]"];
}
if (Request.Form["pData[GAddressPhone]"] != null)
{
info.GAddressPhone = Request.Form["pData[GAddressPhone]"];
}
if (Request.Form["pData[GBankAccount]"] != null)
{
info.GBankAccount = Request.Form["pData[GBankAccount]"];
}
if (Request.Form["pData[PasswordArea]"] != null)
{
info.PasswordArea = Request.Form["pData[PasswordArea]"];
}
if (Request.Form["pData[TotalPriceB]"] != null)
{
info.TotalPriceB = Request.Form["pData[TotalPriceB]"];
}
if (Request.Form["pData[TotalPriceS]"] != null)
{
info.TotalPriceS = Request.Form["pData[TotalPriceS]"];
}
if (Request.Form["pData[XName]"] != null)
{
info.XName = Request.Form["pData[XName]"];
}
if (Request.Form["pData[XIdentificationCode]"] != null)
{
info.XIdentificationCode = Request.Form["pData[XIdentificationCode]"];
}
if (Request.Form["pData[XAddressPhone]"] != null)
{
info.XAddressPhone = Request.Form["pData[XAddressPhone]"];
}
if (Request.Form["pData[XBankAccount]"] != null)
{
info.XBankAccount = Request.Form["pData[XBankAccount]"];
}
if (Request.Form["pData[InspectionTimes]"] != null)
{
info.InspectionTimes = Request.Form["pData[InspectionTimes]"];
}
if (Request.Form["pData[InspectionTime]"] != null)
{
info.InspectionTime = Request.Form["pData[InspectionTime]"];
}
if (Request.Form["pData[Remark]"] != null)
{
info.Remark = Request.Form["pData[Remark]"];
}
#endregion
List <InvoiceSubInfo> LsubInfo = new List <InvoiceSubInfo>();
if (Request.Form["pData[InvoiceSubInfo][0][InvoiceCode]"] != null)
{
for (int i = 0; i < 100; i++)
{
InvoiceSubInfo subInfo = new InvoiceSubInfo();
#region 子数据
if (string.IsNullOrEmpty(Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceCode]"]))
{
break;
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceCode]"] != null)
{
subInfo.InvoiceCode = Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceCode]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceNumber]"] != null)
{
subInfo.InvoiceNumber = Request.Form["pData[InvoiceSubInfo][" + i + "][InvoiceNumber]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][CheckCode]"] != null)
{
subInfo.CheckCode = Request.Form["pData[InvoiceSubInfo][" + i + "][CheckCode]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][MachineNumber]"] != null)
{
subInfo.MachineNumber = Request.Form["pData[InvoiceSubInfo][" + i + "][MachineNumber]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][NO]"] != null)
{
subInfo.NO = i.ToString();
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][GoodsName]"] != null)
{
subInfo.GoodsName = Request.Form["pData[InvoiceSubInfo][" + i + "][GoodsName]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][SpecificationModel]"] != null)
{
subInfo.SpecificationModel = Request.Form["pData[InvoiceSubInfo][" + i + "][SpecificationModel]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][Unit]"] != null)
{
subInfo.Unit = Request.Form["pData[InvoiceSubInfo][" + i + "][Unit]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][Quantity]"] != null)
{
subInfo.Quantity = Request.Form["pData[InvoiceSubInfo][" + i + "][Quantity]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][UnitPrice]"] != null)
{
subInfo.UnitPrice = Request.Form["pData[InvoiceSubInfo][" + i + "][UnitPrice]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][Money]"] != null)
{
subInfo.Money = Request.Form["pData[InvoiceSubInfo][" + i + "][Money]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][TaxRate]"] != null)
{
subInfo.TaxRate = Request.Form["pData[InvoiceSubInfo][" + i + "][TaxRate]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][Tax]"] != null)
{
subInfo.Tax = Request.Form["pData[InvoiceSubInfo][" + i + "][Tax]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][Total]"] != null)
{
subInfo.Total = Request.Form["pData[InvoiceSubInfo][" + i + "][Total]"];
}
if (Request.Form["pData[InvoiceSubInfo][" + i + "][TotalTax]"] != null)
{
subInfo.TotalTax = Request.Form["pData[InvoiceSubInfo][" + i + "][TotalTax]"];
}
#endregion
LsubInfo.Add(subInfo);
}
info.SubInfo = LsubInfo;
}
if (info.InvoiceCode != "")
{
DataSet ds = DataOperate.JudgeInvoiceInfo(info);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
json = "{success:'false',inf:'发票重复'}";
}
else
{
if (info.InvoiceType == "01")
{
DataSet dss = DataOperate.JudgeInvoiceInfoYN(info);
if (dss != null && dss.Tables[0].Rows.Count > 0)
{
int result = DataOperate.InsertInvoiceInfo(info);
if (result > 0)
{
json = "{success:'true',inf:'发票校验成功'}";
}
else
{
json = "{success:'false',inf:'发票数据存储出错'}";
}
}
else
{
json = "{success:'false',inf:'发票名称有误'}";
}
}
else
{
//DataSet dsss = DataOperate.JudgeInvoiceInfoName(info);
//if (dsss != null && dsss.Tables[0].Rows.Count > 0)
//{
int result = DataOperate.InsertInvoiceInfo(info);
if (result > 0)
{
json = "{success:'true',inf:'发票校验成功'}";
}
else
{
json = "{success:'false',inf:'发票数据存储出错'}";
}
//}
//else
//{
// json = "{success:'false',inf:'发票名称有误'}";
//}
}
}
}
Response.Write(json);
Response.End();
}
}