//返回頁面地址給iframe的src
public string Address()
{
if (url.Length > 1)
{
string userId = (base.Request.QueryString["UserId"] == null) ? "" : base.Request.QueryString["UserId"].ToString().Trim();
string moduleCode = (base.Request.QueryString["ModuleCode"] == null) ? "" : base.Request.QueryString["ModuleCode"].ToString().Trim();
//從人事端口登錄時，取得其傳出的UserId，填充Session，防止在部份電腦中出現頁面跳出的問題。
if (!string.IsNullOrEmpty(userId))
{
PersonBll personBll = new PersonBll();
List<PersonModel> user = personBll.GetPersonUserId(userId);
if (user == null || user.Count < 1)
{
Response.Redirect("http://10.138.4.205:100");
}
else
{
Session[GlobalData.UserInfoSessionKey] = user[0];//填充用戶Session
}
}
//url = url.Substring(1) + "?ModuleCode="+moduleCode;
url = url.Substring(1) + "?UserId=" + userId + "&ModuleCode=" + moduleCode;
//url = url + "?UserId=ADMIN";
}
return url;
}
private void btn_delete_Click(object sender, EventArgs e)
{
if (label3.Text.Equals(""))
{
MessageBox.Show("请先查询出要操作的员工信息！", "操作提示",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
DialogResult dr;
dr = MessageBox.Show("确定要删除编号为" + label3.Text + "的员工吗？", "确认退出",
MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
if (dr == DialogResult.OK)
{
PersonBll pb = new PersonBll();
int i = pb.deleteStaff(label3.Text);
if (i == -1)
{
MessageBox.Show("删除失败！", "操作提示",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (i == 0)
{
MessageBox.Show("删除失败！", "操作提示",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
MessageBox.Show("删除成功！", "操作提示",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
if (!info.Equals(""))
{
PersonBll pb1 = new PersonBll();
DataTable result = (DataTable)pb1.selectSingleStaff(info);
dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
dataGridView1.ColumnHeadersVisible = true;
if (result != null && result.Rows.Count > 0)
{
dataGridView1.DataSource = result;
label3.DataBindings.Clear();
label3.DataBindings.Add("Text", result, "employnum");
}
else if (result == null)
{
this.Dispose();
this.Close();
}
else
{
dataGridView1.ColumnHeadersVisible = false;
dataGridView1.DataSource = null;
label3.DataBindings.Clear();
label3.Text = "";
}
}
}
}
}
}
/// <summary>
/// Finds the person.
/// </summary>
/// <param name="passport">The passport.</param>
/// <returns>
/// Current person.
/// </returns>
/// <exception cref="System.ArgumentNullException">passport</exception>
public PersonBll FindPerson(string passport)
{
PersonBll temp = personRepository.Get(passport).ToBllPerson();
if (ReferenceEquals(temp, null))
{
throw new ArgumentNullException($"{nameof(passport)} doesn't contains in the database");
}
return(temp);
}
/// <summary>
/// To the DAL person.
/// </summary>
/// <param name="personBll">The person BLL.</param>
/// <returns>Equals DAL person.</returns>
public static PersonalInfo ToDalPerson(this PersonBll personBll)
{
PersonalInfo temp = new PersonalInfo()
{
Name = personBll.Name,
Surname = personBll.Surname,
Passport = personBll.Passport,
Email = personBll.Email
};
return(temp);
}
/// <summary>
/// To the BLL person.
/// </summary>
/// <param name="personalInfo">The personal information.</param>
/// <returns>Equals BLL person.</returns>
public static PersonBll ToBllPerson(this PersonalInfo personalInfo)
{
PersonBll temp = new PersonBll
{
Id = personalInfo.Id,
Name = personalInfo.Name,
Surname = personalInfo.Surname,
Passport = personalInfo.Passport,
Email = personalInfo.Email
};
return(temp);
}
/// <summary>
/// To the DAL person.
/// </summary>
/// <param name="personBll">The person BLL.</param>
/// <returns>Equals DAL person.</returns>
public static PersonDal ToDalPerson(this PersonBll personBll)
{
PersonDal temp = new PersonDal(personBll.Name, personBll.Surname, personBll.Passport, personBll.Email);
ICollection <AccountDal> accounts = new List <AccountDal>();
foreach (AccountBll account in personBll.Accounts)
{
accounts.Add(account.PartialMapAccountDal());
}
temp.AccountsDal = accounts;
return(temp);
}
/// <summary>
/// To the BLL person.
/// </summary>
/// <param name="personDal">The personal information.</param>
/// <returns>Equals BLL person.</returns>
public static PersonBll ToBllPerson(this PersonDal personDal)
{
PersonBll temp = new PersonBll(personDal.Name, personDal.Surname, personDal.Passport, personDal.Email);
ObservableCollection <AccountBll> accounts = new ObservableCollection <AccountBll>();
foreach (AccountDal account in personDal.AccountsDal)
{
accounts.Add(account.PartialMapAccountBll());
}
temp.Accounts = accounts;
return(temp);
}
static void Main(string[] args)
{
kernel = new StandardKernel();
kernel.ConfigurateResolver();
IBankService service = kernel.Get <IBankService>();
//service.NewOwner("Owner1", "Owner1", "123456", "*****@*****.**");
//service.NewAccount(1, 1000m, 2);
AccountBll temp = service.FindAccount(1158234195);
Console.WriteLine(temp.Person.Name);
PersonBll tempP = service.FindPerson("123456");
//PersonBll person = service.FindPerson("123456");
Console.WriteLine(tempP.Accounts.FirstOrDefault(item => item.Number == 1158234195).Number);
//Console.WriteLine(account.PersoneId);
}
private void button1_Click(object sender, EventArgs e)
{
info = tb_staffinfo.Text.Trim();
if (!info.Equals(""))
{
PersonBll pb = new PersonBll();
DataTable result = (DataTable)pb.selectSingleStaff(info);
dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
dataGridView1.ColumnHeadersVisible = true;
if (result != null && result.Rows.Count > 0)
{
dataGridView1.DataSource = result;
label3.DataBindings.Clear();
label3.DataBindings.Add("Text", result, "employnum");
}
else if (result == null)
{
this.Dispose();
this.Close();
}
else
{
dataGridView1.ColumnHeadersVisible = false;
dataGridView1.DataSource = null;
label3.DataBindings.Clear();
label3.Text = "";
MessageBox.Show("没有查询到信息！", "操作提示",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
dataGridView1.ColumnHeadersVisible = false;
dataGridView1.DataSource = null;
label3.DataBindings.Clear();
label3.Text = "";
MessageBox.Show("请输入要员工信息！", "操作提示",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void FormSelectStaff_Load(object sender, EventArgs e)
{
PersonBll pb = new PersonBll();
DataTable result = (DataTable)pb.selectAllStaff();
dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
if (result != null && result.Rows.Count > 0)
{
dataGridView1.DataSource = result;
}
else if (result == null)
{
this.Dispose();
this.Close();
}
else
{
dataGridView1.ColumnHeadersVisible = false;
dataGridView1.DataSource = null;
}
}
protected override void AjaxProcess()
{
bool flag = false;
string noticeJson = null;
int num = 0;
PersonModel model = new PersonModel();
if (!string.IsNullOrEmpty(Request.Form["Empno"]))
{
PersonBll bll = new PersonBll();
string empno = Request.Form["Empno"];
model.Personcode = empno;
model.Num = bll.GetCount(model);
DataTable dt = bll.GetEmployeeInfo(model.Personcode);
if (dt != null && dt.Rows.Count != 0)
{
model.Cname = dt.Rows[0]["localname"].ToString();
}
flag = true;
}
//if (!string.IsNullOrEmpty(Request.Form["Personcode"]))
//{
// string empno = Request.Form["Personcode"];
// Session["personcode"] = empno;
//}
if (model != null)
{
noticeJson = JsSerializer.Serialize(model);
}
if (flag)
{
Response.Clear();
Response.Write(noticeJson);
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
PersonBll bll = new PersonBll();
UltraWebGridLanguage.DataSource = bll.selectLanguage();
UltraWebGridLanguage.DataBind();
}
/// <summary>
/// Partials the map person ORM.
/// </summary>
/// <param name="personDal">The person DAL.</param>
/// <returns>Current ORM person.</returns>
internal static PersonDal PartialMapPersonDal(this PersonBll personDal)
{
return(new PersonDal(personDal.Name, personDal.Surname, personDal.Passport, personDal.Email));
}
/// <summary>
/// 失效
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDisable_Click(object sender, EventArgs e)
{
logmodel.ProcessFlag = "update";
PersonModel model = GetModel();
PersonBll bll = new PersonBll();
bool succeed = false;
if (model.Personcode != null)
{
model.Deleted = "Y";
succeed = bll.UpdatePersonByKey(model, logmodel);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.AtLastOneChoose + "');", true);
}
if (succeed)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.DisableSuccess + "');", true);
DataBind();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.DisableFailed + "');", true);
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
PersonModel model = PageHelper.GetModel<PersonModel>(pnlContent.Controls);
PersonBll bll = new PersonBll();
List<PersonModel> list = bll.GetList(dt_global);
string[] header = { ControlText.gvHeadPersonCode, ControlText.gvHeadCname, ControlText.gvHeadCompanyName, ControlText.gvHeadDepName, ControlText.gvHeadRoleName, ControlText.gvHeadAdmin, ControlText.gvHeadLanguageName, ControlText.gvHeadLevelName, ControlText.gvHeadLoginTimes, ControlText.gvHeadLoginTime, ControlText.gvHeadTel, ControlText.gvHeadMail, ControlText.gvHeadDeleted, ControlText.gvHeadModifier, ControlText.gvHeadModifyDate };
string[] properties = { "Personcode", "Cname", "CompanyName", "DepName", "RoleName", "IfAdmin", "LanguageName", "LevelName", "LoginTimes", "LoginTime", "Tel", "Mail", "Deleted", "UpdateUser", "UpdateDate" };
string filePath = MapPath("~/ExportFileTemp/") + DateTime.Now.Ticks + ".xls";
NPOIHelper.ExportExcel(list, header, properties, 5000, filePath);
PageHelper.ReturnHTTPStream(filePath, true);
}
protected void btnQuery_Click(object sender, EventArgs e)
{
pager.CurrentPageIndex = 1;
if (hidOperate.Value == "condition")
{
model_global = GetModel();
PersonBll bll = new PersonBll();
DataTable dt = bll.GetPerson(model_global, pager.CurrentPageIndex, pager.PageSize, out totalCount, base.SqlDep);
pager.RecordCount = totalCount;
dt_global = bll.GetPerson(model_global, base.SqlDep); ;
DataBind(dt);
}
}
/// <summary>
/// 重置密碼
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnResetPWD_Click(object sender, EventArgs e)
{
logmodel.ProcessFlag = "update";
PersonModel model = GetModel();
PersonBll bll = new PersonBll();
bool succeed = false;
if (model.Personcode != null)
{
model.Passwd = "Foxconn88";
//succeed = bll.UpdatePersonByKey(model);
succeed = bll.UpdatePWDByKey(model.Personcode, "Foxconn88", logmodel);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.AtLastOneChoose + "');", true);
}
if (succeed)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.ResetPasswordSuccess + "');", true);
DataBind();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.ResetPasswordFailed + "');", true);
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
PersonModel model = GetModel();
PersonBll bll = new PersonBll();
bool succeed;
if (hidOperate.Value == "modify")
{
logmodel.ProcessFlag = "update";
succeed = bll.UpdatePersonByKey(model, logmodel);
if (succeed)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.UpdateSuccess + "');", true);
DataBind();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.UpdateFailed + "');", true);
}
}
if (hidOperate.Value == "add")
{
//model.Passwd = "Foxconn88";
logmodel.ProcessFlag = "insert";
succeed = bll.AddPerson(model, logmodel);
succeed = bll.UpdatePWDByKey(model.Personcode, "Foxconn88", logmodel);
if (succeed)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.AddSuccess + "');", true);
DataBind();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.AddFailed + "');", true);
}
}
}
protected void pager_PageChanged(object sender, EventArgs e)
{
if (hidOperate.Value == "condition")
{
PersonBll bll = new PersonBll();
DataTable dt = bll.GetPerson(model_global, pager.CurrentPageIndex, pager.PageSize, out totalCount, base.SqlDep);
pager.RecordCount = totalCount;
dt_global = bll.GetPerson(model_global, base.SqlDep); ;
DataBind(dt);
}
else
{
PersonBll bll = new PersonBll();
PersonModel model = new PersonModel();
DataTable dt = bll.GetPerson(model, pager.CurrentPageIndex, pager.PageSize, out totalCount, base.SqlDep);
pager.RecordCount = totalCount;
dt_global = bll.GetPerson(model, base.SqlDep); ;
DataBind(dt);
}
}
//替換工號
protected void btn_replace_Click(object sender, EventArgs e)
{
string[] info = ddlDocnoType.SelectedValuesToString(",").Split(new char[] { ',' });
string y = tb_y_empno.Text.Trim();
string n = tb_n_newpno.Text.Trim();
PersonBll person = new PersonBll();
List<PersonModel> listperson = person.GetPersonUserId(y);
List<PersonModel> listperson1 = person.GetPersonUserId(n);
if (!(listperson != null && listperson.Count > 0))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('" + Message.YempnonotExit + "');</script>");
return;
}
if (!(listperson1 != null && listperson1.Count > 0))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('" + Message.NempnonoExit + "');</script>");
return;
}
if (workflowset.ReplaceAllEmpno(info, y, n, listperson1[0].Cname, listperson1[0].Mail, workflowset.GetManager(n)))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('" + Message.ReplaceOK + "');</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('" + Message.DeleteFailed + "');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session["personcode"] = "";
pager.CurrentPageIndex = 1;
HiddenModuleCode.Value = Request.QueryString["ModuleCode"].ToString();
//PageHelper.ButtonControls(base.FuncList, pnlShowPanel.Controls, base.FuncListModule);
if (ClientMessage == null)
{
ClientMessage = new Dictionary<string, string>();
ClientMessage.Add("DeleteConfirm", Message.DeleteConfirm);
ClientMessage.Add("SaveConfim", Message.SaveConfim);
ClientMessage.Add("DataExist", Message.DataExist);
ClientMessage.Add("PersoncodeNotNull", Message.PersoncodeNotNull);
ClientMessage.Add("CnameNotNull", Message.CnameNotNull);
ClientMessage.Add("CompanyIdNotNull", Message.CompanyIdNotNull);
ClientMessage.Add("RolesCodeNotNull", Message.RolesCodeNotNull);
ClientMessage.Add("DepCodeNotNull", Message.DepCodeNotNull);
ClientMessage.Add("LanguageNotNull", Message.LanguageNotNull);
ClientMessage.Add("IfAdminNotNull", Message.IfAdminNotNull);
ClientMessage.Add("AtLastOneChoose", Message.AtLastOneChoose);
}
string clientmsg = JsSerializer.Serialize(ClientMessage);
Page.ClientScript.RegisterStartupScript(GetType(), "ClientMessage", "var Message=" + clientmsg + ";", true);
if (!IsPostBack)
{
HiddenPersonCode.Value = CurrentUserInfo.Personcode;
logmodel.ProcessOwner = CurrentUserInfo.Personcode;
logmodel.TransactionType = Request.QueryString["ModuleCode"].ToString();
logmodel.LevelNo = "2";
logmodel.FromHost = Request.UserHostAddress;
PersonBll bll = new PersonBll();
PersonModel model = new PersonModel();
DataTable tempTable = bll.GetPerson(model, pager.CurrentPageIndex, pager.PageSize, out totalCount, base.SqlDep);
pager.RecordCount = totalCount;
dt_global = bll.GetPerson(model, base.SqlDep);
pager.TextAfterPageIndexBox = "/" + pager.PageCount.ToString();
DataBind(tempTable);
SetSelector(imgCompanyId, txtCompanyId, txtCompanyName, "CompanyId", Request.QueryString["ModuleCode"].ToString());
SetSelector(imgRolCode, txtRoleCode, txtRolesName, "RoleCode", Request.QueryString["ModuleCode"].ToString());
SetSelector(imgDepLevel, txtDepLevel, txtLevelName, "DepLevel", Request.QueryString["ModuleCode"].ToString());
SetSelector(imgLanguage, txtLanguage, txtLanguageName, "Language", Request.QueryString["ModuleCode"].ToString());
SetSelector(imgAdmini, txtIfAdmin, txtAdminName, "IfAdmin", Request.QueryString["ModuleCode"].ToString());
SetSelector(imgDePCode, txtDepCode, txtDepName, "DepCode", Request.QueryString["ModuleCode"].ToString());
SetSelector(imgUserChangePwd, txtUserChangePwd, txtUserChangePwdName, "UserChangePwd", Request.QueryString["ModuleCode"].ToString());
SetSelector(imgUserStartPwd, txtUserStartPwd, txtUserStartPwdName, "UserStartPwd", Request.QueryString["ModuleCode"].ToString());
SetSelector(imegSalaryLogonEnable, txtSalaryLogonEnable, txtSalaryLogonEnableName, "SalaryLogonEnable", Request.QueryString["ModuleCode"].ToString());
SetSelector(imgIpControlFlag, txtIpControlFlag, txtIpControlFlagName, "IpControlFlag", Request.QueryString["ModuleCode"].ToString());
SetSelector(imgEmpType, txtEmpType, txtEmpTypeName, "EmpType", Request.QueryString["ModuleCode"].ToString());
}
}
/// <summary>
/// 刪除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
logmodel.ProcessFlag = "delete";
PersonModel model = GetModel();
PersonBll bll = new PersonBll();
if (model.Personcode != null)
{
int flag = bll.DeletePersonByKey(model.Personcode, logmodel);
if (flag == 1)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.DeleteSuccess + "');", true);
DataBind();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.DeleteFailed + "');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "isnumber", "alert('" + Message.AtLastOneChoose + "');", true);
}
}
/// <summary>
/// 綁定數據
/// </summary>
private void DataBind()
{
//txtPersoncode.ReadOnly = true;
txtPersoncode.Attributes.Add("readonly", "true");
//txtCname.ReadOnly = true;
txtCname.Attributes.Add("readonly", "true");
//txtCompanyId.ReadOnly = true;
txtCompanyId.Attributes.Add("readonly", "true");
//txtDepCode.ReadOnly = true;
txtDepCode.Attributes.Add("readonly", "true");
//txtRoleCode.ReadOnly = true;
txtRoleCode.Attributes.Add("readonly", "true");
//txtLanguage.ReadOnly = true;
txtLanguage.Attributes.Add("readonly", "true");
//txtDepLevel.ReadOnly = true;
txtDepLevel.Attributes.Add("readonly", "true");
//txtIfAdmin.ReadOnly = true;
txtIfAdmin.Attributes.Add("readonly", "true");
//txtTel.ReadOnly = true;
txtTel.Attributes.Add("readonly", "true");
//txtMail.ReadOnly = true;
txtMail.Attributes.Add("readonly", "true");
btnSave.Attributes.Add("disabled", "true");
btnCancel.Attributes.Add("disabled", "true");
PersonBll bll = new PersonBll();
PersonModel model = new PersonModel();
DataTable dt = bll.GetPerson(model, pager.CurrentPageIndex, pager.PageSize, out totalCount, base.SqlDep);
pager.RecordCount = totalCount;
dt_global = bll.GetPerson(model, base.SqlDep); ;
this.UltraWebGridPerson.DataSource = dt;
this.UltraWebGridPerson.DataBind();
pager.TextAfterPageIndexBox = "/" + pager.PageCount.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
PersonBll bll = new PersonBll();
this.UltraWebGridDepLevel.DataSource = bll.selectDepLevel();
UltraWebGridDepLevel.DataBind();
}
/// <summary>
/// 登錄判斷及初始化
/// </summary>
/// <param name="e"></param>
protected override void OnPreInit(EventArgs e)
{
AjaxProcess();
if (CurrentUserInfo == null)
{
List<PersonModel> user = new List<PersonModel>();
if (Request.QueryString["IsMail"] == "Y")
{
user = new PersonBll().GetPersonUserId(Request.QueryString["UserId"], Request.QueryString["PassWord"], Request.QueryString["IsMail"]);
}
else
{
user = new PersonBll().GetPersonLoginId(Request.QueryString["UserId"]);
}
if (user != null && user.Count >= 1)
{
Session[GlobalData.UserInfoSessionKey] = user[0];
}
else
Response.Redirect("http://10.138.4.205:100");
}
}
