/// <summary> /// 得到一个对象实体 /// </summary> public System.Model.self_test GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, stipple, facility, port, errortype, ername, pudate, isdispose, remarks "); strSql.Append(" from self_test "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; System.Model.self_test model = new System.Model.self_test(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["stipple"].ToString() != "") { model.stipple = int.Parse(ds.Tables[0].Rows[0]["stipple"].ToString()); } if (ds.Tables[0].Rows[0]["facility"].ToString() != "") { model.facility = int.Parse(ds.Tables[0].Rows[0]["facility"].ToString()); } if (ds.Tables[0].Rows[0]["port"].ToString() != "") { model.port = int.Parse(ds.Tables[0].Rows[0]["port"].ToString()); } model.errortype = ds.Tables[0].Rows[0]["errortype"].ToString(); model.ername = ds.Tables[0].Rows[0]["ername"].ToString(); if (ds.Tables[0].Rows[0]["pudate"].ToString() != "") { model.pudate = DateTime.Parse(ds.Tables[0].Rows[0]["pudate"].ToString()); } if (ds.Tables[0].Rows[0]["isdispose"].ToString() != "") { model.isdispose = int.Parse(ds.Tables[0].Rows[0]["isdispose"].ToString()); } model.remarks = ds.Tables[0].Rows[0]["remarks"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(System.Model.self_test model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update self_test set "); strSql.Append(" stipple = @stipple , "); strSql.Append(" facility = @facility , "); strSql.Append(" port = @port , "); strSql.Append(" errortype = @errortype , "); strSql.Append(" ername = @ername , "); strSql.Append(" pudate = @pudate , "); strSql.Append(" isdispose = @isdispose , "); strSql.Append(" remarks = @remarks "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@stipple", SqlDbType.Int, 4), new SqlParameter("@facility", SqlDbType.Int, 4), new SqlParameter("@port", SqlDbType.Int, 4), new SqlParameter("@errortype", SqlDbType.NVarChar, 50), new SqlParameter("@ername", SqlDbType.NVarChar, 50), new SqlParameter("@pudate", SqlDbType.DateTime), new SqlParameter("@isdispose", SqlDbType.Int, 4), new SqlParameter("@remarks", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.id; parameters[1].Value = model.stipple; parameters[2].Value = model.facility; parameters[3].Value = model.port; parameters[4].Value = model.errortype; parameters[5].Value = model.ername; parameters[6].Value = model.pudate; parameters[7].Value = model.isdispose; parameters[8].Value = model.remarks; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获得数据列表 /// </summary> public List <System.Model.self_test> DataTableToList(DataTable dt) { List <System.Model.self_test> modelList = new List <System.Model.self_test>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { System.Model.self_test model; for (int n = 0; n < rowsCount; n++) { model = new System.Model.self_test(); if (dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["stipple"].ToString() != "") { model.stipple = int.Parse(dt.Rows[n]["stipple"].ToString()); } if (dt.Rows[n]["facility"].ToString() != "") { model.facility = int.Parse(dt.Rows[n]["facility"].ToString()); } if (dt.Rows[n]["port"].ToString() != "") { model.port = int.Parse(dt.Rows[n]["port"].ToString()); } model.errortype = dt.Rows[n]["errortype"].ToString(); model.ername = dt.Rows[n]["ername"].ToString(); if (dt.Rows[n]["pudate"].ToString() != "") { model.pudate = DateTime.Parse(dt.Rows[n]["pudate"].ToString()); } if (dt.Rows[n]["isdispose"].ToString() != "") { model.isdispose = int.Parse(dt.Rows[n]["isdispose"].ToString()); } model.remarks = dt.Rows[n]["remarks"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(System.Model.self_test model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into self_test("); strSql.Append("stipple,facility,port,errortype,ername,pudate,isdispose,remarks"); strSql.Append(") values ("); strSql.Append("@stipple,@facility,@port,@errortype,@ername,@pudate,@isdispose,@remarks"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@stipple", SqlDbType.Int, 4), new SqlParameter("@facility", SqlDbType.Int, 4), new SqlParameter("@port", SqlDbType.Int, 4), new SqlParameter("@errortype", SqlDbType.NVarChar, 50), new SqlParameter("@ername", SqlDbType.NVarChar, 50), new SqlParameter("@pudate", SqlDbType.DateTime), new SqlParameter("@isdispose", SqlDbType.Int, 4), new SqlParameter("@remarks", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.stipple; parameters[1].Value = model.facility; parameters[2].Value = model.port; parameters[3].Value = model.errortype; parameters[4].Value = model.ername; parameters[5].Value = model.pudate; parameters[6].Value = model.isdispose; parameters[7].Value = model.remarks; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 返回结果 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string res = ""; JsonData jsonResult = new JsonData(); try { //结果类型 string resulttype = Request["resulttype"] != null?Utility.Helper.Checkstr(Request["resulttype"]) : ""; //结果 string result = Request["result"] != null?Utility.Helper.Checkstr(Request["result"]) : ""; //标识 string identify = Request["identify"] != null?Utility.Helper.Checkstr(Request["identify"]) : ""; //接口标识 string requestCode = Request["requetCode"] != null?Utility.Helper.Checkstr(Request["requetCode"]) : ""; //requestCode = Request.Form.ToString(); // //log.setlog("地址", Request.Url.ToString()); //log.setlog("地址", Request.RawUrl); #region 提供服务回调 if (!string.IsNullOrEmpty(resulttype) && !string.IsNullOrEmpty(result) && !string.IsNullOrEmpty(identify)) { log.setlog("服务回调", "resulttype:" + resulttype + " result:" + result + " identify:" + identify + " requestCode:" + requestCode); //标识 string resultNO = result; List <checkStatus> sd = publicData.orderlist; log.setlog("静态变量数据量", sd.Count.ToString()); try { if (sd.Count > 0) { sd = (from s in sd where s.identifying == requestCode select s).ToList(); if (sd.Count > 0) { checkStatus sd_0 = sd[0]; if (sd_0.types == 0) { #region 自检结果 string customId = sd_0.customId; System.Model.facility_port fp = _bll.fpbll.GetModel(sd_0.portid); System.Model.facility_stipple fs = new System.Model.facility_stipple(); System.Model.facility fa = new System.Model.facility(); if (resultNO == "2") //if (resultNO == "0") //if (true) { fa = _bll.fbll.GetModel(sd[0].facilityid); //查询网点 fs = _bll.fsbll.GetModel(fa.fid); //查询设备 折扣 System.Model.facility_type ftype = _bll.ftbll.GetModel(fa.types); //生成订单 string serialNumber = System.DateTime.Now.ToString("yyyyMMddHHmmss") + Utility.Helper.rnds(8); //折后价 decimal prices = ftype.price * ftype.discount; System.Model.order_info oi = new System.Model.order_info(); oi.customid = customId; oi.serialNumber = serialNumber; oi.discount = ftype.discount; oi.price = prices; oi.port = fp.id; oi.pudate = System.DateTime.Now; oi.statuses = 1; oi.facility = Utility.Helper.gerInt(fa.id); oi.duration = ftype.time; oi.stippleid = fs.id; oi.types = 1;//1快充 if (_bll.oibll.Add(oi) > 0) { //生成支付信息 System.Model.Member_Charge_Withdraw mcw = new System.Model.Member_Charge_Withdraw(); mcw.memberid = customId; mcw.moneyes = prices; mcw.serialNumber = serialNumber; mcw.paystatus = 1; mcw.statusname = "未支付"; //mcw.paytype = "";//支付方式 支付宝 微信 钱包 //paystatus 1 未支付 2已支付 //types 1订单 2充值 3...... mcw.types = 1; mcw.pudate = System.DateTime.Now; if (_bll.mcwbll.Add(mcw) > 0) { for (int i = 0; i < publicData.orderlist.Count; i++) { if (publicData.orderlist[i].identifying == requestCode) { publicData.orderlist[i].orderid = serialNumber; log.setlog("订单产生成功", publicData.orderlist[i].orderid); } } //jsonResult["res"] = (int)MyEnum.ResultEnum.成功; //jsonResult["msg"] = "下单成功"; //jsonResult["code"] = ""; // //jsonResult["stipplename"] = fs.name; //jsonResult["servertype"] = "快充"; //jsonResult["price"] = Math.Round(prices, 2).ToString(); //jsonResult["serialnumber"] = serialNumber;//订单号 } else { //jsonResult["res"] = (int)MyEnum.ResultEnum.失败; //jsonResult["msg"] = "错误"; //jsonResult["code"] = "下单失败"; } } else { //jsonResult["res"] = (int)MyEnum.ResultEnum.失败; //jsonResult["msg"] = "错误"; //jsonResult["code"] = "下单失败"; } } else { //错误 //添加自检错误记录 // System.Model.self_test st = new System.Model.self_test(); string name = ""; string typeno; switch (resultNO) { case "0": name = "正常"; typeno = "0"; break; case "2": name = "充电桩和充电枪运行正常"; typeno = "2"; break; case "3": name = "充电桩运行异常"; typeno = "3"; break; case "4": name = "充电枪运行异常"; typeno = "4"; break; case "5": name = "外网电压工作异常"; typeno = "5"; break; case "6": name = "电池工作不正常"; typeno = "6"; break; case "7": name = "充电枪与电池接触良"; typeno = "7"; break; default: name = "系统未知错误"; typeno = "xxxx"; break; } st.facility = Utility.Helper.gerInt(fa.id); st.isdispose = 0; st.port = Utility.Helper.gerInt(fp.fid); st.errortype = "1"; st.stipple = Utility.Helper.gerInt(fs.id); st.pudate = System.DateTime.Now; _bll.stbll.Add(st); //jsonResult["res"] = (int)MyEnum.ResultEnum.失败; //jsonResult["msg"] = "设备故障"; //jsonResult["code"] = "设备故障"; } #endregion } else if (sd_0.types == 1) { #region 充电是否开始 if (!string.IsNullOrEmpty(sd_0.orderid)) { //修改订单充电状态 //开始充电 string strwhere = " serialNumber='" + sd_0.orderid + "' "; List <System.Model.order_info> oilist = _bll.oibll.GetModelList(strwhere); if (oilist.Count == 1) { System.Model.order_info oi = oilist[0]; oi.statuses = 2;//充电中 _bll.oibll.Update(oi); } else { } } #endregion } else if (sd_0.types == 2) { #region 充电是否结束 if (!string.IsNullOrEmpty(sd_0.orderid)) { //修改订单充电状态 //结束充电 string strwhere = " serialNumber='" + sd_0.orderid + "' "; List <System.Model.order_info> oilist = _bll.oibll.GetModelList(strwhere); if (oilist.Count == 1) { System.Model.order_info oi = oilist[0]; oi.statuses = 3;//已完成充电 _bll.oibll.Update(oi); } else { } } #endregion } else if (sd_0.types == 3) { #region 系统故障类型 #endregion } else if (sd_0.types == 4) { #region 充电数据 #endregion } } } } catch (Exception ex) { log.setlog("错误", ex.Message); } jsonResult["res"] = (int)MyEnum.ResultEnum.成功; jsonResult["msg"] = ""; jsonResult["code"] = ""; } else { jsonResult["res"] = (int)MyEnum.ResultEnum.失败; jsonResult["msg"] = ""; jsonResult["code"] = "参数缺失"; } #endregion } catch (Exception ex) { jsonResult["result"] = (int)MyEnum.ResultEnum.系统错误; jsonResult["msg"] = "服务器繁忙,请稍后再试"; jsonResult["code"] = ex.Message; log.setlog("错误", ex.Message); } res = JsonMapper.ToJson(jsonResult); res = MyString.UnicodeToString(res); Response.Write(res); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(System.Model.self_test model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(System.Model.self_test model) { return(dal.Add(model)); }