ZQHApi.git - Gitblit

			@@ -28,7 +28,9 @@
			{

			//执行sql
			strProcName = "select * from [dbo].[TUser] where usercode=@username and password=@password and is_delete='0'";
			strProcName = @"select * from TUser U
			left join TOrganization T on U.stu_torgcode = T.org_code
			where U.usercode =@username and U.password =@password and U.is_delete = '0'";
			//创建参数
			listStr.Add(new SqlParameter("@username", username));
			listStr.Add(new SqlParameter("@password", password));
			@@ -40,18 +42,19 @@
			#endregion

			#region [写入登录记录表]
			public static ToMessage LoginBas(string usercode, string usertype)
			public static ToMessage LoginBas(string usercode, string usertype,string stu_torgcode)
			{
			var sql = "";
			var cont = 0;
			var dynamicParams = new DynamicParameters();
			try
			{
			sql = @"insert into T_Bas_Login(usercode,status,indate,origin)
			values(@usercode,'Y',@indate,@usertype)";
			sql = @"insert into T_Bas_Login(usercode,status,indate,origin,torg_code)
			values(@usercode,'Y',@indate,@usertype,@stu_torgcode)";
			dynamicParams.Add("@usercode", usercode);
			dynamicParams.Add("@usertype", usertype);
			dynamicParams.Add("@indate", DateTime.Now.ToString());
			dynamicParams.Add("@stu_torgcode", stu_torgcode);
			cont = DapperHelper.SQL(sql, dynamicParams);
			if (cont > 0)
			{
			@@ -105,12 +108,13 @@
			}).ToList();
			for (int i = 0; i < data.Count; i++)
			{
			sql = @"select distinct mu.right_code as code,mu.right_name as name,mu.right_seq,mu.is_delete as flag,imgurl
			sql = @"select * from(
			select distinct mu.right_code as code,mu.right_name as name,mu.right_seq,mu.is_delete as flag,imgurl
			from TRight mu
			inner join TRoleRightRelation rl on mu.right_code=rl.right_code
			inner join TUserRoleRelation ro on rl.role_code=ro.role_code
			where mu.type=@usertype and ro.user_code=@usercode and mu.parent_id=@paent_id
			order by mu.right_seq, mu.right_code";
			) as AA order by CAST(AA.right_seq AS DECIMAL) ASC,AA.code";
			dynamicParams.Add("@usercode", usercode);
			dynamicParams.Add("@usertype", usertype);
			dynamicParams.Add("@paent_id", data[i].code);
			@@ -300,7 +304,7 @@
			#endregion

			#region[PC登出]
			public static ToMessage LoginOut(int userid, string usercode, string username, string usertype)
			public static ToMessage LoginOut(int userid, string usercode, string username, string usertype,string stu_torgcode)
			{
			var sql = "";
			var cont = 0;
			@@ -308,15 +312,16 @@
			RedisHelper redis = new RedisHelper();
			try
			{
			sql = @"insert into T_Bas_Login(usercode,status,outdate,origin)
			values(@usercode,'N',@outdate,@usertype)";
			sql = @"insert into T_Bas_Login(usercode,status,outdate,origin,torg_code)
			values(@usercode,'N',@outdate,@usertype,@stu_torgcode)";
			dynamicParams.Add("@usercode", usercode);
			dynamicParams.Add("@usertype", usertype);
			dynamicParams.Add("@outdate", DateTime.Now.ToString());
			dynamicParams.Add("@stu_torgcode", stu_torgcode);
			cont = DapperHelper.SQL(sql, dynamicParams);
			if (cont > 0)
			{
			redis.Remove(Enterprise + "LoginUserID" + usertype + userid, 0); //删除redis
			redis.Remove(Enterprise + stu_torgcode + "LoginUserID" + usertype + userid, 0); //删除redis
			mes.code = "200";
			mes.count = 0;
			mes.Message = "登出成功!";
			@@ -342,7 +347,7 @@
			#endregion

			#region[App登出]
			public static ToMessage LoginAppOut(int userid, string usercode, string username, string usertype)
			public static ToMessage LoginAppOut(int userid, string usercode, string username, string usertype,string stu_torgcode)
			{
			var sql = "";
			var cont = 0;
			@@ -350,15 +355,16 @@
			RedisHelper redis = new RedisHelper();
			try
			{
			sql = @"insert into T_Bas_Login(usercode,status,outdate,origin)
			values(@usercode,'N',@outdate,@usertype)";
			sql = @"insert into T_Bas_Login(usercode,status,outdate,origin,torg_code)
			values(@usercode,'N',@outdate,@usertype,@stu_torgcode)";
			dynamicParams.Add("@usercode", usercode);
			dynamicParams.Add("@usertype", usertype);
			dynamicParams.Add("@outdate", DateTime.Now.ToString());
			dynamicParams.Add("@stu_torgcode", stu_torgcode);
			cont = DapperHelper.SQL(sql, dynamicParams);
			if (cont > 0)
			{
			redis.Remove(Enterprise + "LoginUserID" + usertype + userid, 1); //删除redis
			redis.Remove(Enterprise + stu_torgcode + "LoginUserID" + usertype + userid, 1); //删除redis
			mes.code = "200";
			mes.count = 0;
			mes.Message = "登出成功!";
			@@ -384,12 +390,30 @@
			#endregion

			#region[App登录查询安灯呼叫信息]
			public static ToMessage LoginAppAnDonMessage(string rid, string usercode, string username, string usertype)
			public static ToMessage LoginAppAnDonMessage(string rid, string usercode, string username, string usertype,string stu_torgcode,string stu_torgtypecode)
			{
			var sql = "";
			string search = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			switch (stu_torgtypecode)
			{
			case "":
			search += "and T.description=@description ";
			dynamicParams.Add("@description", "W");
			break;
			case "D":
			search += "and child.org_code=@stu_torgcode ";
			dynamicParams.Add("@stu_torgcode", stu_torgcode);
			break;
			case "W":
			search += "and T.org_code=@stu_torgcode ";
			dynamicParams.Add("@stu_torgcode", stu_torgcode);
			break;
			default:
			break;
			}
			sql = @"select B.eqp_code,E.name as eqp_name,B.wkshp_code,T.org_name as wkshp_name,
			A.type as typecode,D.name as typename,B.start_user,B.start_date
			from TAnDnMessagePush A
			@@ -398,7 +422,8 @@
			left join TOrganization T on B.wkshp_code=T.org_code
			left join TAnDonType D on A.type=d.code
			left join TUser U on A.resp_user=U.usercode
			where A.resp_user=@usercode and B.status='START' and U.rid=@rid and T.description='W'";
			left join TOrganization as child on T.parent_id=child.id
			where A.resp_user=@usercode and B.status='START' and U.rid=@rid "+search;
			dynamicParams.Add("@usercode", usercode);
			dynamicParams.Add("@rid", rid);
			var data = DapperHelper.selectdata(sql, dynamicParams);