private void AuthSuccessCallback(string UserID)
{
LoginMsg.text = "Auth Success";
SystemManage.GetAllTitleData(); //取得所有title data
SystemManage.GetAllStroeItem(); //取得所有物品
//使用playfab登入photon
PlayFabClientAPI.GetPhotonAuthenticationToken(new GetPhotonAuthenticationTokenRequest()
{
PhotonApplicationId = PhotonNetwork.PhotonServerSettings.AppSettings.AppIdRealtime
}, (xr) =>
{
var customAuth = new AuthenticationValues {
AuthType = CustomAuthenticationType.Custom
};
customAuth.AddAuthParameter("username", UserID);
customAuth.AddAuthParameter("token", xr.PhotonCustomAuthenticationToken);
PhotonNetwork.AuthValues = customAuth;
PhotonNetwork.ConnectUsingSettings();
LoginMsg.text = "Login....";
},
(xe) =>
{
LoginMsg.text = "Login Fail";
ModalHelper.WarningMessage("Photon Authentication fail.");
});
}
private void simpleButton_modify_Click(object sender, EventArgs e)
{
if (gridView.SelectedRowsCount != 1)
{
MessageBox.Show("请选择一条记录！", "警告");
return;
}
//获取选中的行的行号
int[] rowNums = gridView.GetSelectedRows();
DataTable dt = (DataTable)gridControl.DataSource;
SystemManage sys = new SystemManage();
sys.Id = Int32.Parse(dt.Rows[rowNums[0]][SystemManage.ID_COLUMN].ToString());
sys.UserName = dt.Rows[rowNums[0]][SystemManage.USERNAME_COLUMN].ToString();
sys.Password = dt.Rows[rowNums[0]][SystemManage.PASSWORD_COLUMN].ToString();
sys.Type = Int32.Parse(dt.Rows[rowNums[0]][SystemManage.TYPE_COLUMN].ToString());
sys.TypeName = dt.Rows[rowNums[0]][SystemManage.TYPENAME_COLUMN].ToString();
sys.Name = dt.Rows[rowNums[0]][SystemManage.NAME_COLUMN].ToString();
sys.IdCard = dt.Rows[rowNums[0]][SystemManage.IDCARD_COLUMN].ToString();
SystemManageEditForm systemManageEditForm = new SystemManageEditForm(sys);
systemManageEditForm.ShowDialog();
pageUpControl.GetDataTable();
}
private void btnBackup_Click(object sender, EventArgs e)
{
try
{
if (txtPath.Text.Trim() != "")
{
string strPath = txtPath.Text + @"\ERPManage";
string strFileName = DateTime.Now.ToString("yyyy-MM-dd");
SystemManage SystemManage = new SystemManage();
SystemManage.sp_BackupDatabase(strPath, strFileName);
//写日志
SysLog.AddOperateLog(SysParams.UserName, "系统数据库备份", "备份", SysParams.UserName + "用户备份了系统数据库,备份路径:" + strPath + strFileName + ".bak");
this.ShowMessage("数据库备份成功,已备份到" + strPath + strFileName + ".bak");
}
else
{
this.ShowMessage("请选择备份路径!");
}
}catch (Exception err)
{
this.ShowErrorMessage("数据库备份出现错误，请检查备份路径是否正确!");
}
}
public static SystemManage GetSystemManage()
{
String sql = "select * from systemmanage ";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
foreach (DataRow dr in dt.Rows)
{
SystemManage sm = new SystemManage();
sm.ID = Convert.ToInt32(dr["id"]);
sm.TikuPwd = dr["tkpwd"].ToString();
sm.KaochangJilv = dr["kcjl"].ToString();
return(sm);
}
return(null);
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public ActionResult DeleteContent()
{
var xid = Request["data1"];
var type = Request["data2"];
string strErr = "";
if (SystemManage.DeleteNewContent(xid, type, ref strErr) == true)
{
return(Json(new { success = "true", Msg = "保存成功" }));
}
else
{
return(Json(new { success = "false", Msg = "保存出错" + "/" + strErr }));
}
}
/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
public ActionResult InsertContent()
{
var type = Request["Type"];
var text = Request["Text"];
string strErr = "";
if (SystemManage.InsertNewContent(type, text, ref strErr) == true)
{
return(Json(new { success = "true", Msg = "保存成功" }));
}
else
{
return(Json(new { success = "false", Msg = "保存出错" + "/" + strErr }));
}
}
public SystemManageEditForm(SystemManage sys)
{
InitializeComponent();
init();
Id = sys.Id;
SystemManage sm = sys;
//编辑，根据id取出原来的数据，显示出来
textEdit_userName.Text = sm.UserName;
textEdit_password.Text = sm.Password;
textEdit_name.Text = sm.Name;
textEdit_IDCard.Text = sm.IdCard;
comboBoxEdit_type.SelectedIndex = smService.getIndex(sm.Type);
//不可修改用户名
textEdit_userName.Properties.ReadOnly = true;
}
public ActionResult upNewContent()
{
var XID = Request["XID"];
var Type = Request["Type"];
var Text = Request["Text"];
string strErr = "";
if (SystemManage.UpdateNewContent(XID, Type, Text, ref strErr) == true)
{
return(Json(new { success = "true", Msg = "保存成功" }));
}
else
{
return(Json(new { success = "false", Msg = "保存出错" + "/" + strErr }));
}
}
public Boolean addRow(SystemManage systemManage)
{
try
{
ICustomsCMS server = XmlRpcInstance.getInstance();
Usercheck usercheck = new Usercheck();
usercheck.idcard = systemManage.IdCard;
usercheck.password = systemManage.Password;
usercheck.realname = systemManage.Name;
usercheck.username = systemManage.UserName;
usercheck.rolename = systemManage.Type.ToString();
DBRPCResponse dBRPCResponse = server.AddUser(usercheck);
return(true);
}
catch (Exception ex)
{
throw new Exception("错误：" + ex.Message);
}
}
public static int UpdateKaochangjilv(string kcjv)
{
String sql = "select * from systemmanage ";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
SystemManage sm = new SystemManage();
foreach (DataRow dr in dt.Rows)
{
sm.ID = Convert.ToInt32(dr["id"]);
sm.TikuPwd = dr["tkpwd"].ToString();
sm.KaochangJilv = dr["kcjl"].ToString();
break;
}
sql = "update systemmanage set kcjl=@kcjl where id=@id";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@kcjl", kcjv));
para_list.Add(new MySqlParameter("@id", sm.ID));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
public ActionResult BasMangeGrid()
{
string strCurPage;
string strRowNum;
string where = "";
if (Request["curpage"] != null)
{
strCurPage = Request["curpage"].ToString();
}
if (Request["rownum"] != null)
{
strRowNum = Request["rownum"].ToString();
}
else
{
strRowNum = "10";
}
string type = Request["sel"].ToString();
if (type != "")//在此处做判断
{
where += " and a.Type ='" + type + "' ";
}
UIDataTable udtTask = new UIDataTable();
if (where != "")
{
udtTask = SystemManage.getNewBasMangeGrid(GFun.SafeToInt32(strRowNum), GFun.SafeToInt32(Request["curpage"]) - 1, where);
}
string strjson = GFun.Dt2Json("", udtTask.DtData);
strjson = strjson.Substring(1);
strjson = strjson.Substring(0, strjson.Length - 1);
string jsonData = "{ \"page\":" + GFun.SafeToInt32(Request["curpage"]) + ", \"total\": " + udtTask.IntTotalPages + ", \"records\": " + udtTask.IntRecords + ", \"rows\": ";
jsonData += strjson + "}";
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public ActionResult PerAllocation()
{
//系统
string sysname = "所有可操作系统";
//用户或角色ID
string id = Request["id"];
//权限类型，user/role
string tp = Request["tp"];
string sysid = "";
//搜索关键字
ViewBag.Search = base.keywords;
if (string.IsNullOrEmpty(tp))
{
return(Content("<script>alert('未接收到需要分配权限的类型')</script>"));
}
if (string.IsNullOrEmpty(id))
{
return(Content("<script>alert('未接收到需要分配权限的对象')</script>"));
}
int newid = int.Parse(id);
//模块
var moduleList = new List <Domain.SYS_MODULE>();
if (tp == "role")
{
var Role = RoleManage.Get(p => p.ID == newid);
var sys = SystemManage.Get(p => p.ID == Role.FK_BELONGSYSTEM.ToString());
sysname = sys.NAME;
sysid = sys.ID;
//获取角色所属系统模块
moduleList = this.ModuleManage.RecursiveModule(this.ModuleManage.LoadAll(p => p.FK_BELONGSYSTEM == Role.FK_BELONGSYSTEM).ToList());
}
else if (tp == "user")
{
//获取管理员可操作系统模块
moduleList = this.ModuleManage.RecursiveModule(this.ModuleManage.LoadAll(p => CurrentUser.System_Id.Any(e => e == p.FK_BELONGSYSTEM)).ToList());
}
//搜索关键字
if (!string.IsNullOrEmpty(keywords))
{
moduleList = moduleList.Where(p => p.NAME.Contains(keywords.ToLower())).ToList();
}
ViewData["ModuleList"] = JsonConverter.JsonClass(moduleList.Select(p => new { p.ID, MODULENAME = GetModuleName(p.NAME, p.LEVELS), p.ICON, p.PARENTID, p.LEVELS }));
//获取权限
var moduleId = moduleList.Select(p => p.ID).ToList();
ViewData["PermissionList"] = this.PermissionManage.LoadAll(p => moduleId.Any(e => e == p.MODULEID)).ToList();
//根据类型获取用户/角色已选中的权限
var selectper = new List <string>();
if (tp == "user")
{
selectper =
this.UserPermissionManage.LoadAll(p => p.FK_USERID == newid)
.Select(p => p.FK_PERMISSIONID)
.Cast <string>()
.ToList();
}
else if (tp == "role")
{
selectper =
this.RolePermissionManage.LoadAll(p => p.ROLEID == newid)
.Select(p => p.PERMISSIONID)
.Cast <string>()
.ToList();
}
ViewData["selectper"] = selectper;
ViewData["PermissionType"] = tp;
ViewData["objId"] = id;
ViewData["systemName"] = sysname;
ViewData["systemId"] = sysid;
return(View());
}
protected void BindData()
{
SystemManage sm = FTInterviewBLL.SystemManageManage.GetSystemManage();
ContentID.InnerHtml = sm.KaochangJilv;
}
private void simpleButton_add_Click(object sender, EventArgs e)
{
SystemManage sm = new SystemManage();
sm.UserName = textEdit_userName.Text;
sm.Password = textEdit_password.Text;
sm.Name = textEdit_name.Text;
sm.IdCard = textEdit_IDCard.Text;
if (String.IsNullOrEmpty(sm.UserName))
{
MessageBox.Show("用户名不能为空！", "提示");
return;
}
if (smService.findRowByIdAndName(id, sm.UserName))
{
MessageBox.Show("用户名已重复！", "提示");
return;
}
if (String.IsNullOrEmpty(sm.Password))
{
MessageBox.Show("密码不能为空！", "提示");
return;
}
if (String.IsNullOrEmpty(sm.Name))
{
MessageBox.Show("姓名不能为空！", "提示");
return;
}
if (String.IsNullOrEmpty(sm.IdCard))
{
MessageBox.Show("证件号不能为空！", "提示");
return;
}
if (comboBoxEdit_type.SelectedIndex == -1 || comboBoxEdit_type.SelectedIndex == 0)
{
MessageBox.Show("请选择类型！", "提示");
return;
}
sm.Type = (smService.getTypes())[comboBoxEdit_type.SelectedIndex].Key;
sm.Id = Id;
//保存
if (Id == 0 && smService.addRow(sm) == true)
{
MessageBox.Show("保存成功！", "提示");
LogService.getInstance().log("新增，用户名为" + sm.UserName, ModuleConstant.SystemManage_MODULE);
this.Close();
}
//编辑
else if (Id != 0 && smService.modifyRow(sm) == true)
{
MessageBox.Show("保存成功！", "提示");
LogService.getInstance().log("修改，用户名为" + sm.UserName, ModuleConstant.SystemManage_MODULE);
this.Close();
}
else
{
MessageBox.Show("保存失败！", "提示");
}
}
