private void btnConnection_Click(object sender, EventArgs e)
{
if (TestConnection())
{
try
{
UserName = txtName.Text.Trim();
string password = MD5Util.GetHash(txtPassword.Text.Trim()); //password HASH
USER_INFO ui = db.USER_INFOs.SingleOrDefault(u => u.UI_NAME == UserName && u.UI_PASSWORD == password);
if (ui == null)
{
MessageBox.Show("用户名或密码错误！");
}
else
{
SysUtil.setCurrentUserID(ui.UI_ID);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("Error to load schema.\n" + ex.Message, "Error to load schema", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/// <summary>
/// Net user user_name /active:{no | yes} [/domain]
/// </summary>
public static int NetUserSetInfoAccountDisabled(string servername, string username)
{
int nStatus;
USER_INFO level = USER_INFO.USER_INFO_1008;
System.UInt32 parm_err;
System.IntPtr userInfoPtr = IntPtr.Zero;
USER_INFO_1008 userInfo = new USER_INFO_1008();
userInfo.usri1008_flags = (uint)(UF.UF_SCRIPT | UF.UF_ACCOUNTDISABLE);
userInfoPtr = Marshal.AllocCoTaskMem(Marshal.SizeOf(userInfo));
Marshal.StructureToPtr(userInfo, userInfoPtr, false);
nStatus = NetUserSetInfo(servername, username, (System.UInt32)level, userInfoPtr, out parm_err);
if (nStatus == NERR_Success)
{
System.Console.WriteLine("User account {0} has been disabled", username);
}
else
{
System.Console.WriteLine("A system error has occurred: {0} {1}", nStatus, MethodBase.GetCurrentMethod());
}
NetApiBufferFree(userInfoPtr);
return(nStatus);
}
public USER_INFO Login(string usu, string pass)
{
DaoCliente dao = new DaoCliente();
USER_INFO log = dao.Login(usu, pass);
return(log);
}
private void OnLoginSucceed()
{
// Current user id issued by Kakao platform
string playerId = KGLocalPlayer.currentPlayer.playerId;
// Access token issued by Kakao platform
string accessToken = KGSession.accessToken;
// IDP information
var idpProfile = KGLocalPlayer.currentPlayer.idpProfile;
SingularSDK.SetCustomUserId(playerId);
string nickname = string.Empty;
if (idpProfile.idpCode.Equals(KGIdpCodeString.Kakao))
{
KGKakaoProfile kakaoProfile = idpProfile as KGKakaoProfile;
nickname = kakaoProfile.nickname;
}
USER_INFO userInfo = new USER_INFO();
userInfo.strUserName = string.Empty;
userInfo.strNickName = nickname;
userInfo.strUserID = playerId;
userInfo.strAccessToken = accessToken;
userInfo.bGuest = idpProfile.idpCode.Equals(KGIdpCodeString.Guest);
_IsLogined = true;
if (_LoginCallback != null)
{
_LoginCallback(LOGIN_STATE.LT_LOGIN_SUCCEED, userInfo);
}
}
/// <summary>
/// http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q187/5/35.asp&NoWebContent=1 How To Change Passwords Programmatically in Windows NT
/// http://support.microsoft.com/kb/149427 How to Change User Password at Command Prompt
/// net user user_name * /domain
/// When you are prompted to type a password for the user, type the new password, not the existing password. After you type the new password, the system prompts you to retype the password to confirm. The password is now changed.
/// net user user_name new_password
/// </summary>
public static int NetUserSetInfoPassword(string servername, string username, string newpassword)
{
int nStatus;
USER_INFO level = USER_INFO.USER_INFO_1003;
System.UInt32 parm_err;
System.IntPtr userInfoPtr = IntPtr.Zero;
USER_INFO_1003 userInfo = new USER_INFO_1003();
userInfo.usri1003_password = newpassword;
userInfoPtr = Marshal.AllocCoTaskMem(Marshal.SizeOf(userInfo));
Marshal.StructureToPtr(userInfo, userInfoPtr, false);
nStatus = NetUserSetInfo(servername, username, (System.UInt32)level, userInfoPtr, out parm_err);
NetApiBufferFree(userInfoPtr);
if (nStatus == NERR_Success)
{
System.Console.WriteLine("Password has been changed successfully");
}
else
{
System.Console.WriteLine("A system error has occurred: {0} {1}", nStatus, MethodBase.GetCurrentMethod());
}
return(nStatus);
}
public USER_INFO UserLoginAuthority(string UserId, string Password)
{
USER_INFO users = null;
string sql = @"
SELECT U.SN, U.NAME, U.PASSWORD, U.FORCE_PWD, G.ROLES_SN
FROM USERS U LEFT JOIN GRANTS G
ON U.SN=G.USERS_SN
WHERE U.ID=@ID AND U.MODE='Y'
";
using (DbCommand cmd = Db.GetSqlStringCommand(sql))
{
Db.AddInParameter(cmd, "ID", DbType.String, UserId);
using (IDataReader reader = this.Db.ExecuteReader(cmd))
{
if (reader.Read() && reader["PASSWORD"] as string == Password)
{
users = new USER_INFO()
{
SN = reader["SN"] as Int16? ?? null,
ID = UserId,
NAME = reader["NAME"] as string,
FORCE_PWD = reader["FORCE_PWD"] as Int16? ?? null,
ROLES_SN = reader["ROLES_SN"] as Int32? ?? null
};
}
}
}
return(users);
}
public Numbers processNumbers(string message, string type)
{
if (string.IsNullOrEmpty(message))
{
return(null);
}
Numbers tmpPhoneNumbers = new Numbers();
char splitChar = ';';
string[] tempArr = message.Split(splitChar);
for (int i = 0; i < tempArr.Length; i++)
{
//userInfo = dbManager.GetUser("", tempArr[i], "", "", "", "");
USER_INFO userInfo = new USER_INFO();
userInfo.phone = tempArr[i];
USER_INFO[] userInfoArr = myGlobals.dbManager.GetUser(userInfo);
if (userInfoArr.Length > 0)
{
tmpPhoneNumbers.addNumber(userInfoArr[0].type, tempArr[i]);
}
else
{
//dbManager.AddUser("", tempArr[i], "", "", "", type);
userInfo.type = type;
if (myGlobals.pocTypes.Contains(type))
{
myGlobals.dbManager.AddUser(userInfo);
}
tmpPhoneNumbers.addNumber(type, tempArr[i]);
}
}
return(tmpPhoneNumbers);
}
protected void btn5_click(object sender, EventArgs e)
{
USER_INFO model = new USER_INFO(13, "new_name", "670B1472");
int result = bll.Update(model);
Response.Write("<script>alert('" + result + "')</script>");
}
protected void btn6_click(object sender, EventArgs e)
{
USER_INFO model = new USER_INFO("new_name2", "089892089");
int result = bll.Update(model, "username = '******'");
Response.Write("<script>alert('" + result + "')</script>");
}
string confRoomInfo(string msg, Socket sock)
{
string serverRoomId = TextFollowing(msg, "SERVERROOMID:");
int i;
i = msg.LastIndexOf("CONFMEMBER");
int num = Convert.ToInt32(msg[i + 1]);
int oldNum = num;
USER_INFO userInfo = new USER_INFO();
userInfo.serverRoomId = serverRoomId;
USER_INFO[] userInfoArr = myGlobals.dbManager.GetUser(userInfo);
foreach (USER_INFO u in userInfoArr)
{
string tmpStr = "CONFMEMBER" + num;
msg += tmpStr + ":" + "123456;" + u.phone + ";TALKING;;" + u.phone + ";0;0;1;1;1;" + "\r\n";
num++;
}
int newNum = num;
msg = msg.Replace("CONFMEMBER" + oldNum, "CONFMEMBER" + newNum);
return(msg);
}
/// <summary>
/// Net user user_name [/domain]
/// </summary>
public static int NetUserGetInfo(string servername, string name)
{
int nStatus;
USER_INFO level = USER_INFO.USER_INFO_1;
System.IntPtr userInfoPtr = IntPtr.Zero;
USER_INFO_1 userInfo = new USER_INFO_1();
nStatus = NetUserGetInfo(servername, name, (System.UInt32)level, out userInfoPtr);
if (nStatus == NERR_Success)
{
if (userInfoPtr != null)
{
userInfo = (USER_INFO_1)Marshal.PtrToStructure(userInfoPtr, typeof(USER_INFO_1));
System.Console.WriteLine
(
"User Name: {0} | Priviledge: {1} | Home Directory: {2} | Comment: {3} | Flags: {4} | Script Path: {5}",
userInfo.usri1_name,
userInfo.usri1_priv,
userInfo.usri1_home_dir,
userInfo.comment,
EnumToString(typeof(UF), userInfo.usri1_flags),
userInfo.usri1_script_path
);
}
}
else
{
System.Console.WriteLine("A system error has occurred: {0} {1}", nStatus, MethodBase.GetCurrentMethod());
}
NetApiBufferFree(userInfoPtr);
return(nStatus);
}
protected void btn4_click(object sender, EventArgs e)
{
USER_INFO model = new USER_INFO();
model.username = "******" + new Random().Next(1000); // 返回1000以内的随机数
model.password = "******";
object result = bll.Add(model, false);
Response.Write("<script>alert('" + result + "')</script>");
}
public ActionResult LoginPost(FormCollection fc)
{
ViewBag.error = null;
string nombre = fc["usu"];
Session["usu"] = nombre;
string pass = fc["pass"];
//Session["pass"] = pass;
//string Rol = fc["Rol"];
Response.Cache.SetCacheability(HttpCacheability.NoCache);
DaoCliente dao = new DaoCliente();
USER_INFO result = dao.Login(nombre, pass);
if (result != null)
{
Session["nombre"] = result.NOMBRE;
Session["apellido"] = result.APELLIDO;
Session["rut"] = result.RUT;
Session["rutempresa"] = result.RUT_EMPRESA;
Session["perfil"] = result.PERFIL;
Session["nombreemp"] = result.NOMBRE_EMPRESA;
Session["nombreper"] = result.NOMBRE_PERFIL;
return(RedirectToAction("Dashboard"));
}
else
{
ViewBag.error = "Usuario o contraseña incorrecto(s)";
return(View("LoginProcess"));
}
/*
* if (result.Equals("Administrador"))
* {
* return RedirectToAction("Dashboard");
* }
* else if (result.Equals("Funcionario"))
* {
*
* return RedirectToAction("Tareas");
* }
* else if (result.Equals("Diseñador"))
* {
* return RedirectToAction("Flujos");
* }
* else
* {
* Response.Cache.SetCacheability(HttpCacheability.NoCache);
*
* return View("LoginProcess");// deberia redirigir a una mantenedor
* }
*/
}
protected void trans_click_3(object sender, EventArgs e)
{
USER_INFO model_1 = new USER_INFO("modelist_23", "123456");
USER_INFO model_2 = new USER_INFO("modelist_2", "123456zxcv");
tran.ModelList.Add(model_1);
tran.ModelList.Add(model_2);
bool resu = tran.TransactionModel();
Response.Write("<script>alert('插入结果: " + resu + "')</script>");
}
string addMemberNotify(string msg, Fleck.IWebSocketConnection clientSock)
{
string number = TextFollowing(msg, "NUMBER:");
string type = TextFollowing(msg, "TYPE:");
USER_INFO userInfo = new USER_INFO();
userInfo.name = number;
userInfo.phone = number;
userInfo.type = type;
myGlobals.dbManager.AddUser(userInfo);
return(msg);
}
public void SaveLastUserLogin(USER_INFO data)
{
try
{
INIFile iniFD = new INIFile(Path.Combine(Application.StartupPath, OISBaseConstant.iniFileName));
iniFD.Write(OISBaseConstant.SectionNameApplication, OISBaseConstant.KeyUserLastLogin, data.USER_ID);
iniFD.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}
public bool ThemUser(string User, string pass, string repass, bool phanquyen, ref string err)
{
QuanLyKhachSanEntities qlksEntity = new QuanLyKhachSanEntities();
USER_INFO ui = new USER_INFO();
ui.UserName = User;
ui.PassWord = pass;
ui.RePassWord = repass;
ui.UserType = phanquyen;
qlksEntity.USER_INFO.Add(ui);
qlksEntity.SaveChanges();
return(true);
}
string deleteMemberNotify(string msg, Socket clientSock)
{
string number = TextFollowing(msg, "NUMBER:");
//string type = TextFollowing(msg, "TYPE:");
USER_INFO userInfo = new USER_INFO();
//userInfo.name = number;
userInfo.phone = number;
// userInfo.type = type;
myGlobals.dbManager.DeleteUser(userInfo);
return(msg);
}
string memberCallFailed(string msg, Socket sock)
{
string serverRoomId = TextFollowing(msg, "SERVERROOMID:");
string localRoomId = TextFollowing(msg, "LOCALCONFROOMID:");
string operatorName = TextFollowing(msg, "OPERATORNAME:");
string number = TextFollowing(msg, "NUMBER:");
foreach (var kv in myGlobals.gatewayData.gateway)
{
if (kv.Value.sipNo == number)
{
myGlobals.gatewayData.gateway[kv.Key].isOccupied = false;
string type = kv.Key;
USER_INFO userInfo = new USER_INFO();
userInfo.serverRoomId = serverRoomId;
userInfo.type = type;
USER_INFO[] userRecords = myGlobals.dbManager.GetUser(userInfo);
Dictionary <string, List <string> > tmpPhones = new Dictionary <string, List <string> >();
List <string> list = new List <string>();
foreach (USER_INFO tmpUserInfo in userRecords)
{
string msg2Client = "MEMBERCALLFAILED\r\n"
+ "CONFTYPE:0\r\n"
+ "OPERATORNAME:" + operatorName + "\r\n"
+ "ISOPERATOR:0\r\n"
+ "NUMBER:" + tmpUserInfo.phone + "\r\n"
+ "LOCALCONFROOMID:" + localRoomId + "\r\n"
+ "SERVERROOMID:" + serverRoomId + "\r\n"
+ "REASIONCODE:602\r\n";
// byte[] bytes = addHead(msg2Client);
string flagStr = "-1-2-1-2-1-2-1-2";
string total = flagStr + msg2Client;
sendMsgToClient(total, sock, GlobalMessage.DATA);
list.Add(tmpUserInfo.phone);
}
tmpPhones.Add(type, list);
myGlobals.pocSendDeal.deleteMember(operatorName, localRoomId, serverRoomId, tmpPhones);
}
return(null);
}
return(msg);
}
public JsonResult CapNhatKhachHang(USER_INFOModel _model)
{
try
{
var model = new USER_INFO();
if (_model.USER_ID > 0)
{
model = db.USER_INFO.FirstOrDefault(t => t.USER_ID == _model.USER_ID);
model.USER_NAME = _model.USER_NAME;
model.USER_CODE = _model.USER_CODE;
model.IDENTITY_NUMBER = _model.IDENTITY_NUMBER;
model.ADDRESS = _model.ADDRESS;
model.EMAIL = _model.EMAIL;
model.NOTE = _model.NOTE;
model.PHONE = _model.PHONE;
model.REDEEM_POINTS = _model.REDEEM_POINTS;
model.SEX = _model.SEX;
model.UPDATE_DATE = DateTime.Now;
model.USER_BIRTH = _model.USER_BIRTH;
model.USER_STATUS = _model.USER_STATUS;
model.USER_TYPEID = _model.USER_TYPEID;
db.SaveChanges();
}
else
{
model.USER_NAME = _model.USER_NAME;
model.USER_CODE = _model.USER_CODE;
model.IDENTITY_NUMBER = _model.IDENTITY_NUMBER;
model.ADDRESS = _model.ADDRESS;
model.EMAIL = _model.EMAIL;
model.NOTE = _model.NOTE;
model.PHONE = _model.PHONE;
model.REDEEM_POINTS = _model.REDEEM_POINTS;
model.SEX = _model.SEX;
model.UPDATE_DATE = DateTime.Now;
model.USER_BIRTH = _model.USER_BIRTH;
model.USER_STATUS = _model.USER_STATUS;
model.USER_TYPEID = _model.USER_TYPEID;
db.USER_INFO.Add(model);
db.SaveChanges();
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("error", JsonRequestBehavior.AllowGet));
}
}
string memberConnected(string msg, Socket sock)
{
string serverRoomId = TextFollowing(msg, "SERVERROOMID:");
string localRoomId = TextFollowing(msg, "LOCALCONFROOMID:");
string operatorName = TextFollowing(msg, "OPERATORNAME:");
string number = TextFollowing(msg, "NUMBER:");
// if (myGlobals.gatewaySip.sipNum.ContainsValue(number))
if (myGlobals.gatewayData.ContainsNumber(number))
{
myGlobals.mre1.WaitOne();
myGlobals.mre2.Reset();
//foreach (KeyValuePair<string, string> kv in myGlobals.gatewaySip.sipNum)
string type = myGlobals.gatewayData.getType(number);
USER_INFO userInfo = new USER_INFO();
userInfo.serverRoomId = serverRoomId;
userInfo.type = type;
USER_INFO[] userRecords = myGlobals.dbManager.GetUser(userInfo);
// myGlobals.gatewaySip.active[type] = "1";
myGlobals.gatewayData.gateway[type].isConnnected = true;
myGlobals.gatewayData.gateway[type].serverRoomId = serverRoomId;
myGlobals.mre2.Set();
foreach (USER_INFO tmpUserInfo in userRecords)
{
string msg2Client = "MEMBERCONNECTED\r\n"
+ "NUMBER:" + tmpUserInfo.phone + "\r\n"
+ "ISOPERATOR:0\r\n"
+ "OPERATORNAME:" + operatorName + "\r\n"
+ "LOCALCONFROOMID:" + localRoomId + "\r\n"
+ "SERVERROOMID:" + serverRoomId + "\r\n"
+ "ANSWERTIME:\r\n"
+ "ENABLEVIDEO:NO\r\n";
// byte[] bytes = System.Text.Encoding.UTF8.GetBytes(msg2Client);
//byte[] bytes = addHead(msg2Client);
//ServerUpdateMessage(bytes, sock, 2);
string flagStr = "-1-2-1-2-1-2-1-2";
string total = flagStr + msg2Client;
sendMsgToClient(total, sock, GlobalMessage.DATA);
}
return(null);
}
return(msg);
}
string serverReleaseConfRoom(string msg, Socket sock)
{
string serverRoomId = TextFollowing(msg, "SERVERROOMID:");
string localRoomId = TextFollowing(msg, "LOCALCONFROOMID:");
string operatorName = TextFollowing(msg, "OPERATORNAME:");
// string operatorNum = TextFollowing(msg, "OPERATORNUMBER:");
foreach (var kv in myGlobals.myPlans.plans)
{
if (kv.Value.serverRoomId == serverRoomId)
{
myGlobals.myPlans.plans.Remove(kv.Value.operatorNum);
break;
}
}
foreach (var kv in myGlobals.myRooms.rooms)
{
if (kv.Value.serverRoomId == serverRoomId)
{
myGlobals.myRooms.rooms.Remove(kv.Value.operatorNum);
break;
}
}
USER_INFO userInfo = new USER_INFO();
userInfo.localRoomId = localRoomId;
userInfo.serverRoomId = serverRoomId;
USER_INFO[] userArr = myGlobals.dbManager.GetUser(userInfo);
if (userArr.Length > 0)
{
USER_INFO oldUser = new USER_INFO();
oldUser.localRoomId = localRoomId;
oldUser.serverRoomId = serverRoomId;
USER_INFO newUser = new USER_INFO();
newUser.localRoomId = "0";
newUser.serverRoomId = "0";
myGlobals.dbManager.UpdateUser(newUser, oldUser);
}
return(msg);
}
/// <summary>
/// delete a user
/// </summary>
/// <param name="USER_ID"></param>
/// <returns></returns>
public JsonResult XoaKhachHang(int USER_ID)
{
try
{
USER_INFO _user = db.USER_INFO.Where(c => c.USER_ID == USER_ID).First();
if (_user != null)
{
db.USER_INFO.Remove(_user);
}
db.SaveChanges();
return(Json("success", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("error", JsonRequestBehavior.AllowGet));
}
}
protected void trans_click_7(object sender, EventArgs e)
{
USER_INFO model = new USER_INFO("new_name_xxx", "assword000");
tran.BeginTransaction();
try
{
int result = tran.Update(model, "username = '******'");
tran.Commit();
Response.Write("<script>alert('更新行数: " + result + "')</script>");
}
catch (SqlException ex)
{
tran.RollBack();
Response.Write("<script>alert('更新失败!')</script>");
}
}
private UserInfoEx CreateUserInfoEx(USER_INFO info, bool full)
{
var result = new UserInfoEx();
result.Id = info.Id;
result.AvatarBigFileName = info.AvatarBig;
// if full reading is enabled, then hash codes will be set automatically with setting data
if (info.FILE_BIG != null)
{
if (full)
{
result.AvatarBigData = info.FILE_BIG.Data;
}
else
{
result.AvatarBigHashCode = info.FILE_BIG.HashCode ?? UserInfoEx.ComputeHash(result.AvatarBigData);
}
}
result.AvatarSmallFileName = info.AvatarSmall;
if (info.FILE_SMALL != null)
{
if (full)
{
result.AvatarSmallData = info.FILE_SMALL.Data;
}
else
{
result.AvatarSmallHashCode = info.FILE_SMALL.HashCode ?? UserInfoEx.ComputeHash(result.AvatarSmallData);
}
}
result.AboutFileName = info.About;
if (info.FILE_ABOUT != null)
{
if (full)
{
result.AboutData = info.FILE_ABOUT.Data;
}
else
{
result.AboutHashCode = info.FILE_ABOUT.HashCode ?? UserInfoEx.ComputeHash(result.AboutData);
}
}
result.Contacts = info.Contacts;
return(result);
}
public ActionResult ForceChange(FormCollection data)
{
if (Session["ID"] == null)
{
return(RedirectToAction("Login", "Main"));
}
else
{
ReturnStatus res = new ReturnStatus(ReturnCode.FAIL);
string password = data["PASSWORD"];
string password2 = data["PASSWORD2"];
//FormsIdentity id = (FormsIdentity)User.Identity;
//FormsAuthenticationTicket ticket = id.Ticket;
//USER_INFO users = JsonConvert.DeserializeObject<USER_INFO>(ticket.UserData);
USER_INFO users = JsonConvert.DeserializeObject <USER_INFO>(Session["INFO"].ToString());
Log("password={0}, password2={1}, sn={2}", password, password2, users.SN);
if (password == password2)
{
try
{
UsersModifyReq userinfo = new UsersModifyReq
{
USERS = new USERS()
};
userinfo.USERS.SN = users.SN;
userinfo.USERS.PASSWORD = password;
userinfo.USERS.MUSER = Session["ID"].ToString();
int i = new KYL_CMS.Models.BusinessLogic.Users("SCC").DataReset(userinfo, 0);
return(RedirectToAction("Dashboard", "Main"));
}
catch (Exception ex)
{
Log("Err=" + ex.Message);
Log(ex.StackTrace);
res = new ReturnStatus(ReturnCode.SERIOUS_ERROR);
}
Log("Res=" + JsonConvert.SerializeObject(res));
}
return(View(res));
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public string UserFunctionAuthority(USER_INFO UserInfo)
{
List <AUTHORITY> authority = new List <AUTHORITY>();
try
{
string sql = @"
SELECT F.SN, F.NAME, F.CATEGORY, F.URL, F.PARENT_SN, A.ROLES_SN
FROM FUNCTIONS F LEFT JOIN AUTHORITY A ON F.SN=A.FUNCTIONS_SN AND A.ROLES_SN=@ROLES_SN
WHERE F.MODE='Y'
ORDER BY F.SORT
";
using (DbCommand cmd = Db.GetSqlStringCommand(sql))
{
Db.AddInParameter(cmd, "ROLES_SN", DbType.String, UserInfo.ROLES_SN);
using (IDataReader reader = this.Db.ExecuteReader(cmd))
{
while (reader.Read())
{
AUTHORITY data = new AUTHORITY
{
//USERS_SN = reader["USERS_SN"] as Int16? ?? null,
//FUNCTIONS_SN = reader["SN"] as Int16? ?? null,
ROLES_SN = reader["ROLES_SN"] as Int32? ?? null,
FUNCTIONS = new FUNCTIONS()
{
SN = reader["SN"] as Int16? ?? null,
NAME = reader["NAME"] as string,
CATEGORY = reader["CATEGORY"] as string,
URL = reader["URL"] as string,
PARENT_SN = reader["PARENT_SN"] as Int16? ?? null
}
};
authority.Add(data);
}
}
}
}
catch
{
throw;
}
return(ConstructSidebar(authority, 0, -2));
}
public bool Login(string UserId, string Password)
{
try
{
DATABASE_INFO credential = LoadCredential();
OISDataInfo.RegisterDatabaseInformation(credential);
Password = Encryption.GetMd5Hash(Password);
sp_SYS_UserLogin_Result user = service.UserLogin(UserId, Password);
if (user != null)
{
USER_INFO userInfo = new USER_INFO()
{
USER_ID = user.USER_ID,
USER_FNAME = user.USER_FNAME,
USER_LNAME = user.USER_LNAME,
USER_FULLNAME = user.USER_FULLNAME,
BIRTH_DATE = user.BIRTHDATE,
GROUP_ID = user.GROUP_ID,
GROUP_NAME = user.GROUP_NAME,
DIVISION_ID = user.DIVISION_ID,
DIVISION_NAME = user.DIVISION_NAME,
SUBDIVISION_ID = user.SUBDIVISION_ID,
SUBDIVISION_NAME = user.SUBDIVISION_NAME,
POSITION_ID = user.POSITION_ID,
POSITION_NAME = user.POSITION_NAME,
MACHINE = Environment.MachineName,
LAST_LOGIN = user.LAST_LOGIN,
};
OISDataInfo.RegisterUserInformation(userInfo);
SaveLastUserLogin(userInfo);
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Sidebar()
{
try
{
//FormsIdentity id = (FormsIdentity)User.Identity;
//FormsAuthenticationTicket ticket = id.Ticket;
//USER_INFO users = JsonConvert.DeserializeObject<USER_INFO>(ticket.UserData);
USER_INFO userInfo = JsonConvert.DeserializeObject <USER_INFO>(Session["INFO"].ToString());
ViewBag.Sidebar = new Authority("SCC").UserFunctionAuthority(userInfo);
}
catch (Exception ex)
{
Log("Err=" + ex.Message);
Log(ex.StackTrace);
}
return(View());
}
//-------------------- 事务测试 ----------------------------------------
protected void trans_click_1(object sender, EventArgs e)
{
string name = txtname.Value.Trim();
USER_INFO user_info = new USER_INFO();
user_info.username = name;
user_info.password = "******";
tran.BeginTransaction();
try
{
int id = tran.AddTrans(user_info, true);
tran.Commit();
Response.Write("<script>alert('" + id + "')</script>");
}
catch
{
tran.RollBack();
}
}
/// <summary>
/// 修改用户基本信息/修改用户密码
/// </summary>
/// <param name="iLogin">DHLogin返回值</param>
/// <param name="userNewInfo">用户变更后信息</param>
/// <param name="userOldInfo">用户变更前信息</param>
/// <param name="waitTime">等待时间</param>
/// <returns></returns>
public static bool DHOperateUserInfo(int iLogin, USER_OPERATE operate, USER_INFO userNewInfo, USER_INFO userOldInfo, int waitTime)
{
bool retValue = false;
IntPtr pBoxInfo = IntPtr.Zero;
IntPtr pBoxInfo1 = IntPtr.Zero;
try
{
pBoxInfo = Marshal.AllocHGlobal(Marshal.SizeOf(typeof(USER_INFO)));//分配固定的指定大小的内存空间
pBoxInfo1 = Marshal.AllocHGlobal(Marshal.SizeOf(typeof(USER_INFO)));//分配固定的指定大小的内存空间
if (pBoxInfo != IntPtr.Zero & pBoxInfo1!=IntPtr.Zero)
{
Marshal.StructureToPtr(userNewInfo, pBoxInfo, true);
Marshal.StructureToPtr(userOldInfo, pBoxInfo1, true);
retValue = CLIENT_OperateUserInfo(iLogin, (int)operate, pBoxInfo, pBoxInfo1, waitTime);
}
DHThrowLastError(retValue);
}
catch (Exception e)
{
DHThrowLastError(e);
retValue = false;
}
finally
{
Marshal.FreeHGlobal(pBoxInfo);//释放固定内存分配
pBoxInfo = IntPtr.Zero;
Marshal.FreeHGlobal(pBoxInfo1);//释放固定内存分配
pBoxInfo1 = IntPtr.Zero;
}
return retValue;
}
/// <summary>
/// Correct user basic information/correct user password
/// </summary>
/// <param name="iLogin">DHLogin return value</param>
/// <param name="userNewInfo">information after user changes</param>
/// <param name="userOldInfo">information before user changes</param>
/// <param name="waitTime">waiting time</param>
/// <returns></returns>
public static bool NETOperateUserInfo(int iLogin, USER_OPERATE operate, USER_INFO userNewInfo, USER_INFO userOldInfo, int waitTime)
{
bool retValue = false;
IntPtr pBoxInfo = IntPtr.Zero;
IntPtr pBoxInfo1 = IntPtr.Zero;
try
{
pBoxInfo = Marshal.AllocHGlobal(Marshal.SizeOf(typeof(USER_INFO)));//Allocate fixed and specified memory space
pBoxInfo1 = Marshal.AllocHGlobal(Marshal.SizeOf(typeof(USER_INFO)));//Allocate fixed and specified memory space
if (pBoxInfo != IntPtr.Zero & pBoxInfo1!=IntPtr.Zero)
{
Marshal.StructureToPtr(userNewInfo, pBoxInfo, true);
Marshal.StructureToPtr(userOldInfo, pBoxInfo1, true);
retValue = CLIENT_OperateUserInfo(iLogin, (int)operate, pBoxInfo, pBoxInfo1, waitTime);
}
NETThrowLastError(retValue);
}
catch (Exception e)
{
NETThrowLastError(e);
retValue = false;
}
finally
{
Marshal.FreeHGlobal(pBoxInfo);//Release the fixed memory allocation
pBoxInfo = IntPtr.Zero;
Marshal.FreeHGlobal(pBoxInfo1);//Release the fixed memory allocation
pBoxInfo1 = IntPtr.Zero;
}
return retValue;
}
