private static string CreateNewOrderNo(cvmOrders model)
{
string str_order_no = "";
string str_guid = Guid.NewGuid().ToString().Substring(0, 25).ToUpper();
using (goshoppingEntities db = new goshoppingEntities())
{
Orders orders = new Orders();
orders.order_closed = 0;
orders.order_validate = 0;
orders.order_no = "";
orders.order_date = DateTime.Now;
orders.user_no = UserAccount.UserNo;
orders.order_status = "ON";
orders.order_guid = str_guid;
orders.payment_no = model.payment_no;
orders.shipping_no = model.shipping_no;
orders.receive_name = model.receive_name;
orders.receive_email = model.receive_email;
orders.receive_address = model.receive_address;
orders.remark = "";
db.Orders.Add(orders);
db.SaveChanges();
var neword = db.Orders.Where(m => m.order_guid == str_guid).FirstOrDefault();
if (neword != null)
{
str_order_no = neword.rowid.ToString().PadLeft(8, '0');
neword.order_no = str_order_no;
db.SaveChanges();
}
}
return(str_order_no);
}
private static int GetCartTotals()
{
int?int_totals = 0;
using (goshoppingEntities db = new goshoppingEntities())
{
if (UserAccount.IsLogin)
{
var data1 = db.Carts
.Where(m => m.user_no == UserAccount.UserNo)
.ToList();
if (data1 != null)
{
int_totals = data1.Sum(m => m.amount);
}
}
else
{
var data2 = db.Carts
.Where(m => m.lot_no == LotNo)
.ToList();
if (data2 != null)
{
int_totals = data2.Sum(m => m.amount);
}
}
}
if (int_totals == null)
{
int_totals = 0;
}
return(int_totals.GetValueOrDefault());
}
public ActionResult Edit(Status models)
{
bool status = false;
if (ModelState.IsValid)
{
using (goshoppingEntities db = new goshoppingEntities())
{
if (models.rowid > 0)
{
//Edit
var Status = db.Status.Where(m => m.rowid == models.rowid).FirstOrDefault();
if (Status != null)
{
Status.mno = models.mno;
Status.mname = models.mname;
Status.remark = models.remark;
}
}
else
{
//Save
db.Status.Add(models);
}
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
/// <summary>
/// 消費者付款
/// </summary>
public static void CartPayment(cvmOrders model)
{
OrderNo = CreateNewOrderNo(model);
using (goshoppingEntities db = new goshoppingEntities())
{
var datas = db.Carts
.Where(m => m.user_no == UserAccount.UserNo)
.ToList();
if (datas != null)
{
foreach (var item in datas)
{
OrdersDetail detail = new OrdersDetail();
detail.order_no = OrderNo;
detail.product_no = item.product_no;
detail.product_name = item.product_name;
detail.vendor_no = Shop.GetVendorNoByProduct(item.product_no);
detail.category_name = Shop.GetCategoryName(item.product_no);
detail.product_spec = item.product_spec;
detail.qty = item.qty;
detail.price = item.price;
detail.amount = item.amount;
detail.remark = "";
db.OrdersDetail.Add(detail);
db.SaveChanges();
db.Carts.Remove(item);
db.SaveChanges();
}
}
}
}
public static List <Status> GetStatusList()
{
using (goshoppingEntities db = new goshoppingEntities())
{
return(db.Status.OrderBy(m => m.mno).ToList());
}
}
/// <summary>
/// 取得商品子分類產品數量
/// </summary>
/// <param name="id">父分類id</param>
/// <returns></returns>
public static int GetProductCount(int id)
{
using (goshoppingEntities db = new goshoppingEntities())
{
return(db.Products.Where(m => m.categoryid == id).Count());
}
}
public ActionResult EditProfile(Users model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (goshoppingEntities db = new goshoppingEntities())
{
var user = db.Users
.Where(m => m.rowid == model.rowid)
.FirstOrDefault();
if (user != null)
{
user.mname = model.mname;
user.email = model.email;
user.birthday = model.birthday;
user.remark = model.remark;
db.SaveChanges();
}
return(RedirectToAction("AdminProfile"));
}
}
public static List <Users> GetVendorsList()
{
using (goshoppingEntities db = new goshoppingEntities())
{
return(db.Users.Where(m => m.role_no == "Vendor").OrderBy(m => m.mno).ToList());
}
}
public ActionResult Index(int id = 0, int code = -1)
{
UserAccount.UserStatus = id;
if (code == -1)
{
if (UserAccount.UserCode == -1)
{
UserAccount.UserCode = 0;
}
}
else
{
UserAccount.UserCode = code;
}
if (id > 0)
{
using (goshoppingEntities db = new goshoppingEntities())
{
string str_order_no = "";
var orders = db.Orders.Where(m => m.rowid == id).FirstOrDefault();
if (orders != null)
{
str_order_no = orders.order_no;
}
var details = db.OrdersDetail.Where(m => m.order_no == str_order_no).ToList();
ViewBag.OrderNo = str_order_no;
ViewBag.OrderDetail = details;
}
}
return(View());
}
public ActionResult ChangeStatus(int id = 0)
{
string str_status = "ON";
using (goshoppingEntities db = new goshoppingEntities())
{
var model = db.Orders.Where(m => m.rowid == id).FirstOrDefault();
if (model != null)
{
str_status = model.order_status;
}
var selectList = new List <SelectListItem>();
List <Status> lists = Shop.GetStatusList();
foreach (var item in lists)
{
SelectListItem list = new SelectListItem();
list.Value = item.mno;
list.Text = item.mname;
selectList.Add(list);
}
//預設選擇哪一筆
selectList.Where(m => m.Value == str_status).First().Selected = true;
ViewBag.SelectList = selectList;
return(View(model));
}
}
public ActionResult GetDataList()
{
using (goshoppingEntities db = new goshoppingEntities())
{
var models = db.Orders
.Join(db.Payments, p => p.payment_no, d => d.mno,
(p1, d1) => new { p1, payment_name = d1.mname })
.Join(db.Status, p => p.p1.order_status, d => d.mno,
(p2, d2) => new { p2, status_name = d2.mname })
.Join(db.Shippings, p => p.p2.p1.shipping_no, d => d.mno,
(p3, d3) => new
{
rowid = p3.p2.p1.rowid,
order_closed = p3.p2.p1.order_closed,
user_no = p3.p2.p1.user_no,
order_no = p3.p2.p1.order_no,
order_date = p3.p2.p1.order_date,
status_no = p3.p2.p1.order_status,
status_name = p3.status_name,
shipping_name = d3.mname,
payment_name = p3.p2.payment_name,
receive_name = p3.p2.p1.receive_name,
receive_address = p3.p2.p1.receive_address,
remark = p3.p2.p1.remark
})
.Where(m => m.user_no == UserAccount.UserNo)
.Where(m => m.order_closed == UserAccount.UserCode)
.OrderByDescending(m => m.order_no).ToList();
return(Json(new { data = models }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 取得目前購物車筆數
/// </summary>
/// <returns></returns>
private static int GetCartCount()
{
int int_count = 0;
using (goshoppingEntities db = new goshoppingEntities())
{
if (UserAccount.IsLogin)
{
var data1 = db.Carts
.Where(m => m.user_no == UserAccount.UserNo)
.ToList();
if (data1 != null)
{
int_count = data1.Count;
}
}
else
{
var data2 = db.Carts
.Where(m => m.lot_no == LotNo)
.ToList();
if (data2 != null)
{
int_count = data2.Count;
}
}
}
return(int_count);
}
/// <summary>
/// 取得父分類列表
/// </summary>
/// <param name="catrgoryNo">分類代號</param>
/// <param name="list_no">代號列表</param>
/// <param name="list_name">名稱列表</param>
/// <returns></returns>
public static int GetParentCategoryList(string catrgoryNo, ref List <string> list_no, ref List <string> list_name)
{
using (goshoppingEntities db = new goshoppingEntities())
{
int int_id = 0;
int int_count = 0;
var model = db.Categorys.Where(m => m.category_no == catrgoryNo).FirstOrDefault();
if (model != null)
{
int_id = model.rowid;
while (int_id > 0)
{
var item = db.Categorys.Where(m => m.rowid == int_id).FirstOrDefault();
if (item == null)
{
return(int_count);
}
int_count++;
list_no.Add(item.category_no);
list_name.Add(item.category_name);
int_id = item.parentid.GetValueOrDefault();
}
}
return(int_count);
}
}
public ActionResult GetDataList()
{
using (Models.goshoppingEntities db = new goshoppingEntities())
{
var models = db.HeartDetails.OrderBy(m => m.rowid).ToList();
return(Json(new { data = models }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetDataList()
{
using (goshoppingEntities db = new goshoppingEntities())
{
var models = db.Status.OrderBy(m => m.mno).ToList();
return(Json(new { data = models }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(Products models)
{
bool status = false;
if (ModelState.IsValid)
{
using (goshoppingEntities db = new goshoppingEntities())
{
int int_cate_id = 0;
if (models.rowid > 0)
{
//Edit
var products = db.Products.Where(m => m.rowid == models.rowid).FirstOrDefault();
if (products != null)
{
int_cate_id = models.categoryid.GetValueOrDefault();
products.product_no = models.product_no;
products.product_name = models.product_name;
products.product_spec = models.product_spec;
products.categoryid = int_cate_id;
products.category_name = Shop.GetCategoryName(int_cate_id);
products.istop = (models.bool_istop) ? 1 : 0;
products.issale = (models.bool_issale) ? 1 : 0;
products.issize = (models.bool_issize) ? 1 : 0;
products.iscolor = (models.bool_iscolor) ? 1 : 0;
products.price = models.price;
products.start_count = models.start_count;
products.browse_count = models.browse_count;
products.vendor_no = UserAccount.UserNo;
products.remark = models.remark;
products.product_content = models.product_content;
products.deadline_end = models.deadline_end;
products.deadline_start = models.deadline_start;
products.product_tag = models.product_tag;
products.color_name = models.color_name;
products.size_name = models.size_name;
}
}
else
{
//Save
models.vendor_no = UserAccount.UserNo;
int_cate_id = models.categoryid.GetValueOrDefault();
models.category_name = Shop.GetCategoryName(int_cate_id);
models.istop = (models.bool_istop) ? 1 : 0;
models.issale = (models.bool_issale) ? 1 : 0;
models.issize = (models.bool_issize) ? 1 : 0;
models.iscolor = (models.bool_iscolor) ? 1 : 0;
db.Products.Add(models);
}
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Edit(Users models)
{
bool status = false;
ModelState.Remove("Password"); //忽略 Password 驗證
ModelState.Remove("role_no"); //忽略 role_no 驗證
if (ModelState.IsValid)
{
using (goshoppingEntities db = new goshoppingEntities())
{
if (models.rowid > 0)
{
//Edit
var users = db.Users.Where(m => m.rowid == models.rowid).FirstOrDefault();
if (users != null)
{
users.isvarify = Shop.BoolToInteger(models.bool_isvarify);
users.mno = models.mno;
users.mname = models.mname;
users.email = models.email;
users.birthday = models.birthday;
users.remark = models.remark;
}
}
else
{
//Save
models.role_no = UserAccount.UserRoleNo;
models.varify_code = UserAccount.GetNewVarifyCode(); //產生驗證碼
if (UserAccount.UserStatus < 2)
{
models.isvarify = UserAccount.UserStatus;
}
else
{
models.isvarify = Shop.BoolToInteger(models.bool_isvarify);
}
db.Users.Add(models);
}
try
{
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
db.Configuration.ValidateOnSaveEnabled = true;
status = true;
}
catch (Exception ex)
{
string str_message = ex.Message;
status = false;
}
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Edit(int id = 0)
{
using (goshoppingEntities db = new goshoppingEntities())
{
var models = db.Products.Where(m => m.rowid == id).FirstOrDefault();
//Category DropDownList
string str_rowid = "0";
var categoryList = new List <SelectListItem>();
List <Categorys> clists = db.Categorys.OrderBy(m => m.category_no).ToList();
foreach (var item in clists)
{
SelectListItem list = new SelectListItem();
list.Value = item.rowid.ToString();
list.Text = Shop.GetCategoryName(item.rowid);
categoryList.Add(list);
if (id == 0)
{
if (str_rowid == "0")
{
str_rowid = item.rowid.ToString();
}
}
}
if (models != null)
{
str_rowid = models.categoryid.ToString();
}
//預設選擇哪一筆
categoryList.Where(m => m.Value == str_rowid).First().Selected = true;
ViewBag.CategoryList = categoryList;
if (id == 0)
{
Products new_model = new Products();
new_model.size_name = "";
new_model.color_name = "";
new_model.remark = "";
new_model.start_count = 5;
new_model.browse_count = 0;
new_model.bool_istop = false;
new_model.bool_issale = true;
new_model.bool_iscolor = true;
new_model.bool_issize = true;
return(View(new_model));
}
models.bool_istop = (models.istop == 1);
models.bool_issale = (models.issale == 1);
models.bool_iscolor = (models.iscolor == 1);
models.bool_issize = (models.issize == 1);
return(View(models));
}
}
public static List <HeartDetails> HeartNew()
{
goshoppingEntities db = new goshoppingEntities();
var lists = db.HeartDetails
.Where(m => m.flag == 1)
.OrderBy(m => m.deadline_start)
.ToList();
return(lists);
}
public ActionResult EditProfile()
{
using (goshoppingEntities db = new goshoppingEntities())
{
var model = db.Users
.Where(m => m.mno == UserAccount.UserNo)
.FirstOrDefault();
return(View(model));
}
}
public ActionResult GetDataList()
{
using (goshoppingEntities db = new goshoppingEntities())
{
int int_pid = int.Parse(Session["CategoryID"].ToString());
var models = db.Categorys
.Where(m => m.parentid == int_pid)
.OrderBy(m => m.category_no).ToList();
return(Json(new { data = models }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 取得商品子分類列表
/// </summary>
/// <param name="id">父分類id</param>
/// <returns></returns>
public static List <Categorys> GetCategorys(int id)
{
using (goshoppingEntities db = new goshoppingEntities())
{
var lists = db.Categorys
.Where(m => m.parentid == id)
.OrderBy(m => m.category_no)
.ToList();
return(lists);
}
}
public static List <Products> GetProducts()
{
using (goshoppingEntities db = new goshoppingEntities())
{
var lists = db.Products
.Where(m => m.issale == 1)
.OrderBy(m => m.deadline_end)
.ToList();
return(lists);
}
}
public ActionResult GetDataList()
{
using (goshoppingEntities db = new goshoppingEntities())
{
var models = db.HeartDetails
.Where(m => m.Mno == UserAccount.UserNo)
.OrderBy(m => m.heart_no)
.ToList();
return(Json(new { data = models }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(int id = 0)
{
using (goshoppingEntities db = new goshoppingEntities())
{
if (id == 0)
{
Status new_model = new Status();
return(View(new_model));
}
var models = db.Status.Where(m => m.rowid == id).FirstOrDefault();
return(View(models));
}
}
public ActionResult ReturnToParent()
{
using (goshoppingEntities db = new goshoppingEntities())
{
int int_pid = int.Parse(Session["CategoryID"].ToString());
var model = db.Categorys.Where(m => m.rowid == int_pid).FirstOrDefault();
if (model != null)
{
int_pid = model.parentid.GetValueOrDefault();
}
return(RedirectToAction("Index", "Category", new { id = int_pid }));
}
}
public static List <Products> GetTopColthProducts()
{
using (goshoppingEntities db = new goshoppingEntities())
{
var lists = db.Products
.Where(m => m.istop == 1)
.Where(m => m.issale == 1)
.Where(m => m.categoryid == 3 || m.categoryid == 10 || m.categoryid == 11 || m.categoryid == 12)
.OrderBy(m => m.product_no)
.ToList();
return(lists);
}
}
/// <summary>
/// 取得日期範圍中的銷售金額
/// </summary>
/// <param name="startDate">開始日期</param>
/// <param name="endDate">結束日期</param>
/// <returns></returns>
private int GetSaleAmount(DateTime startDate, DateTime endDate)
{
using (goshoppingEntities db = new goshoppingEntities())
{
int int_amount = 0;
startDate = startDate.ezMinDateTime();
endDate = endDate.ezMaxDateTime();
if (UserAccount.RoleNo == AppEnum.enUserRole.Admin)
{
object obj_value = db.OrdersDetail
.Join(db.Orders, p => p.order_no, d => d.order_no,
(p1, d1) => new { p1, d1 })
.Where(m => m.d1.order_date >= startDate)
.Where(m => m.d1.order_date <= endDate)
.Sum(m => m.p1.amount);
if (obj_value != null)
{
int.TryParse(obj_value.ToString(), out int_amount);
}
}
if (UserAccount.RoleNo == AppEnum.enUserRole.Member)
{
object obj_value = db.OrdersDetail
.Join(db.Orders, p => p.order_no, d => d.order_no,
(p1, d1) => new { p1, d1 })
.Where(m => m.d1.order_date >= startDate)
.Where(m => m.d1.order_date <= endDate)
.Where(m => m.d1.user_no == UserAccount.UserNo)
.Sum(m => m.p1.amount);
if (obj_value != null)
{
int.TryParse(obj_value.ToString(), out int_amount);
}
}
if (UserAccount.RoleNo == AppEnum.enUserRole.Vendor)
{
object obj_value = db.OrdersDetail
.Join(db.Orders, p => p.order_no, d => d.order_no,
(p1, d1) => new { p1, d1 })
.Where(m => m.d1.order_date >= startDate)
.Where(m => m.d1.order_date <= endDate)
.Where(m => m.p1.vendor_no == UserAccount.UserNo)
.Sum(m => m.p1.amount);
if (obj_value != null)
{
int.TryParse(obj_value.ToString(), out int_amount);
}
}
return(int_amount);
}
}
/// <summary>
/// 取得置頂商品列表
/// </summary>
/// <returns></returns>
public static List <Products> GetTopProducts()
{
using (goshoppingEntities db = new goshoppingEntities())
{
var lists = db.Products
.Where(m => m.ishot == 1)
.Where(m => m.issale == 1)
.OrderBy(m => m.product_no)
.ToList();
return(lists);
}
}
public static string GetUserName(string userNo)
{
string str_name = "";
using (goshoppingEntities db = new goshoppingEntities())
{
var models = db.Users.Where(m => m.mno == userNo).FirstOrDefault();
if (models != null)
{
str_name = models.mname;
}
}
return(str_name);
}
