public bool UpdateSourceGoods(string offerid, JSReader jsr)
{
using (MySqlDbConnection dbc = MySqlConnstr.GetDBConnection())
{
try
{
DateTime ti = DateTime.Now;
String estimatemoney = jsr["estimatemoney"].ToString();
String totalmonetaryamount = jsr["totalmonetaryamount"].ToString();
var dt = dbc.GetEmptyDataTable("tb_b_sourcegoodsinfo_offer");
var dtt = new SmartFramework4v2.Data.DataTableTracker(dt);
var dr = dt.NewRow();
dr["offerid"] = offerid;
if (!string.IsNullOrEmpty(estimatemoney))
{
dr["estimatemoney"] = Convert.ToDecimal(estimatemoney);
}
if (!string.IsNullOrEmpty(totalmonetaryamount))
{
dr["totalmonetaryamount"] = Convert.ToDecimal(totalmonetaryamount);
}
dr["updateuser"] = SystemUser.CurrentUser.UserID;
dr["updatetime"] = ti;
dt.Rows.Add(dr);
dbc.UpdateTable(dt, dtt);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
public object SaveMenuByPC(JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
string menuName = jsr["menuName"];
if (menuName == "")
{
throw new Exception("菜单名称不能为空！");
}
string menuurl = jsr["menuurl"];
if (menuurl == "")
{
throw new Exception("菜单链接不能为空！");
}
string menuPx = jsr["menuPx"];
if (menuPx == "")
{
throw new Exception("菜单序号不能为空！");
}
if (string.IsNullOrEmpty(jsr["menuId"].ToString()))
{
//新增
string menuId = Guid.NewGuid().ToString();
var dt = dbc.GetEmptyDataTable("tb_b_menu_pc");
var sr = dt.NewRow();
sr["menuId"] = new Guid(menuId);
sr["moduleId"] = jsr["moduleId"].ToString();
sr["menuName"] = menuName;
sr["menuPx"] = menuPx;
sr["menuurl"] = menuurl;
dt.Rows.Add(sr);
dbc.InsertTable(dt);
}
else
{
//修改
string menuId = jsr["menuId"].ToString();
var dt = dbc.GetEmptyDataTable("tb_b_menu_pc");
var dtt = new SmartFramework4v2.Data.DataTableTracker(dt);
var sr = dt.NewRow();
sr["menuId"] = new Guid(menuId);
sr["moduleId"] = jsr["moduleId"].ToString();
sr["menuName"] = menuName;
sr["menuPx"] = menuPx;
sr["menuurl"] = menuurl;
dt.Rows.Add(sr);
dbc.UpdateTable(dt, dtt);
}
return(true);
}
}
public object SaveJs(JSReader jsr)
{
var user = SystemUser.CurrentUser;
string companyId = user.CompanyID;
using (DBConnection dbc = new DBConnection())
{
string lbmc = jsr["roleName"];
if (lbmc == "")
{
throw new Exception("角色名称不能为空！");
}
string jsxh = jsr["rolePx"];
if (jsxh == "")
{
throw new Exception("角色序号不能为空！");
}
if (jsr["roleId"].ToString() == "")
{
//新增
string jsid = Guid.NewGuid().ToString();
var dt = dbc.GetEmptyDataTable("tb_b_roledb");
var sr = dt.NewRow();
sr["roleId"] = new Guid(jsid);
sr["roleName"] = lbmc;
sr["rolePx"] = jsr["rolePx"].ToInteger();
sr["companyId"] = companyId;
dt.Rows.Add(sr);
dbc.InsertTable(dt);
}
else
{
//修改
string jsid = jsr["roleId"].ToString();
var dt = dbc.GetEmptyDataTable("tb_b_roledb");
var dtt = new SmartFramework4v2.Data.DataTableTracker(dt);
var sr = dt.NewRow();
sr["roleId"] = new Guid(jsid);
sr["roleName"] = lbmc;
sr["rolePx"] = jsr["rolePx"].ToInteger();
sr["companyId"] = companyId;
dt.Rows.Add(sr);
dbc.UpdateTable(dt, dtt);
}
return(GetRole());
}
}
public object SavePrivilege(JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
string privilegeName = jsr["privilegeName"];
if (privilegeName == "")
{
throw new Exception("权限名称不能为空！");
}
string privilegePx = jsr["privilegePx"];
if (privilegePx == "")
{
throw new Exception("权限序号不能为空！");
}
if (string.IsNullOrEmpty(jsr["privilegeId"].ToString()))
{
//新增
string privilegeId = Guid.NewGuid().ToString();
var dt = dbc.GetEmptyDataTable("tb_b_privilege");
var sr = dt.NewRow();
sr["privilegeId"] = new Guid(privilegeId);
sr["menuId"] = jsr["menuId"].ToString();
sr["moduleId"] = jsr["moduleId"].ToString();
sr["privilegeName"] = privilegeName;
sr["privilegePx"] = privilegePx;
dt.Rows.Add(sr);
dbc.InsertTable(dt);
}
else
{
//修改
string privilegeId = jsr["privilegeId"].ToString();
var dt = dbc.GetEmptyDataTable("tb_b_privilege");
var dtt = new SmartFramework4v2.Data.DataTableTracker(dt);
var sr = dt.NewRow();
sr["privilegeId"] = new Guid(privilegeId);
sr["menuId"] = jsr["menuId"].ToString();
sr["moduleId"] = jsr["moduleId"].ToString();
sr["privilegeName"] = privilegeName;
sr["privilegePx"] = privilegePx;
dt.Rows.Add(sr);
dbc.UpdateTable(dt, dtt);
}
return(true);
}
}
public object SaveModuleByPC(JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
string mkmc = jsr["moduleName"];
if (mkmc == "")
{
throw new Exception("模块名称不能为空！");
}
string mkpx = jsr["modulePx"];
if (mkpx == "")
{
throw new Exception("模块序号不能为空！");
}
if (string.IsNullOrEmpty(jsr["moduleId"].ToString()))
{
//新增
string moduleId = Guid.NewGuid().ToString();
var dt = dbc.GetEmptyDataTable("tb_b_module_pc");
var sr = dt.NewRow();
sr["moduleId"] = new Guid(moduleId);
sr["moduleName"] = mkmc;
sr["modulePx"] = mkpx;
dt.Rows.Add(sr);
dbc.InsertTable(dt);
}
else
{
//修改
string moduleId = jsr["moduleId"].ToString();
var dt = dbc.GetEmptyDataTable("tb_b_module_pc");
var dtt = new SmartFramework4v2.Data.DataTableTracker(dt);
var sr = dt.NewRow();
sr["moduleId"] = new Guid(moduleId);
sr["moduleName"] = mkmc;
sr["modulePx"] = mkpx;
dt.Rows.Add(sr);
dbc.UpdateTable(dt, dtt);
}
return(true);
}
}
public object SaveInfo(JSReader jsr)
{
var user = SystemUser.CurrentUser;
string companyId = user.CompanyID;
using (DBConnection dbc = new DBConnection())
{
string mc = jsr["name"];
if (mc == "")
{
throw new Exception("名称不能为空！");
}
if (jsr["id"].ToString() == "")
{
//新增
string id = Guid.NewGuid().ToString();
var dt = dbc.GetEmptyDataTable("tb_b_carriagechb");
var sr = dt.NewRow();
sr["id"] = new Guid(id);
sr["name"] = mc;
dt.Rows.Add(sr);
dbc.InsertTable(dt);
}
else
{
//修改
string id = jsr["id"].ToString();
var dt = dbc.GetEmptyDataTable("tb_b_carriagechb");
var dtt = new SmartFramework4v2.Data.DataTableTracker(dt);
var sr = dt.NewRow();
sr["id"] = new Guid(id);
sr["name"] = mc;
dt.Rows.Add(sr);
dbc.UpdateTable(dt, dtt);
}
return(GetInfo());
}
}
public override void ProcessNotify()
{
WxPayData notifyData = GetNotifyData();
//检查支付结果中transaction_id是否存在
if (!notifyData.IsSet("transaction_id"))
{
//若transaction_id不存在，则立即返回结果给微信支付后台
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "支付结果中微信订单号不存在");
Log.Error(this.GetType().ToString(), "The Pay result is error : " + res.ToXml());
page.Response.Write(res.ToXml());
page.Response.End();
}
string transaction_id = notifyData.GetValue("transaction_id").ToString();
//查询订单，判断订单真实性
if (!QueryOrder(transaction_id))
{
//若订单查询失败，则立即返回结果给微信支付后台
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "订单查询失败");
Log.Error(this.GetType().ToString(), "Order query failure : " + res.ToXml());
page.Response.Write(res.ToXml());
page.Response.End();
}
//查询订单成功
else
{
WxPayData res = new WxPayData();
res.SetValue("return_code", "SUCCESS");
res.SetValue("return_msg", "OK");
Log.Info(this.GetType().ToString(), "order query success : " + res.ToXml());
using (var db = new DBConnection())
{
string ordercode = notifyData.GetValue("attach").ToString();
string sql = "select * from tb_b_order where OrderCode =" + db.ToSqlValue(ordercode);
DataTable dt = db.ExecuteDataTable(sql);
sql = "update tb_b_order set ZhiFuZT = 1,Status = 0,SXZT = 0 where OrderCode =" + db.ToSqlValue(ordercode);
db.ExecuteNonQuery(sql);
sql = "select * from tb_b_mycard where status = 0 and CardUserID = '" + dt.Rows[0]["SaleUserID"].ToString() + "' and UserID = '" + dt.Rows[0]["BuyUserID"].ToString() + "'";
DataTable dt_card = db.ExecuteDataTable(sql);
DataTable dt_new = db.GetEmptyDataTable("tb_b_mycard");
SmartFramework4v2.Data.DataTableTracker dtt_new = new SmartFramework4v2.Data.DataTableTracker(dt_new);
DataRow dr = dt_new.NewRow();
if (dt_card.Rows.Count == 0)
{
dr["mycardId"] = Guid.NewGuid();
}
else
{
dr["mycardId"] = dt_card.Rows[0]["mycardId"].ToString();
}
if (dt_card.Rows.Count == 0)
{
dr["points"] = Convert.ToDecimal(dt.Rows[0]["Points"]);
}
else
{
dr["points"] = Convert.ToDecimal(Convert.ToInt32(dt_card.Rows[0]["points"]) + Convert.ToInt32(dt.Rows[0]["Points"]));
}
dr["UserID"] = dt.Rows[0]["BuyUserID"];
dr["CardUserID"] = dt.Rows[0]["SaleUserID"];
dr["status"] = 0;
dt_new.Rows.Add(dr);
if (dt_card.Rows.Count == 0)
{
db.InsertTable(dt_new);
}
else
{
db.UpdateTable(dt_new, dtt_new);
}
}
page.Response.Write(res.ToXml());
//page.Response.Redirect("http://wx.chahuobao.net/weixin/html/menu.aspx");
//page.Response.Write("<script>window.open('http://wx.chahuobao.net/weixin/html/menu.aspx');</script>");
page.Response.End();
}
}
public object SaveJs(JSReader jsr, string zt)
{
var user = SystemUser.CurrentUser;
string userid = user.UserID;
using (DBConnection dbc = new DBConnection())
{
string lbmc = jsr["JS_NAME"];
if (lbmc == "")
{
throw new Exception("角色名称不能为空！");
}
string jsxh = jsr["JS_PX"];
if (jsxh == "")
{
throw new Exception("角色序号不能为空！");
}
if (jsr["JS_ZT"] == "")
{
throw new Exception("角色状态出错！");
}
if (jsr["JS_Type"] == "")
{
throw new Exception("角色类别出错！");
}
int jszt = jsr["JS_ZT"].ToInteger();
if (jsr["JS_ID"].ToString() == "")
{
//新增
string jsid = Guid.NewGuid().ToString();
var dt = dbc.GetEmptyDataTable("tb_b_JS");
var sr = dt.NewRow();
sr["JS_ID"] = new Guid(jsid);
sr["JS_NAME"] = lbmc;
sr["JS_PX"] = jsr["JS_PX"].ToInteger();
sr["JS_Type"] = jsr["JS_Type"].ToInteger();
sr["JS_ZT"] = jszt;
sr["status"] = false;
sr["updatetime"] = DateTime.Now;
sr["addtime"] = DateTime.Now;
sr["updateuser"] = userid;
dt.Rows.Add(sr);
dbc.InsertTable(dt);
}
else
{
//修改
string jsid = jsr["JS_ID"].ToString();
var dt = dbc.GetEmptyDataTable("tb_b_JS");
var dtt = new SmartFramework4v2.Data.DataTableTracker(dt);
var sr = dt.NewRow();
sr["JS_ID"] = new Guid(jsid);
sr["JS_NAME"] = lbmc;
sr["JS_PX"] = jsr["JS_PX"].ToInteger();
sr["JS_Type"] = jsr["JS_Type"].ToInteger();
sr["JS_ZT"] = jszt;
sr["updatetime"] = DateTime.Now;
sr["updateuser"] = userid;
dt.Rows.Add(sr);
dbc.UpdateTable(dt, dtt);
}
return(GetJs(zt));
}
}
