//GET: OrderList
public ActionResult OrderList()
{
if (!check())
{
return(RedirectToAction("Login", "User"));
}
var dao = new OrderDao();
List <ListOrderModel> res = new List <ListOrderModel>();
List <DonHang> listOrder = new List <DonHang>();
listOrder = dao.getOrderList();
foreach (var item in listOrder)
{
ListOrderModel order = new ListOrderModel();
order.ID = item.ID;
order.OrderCode = item.OrderCode;
order.CustomerID = item.CustomerID;
order.Price = item.Price;
order.Timer = item.Timer;
order.State = 0;
List <OrderDetail> tmp = dao.getInfoOrder(item.ID);
foreach (var i in tmp)
{
order.list.Add(i.FoodID, i.Quantily);
}
res.Add(order);
}
return(View(res));
}
public static string GetDeclPdf(string orderCode)
{
ListOrderModel orderModel = new ListOrderModel();
DataTable dt = orderModel.getDeclPath(orderCode);
string json = "";
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
string output = HttpRuntime.AppDomainAppPath + @"\TempFile\tempPdf\" + dr["declcode"] + ".pdf";
bool bf = true;
if (!File.Exists(output))
{
//PDF获取文件
System.Uri Uri = new Uri("ftp://" + ConfigurationManager.AppSettings["FTPServer"] + ":" + ConfigurationManager.AppSettings["FTPPortNO"]);
string UserName = ConfigurationManager.AppSettings["FTPUserName"];
string Password = ConfigurationManager.AppSettings["FTPPassword"];
FtpHelper ftp = new FtpHelper(Uri, UserName, Password);
bf = ftp.DownloadFile("/" + dr["filename"].ToString2() + "", output);
}
if (bf)
{
//pdf转picture
string picPath = HttpRuntime.AppDomainAppPath + @"\TempFile\tempPic\";
json += ConvertPDF.pdfToPic(output, picPath, dr["declcode"].ToString2());
}
}
}
return(json);
}
public static string QueryOrderDetail(string code)
{
try
{
ListOrderModel orderModel = new ListOrderModel();
DataSet ds = orderModel.getOrderDetail(code);
ds.Tables[0].Rows[0]["busitype"] = SwitchHelper.switchValue("busitype", ds.Tables[0].Rows[0]["busitype"].ToString2());
if (ds.Tables.Count > 1 && ds.Tables[1].Columns.Contains("modifyflag"))
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
dr["modifyflag"] = SwitchHelper.switchValue("modifyflag", dr["modifyflag"].ToString2());
}
}
if (ds.Tables.Count > 2 && ds.Tables[2].Columns.Contains("modifyflag"))
{
foreach (DataRow dr in ds.Tables[2].Rows)
{
dr["modifyflag"] = SwitchHelper.switchValue("modifyflag", dr["modifyflag"].ToString2());
}
}
IsoDateTimeConverter iso = new IsoDateTimeConverter();//序列化JSON对象时,日期的处理格式
iso.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string json = JsonConvert.SerializeObject(ds, iso);
return(json);
}
catch (Exception e)
{
LogHelper.Write("MyBusiness_QueryOrderDetail异常:" + e.Message);
return("");
}
}
public static string getInfo(string code)
{
ListOrderModel model = new ListOrderModel();
DataTable dt = model.getSubsInfo(code);
IsoDateTimeConverter iso = new IsoDateTimeConverter();//序列化JSON对象时,日期的处理格式
try
{
foreach (DataRow dr in dt.Rows)
{
dr["ischeck"] = dr["ischeck"].ToString2() == "1" ? "海关查验" : "";
dr["checkpic"] = dr["checkpic"].ToString2() == "1" ? "含查验图片" : "";
dr["inspischeck"] = dr["inspischeck"].ToString2() == "1" ? "国检查验" : "";
dr["lawflag"] = dr["lawflag"].ToString2() == "1" ? "含法检" : "";
dr["declstatus"] = SwitchHelper.switchValue("declstatus", dr["declstatus"].ToString2());
dr["inspstatus"] = SwitchHelper.switchValue("inspstatus", dr["inspstatus"].ToString2());
if (string.IsNullOrEmpty(dr["divideno"].ToString2()))
{
dr["divideno"] = "";
}
if (string.IsNullOrEmpty(dr["logisticsstatus"].ToString2()))
{
dr["logisticsstatus"] = "";
}
if (string.IsNullOrEmpty(dr["contractno"].ToString2()))
{
dr["contractno"] = "";
}
}
}
catch (Exception e)
{
LogHelper.Write("BusiSubsDetail:" + e.Message);
}
iso.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string json = JsonConvert.SerializeObject(dt, iso);
return(json);
}
public ActionResult ListOrders(string date1, string date2, string filter = "", int status = 0, int page = 1)
{
try
{
// Validate page
page = page > 0 ? page : 1;
// Get default pagesize
var pageSize = int.Parse(ConfigurationManager.AppSettings["PAGE_SIZE"]);
// Get search date range
var provider = CultureInfo.InvariantCulture;
var d1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
var d2 = DateTime.Now;
if (!String.IsNullOrWhiteSpace(date1) && !String.IsNullOrWhiteSpace(date2))
{
DateTime.TryParseExact(date1, "dd/MM/yyyy", provider, DateTimeStyles.None, out d1);
DateTime.TryParseExact(date2 + " 23:59:59", "dd/MM/yyyy HH:mm:ss", provider, DateTimeStyles.None, out d2);
}
// Query data
var pDate1 = new SqlParameter("date1", d1);
var pDate2 = new SqlParameter("date2", d2);
var pFilter = new SqlParameter("filter", filter);
var pStatus = new SqlParameter("status", status);
var pPageIndex = new SqlParameter("pageIndex", page);
var pPageSize = new SqlParameter("pageSize", pageSize);
var pItemCount = new SqlParameter("itemCount", System.Data.SqlDbType.Int, 4);
pPageIndex.Direction = System.Data.ParameterDirection.InputOutput;
pItemCount.Direction = System.Data.ParameterDirection.Output;
var orders = db.Database.SqlQuery <Order>(@"EXEC [dbo].[usp_searchOrders]
@date1,
@date2,
@filter,
@status,
@pageIndex OUT,
@pageSize,
@itemCount OUT",
pDate1,
pDate2,
pFilter,
pStatus,
pPageIndex,
pPageSize,
pItemCount).ToList();
// Create view model
var totalItems = (int)pItemCount.Value;
var pager = new Pager(totalItems, (int)pPageIndex.Value, pageSize);
var statusOptions = new SelectListItem[]
{
new SelectListItem {
Value = "0", Text = "--Tất cả--", Selected = (status == 0)
},
new SelectListItem {
Value = "1", Text = "Đang Mở", Selected = (status == (int)Order.Status.STATUS_OPENED)
},
new SelectListItem {
Value = "2", Text = "Đã tiếp nhận", Selected = (status == (int)Order.Status.STATUS_PENDIND)
},
new SelectListItem {
Value = "3", Text = "Đang xử lý lý", Selected = (status == (int)Order.Status.STATUS_PROCESSING)
},
new SelectListItem {
Value = "4", Text = "Hoàn tất", Selected = (status == (int)Order.Status.STATUS_FINISHED)
},
new SelectListItem {
Value = "5", Text = "Đã đóng", Selected = (status == (int)Order.Status.STATUS_CLOSED)
}
};
var model = new ListOrderModel
{
Date1 = d1,
Date2 = d2,
Filter = filter,
Status = status,
StatusOptions = statusOptions,
Items = orders,
Pager = pager
};
return(View(model));
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.ToString());
EventWriter.WriteEventLog("SaleController - ListOrders: " + ex.ToString());
}
return(View());
}
public static string QueryData(string submittimestart, string submittimeend, string declarationcode, string customarea, string ispass, string ischeck, string busitype,
string modifyflag, string auditflag, string busiunit, string ordercode, string cusno, string divideno, string contractno, string passtimestart, string passtimeend,
int itemsperload, int lastindex)
{
string sum = "0";
ListOrderModel orderModel = new ListOrderModel();
WGUserEn user = (WGUserEn)HttpContext.Current.Session["user"];
if (user == null || string.IsNullOrEmpty(user.CustomerCode))
{
return("");
}
string customerCode = user.CustomerCode;
string hsCode = user.HSCode;
if (user.IsCompany != 1)//如果不是企业角色，不能查出其对应经营单位的订单
{
hsCode = "";
}
if (user.IsCustomer != 1)//如果不是委托单位角色，不能查出其对应委托单位的订单
{
customerCode = "";
}
DataTable dt = orderModel.getOrder(submittimestart, submittimeend, declarationcode, customarea, ispass, ischeck, busitype, modifyflag, auditflag, busiunit, ordercode,
cusno, divideno, contractno, passtimestart, passtimeend, itemsperload, lastindex, customerCode, hsCode, out sum);
//DataTable dt = orderModel.getOrder(submittimestart, submittimeend, declarationcode, customarea, ispass, ischeck, busitype, modifyflag, auditflag, busiunit, ordercode,
// cusno, divideno, contractno, passtimestart, passtimeend, itemsperload, lastindex, "RBDZKJKSYXGS", "3223640003", out sum);
IsoDateTimeConverter iso = new IsoDateTimeConverter();//序列化JSON对象时,日期的处理格式
try
{
foreach (DataRow dr in dt.Rows)
{
dr["ischeck"] = dr["ischeck"].ToString2() == "1" ? "海关查验" : "";
dr["checkpic"] = dr["checkpic"].ToString2() == "1" ? "含查验图片" : "";
dr["inspischeck"] = dr["inspischeck"].ToString2() == "1" ? "国检查验" : "";
dr["lawflag"] = dr["lawflag"].ToString2() == "1" ? "含法检" : "";
dr["declstatus"] = SwitchHelper.switchValue("declstatus", dr["declstatus"].ToString2());
dr["inspstatus"] = SwitchHelper.switchValue("inspstatus", dr["inspstatus"].ToString2());
if (string.IsNullOrEmpty(dr["divideno"].ToString2()))
{
dr["divideno"] = "";
}
if (string.IsNullOrEmpty(dr["logisticsstatus"].ToString2()))
{
dr["logisticsstatus"] = "";
}
if (string.IsNullOrEmpty(dr["contractno"].ToString2()))
{
dr["contractno"] = "";
}
dr["sum"] = sum;
}
}
catch (Exception e)
{
LogHelper.Write("MyBusiness_QueryData:" + e.Message);
}
iso.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string json = JsonConvert.SerializeObject(dt, iso);
return(json);
}
