/// <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)); }