/// <summary> /// 上传服务前后的图片 /// </summary> /// <returns></returns> public ActionResult Upload() { try { string FlowerTreatmentId = Request["FlowerTreatmentId"]; HttpPostedFileBase files = Request.Files["file"]; string type = Request["servertype"]; Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); Model.FlowerTreatment FlowerTreatment = Sys_FlowerTreatment.GetModel(FlowerTreatmentId.ToString()); if (type == "befor")//服务前图片 { if (!string.IsNullOrEmpty(FlowerTreatment.Photo)) { DeleteFlowerPhoto(FlowerTreatment.Photo); } FlowerTreatment.Photo = Utility.ChangeText.SaveUploadPicture(files, "img"); } else { if (!string.IsNullOrEmpty(FlowerTreatment.ChangePhoto)) { DeleteFlowerPhoto(FlowerTreatment.ChangePhoto); } FlowerTreatment.ChangePhoto = Utility.ChangeText.SaveUploadPicture(files, "Serveraf"); } Sys_FlowerTreatment.UpdateServerPhoto(FlowerTreatment); return(Json(new { result = "OK", msg = "更换图片成功" }, "text/html", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Utility.Log.WriteTextLog("报错", "FlowerTreatment", "upload", "后台提交服务的图片", ""); return(null); } }
/// <summary> /// 写入一条记录 /// </summary> /// <param name="FlowerTreatment"></param> /// <returns></returns> public bool InsertFlowerTreatment(Model.FlowerTreatment FlowerTreatment) { const string sql = @"INSERT INTO FlowerTreatment(FlowerNumber,UsersId,FlowerTreatmentType,ContentMsg,Photo,OwnedUsersId,OwnedUsersRealName,FlowerTreatmentAddress,UserRealName, OwnedCompany,LogoPhoto,State,starttime,ArrangementId) VALUES(@FlowerNumber,@UsersId,@FlowerTreatmentType,@ContentMsg,@Photo,@OwnedUsersId,@OwnedUsersRealName, @FlowerTreatmentAddress,@UserRealName,@OwnedCompany,@LogoPhoto,@State,@starttime,@ArrangementId)"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { FlowerTreatment.FlowerNumber, FlowerTreatment.UsersId, FlowerTreatment.FlowerTreatmentType, FlowerTreatment.ContentMsg, FlowerTreatment.Photo, FlowerTreatment.OwnedUsersId, FlowerTreatment.OwnedUsersRealName, FlowerTreatment.FlowerTreatmentAddress, FlowerTreatment.UserRealName, FlowerTreatment.OwnedCompany, FlowerTreatment.LogoPhoto, FlowerTreatment.State, FlowerTreatment.starttime, FlowerTreatment.ArrangementId }))); }
/// <summary> /// 服务后 /// </summary> /// <returns></returns> public ActionResult AddServerPhoto() { Model.FlowerTreatment FlowerTreatment = new Model.FlowerTreatment() { id = int.Parse(Request["id"]), ArrangementId = Request["ArrangementId"] }; return(View(FlowerTreatment)); }
/// <summary> /// 服务后图片 /// </summary> /// <returns></returns> public ActionResult serverafter() { string id = Request["id"]; Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); Model.FlowerTreatment FlowerTreatment = Sys_FlowerTreatment.GetModel(id); return(View(FlowerTreatment)); }
/// <summary> /// 开始养护花卉 /// </summary> /// <param name="arrid">摆放的id</param> /// <returns></returns> public ActionResult StartCurFlowers(string arrid, string ownedUsersId) { try { Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); int userid = Utility.ChangeText.GetUsersId(); Business.Sys_FlowerArrangement Sys_FlowerArrangement = new Business.Sys_FlowerArrangement(); Model.FlowerArrangement FlowerArrangement = Sys_FlowerArrangement.GetModel(arrid); Model.FlowerTreatment FTreatment = Sys_FlowerTreatment.GetModelbyid(arrid.ToString(), ownedUsersId, userid.ToString()); if (FTreatment == null || (FTreatment.endtime != null && FTreatment.State == "已完成"))//有了结束养护时间说明这个记录完成了 { Model.FlowerTreatment FlowerTreatment = new Model.FlowerTreatment(); Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin(); FlowerTreatment.FlowerTreatmentType = "开始养护"; FlowerTreatment.State = "未完成"; FlowerTreatment.UsersId = userid; FlowerTreatment.ArrangementId = arrid; FlowerTreatment.FlowerNumber = FlowerArrangement.ShopId.ToString(); FlowerTreatment.OwnedUsersId = ownedUsersId; FlowerTreatment.UserRealName = Utility.ChangeText.GetRealName(); FlowerTreatment.FlowerTreatmentAddress = FlowerArrangement.arrangement; Model.UserAdmin UserAdmin = Sys_UserAdmin.GetUserAdminByUserId(Convert.ToInt32(FlowerTreatment.OwnedUsersId)); FlowerTreatment.OwnedUsersRealName = UserAdmin.RealName; FlowerTreatment.OwnedCompany = UserAdmin.OwnedCompany; FlowerTreatment.LogoPhoto = UserAdmin.LogoPhoto; FlowerTreatment.starttime = DateTime.Now;//记录开始养护时间 ////同一登录人,同一公司,一天只能提交一次 //StringBuilder stb = new StringBuilder(); //if (userid != 0) //{ // stb.Append(" t.UsersId=" + userid + ""); //} //if (!string.IsNullOrEmpty(FlowerTreatment.OwnedUsersId)) //{ // stb.Append(" and t.OwnedUsersId='" + FlowerTreatment.OwnedUsersId + "'"); //} //string dt = DateTime.Now.ToShortDateString(); //{ // stb.Append(" and time>'" + dt + "'"); //} //stb.Append(" and starttime !='' "); //Utility.Log.WriteTextLog("开始养护花卉", "arrid", arrid, "stb", stb.ToString()); //if (Sys_FlowerTreatment.FlowerTreatmentList(stb.ToString()).Count == 0) //{ Sys_FlowerTreatment.InsertFlowerTreatment(FlowerTreatment); return(Content("1")); //} //else //{ // return Content("0");//今天已经开始养护过了 //} } } catch { } return(Json(new { resule = '1' }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 养护花卉服务前后 /// </summary> public bool UpdateServerPhoto(Model.FlowerTreatment FlowerTreatment) { const string sql = @"UPDATE FlowerTreatment SET Photo=@Photo,ChangePhoto=@ChangePhoto WHERE id=@id"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { FlowerTreatment.Photo, FlowerTreatment.ChangePhoto, FlowerTreatment.id }))); }
/// <summary> /// 结束养护花卉 /// </summary> public bool UpdateServer(Model.FlowerTreatment FlowerTreatment) { const string sql = @"UPDATE FlowerTreatment SET endtime=@endtime,FlowerTreatmentType=@FlowerTreatmentType,State=@State WHERE id=@id"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { FlowerTreatment.endtime, FlowerTreatment.FlowerTreatmentType, FlowerTreatment.State, FlowerTreatment.id, }))); }
/// <summary> /// 养护花卉服务后 /// </summary> public bool AddServerPhoto(Model.FlowerTreatment FlowerTreatment) { const string sql = @"UPDATE FlowerTreatment SET FlowerTreatmentType=@FlowerTreatmentType,ChangePhoto=@ChangePhoto,endtime=@endtime,State=@State WHERE id=@id"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { FlowerTreatment.FlowerTreatmentType, FlowerTreatment.ChangePhoto, FlowerTreatment.id, FlowerTreatment.endtime, FlowerTreatment.State }))); }
public ActionResult EditInfo(Model.FlowerTreatment FlowerTreatment) { Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin(); Model.UserAdmin UserAdmin = Sys_UserAdmin.GetUserAdminByUserId(Convert.ToInt32(FlowerTreatment.OwnedUsersId)); Model.UserAdmin UserAdmin1 = Sys_UserAdmin.GetUserAdminByUserId(FlowerTreatment.UsersId); FlowerTreatment.UserRealName = UserAdmin1.RealName; FlowerTreatment.OwnedUsersRealName = UserAdmin.RealName; if (Sys_FlowerTreatment.Update(FlowerTreatment)) { return(Content("1")); } return(Content("0")); }
/// <summary> /// 查询服务前图片 /// </summary> /// <returns></returns> public ActionResult ServerBefor(string arrid, string ownedUsersId) { Model.FlowerTreatment FlowerTreatment = new Model.FlowerTreatment(); Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); int userid = Utility.ChangeText.GetUsersId(); FlowerTreatment = Sys_FlowerTreatment.GetModelbyArrid(arrid, ownedUsersId, userid.ToString()); //只有服务前图片 if (FlowerTreatment != null && FlowerTreatment.Photo != null && FlowerTreatment.ChangePhoto == null) { return(Json(new { result = "OK", data = FlowerTreatment }, "text/html", JsonRequestBehavior.AllowGet)); } else { return(Json(new { result = "OK", data = "" }, "text/html", JsonRequestBehavior.AllowGet)); } }
public bool Update(Model.FlowerTreatment FlowerTreatment) { const string sql = @"UPDATE FlowerTreatment SET FlowerNumber=@FlowerNumber,UserRealName=@UserRealName,UsersId=@UsersId,FlowerTreatmentAddress=@FlowerTreatmentAddress, ContentMsg=@ContentMsg,OwnedUsersRealName=@OwnedUsersRealName,OwnedUsersId=@OwnedUsersId WHERE id=@id"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { FlowerTreatment.FlowerNumber, FlowerTreatment.UserRealName, FlowerTreatment.UsersId, FlowerTreatment.FlowerTreatmentAddress, FlowerTreatment.ContentMsg, FlowerTreatment.OwnedUsersRealName, FlowerTreatment.OwnedUsersId, FlowerTreatment.id, }))); }
/// <summary> /// 结束养护 /// </summary> /// <returns></returns> public ActionResult EndCurFlowers(string arrid, string ownedUsersId) { Model.FlowerTreatment FlowerTreatment = new Model.FlowerTreatment(); Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin(); Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); int userid = Utility.ChangeText.GetUsersId(); FlowerTreatment = Sys_FlowerTreatment.GetModelbyOwnid(ownedUsersId); if (FlowerTreatment != null && FlowerTreatment.endtime == null) { FlowerTreatment.endtime = DateTime.Now; FlowerTreatment.FlowerTreatmentType = "结束养护"; FlowerTreatment.State = "已完成"; if (Sys_FlowerTreatment.UpdateServer(FlowerTreatment)) { return(Content("1")); } } return(Content("0")); }
public ActionResult UpServerPhoto(Model.FlowerTreatment FlowerTreatment) { try { HttpPostedFileBase file = Request.Files["file"]; FlowerTreatment.ChangePhoto = Utility.ChangeText.SaveUploadPicture(file, "Serveraf"); FlowerTreatment.FlowerTreatmentType = "服务后"; FlowerTreatment.State = "已完成"; FlowerTreatment.endtime = DateTime.Now; Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); if (Sys_FlowerTreatment.AddServerPhoto(FlowerTreatment)) { return(Json(new { msg = "1", path = FlowerTreatment.ChangePhoto })); } } catch (Exception ex) { Utility.Log.WriteTextLog("服务后提交图", "UpServerPhoto", FlowerTreatment.id.ToString(), "", ex.ToString()); } return(View()); }
public ActionResult AddServerPhoto(Model.FlowerTreatment FlowerTreatment) { try { HttpPostedFileBase file = Request.Files["attach_paths"]; FlowerTreatment.ChangePhoto = Utility.ChangeText.SaveUploadPicture(file, "Serveraf"); FlowerTreatment.FlowerTreatmentType = "服务后"; FlowerTreatment.State = "已完成"; FlowerTreatment.endtime = DateTime.Now; Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); if (Sys_FlowerTreatment.AddServerPhoto(FlowerTreatment)) { return(RedirectToAction("TreatRecord", "MFlower", new { ArrangementId = FlowerTreatment.ArrangementId, s = "add" })); } } catch (Exception ex) { Utility.Log.WriteTextLog("服务后提交图", "AddServerPhoto", FlowerTreatment.id.ToString(), "", ex.ToString()); } return(View()); }
public ActionResult GetArrangementInfo(string ArrangementId) { try { string id = Request["ArrangementId"]; Business.Sys_FlowerArrangement Sys_FlowerArrangement = new Business.Sys_FlowerArrangement(); Model.FlowerArrangement FlowerArrangement = Sys_FlowerArrangement.GetModel(id); if (FlowerArrangement.belongUsersId != 0) { //DateTime dt = Sys_FlowerArrangement.GetFlowerTreatmentModel(FlowerArrangement.belongUsersId.ToString()).time; Model.FlowerTreatment FlowerTreatment = new Model.FlowerTreatment(); Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); FlowerTreatment = Sys_FlowerTreatment.GetModelbyOwnid(FlowerArrangement.belongUsersId.ToString()); if (FlowerTreatment != null) { if (FlowerTreatment.starttime != null && FlowerTreatment.endtime == null) //没有结束养护时间 { DateTime dt = (DateTime)FlowerTreatment.starttime; //开始养护时间 ViewBag.Treattime = dt; ViewBag.PlanTreatTime = dt.AddDays(7); } } } //if (Session["RoleCode"] != null && Session["RoleCode"].ToString() == "Tourist") //{ // ViewData["IsTourist"] = 1; //} //当操作人不是对应绑定客户与超级管理员时,判断是否为养护人员,如果为养护人员则判断是否有权限操作此更换花卉 if (Session["RoleCode"] != null) { #region 原来的逻辑 //if (Session["RoleCode"].ToString() != "Customer" && Session["RoleCode"].ToString() != "SuperAdministrator") //{ // if (Session["RoleCode"].ToString() == "yanghu") // { // Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin(); // List<Model.UserAdmin> UserAdminList = new List<Model.UserAdmin>(); // UserAdminList = Sys_UserAdmin.GetUserAdminListByRoleCode("Customer", Utility.ChangeText.GetUsersId()); // //判断所属客户权限中是否包含此客户 // UserAdminList = UserAdminList.Where(x => x.ID == FlowerArrangement.belongUsersId).ToList(); // if (UserAdminList.Count() > 0) // { // ViewData["IsAllower"] = 1; // } // else // { // ViewData["IsAllower"] = 0; // } // } // else // { // ViewData["IsAllower"] = 0; // } //} //else { // ViewData["IsAllower"] = 1; //} #endregion if (Session["RoleCode"].ToString() != "Customer") { ViewData["IsAllower"] = 1; } else { ViewData["IsAllower"] = 0; } } return(View(FlowerArrangement)); } catch (Exception ex) { Utility.Log.WriteTextLog("扫码页面", "MMain", ex.Message, "GetArrangementInfo", ex.ToString()); return(null); } }
public ActionResult ConservationFlowers(Model.FlowerTreatment FlowerTreatment) { try { string x = string.Empty, y = string.Empty, strReturn = string.Empty; string apiurl = "http://api.map.baidu.com/geoconv/v1/?coords=" + Request["longitude"] + "," + Request["latitude"] + "&from=1&to=5&ak=Kl3rqGn6gECfy7mH5rS3fkGkaWYiyVlr"; string detail = Utility.PostData.GetData(apiurl); ERP.MobleControllers.MMainController.BaiDuCoordinates jd = JsonConvert.DeserializeObject <ERP.MobleControllers.MMainController.BaiDuCoordinates>(detail); List <ERP.MobleControllers.MMainController.bc_result> result = jd.result; foreach (var item in result) { x = item.x; y = item.y; } apiurl = "http://api.map.baidu.com/geocoder/v2/?ak=Kl3rqGn6gECfy7mH5rS3fkGkaWYiyVlr&callback=renderReverse&location=" + y + "," + x + "&output=json&pois=1"; detail = Utility.PostData.GetData(apiurl); detail = detail.Replace("renderReverse&&renderReverse(", ""); detail = detail.TrimEnd(')'); ERP.MobleControllers.MMainController.GetAddressNew GetAddress = JsonConvert.DeserializeObject <ERP.MobleControllers.MMainController.GetAddressNew>(detail); Utility.Log.WriteTextLog("返回定位", "花卉养护当前地址", GetAddress.result.formatted_address, "detail", detail); Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin(); Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); int userid = Utility.ChangeText.GetUsersId(); FlowerTreatment.FlowerTreatmentType = "养护花卉"; FlowerTreatment.UsersId = userid; FlowerTreatment.OwnedUsersId = Request["deptSelectItems"]; FlowerTreatment.UserRealName = Utility.ChangeText.GetRealName(); FlowerTreatment.FlowerTreatmentAddress = GetAddress.result.formatted_address; Model.UserAdmin UserAdmin = Sys_UserAdmin.GetUserAdminByUserId(Convert.ToInt32(FlowerTreatment.OwnedUsersId)); FlowerTreatment.OwnedUsersRealName = UserAdmin.RealName; FlowerTreatment.OwnedCompany = UserAdmin.OwnedCompany; FlowerTreatment.LogoPhoto = UserAdmin.LogoPhoto; //同一登录人,同一公司,一天只能提交一次 StringBuilder stb = new StringBuilder(); if (userid != 0) { stb.Append(" t.UsersId=" + userid + ""); } if (!string.IsNullOrEmpty(FlowerTreatment.OwnedUsersId)) { stb.Append(" and t.OwnedUsersId='" + FlowerTreatment.OwnedUsersId + "'"); } string dt = DateTime.Now.ToShortDateString(); { stb.Append(" and time>'" + dt + "'"); } if (Sys_FlowerTreatment.FlowerTreatmentList(stb.ToString()).Count == 0) { Sys_FlowerTreatment.InsertFlowerTreatment(FlowerTreatment); return(Content("1")); } else { return(Content("0")); } } catch (Exception ex) { Utility.Log.WriteTextLog("返回定位错误", "ConservationFlowers", "养护花卉", "post方法", ex.ToString()); return(View()); } }
/// <summary> /// 扫码页面中的上传图片养护 ///</summary> /// <returns></returns> public ActionResult Upload() { try { string FlowerArrangementId = Request["FlowerArrangementId"]; string remarks = Request["remarks"]; HttpPostedFileBase files = Request.Files["file"]; if (files == null) { Utility.Log.WriteTextLog("扫码页面上传图片养护", "FlowerArrangementId", FlowerArrangementId, "files", files == null ? "true" : "fasle"); return(Json("Faild", JsonRequestBehavior.AllowGet)); } Business.Sys_FlowerArrangement Sys_FlowerArrangement = new Business.Sys_FlowerArrangement(); Model.FlowerArrangement FlowerArrangement = Sys_FlowerArrangement.GetModel(FlowerArrangementId); Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin(); Business.Sys_FlowerTreatment Sys_FlowerTreatment = new Business.Sys_FlowerTreatment(); int userid = Utility.ChangeText.GetUsersId(); Model.FlowerTreatment FTreatment = Sys_FlowerTreatment.GetModelbyArrid(FlowerArrangement.id.ToString(), FlowerArrangement.belongUsersId.ToString(), userid.ToString()); if (FTreatment == null)//有未上传服务后图,不可以再提交 { string FilePath = Utility.ChangeText.SaveUploadPicture(files, "img"); Model.FlowerTreatment FlowerTreatment = new Model.FlowerTreatment(); FlowerTreatment.FlowerTreatmentType = "服务前"; FlowerTreatment.State = "未完成"; FlowerTreatment.UsersId = userid; FlowerTreatment.ArrangementId = FlowerArrangement.id.ToString(); FlowerTreatment.FlowerNumber = FlowerArrangement.ShopId.ToString(); FlowerTreatment.OwnedUsersId = FlowerArrangement.belongUsersId.ToString(); FlowerTreatment.UserRealName = Utility.ChangeText.GetRealName(); FlowerTreatment.FlowerTreatmentAddress = FlowerArrangement.arrangement; Model.UserAdmin UserAdmin = Sys_UserAdmin.GetUserAdminByUserId(Convert.ToInt32(FlowerTreatment.OwnedUsersId)); FlowerTreatment.OwnedUsersRealName = UserAdmin.RealName; FlowerTreatment.OwnedCompany = UserAdmin.OwnedCompany; FlowerTreatment.LogoPhoto = UserAdmin.LogoPhoto; FlowerTreatment.Photo = FilePath; //提交图片 FlowerTreatment.ContentMsg = remarks; //提交内容 if (Sys_FlowerTreatment.InsertFlowerTreatment(FlowerTreatment)) { Model.Wx_SendMsg Wx_SendMsg = new Model.Wx_SendMsg() { template_id = "MU4CvSNXPYTMjhGJdWuWNvpc5Ls2VPAmcaST4lWrTaM", touser = Utility.ChangeText.GetOpenId(), url = "http://www.thuay.com/MMain/GetArrangementInfo?way=Arrangement&ArrangementId=" + FlowerArrangementId, data = new { first = new { value = "您好!已经有客户(" + FlowerTreatment.OwnedCompany + ")需要服务,请尽快前往。", color = "#173177" }, keyword1 = new { value = FlowerTreatment.FlowerNumber, color = "#173177" }, keyword2 = new { value = "养护花卉", color = "#173177" }, keyword3 = new { value = "养护", color = "#173177" }, keyword4 = new { value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), color = "#173177" }, remark = new { value = "详细内容:" + FlowerTreatment.ContentMsg + ".点击此消息,查看详情。", color = "#173177" }, } }; WxHelper.WxMain.SendMsg(JsonConvert.SerializeObject(Wx_SendMsg)); } return(Content("1")); } else { return(Content("0"));//未完成 } } catch (Exception ex) { Utility.Log.WriteTextLog("扫码页面上传图片养护报错", "FlowerArrangementId", "MFlower", "Upload", ex.ToString()); return(null); } }