/// <summary>
/// 得到价格实体
/// </summary>
protected virtual IList <OrderInvoiceEntity> GetChangeAmountEntities()
{
var infos = new List <OrderInvoiceEntity>();
foreach (GridViewRow gvr in GridView.Rows)
{
if (gvr.RowType != DataControlRowType.DataRow)
{
continue;
}
var ckSelect = gvr.FindControl("ckSelect") as System.Web.UI.HtmlControls.HtmlInputCheckBox;
if (ckSelect != null && !ckSelect.Checked)
{
continue;
}
var txtAmount = gvr.FindControl("txtAmount") as System.Web.UI.HtmlControls.HtmlInputText;
var txtRemark = gvr.FindControl("txtRemark") as System.Web.UI.HtmlControls.HtmlInputText;
if (txtAmount == null)
{
continue;
}
var info = new OrderInvoiceEntity
{
Id = ckSelect.Value.Convert <long>(),
Amount = txtAmount.Value.Convert <decimal>(),
Remark = txtRemark.Value,
SaveType = SaveType.Modify,
};
info.SetProperty(it => it.Amount);
info.SetProperty(it => it.Remark);
infos.Add(info);
}
return(infos);
}
public List <OrderInvoiceEntity> Getinvoicedetails()
{
// int i = 0;
OrderInvoiceEntity inventity;
List <OrderInvoiceEntity> invList = new List <OrderInvoiceEntity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spGetInvoiceDetails", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
inventity = new OrderInvoiceEntity();
inventity.InvOrderNo = Convert.ToInt32(dr["InvOrderno"]);
inventity.InvoiceNo = Convert.ToInt32(dr["InvoiceNo"]);
inventity.InvoiceType = dr["InvoiceType"].ToString();
inventity.CustomerName = dr["CustomerName"].ToString();
inventity.InvoiceDate = Convert.ToDateTime(dr["Currentdate"]);
inventity.deliverydate = Convert.ToDateTime(dr["DeliveryDate"]);
int i = dr.GetOrdinal("ETAdate");
if (dr.IsDBNull(i))
{
inventity.ETADate = DateTime.MinValue;
}
else
{
inventity.ETADate = Convert.ToDateTime(dr["ETAdate"]);
}
inventity.InvoiceAmount = Convert.ToDecimal(dr["Inv_Amt"]);
inventity.RecieveAmt = Convert.ToDecimal(dr["RecieveAmt"]);
inventity.UploadFileName = dr["UploadFile"].ToString();
inventity.PendingDays = Convert.ToInt32(dr["Pendingdays"]);
invList.Add(inventity);
}
if (isnull)
{
return(null);
}
else
{
return(invList);
}
}
}
}
}
// public ActionResult OrderInvoice(List<OrderInvoiceEntity> Invoicedetails)
public ActionResult OrderInvoice(List <OrderInvoiceEntity> Invoicedetails)
{
string fileName = "";
string path = Server.MapPath("~/Content/Uploads");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
try
{
if (Request != null)
{
HttpPostedFileBase file = Request.Files["postedFile"];
if (file != null && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
fileName = file.FileName;
//string fileName = Path.GetFileName(invoicemodel.UploadImage.FileName);
//string invstatus = Request.Form["uploadType"].ToString();
file.SaveAs(Path.Combine(path, fileName));
}
}
}
catch (Exception ex)
{
string msg = ex.Message;
}
List <OrderInvoiceEntity> ulist = new List <OrderInvoiceEntity>();
OrderInvoiceEntity ent;
// var Invorderno = Invoicedetails.ToArray();
ent = new OrderInvoiceEntity();
ent.InvOrderNo = Convert.ToInt32(Request.Form["UploadInvOrderNo"]);
ent.UploadFileName = fileName.ToString();
ulist.Add(ent);
AddSerialBL obj = new AddSerialBL();
int value = obj.AddUploadInvoiceFile(ulist);
if (value == 1)
{
Response.Write("<script>alert('Updated successfully')</script>");
}
else
{
Response.Write("<script>alert('Not Updated successfully')</script>");
}
return(RedirectToAction("OrderInvoice"));
}
public List <OrderInvoiceEntity> GetInvoiceStatus()
{
// int i = 0;
OrderInvoiceEntity inventity;
List <OrderInvoiceEntity> invList = new List <OrderInvoiceEntity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spGetInvoiceStatus", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
inventity = new OrderInvoiceEntity();
inventity.InvOrderNo = Convert.ToInt32(dr["InvOrderno"]);
inventity.InvoiceNo = Convert.ToInt32(dr["Invoiceno"]);
inventity.status_id = Convert.ToInt32(dr["Status_id"]);
inventity.InvoiceType = (dr["InvoiceType"]).ToString();
inventity.CustomerName = dr["CustomerName"].ToString();
inventity.InvoiceAmount = Convert.ToInt32(dr["InvoiceAmount"]);
inventity.RecieveAmt = Convert.ToDecimal(dr["RecieveAmt"]);
inventity.InvoiceDate = Convert.ToDateTime(dr["Invoicedate"]);
inventity.RecivingDate = Convert.ToDateTime(dr["Receiveddate"]);
inventity.InvComment = Convert.ToString(dr["Comment"]);
inventity.UploadFileName = Convert.ToString(dr["UploadFile"]);
invList.Add(inventity);
}
if (isnull)
{
return(null);
}
else
{
return(invList);
}
}
}
}
}
public List <OrderInvoiceEntity> GetTransactiondetails(string OrderNo)
{
// int i = 0;
OrderInvoiceEntity inventity;
List <OrderInvoiceEntity> invList = new List <OrderInvoiceEntity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spGetTransactionDetails", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter InvOrderNo = cmd.Parameters.AddWithValue("@OrderNo", OrderNo);
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
inventity = new OrderInvoiceEntity();
inventity.TransactionId = Convert.ToInt32(dr["Transaction_id"]);
inventity.InvOrderNo = Convert.ToInt32(dr["InvoiceOrderNo"]);
inventity.InvType = dr["Amt_type"].ToString();
inventity.RecieveAmt = Convert.ToDecimal(dr["RecievedAmt"]);
inventity.AdjustmentValue = Convert.ToDecimal(dr["AdjustedValue"]);
inventity.Reciving_Date = dr["RecieveDate"].ToString();
inventity.InvComment = dr["ReceivedComment"].ToString();
invList.Add(inventity);
}
if (isnull)
{
return(null);
}
else
{
return(invList);
}
}
}
}
}
/// <summary>
/// 设置发票核销
/// </summary>
protected virtual void SetInvoices(bool isStatus)
{
InvokeItemLoader("InvoiceoutItems");
if (InvoiceoutItems == null)
{
return;
}
foreach (var invoiceoutItem in InvoiceoutItems)
{
var invoice = new OrderInvoiceEntity
{
Order = invoiceoutItem.Order,
Number = InvoiceNumber,
Amount = isStatus ? invoiceoutItem.Amount : 0 - invoiceoutItem.Amount,
Remark = "",
SaveType = SaveType.Add
};
OrderInvoices.Add(invoice);
}
}
public List <OrderInvoiceEntity> CheckReceiveAmt(int ReceiveOrderId, decimal AdjustedAmt, decimal ReceiveAmt)
{
// int i = 0;
OrderInvoiceEntity inventity;
List <OrderInvoiceEntity> invList = new List <OrderInvoiceEntity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("SpCheckReceivedAmt", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter ReceivedAmt = cmd.Parameters.AddWithValue("@ReceiveAmt", ReceiveAmt);
SqlParameter Adjustedvalue = cmd.Parameters.AddWithValue("@AdjustedValue", AdjustedAmt);
SqlParameter Invordeno = cmd.Parameters.AddWithValue("@InvOrderNo", ReceiveOrderId);
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
inventity = new OrderInvoiceEntity();
inventity.ReceivedValue = Convert.ToInt32(dr["ReceivedAmt"]);
invList.Add(inventity);
}
if (isnull)
{
return(null);
}
else
{
return(invList);
}
}
}
}
}
public List <OrderInvoiceEntity> GetCommentbyRoles(string username)
{
// int i = 0;
OrderInvoiceEntity inventity;
List <OrderInvoiceEntity> invList = new List <OrderInvoiceEntity>();
using (SqlConnection myConnection = new SqlConnection(cs))
{
using (SqlCommand cmd = new SqlCommand("spGetCommentbyRoles", myConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
myConnection.Open();
SqlParameter UploadType = cmd.Parameters.AddWithValue("@USERNAME", username);
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
inventity = new OrderInvoiceEntity();
inventity.Emp_id = Convert.ToInt32(dr["Emp_id"]);
invList.Add(inventity);
}
if (isnull)
{
return(null);
}
else
{
return(invList);
}
}
}
}
}
public ActionResult GetSamllBill()
{
var id = Request["id"] as string;
var templeid = Request["templeid"] as string;
var tempId = templeid.ToInt();
List <OrderGroupQueryModel> details = null;
OrderFeeQueryModel otherFee = null;
OrderInvoiceEntity invoice = null;
var qrcodeUrl = string.Empty;
var viewName = "Delivery";
var order = obServ.GetOrder(id);
if (order != null)
{
var detail = obServ.GetDetail(id);
details = obServ.GetOrderDetails(order.PlatformId, (detail != null ? detail.Detail : string.Empty));
otherFee = obServ.GetOrderFeeDetail(order, detail);
invoice = obServ.GetOrderInvoice(id);
switch (tempId)
{
case (int)SmallBillType.Kitchen:
{
//厨房小票
viewName = "Kitchen";
break;
}
case (int)SmallBillType.Merchant:
{
//商家小票
viewName = "Merchant";
break;
}
case (int)SmallBillType.Delivery:
{
//配送小票
viewName = "Delivery";
qrcodeUrl = obServ.GetOrderDetailUrl(order.Id);
break;
}
case (int)SmallBillType.Customer:
{
//客户小票
viewName = "Customer";
qrcodeUrl = obServ.GetOrderDetailUrl(order.Id);
break;
}
case (int)SmallBillType.Cancel:
{
//取消小票
viewName = "Cancel";
break;
}
default:
break;
}
}
ViewBag.Order = order;
ViewBag.Details = details;
ViewBag.OtherFee = otherFee;
ViewBag.Invoice = invoice != null ? (string.Format("{0}{1}", invoice.InvoiceHeader, (!string.IsNullOrWhiteSpace(invoice.TaxPayerId) ? string.Format("【{0}】", invoice.TaxPayerId) : string.Empty))) : string.Empty;
ViewBag.QrcodeUrl = qrcodeUrl;
return(View(viewName));
}
