protected void btnBc_Click(object sender, EventArgs e)
{
try
{
string id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
System.Model.facility_type fs = _bll.ftbll.GetModel(Utility.Helper.gerInt(id));
if (fs != null)
{
fs.discount = Utility.Helper.gerDecimal(this.txtdiscount.Text);
fs.price = Utility.Helper.gerDecimal(this.txtprice.Text);
fs.time = Utility.Helper.gerInt(this.txttime.Text);
fs.tyoe = this.txttyoe.Text;
if (_bll.ftbll.Update(fs))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Test", "alert('编辑成功！');window.location.href='admin_type.aspx';", true);
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Test", "alert('编辑失败！');window.location.href='admin_type.aspx';", true);
}
}
}
else
{
System.Model.facility_type fs = new System.Model.facility_type();
fs.discount = Utility.Helper.gerDecimal(this.txtdiscount.Text);
fs.price = Utility.Helper.gerDecimal(this.txtprice.Text);
fs.time = Utility.Helper.gerInt(this.txttime.Text);
fs.tyoe = this.txttyoe.Text;
fs.pudate = System.DateTime.Now;
if (_bll.ftbll.Add(fs) > 0)
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Test", "alert('添加成功！');window.location.href='admin_type.aspx';", true);
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Test", "alert('添加失败！');window.location.href='admin_type.aspx';", true);
}
}
}
catch
{
Response.Redirect(ConfigurationManager.AppSettings["VirturlPath"] + "/error500.aspx?menu1=2&menu2=4");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public System.Model.facility_type GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, tyoe, time, price, pudate, isdel, discount ");
strSql.Append(" from facility_type ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
System.Model.facility_type model = new System.Model.facility_type();
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());
}
model.tyoe = ds.Tables[0].Rows[0]["tyoe"].ToString();
if (ds.Tables[0].Rows[0]["time"].ToString() != "")
{
model.time = int.Parse(ds.Tables[0].Rows[0]["time"].ToString());
}
if (ds.Tables[0].Rows[0]["price"].ToString() != "")
{
model.price = decimal.Parse(ds.Tables[0].Rows[0]["price"].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]["isdel"].ToString() != "")
{
model.isdel = int.Parse(ds.Tables[0].Rows[0]["isdel"].ToString());
}
if (ds.Tables[0].Rows[0]["discount"].ToString() != "")
{
model.discount = decimal.Parse(ds.Tables[0].Rows[0]["discount"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <System.Model.facility_type> DataTableToList(DataTable dt)
{
List <System.Model.facility_type> modelList = new List <System.Model.facility_type>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
System.Model.facility_type model;
for (int n = 0; n < rowsCount; n++)
{
model = new System.Model.facility_type();
if (dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
model.tyoe = dt.Rows[n]["tyoe"].ToString();
if (dt.Rows[n]["time"].ToString() != "")
{
model.time = int.Parse(dt.Rows[n]["time"].ToString());
}
if (dt.Rows[n]["price"].ToString() != "")
{
model.price = decimal.Parse(dt.Rows[n]["price"].ToString());
}
if (dt.Rows[n]["pudate"].ToString() != "")
{
model.pudate = DateTime.Parse(dt.Rows[n]["pudate"].ToString());
}
if (dt.Rows[n]["isdel"].ToString() != "")
{
model.isdel = int.Parse(dt.Rows[n]["isdel"].ToString());
}
if (dt.Rows[n]["discount"].ToString() != "")
{
model.discount = decimal.Parse(dt.Rows[n]["discount"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(System.Model.facility_type model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update facility_type set ");
strSql.Append(" tyoe = @tyoe , ");
strSql.Append(" time = @time , ");
strSql.Append(" price = @price , ");
strSql.Append(" pudate = @pudate , ");
strSql.Append(" isdel = @isdel , ");
strSql.Append(" discount = @discount ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@tyoe", SqlDbType.NVarChar, 50),
new SqlParameter("@time", SqlDbType.Int, 4),
new SqlParameter("@price", SqlDbType.Money, 8),
new SqlParameter("@pudate", SqlDbType.DateTime),
new SqlParameter("@isdel", SqlDbType.Int, 4),
new SqlParameter("@discount", SqlDbType.Float, 8)
};
parameters[0].Value = model.id;
parameters[1].Value = model.tyoe;
parameters[2].Value = model.time;
parameters[3].Value = model.price;
parameters[4].Value = model.pudate;
parameters[5].Value = model.isdel;
parameters[6].Value = model.discount;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(System.Model.facility_type model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into facility_type(");
strSql.Append("tyoe,time,price,pudate,isdel,discount");
strSql.Append(") values (");
strSql.Append("@tyoe,@time,@price,@pudate,@isdel,@discount");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@tyoe", SqlDbType.NVarChar, 50),
new SqlParameter("@time", SqlDbType.Int, 4),
new SqlParameter("@price", SqlDbType.Money, 8),
new SqlParameter("@pudate", SqlDbType.DateTime),
new SqlParameter("@isdel", SqlDbType.Int, 4),
new SqlParameter("@discount", SqlDbType.Float, 8)
};
parameters[0].Value = model.tyoe;
parameters[1].Value = model.time;
parameters[2].Value = model.price;
parameters[3].Value = model.pudate;
parameters[4].Value = model.isdel;
parameters[5].Value = model.discount;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(System.Model.facility_type model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(System.Model.facility_type model)
{
return(dal.Add(model));
}
/// <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);
}
}
