protected override void InitDict() { base.InitDict(); if (cu.x_cart.Count() == 0) { dict.Add("img", "/img/wx/uig.png"); dict.Add("msg", "购物车是空的"); dict.Add("bt_txt", "去选商品"); dict.Add("bt_url", "/wx/goods/list.html"); dict.Add("show_foot", 1); } else { decimal shipAmount = cu.x_cart.Where(o => o.calcfreight == 1).Sum(o => o.price * o.count).Value;//?? decimal shipfee = shipAmount >= cfg.free_ship ? 0 : cfg.shipfee; dict.Add("gs", cu.x_cart.ToList()); dict.Add("gc", cu.x_cart.Where(o => o.sel == true).Sum(o => o.count)); dict.Add("ps", cu.x_cart.Where(o => o.sel == true).Sum(o => o.price * o.count)); dict.Add("shipfee", shipfee); x_address ad = cu.x_address.FirstOrDefault(o => o.address_id == aid); if (ad == null) { ad = cu.x_address.FirstOrDefault(); } dict.Add("ad", ad); var ds = new List <string>(); var dt = DateTime.Now; for (var i = 0; ds.Count() < 4;) { var d = dt.AddDays(i++); if (d.DayOfWeek == DayOfWeek.Saturday || d.DayOfWeek == DayOfWeek.Sunday) { continue; } ds.Add(d.ToString("yyyy-MM-dd")); } dict.Add("ds", ds); } }
protected override XResp Execute() { x_address ad = null; if (id > 0) { ad = cu.x_address.FirstOrDefault(o => o.address_id == id); } if (ad == null) { ad = new x_address() { ctime = DateTime.Now, user_id = cu.id } } ; ad.sheng = GetDictName("sys.city", p); ad.shi = GetDictName("sys.city", c); ad.qu = GetDictName("sys.city", x); ad.zhen = GetDictName("sys.city", s); ad.tel = tel; ad.addr = addr; ad.name = name; if (ad.address_id == 0) { DB.x_address.InsertOnSubmit(ad); } SubmitDBChanges(); return(new XResp() { msg = ad.address_id + "" }); } }
//public static string CekNoIden(string identity_no) //{ // using (DBSpecEntities db = new DBSpecEntities()) // { // x_biodata dt = db.x_biodata.Where(a => a.identity_no.Equals(identity_no)).FirstOrDefault(); // if(dt!= null) // { // return "ada"; // } // else // { // return "tidak ada"; // } // } //} //public static string CekNoIden(string identity_no, int identity_type_id) //{ // using (DBSpecEntities db = new DBSpecEntities()) // { // x_biodata dt = db.x_biodata.Where(a => a.identity_no.Equals(identity_no)).FirstOrDefault(); // x_biodata dt2 = db.x_biodata.Where(b => b.identity_type_id.Equals(identity_type_id)).FirstOrDefault(); // if (dt != null) // { // if (dt2 != null) // { // return "ada"; // } // } // else // { // return "tidak ada"; // } // } //} public static bool saveData(VMPelamar bio) { using (DBSpecEntities db = new DBSpecEntities()) { try { x_biodata isibiodata = new x_biodata(); isibiodata.fullname = bio.fullname; isibiodata.nick_name = bio.nick_name; isibiodata.pob = bio.pob; isibiodata.dob = bio.dob; isibiodata.gender = bio.gender; isibiodata.religion_id = bio.religion_id; isibiodata.high = bio.high; isibiodata.weight = bio.weight; isibiodata.nationally = bio.nationally; isibiodata.ethnic = bio.ethnic; isibiodata.hobby = bio.hobby; isibiodata.identity_type_id = bio.identity_type_id; isibiodata.identity_no = bio.identity_no; isibiodata.email = bio.email; isibiodata.phone_number1 = bio.phone_number1; isibiodata.phone_number2 = bio.phone_number2; isibiodata.parent_phone_number = bio.parent_phone_number; isibiodata.child_sequence = bio.child_sequence; isibiodata.how_many_brothers = bio.how_many_brothers; isibiodata.marital_status_id = bio.marital_status_id; isibiodata.marriage_year = bio.marriage_year; isibiodata.addrbook_id = bio.addrbook_id; isibiodata.created_by = 12; isibiodata.created_on = System.DateTime.Now; isibiodata.is_delete = false; db.x_biodata.Add(isibiodata); db.SaveChanges(); x_address isiaddress = new x_address(); isiaddress.address1 = bio.address1; isiaddress.address2 = bio.address2; isiaddress.postal_code1 = bio.postal_code1; isiaddress.postal_code2 = bio.postal_code2; isiaddress.rt1 = bio.rt1; isiaddress.rt2 = bio.rt2; isiaddress.rw1 = bio.rw1; isiaddress.rw2 = bio.rw2; isiaddress.kecamatan1 = bio.kecamatan1; isiaddress.kecamatan2 = bio.kecamatan2; isiaddress.kelurahan1 = bio.kelurahan1; isiaddress.kelurahan2 = bio.kelurahan2; isiaddress.region1 = bio.region1; isiaddress.region2 = bio.region2; isiaddress.biodata_id = isibiodata.id; isiaddress.created_by = 123; isiaddress.created_on = System.DateTime.Now; //isiaddress.deleted_by = 123; //isiaddress.deleted_on = System.DateTime.Now; //isiaddress.modified_by = 123; //isiaddress.modified_on = System.DateTime.Now; isiaddress.is_delete = false; db.x_address.Add(isiaddress); db.SaveChanges(); return(true); } catch (Exception) { return(false); throw; } } }
protected override XResp Execute() { x_address ad = null; if (id > 0) { ad = DB.x_address.FirstOrDefault(o => o.address_id == id); if (ad == null) { throw new XExcep("T收货地址不存在"); } if (ad.user_id != cu.user_id) { throw new XExcep("T收货地址不属于你"); } } else { ad = new x_address() { user_id = cu.user_id, ctime = DateTime.Now } }; ad.name = name; ad.tel = tel; ad.sheng = she; ad.shi = shi; ad.qu = qu; ad.zhen = zh; ad.addr = addr; ad.stime = st; ad.range = GetDictName("sys.city", she + "," + shi + "," + qu + "," + zh, " "); if (id == 0) { if (cu.x_address.Count() == 0) { ad.def = true; } DB.x_address.InsertOnSubmit(ad); } else { if (def == 1) { var d = DB.x_address.FirstOrDefault(o => o.address_id != id && o.user_id == cu.user_id && o.def == true); if (d != null) { d.def = false; } ad.def = true; } else { ad.def = false; } } SubmitDBChanges(); return(new XResp()); } }