public string MakeUpInvoice(int accId, decimal invoiceMoney, int oid, string invoiceAddressee,
string invoicePhone, string invoiceName, string invoiceAdress)
{
var invoiceModel = new T_Order_Invoice();
invoiceModel.accId = accId;
invoiceModel.oid = oid;
invoiceModel.createDate = DateTime.Now;
invoiceModel.invoiceMoney = invoiceMoney;
invoiceModel.invoiceName = invoiceName;
invoiceModel.invoiceAddressee = invoiceAddressee;
invoiceModel.invoiceDesc = "信息服务费";
invoiceModel.invoicePhone = invoicePhone;
invoiceModel.invoiceAddress = invoiceAdress;
invoiceModel.invoiceStatus = 0;
invoiceModel.invoiceNo = "";
int invoiceId = T_Order_InvoiceBLL.AddInvoice(invoiceModel);
bool status = T_OrderInfoBLL.SetInvoiceId(accId, oid, invoiceId);
if (status)
{
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 增加一条发票信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddInvoice(T_Order_Invoice model)
{
int reVal = 0;
var strSql = new StringBuilder();
strSql.Append("insert into T_Order_Invoice(");
strSql.Append("accId,oid,createDate,invoiceMoney,invoiceName,invoiceDesc,invoicePhone,invoiceAddress,invoiceStatus,invoiceNo,invoiceRemark,invoiceOperatorId,invoiceOPeratorTime,invoiceAddressee)");
strSql.Append(" values (");
strSql.Append("@accId,@oid,@createDate,@invoiceMoney,@invoiceName,@invoiceDesc,@invoicePhone,@invoiceAddress,@invoiceStatus,null,null,null,null,@invoiceAddressee)");
strSql.Append(";select @@IDENTITY");
try
{
reVal = HelperForFrontend.ExecuteScalar <int>(strSql.ToString(), new
{
accId = model.accId,
oid = model.oid,
createDate = model.createDate,
invoiceMoney = model.invoiceMoney,
invoiceName = model.invoiceName,
invoiceDesc = model.invoiceDesc,
invoicePhone = model.invoicePhone,
invoiceAddress = model.invoiceAddress,
invoiceStatus = model.invoiceStatus,
invoiceAddressee = model.invoiceAddressee
});
}
catch (Exception ex)
{
return(0);
}
return(reVal);
}
/// <summary>
/// 增加一条发票信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int AddInvoice(T_Order_Invoice model)
{
T_Order_InvoiceDAL dal = new T_Order_InvoiceDAL();
return(dal.AddInvoice(model));
}
