public object AddAuthDetail(JSReader jsr, string authno, int lx)
{
try
{
string timelong;
if (lx == 2)
{
timelong = jsr["ApplyDay"].ToString();
}
else
{
timelong = jsr["ApplyHour"].ToString();
}
string url = "http://wx.zhisuroom.com/API/LockHandler.ashx";
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("interface", "AddAuthDetail");
parameters.Add("authno", authno);
parameters.Add("authtype", lx.ToString());
parameters.Add("timelong", timelong);
parameters.Add("totalprice", jsr["Money"].ToString());
string result = WebService.CallService(url, parameters);
JObject json = JsonConvert.DeserializeObject(result) as JObject;
return(new { status = json["Status"].ToString(), info = json["Info"].ToString() });
}
catch (Exception ex)
{
throw ex;
}
}
public object SaveZDBLX(JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
try
{
string id = jsr["LXID"].ToString();
string LXMC = jsr["LXMC"].ToString();
if (string.IsNullOrEmpty(id))
{
DataTable dt = dbc.GetEmptyDataTable("Lock_ZDBLX");
DataRow dr = dt.NewRow();
dr["LXMC"] = LXMC;
//dr["LX"] = LX;
dr["ZT"] = 0;
dt.Rows.Add(dr);
dbc.InsertTable(dt);
}
else
{
dbc.ExecuteNonQuery("update Lock_ZDBLX set LXMC=" + dbc.ToSqlValue(LXMC) + " where LXID=" + Convert.ToInt16(id));
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
public object SaveLP(string userid, JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
dbc.BeginTransaction();
try
{
JSReader[] js = jsr.ToArray();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"delete from tb_b_User_LP_GL where User_ID='" + userid + "'";
dbc.ExecuteNonQuery(cmd);
for (int i = 0; i < js.Length; i++)
{
cmd = new SqlCommand();
cmd.CommandText = @"insert into tb_b_User_LP_GL select newid(),@userid,@lp_id,null,0,getdate(),getdate(),'9b628843-8ff6-4100-a7f9-73b4043871ad'";
cmd.Parameters.AddWithValue("@userid", userid);
cmd.Parameters.AddWithValue("@lp_id", js[i].ToString());
dbc.ExecuteNonQuery(cmd);
}
dbc.CommitTransaction();
cmd = new SqlCommand();
cmd.CommandText = @"select UL_ID,a.lp_id,lp_name,lp_path,UL_PX from tb_b_User_LP_GL a left join tb_b_LeaderPage b on a.lp_id=b.lp_id where a.delflag=0 and a.User_ID='" + userid + "' order by UL_PX";
DataTable dt = dbc.ExecuteDataTable(cmd);
return(dt);
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public object Delete(string userid, JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
dbc.BeginTransaction();
try
{
JSReader[] js = jsr.ToArray();
SqlCommand cmd = new SqlCommand();
for (int i = 0; i < js.Length; i++)
{
cmd = new SqlCommand();
cmd.CommandText = @"delete from tb_b_User_LP_GL where UL_ID=@UL_ID";
cmd.Parameters.AddWithValue("@UL_ID", js[i].ToString());
dbc.ExecuteNonQuery(cmd);
}
dbc.CommitTransaction();
cmd = new SqlCommand();
cmd.CommandText = @"select UL_ID,a.lp_id,lp_name,lp_path,UL_PX from tb_b_User_LP_GL a left join tb_b_LeaderPage b on a.lp_id=b.lp_id where a.delflag=0 and a.User_ID='" + userid + "' order by UL_PX";
DataTable dt = dbc.ExecuteDataTable(cmd);
return(dt);
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public bool UpdateConstituteOffer(string offerid, JSReader jsr)
{
using (MySqlDbConnection dbc = MySqlConnstr.GetDBConnection())
{
try
{
decimal estimateautomoney = string.IsNullOrEmpty(jsr["estimateautomoney"].ToString()) ? 0 : Convert.ToDecimal(jsr["estimateautomoney"].ToString()); //预估自动计算金额
decimal estimatecompletemoney = string.IsNullOrEmpty(jsr["estimatecompletemoney"].ToString()) ? 0 : Convert.ToDecimal(jsr["estimatecompletemoney"].ToString()); //预估综合成本
decimal estimatetaxmoney = string.IsNullOrEmpty(jsr["estimatetaxmoney"].ToString()) ? 0 : Convert.ToDecimal(jsr["estimatetaxmoney"].ToString()); //预估税费成本
decimal estimatecostmoney = string.IsNullOrEmpty(jsr["estimatecostmoney"].ToString()) ? 0 : Convert.ToDecimal(jsr["estimatecostmoney"].ToString()); //预估资金成本
if (estimateautomoney != 0 && (estimateautomoney == estimatecompletemoney + estimatetaxmoney + estimatecostmoney))
{
string sql = @"update tb_b_sourcegoodsinfo_offer set estimatecompletemoney=" + dbc.ToSqlValue(estimatecompletemoney) + ",estimatetaxmoney=" + dbc.ToSqlValue(estimatetaxmoney) + ",estimatecostmoney=" + dbc.ToSqlValue(estimatecostmoney) + @"
where offerid=" + dbc.ToSqlValue(offerid);
dbc.ExecuteNonQuery(sql);
return(true);
}
else
{
throw new Exception("组成成分填写错误！");
}
}
catch (Exception ex)
{
throw ex;
}
}
}
public object GetLockRecord(int roomid)
{
try
{
string url = "http://wx.zhisuroom.com/API/LockHandler.ashx";
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("interface", "GetLockRecord");
parameters.Add("roomid", roomid.ToString());
parameters.Add("start", "");
parameters.Add("end", "");
string result = WebService.CallService(url, parameters);
JObject json = JsonConvert.DeserializeObject(result) as JObject;
JSReader jsr = JSReader.ParseJSON(json["Info"].ToString());
DataTable dt = new DataTable();
dt.Columns.Add("date");
dt.Columns.Add("type");
for (int i = 0; i < jsr.Count(); i++)
{
DataRow dr = dt.NewRow();
dr["date"] = jsr[i]["ActionTime"].ToString();
dr["type"] = jsr[i]["Action"].ToString();
dt.Rows.Add(dr);
}
DataView dv = dt.DefaultView;
dv.Sort = "date desc";
DataTable dt2 = dv.ToTable();
return(new { status = json["Status"].ToString(), dt = dt2 });
}
catch (Exception ex)
{
throw ex;
}
}
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 CodePiece Parse(string code)
{
var p = new JSReader(code);
var block = new CodeBlock();
ReadCodes(p, ref block);
return block;
}
public object GetDevice(JSReader jsr)
{
try
{
string url = "http://wx.zhisuroom.com/API/LockHandler.ashx";
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("interface", "GetDevice");
parameters.Add("deviceno", jsr["DeviceNo"].ToString());
parameters.Add("devicesn", jsr["DeviceSN"].ToString());
string result = WebService.CallService(url, parameters);
JObject json = JsonConvert.DeserializeObject(result) as JObject;
bool iskg = false;
if (json["status"].ToString() == "ok")
{
string equipmentpara = json["equipmentpara_table"].ToString();
JObject json2 = JsonConvert.DeserializeObject(equipmentpara.Replace("\r\n", "").Replace("[", "").Replace("]", "")) as JObject;
for (int i = 1; i < 6; i++)
{
if (json2["EquipmentCon" + i + "Type"].ToString() != "无")
{
iskg = true;
}
}
}
return(new { status = json["status"].ToString(), result = result, iskg = iskg });
}
catch (Exception ex)
{
throw ex;
}
}
public object SaveRoomPrice(JSReader jsr, int roomId)
{
using (DBConnection dbc = new DBConnection())
{
dbc.BeginTransaction();
try
{
//DataTable dt = dbc.ExecuteDataTable("select * from Lock_RoomOtherDayPrice where RoomId=" + roomId + " and ((StartDate>='" + jsr["StartDate"].ToString() + "' and StartDate<='" + jsr["EndDate"].ToString() + "') or (EndDate>='" + jsr["StartDate"].ToString() + "' and EndDate<='" + jsr["EndDate"].ToString() + "'))");
//if (dt.Rows.Count > 0)
// throw new Exception("该时间段内有价格设置请重新选择");
string sql = "select * from Lock_RoomOtherDayPrice where RoomId = '" + roomId + "' and StartDate >= '" + jsr["StartDate"].ToDate() + "' and StartDate <= '" + jsr["EndDate"].ToDate() + "'";
DataTable dt_price = dbc.ExecuteDataTable(sql);
if (dt_price.Rows.Count > 0)
{
sql = "delete from Lock_RoomOtherDayPrice where RoomId = '" + roomId + "' and StartDate >= '" + jsr["StartDate"].ToDate() + "' and StartDate <= '" + jsr["EndDate"].ToDate() + "'";
dbc.ExecuteNonQuery(sql);
}
TimeSpan days = jsr["EndDate"].ToDate().Subtract(jsr["StartDate"].ToDate());
int days_num = days.Days;
for (int i = 0; i <= days_num; i++)
{
sql = "insert into Lock_RoomOtherDayPrice values(" + roomId + ",'" + jsr["StartDate"].ToDate().AddDays(i) + "','" + jsr["StartDate"].ToDate().AddDays(i) + "','" + jsr["Price"].ToSingle() + "',null,null,'" + jsr["WeekEndPrice"].ToSingle() + "','" + jsr["HourPrice"].ToSingle() + "','" + jsr["HourWeekEndPrice"].ToSingle() + "',null,'" + jsr["HourPrice2"].ToSingle() + "','" + jsr["HourWeekEndPrice2"].ToSingle() + "','" + jsr["HourPrice3"].ToSingle() + "','" + jsr["HourWeekEndPrice3"].ToSingle() + "','" + jsr["MonthRentPrice"].ToSingle() + "',0)";
dbc.ExecuteNonQuery(sql);
}
dbc.CommitTransaction();
return(true);
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public bool DelUserByids(JSReader jsr)
{
var user = SystemUser.CurrentUser;
string userid = user.UserID;
using (DBConnection dbc = new DBConnection())
{
dbc.BeginTransaction();
try
{
for (int i = 0; i < jsr.ToArray().Length; i++)
{
string str = "update tb_b_Users set User_DelFlag = 1,Updatetime=@Updatetime,Updateuser=@Updateuser where user_id =@user_id";
SqlCommand cmd = new SqlCommand(str);
cmd.Parameters.AddWithValue("@Updatetime", DateTime.Now);
cmd.Parameters.AddWithValue("@Updateuser", userid);
cmd.Parameters.AddWithValue("@user_id", jsr.ToArray()[i].ToString());
dbc.ExecuteNonQuery(cmd);
}
dbc.CommitTransaction();
return(true);
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public object GetGqqListByPage(int pagnum, int pagesize, JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
try
{
int cp = pagnum;
int ac = 0;
List <string> wArr = new List <string>();
if (!string.IsNullOrEmpty(jsr["cx_zxmc"]))
{
wArr.Add(dbc.C_Like("c.UserXM", jsr["cx_zxmc"], LikeStyle.LeftAndRightLike));
}
if (!string.IsNullOrEmpty(jsr["cx_fhrzh"]))
{
wArr.Add(dbc.C_Like("b.UserName", jsr["cx_fhrzh"], LikeStyle.LeftAndRightLike));
}
string cx_beg = jsr["cx_beg"].ToString();
if (!string.IsNullOrEmpty(cx_beg))
{
wArr.Add("a.addTimd >= " + dbc.ToSqlValue(Convert.ToDateTime(cx_beg)));
}
string cx_endjsr = jsr["cx_end"].ToString();
if (!string.IsNullOrEmpty(cx_endjsr))
{
wArr.Add("a.addTimd < " + dbc.ToSqlValue(Convert.ToDateTime(cx_endjsr).AddDays(1)));
}
string sqlW = "";
if (wArr.Count > 0)
{
sqlW = " and " + string.Join(" and ", wArr);
}
string str = @"select a.*,b.UserName fhrzh,c.UserXM zxmc,
case
when d.id IS NULL then 0
else 1 end as shzt from(
select t1.*,t2.UserID,t2.CardUserID from tb_b_invalid_points t1
left join tb_b_mycard t2 on t1.mycardId=t2.mycardId
)a
left join tb_b_user b on a.UserID=b.UserID
left join tb_b_user c on a.CardUserID=c.UserID
left join tb_b_return_points d on a.invalidId=d.invalidId and d.status=0
where a.status=0 and a.addTimd>'2019/6/24'" + sqlW + " order by a.addTimd desc";
//开始取分页数据
System.Data.DataTable dtPage = new System.Data.DataTable();
dtPage = dbc.GetPagedDataTable(str, pagesize, ref cp, out ac);
return(new { dt = dtPage, cp = cp, ac = ac });
}
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 void SaveGoods(JSReader jsr)
{
if (string.IsNullOrEmpty(jsr["goodstypeid"].ToString()))
{
throw new Exception("货品类别不能为空");
}
if (jsr["goodsname"].IsNull || jsr["goodsname"].IsEmpty)
{
throw new Exception("货品名称不能为空");
}
using (MySqlDbConnection dbc = MySqlConnstr.GetDBConnection())
{
try
{
if (string.IsNullOrEmpty(jsr["goodsid"].ToString()))
{
var goodsid = Guid.NewGuid().ToString();
var dt = dbc.GetEmptyDataTable("tb_b_goods");
var dr = dt.NewRow();
dr["goodsid"] = goodsid;
dr["goodsname"] = jsr["goodsname"].ToString();
dr["goodstype"] = jsr["goodstypeid"].ToString();
dr["status"] = 0;
dr["adduser"] = SystemUser.CurrentUser.UserID;
dr["addtime"] = DateTime.Now;
dr["updateuser"] = SystemUser.CurrentUser.UserID;
dr["updatetime"] = DateTime.Now;
dt.Rows.Add(dr);
dbc.InsertTable(dt);
}
else
{
var dt = dbc.GetEmptyDataTable("tb_b_goods");
var dtt = new SmartFramework4v2.Data.DataTableTracker(dt);
var dr = dt.NewRow();
dr["goodsid"] = jsr["goodsid"].ToString();
dr["goodsname"] = jsr["goodsname"].ToString();
dr["goodstype"] = jsr["goodstypeid"].ToString();
dr["updateuser"] = SystemUser.CurrentUser.UserID;
dr["updatetime"] = DateTime.Now;
dt.Rows.Add(dr);
dbc.UpdateTable(dt, dtt);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
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 GetHotelBJList(int RoomId)
{
try
{
string url = "http://wx.zhisuroom.com/API/LockHandler.ashx";
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("interface", "GetHotelBJList");
parameters.Add("roomid", RoomId.ToString());
string result = WebService.CallService(url, parameters);
JObject json = JsonConvert.DeserializeObject(result) as JObject;
return(new { status = json["Status"].ToString(), result = JSReader.ParseJSON(json["Info"].ToString()) });
}
catch (Exception ex)
{
throw ex;
}
}
public object DeleteJs(JSReader jsr)
{
var user = SystemUser.CurrentUser;
string userid = user.UserID;
string companyId = user.CompanyID;
using (DBConnection dbc = new DBConnection())
{
dbc.BeginTransaction();
try
{
for (int i = 0; i < jsr.ToArray().Length; i++)
{
//判断角色是否被用户关联就不能删除
string str = "select count(*) from tb_b_user_role where roleId=@roleId and companyId=@companyId";
SqlCommand ocmd = new SqlCommand(str);
ocmd.Parameters.AddWithValue("@roleId", jsr.ToArray()[i].ToString());
ocmd.Parameters.AddWithValue("@companyId", companyId);
int num = Convert.ToInt32(dbc.ExecuteScalar(ocmd));
if (num > 0)
{
throw new Exception("你所要删除的角色已经被用户关联，请先删除用户再进行此操作！");
}
else
{
string delstr = "delete from tb_b_roledb where roleId=@roleId and companyId=@companyId";
ocmd = new SqlCommand(delstr);
ocmd.Parameters.AddWithValue("roleId", jsr.ToArray()[i].ToString());
ocmd.Parameters.AddWithValue("companyId", companyId);
dbc.ExecuteNonQuery(ocmd);
}
}
dbc.CommitTransaction();
return(GetRole());
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public object SendCMDAgainTF(string authno)
{
try
{
string url = "http://wx.zhisuroom.com/API/LockHandler.ashx";
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("interface", "SendCMDAgainTF");
parameters.Add("authno", authno);
string result = WebService.CallService(url, parameters);
JObject json = JsonConvert.DeserializeObject(result) as JObject;
return(new { status = json["Status"].ToString(), info = JSReader.ParseJSON(json["Info"].ToString()) });
}
catch (Exception ex)
{
throw ex;
}
}
public object DeleteJs(JSReader jsr, string zt)
{
var user = SystemUser.CurrentUser;
string userid = user.UserID;
using (DBConnection dbc = new DBConnection())
{
dbc.BeginTransaction();
try
{
for (int i = 0; i < jsr.ToArray().Length; i++)
{
//判断角色是否被用户关联就不能删除
string str = "select count(*) from tb_b_User_JS_Gl where JS_ID=@JS_ID and delflag=0";
SqlCommand ocmd = new SqlCommand(str);
ocmd.Parameters.AddWithValue("@JS_ID", jsr.ToArray()[i].ToString());
int num = Convert.ToInt32(dbc.ExecuteScalar(ocmd));
if (num > 0)
{
throw new Exception("你所要删除的角色已经被用户关联，请先删除用户再进行此操作！");
}
else
{
string delstr = "update tb_b_JS set status=1,updatetime=@updatetime,updateuser=@updateuser where JS_ID=@JS_ID";
ocmd = new SqlCommand(delstr);
ocmd.Parameters.AddWithValue("updatetime", DateTime.Now);
ocmd.Parameters.AddWithValue("updateuser", userid);
ocmd.Parameters.AddWithValue("JS_ID", jsr.ToArray()[i].ToString());
dbc.ExecuteNonQuery(ocmd);
}
}
dbc.CommitTransaction();
return(GetJs(zt));
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public object CancelAuthorizeOrder(int authid, int type)
{
try
{
string url = "http://wx.zhisuroom.com/API/LockHandler.ashx";
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("interface", "CancelAuthorizeOrder");
parameters.Add("type", type.ToString());
parameters.Add("authid", authid.ToString());
string result = WebService.CallService(url, parameters);
JObject json = JsonConvert.DeserializeObject(result) as JObject;
return(new { status = json["Status"].ToString(), info = JSReader.ParseJSON(json["Info"].ToString()) });
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateMktOffer(string offerid, JSReader jsr)
{
using (MySqlDbConnection dbc = MySqlConnstr.GetDBConnection())
{
try
{
dbc.BeginTransaction();
String totalmonetaryamount = jsr["totalmonetaryamount"].ToString();
String estimatemoney = jsr["estimatemoney"].ToString();
String estimatecompletemoney = jsr["estimatecompletemoney"].ToString();
String estimatetaxmoney = jsr["estimatetaxmoney"].ToString();
String estimatecostmoney = jsr["estimatecostmoney"].ToString();
string sql = "update tb_b_sourcegoodsinfo_offer set flowstatus = 90,totalmonetaryamount=" + dbc.ToSqlValue(totalmonetaryamount) + ",estimatemoney=" + dbc.ToSqlValue(estimatemoney) + ",estimatecompletemoney=" + dbc.ToSqlValue(estimatecompletemoney) + ",estimatetaxmoney=" + dbc.ToSqlValue(estimatetaxmoney) + ",estimatecostmoney=" + dbc.ToSqlValue(estimatecostmoney) + " where offerid=" + dbc.ToSqlValue(offerid);
dbc.ExecuteNonQuery(sql);
DateTime ti = DateTime.Now;
var dt = dbc.GetEmptyDataTable("tb_b_sourcegoodsinfo_offer_flow");
var newDr = dt.NewRow();
newDr["flowid"] = Guid.NewGuid();
newDr["offerid"] = offerid;
newDr["flowstatus"] = 90;
newDr["status"] = 0;
newDr["adduser"] = SystemUser.CurrentUser.UserID;
newDr["addtime"] = ti;
newDr["updateuser"] = SystemUser.CurrentUser.UserID;
newDr["updatetime"] = ti;
dt.Rows.Add(newDr);
dbc.InsertTable(dt);
/*insert into tb_b_sourcegoodsinfo_offer_record;recrodtype = "市场部询价单已提交企业"，recordmemo = "xxx 在xxx时间 市场部询价单已提交企业"；*/
LogBySourcegoodsinfoOffer(dbc, offerid, "市场部询价单已提交企业", SystemUser.CurrentUser.UserName + "在" + ti + "市场部询价单已提交企业", ti);
dbc.CommitTransaction();
return(true);
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public object SaveZDB(JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
try
{
string id = jsr["ZDBID"].ToString();
string MC = jsr["MC"].ToString();
int LX = Convert.ToInt16(jsr["LX"].ToString());
string XH = jsr["XH"].ToString();
if (string.IsNullOrEmpty(id))
{
DataTable dt = dbc.GetEmptyDataTable("Lock_ZDB");
DataRow dr = dt.NewRow();
dr["MC"] = MC;
dr["LX"] = LX;
dr["XH"] = XH;
dr["ZT"] = 0;
dt.Rows.Add(dr);
dbc.InsertTable(dt);
}
else
{
DataTable dt = dbc.GetEmptyDataTable("Lock_ZDB");
dt.Columns["ZDBID"].ReadOnly = false;
DataTableTracker dtt = new DataTableTracker(dt);
DataRow dr = dt.NewRow();
dr["ZDBID"] = id;
dr["MC"] = MC;
dr["LX"] = LX;
dr["XH"] = XH;
dr["ZT"] = 0;
dt.Rows.Add(dr);
dbc.UpdateTable(dt, dtt);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
}
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 object DeleteRoomDevice(JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
dbc.BeginTransaction();
try
{
for (int i = 0; i < jsr.ToArray().Length; i++)
{
int ID = jsr.ToArray()[i].ToInteger();
dbc.ExecuteNonQuery("delete from Lock_Device where ID=" + ID);
}
dbc.CommitTransaction();
return(true);
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public object AddRefundLive(JSReader jsr, string authno)
{
try
{
string url = "http://wx.zhisuroom.com/API/LockHandler.ashx";
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("interface", "AddRefundLive");
parameters.Add("authno", authno);
parameters.Add("refundtime", DateTime.Now.ToString());
parameters.Add("ActualTotalPrice", jsr["ActualTotalPrice"].ToString());
parameters.Add("OtherPrice", jsr["OtherPrice"].ToString());
parameters.Add("RefundPrice", jsr["RefundPrice"].ToString());
string result = WebService.CallService(url, parameters);
JObject json = JsonConvert.DeserializeObject(result) as JObject;
return(new { status = json["Status"].ToString(), info = JSReader.ParseJSON(json["Info"].ToString()) });
}
catch (Exception ex)
{
throw ex;
}
}
public object ApplyService(JSReader jsr)
{
try
{
string url = "http://wx.zhisuroom.com/API/LockHandler.ashx";
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("interface", "ApplyService");
parameters.Add("selroomid", jsr["RoomId"].ToString());
parameters.Add("authno", "");
parameters.Add("servicetype", jsr["ServiceType"].ToString());
parameters.Add("remark", jsr["Remark"].ToString());
parameters.Add("starttime", jsr["starttime"].ToString());
parameters.Add("endtime", jsr["endtime"].ToString());
parameters.Add("AssignUserId", jsr["AssignUserId"].ToString());
string result = WebService.CallService(url, parameters);
JObject json = JsonConvert.DeserializeObject(result) as JObject;
return(new { status = json["Status"].ToString() });
}
catch (Exception ex)
{
throw ex;
}
}
public object DeleteHotel(JSReader jsr)
{
using (DBConnection dbc = new DBConnection())
{
dbc.BeginTransaction();
try
{
for (int i = 0; i < jsr.ToArray().Length; i++)
{
int ID = jsr.ToArray()[i].ToInteger();
dbc.ExecuteNonQuery("delete from Lock_HotelApply where ID=" + ID + " and UserId=" + SystemUser.CurrentUser.UserID);
dbc.ExecuteNonQuery("delete from Lock_HotelApply where HotelId=" + ID + " and UserId=" + SystemUser.CurrentUser.UserID);
}
dbc.CommitTransaction();
return(true);
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public bool DelGoodsPrice(JSReader jsr)
{
using (MySqlDbConnection dbc = MySqlConnstr.GetDBConnection())
{
dbc.BeginTransaction();
try
{
for (int i = 0; i < jsr.ToArray().Length; i++)
{
string sqlStr = "update tb_b_pricemodel set status=1 where id=" + dbc.ToSqlValue(jsr.ToArray()[i].ToString());
dbc.ExecuteDataTable(sqlStr);
}
dbc.CommitTransaction();
return(true);
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
public object SaveRoomDevice(JSReader jsr, int RoomId)
{
using (DBConnection dbc = new DBConnection())
{
dbc.BeginTransaction();
try
{
string ID = jsr["ID"].ToString();
if (jsr["DeviceType"].ToInteger() == 2)
{
if (ID == "")
{
int wgNum = Convert.ToInt16(dbc.ExecuteScalar("select count(*) from Lock_Device where RoomId=" + RoomId + " and DeviceType=2 "));
if (wgNum > 0)
{
throw new Exception("该房间已存在网关设备");
}
}
else
{
int wgNum = Convert.ToInt16(dbc.ExecuteScalar("select count(*) from Lock_Device where RoomId=" + RoomId + " and DeviceType=2 and ID<>" + ID));
if (wgNum > 0)
{
throw new Exception("该房间已存在网关设备");
}
}
}
var dtDevice = dbc.GetEmptyDataTable("Lock_Device");
DataTableTracker dtt = new DataTableTracker(dtDevice);
var drDevice = dtDevice.NewRow();
drDevice["RoomId"] = RoomId;
drDevice["DeviceName"] = jsr["DeviceName"].ToString();
drDevice["DeviceNo"] = jsr["DeviceNo"].ToString();
drDevice["DeviceSN"] = jsr["DeviceSN"].ToInteger();
drDevice["DeviceType"] = jsr["DeviceType"].ToInteger();
drDevice["CallBackData"] = jsr["CallBackData"].ToString();
drDevice["BindSuccess"] = 0;
JObject json = JsonConvert.DeserializeObject(jsr["CallBackData"].ToString()) as JObject;
string equipmentpara = json["equipmentpara_table"].ToString();
JObject json2 = JsonConvert.DeserializeObject(equipmentpara.Replace("\r\n", "").Replace("[", "").Replace("]", "")) as JObject;
drDevice["EquipmentInfoNum"] = json2["EquipmentInfoNum"].ToString();
drDevice["EquipmentInfo1Type"] = json2["EquipmentInfo1Type"].ToString();
drDevice["EquipmentInfo2Type"] = json2["EquipmentInfo2Type"].ToString();
drDevice["EquipmentInfo3Type"] = json2["EquipmentInfo3Type"].ToString();
drDevice["EquipmentInfo4Type"] = json2["EquipmentInfo4Type"].ToString();
drDevice["EquipmentInfo5Type"] = json2["EquipmentInfo5Type"].ToString();
drDevice["EquipmentConNum"] = json2["EquipmentConNum"].ToString();
drDevice["EquipmentCon1Type"] = json2["EquipmentCon1Type"].ToString();
drDevice["EquipmentCon2Type"] = json2["EquipmentCon2Type"].ToString();
drDevice["EquipmentCon3Type"] = json2["EquipmentCon3Type"].ToString();
drDevice["EquipmentCon4Type"] = json2["EquipmentCon4Type"].ToString();
drDevice["EquipmentCon5Type"] = json2["EquipmentCon5Type"].ToString();
if (jsr["DevicePosition"].ToString() != "")
{
dbc.ExecuteNonQuery("update Lock_Device set DevicePosition=null where RoomId=" + RoomId + " and DevicePosition=" + jsr["DevicePosition"].ToString());
drDevice["DevicePosition"] = Convert.ToInt16(jsr["DevicePosition"].ToString());
drDevice["SwitchName"] = jsr["SwitchName"].ToString();
drDevice["SwitchType"] = jsr["SwitchType"].ToString();
}
if (ID == "")
{
dtDevice.Rows.Add(drDevice);
dbc.InsertTable(dtDevice);
}
else
{
if (jsr["DevicePosition"].ToString() == "")
{
drDevice["DevicePosition"] = DBNull.Value;
}
drDevice["ID"] = Convert.ToInt16(ID);
dtDevice.Rows.Add(drDevice);
dtDevice.Columns["ID"].ReadOnly = false;
dbc.UpdateTable(dtDevice, dtt);
}
dbc.CommitTransaction();
return(true);
}
catch (Exception ex)
{
dbc.RoolbackTransaction();
throw ex;
}
}
}
