protected override bool OnSaveData()
{
if (tblRole == null)
{
return(false);
}
try
{
SqlBaseProvider.InsertOperRole(id, tblRole);
this.OnDisplayAllCtrls(false);
tsbSave.Visible = false;
tsbCancel.Visible = false;
fState = FormState.Detail;
if (parentForm != null)
{
parentForm.RefreshForm();
}
}
catch (Exception ex)
{
Global.ShowSysError(ex);
return(false);
}
return(true);
}
protected override bool OnSaveData()
{
try
{
SysCompany sc = new SysCompany();
sc.CoID = txtCoID.Text;
sc.CoName = txtCoName.Text;
sc.CoAddress = txtCoAddress.Text;
sc.CoPost = txtCoPost.Text;
sc.CoTele = txtCoTele.Text;
sc.CoFax = txtCoFax.Text;
sc.CoEMail = txtCoEMail.Text;
sc.SortOrder = Convert.ToInt16(txtCoOrder.Text);
sc.CoMan = txtCoMan.Text;
sc.CoStatus = Convert.ToInt16(ddlCoStatus.SelectedValue);
if (this.FState == FormState.New)
{
SqlBaseProvider.SaveSysCompany(sc, DataProviderAction.Create);
}
else
{
SqlBaseProvider.SaveSysCompany(sc, DataProviderAction.Update);
}
return(true);
}
catch (Exception)
{
throw;
}
}
protected override void OnInitData()
{
base.OnInitData();
try
{
if (String.IsNullOrEmpty(id))
{
id = String.Empty;
txtProjectCode.Text = String.Empty;
txtProjectName.Text = String.Empty;
txtProjectDesc.Text = String.Empty;
txtWorkDate.Text = String.Empty;
CtrlHelper.SelectDropDownList(ddlProjectType, DropAddFlag.Select.ToString());
CtrlHelper.SelectDropDownList(ddlProjectStatus, DropAddFlag.Select.ToString());
CtrlHelper.SelectDropDownList(ddlProjectManager, DropAddFlag.Select.ToString());
CtrlHelper.SelectDropDownList(ddlWorkUnit, DropAddFlag.Select.ToString());
}
else
{
BusProject item = SqlBaseProvider.GetBusProject(id);
if (String.IsNullOrEmpty(item.ProjectID))
{
throw new Exception("未找到编号为[" + id + "]的员工信息！");
}
id = item.ProjectID;
txtProjectCode.Text = item.ProjectCode;
txtProjectName.Text = item.ProjectName;
txtWorkDate.Text = item.WorkDate.ToString();
txtProjectDesc.Text = item.ProjectDesc;
CtrlHelper.SelectDropDownList(ddlProjectManager, item.ProjectManager.ToString());
CtrlHelper.SelectDropDownList(ddlProjectType, item.ProjectType.ToString());
CtrlHelper.SelectDropDownList(ddlProjectStatus, item.ProjectStatus.ToString());
CtrlHelper.SelectDropDownList(ddlWorkUnit, item.WorkUnit.ToString());
int mAuth = Program.ManInfo.Auths.FindAuthByCode(this.mCode);
if (!CoreCtrls.CheckAuth(mAuth, AuthType.Edit))
{
this.OnDisplayAllCtrls(false);
tsbCancel.Visible = false;
tsbSave.Visible = false;
tsbEdit.Visible = false;
this.fState = FormState.Detail;
}
else
{
this.OnDisplayEditCtrls(false);
this.fState = FormState.Edit;
}
}
}
catch (Exception)
{
throw;
}
}
private void tsbAddChild_Click(object sender, EventArgs e)
{
try
{
if (!String.IsNullOrEmpty(tvDept.SelectedValue.ToString()))
{
OnInitData();
CtrlHelper.EnableCtrls(allCtrls);
CtrlHelper.DisableCtrls(newCtrls);
SysDept sd = SqlBaseProvider.GetSysDept(tvDept.SelectedValue.ToString());
CtrlHelper.SelectDropDownList(ddlCoID, sd.CoID);
txtDeptPID.Text = sd.DeptID;
fState = FormState.New;
tsbSave.Visible = true;
tsbCancel.Visible = true;
}
else
{
Global.ShowSysInfo("请选择需要增加同级部门的相关部门！");
}
}
catch (Exception ex)
{
Global.ShowSysError(ex);
}
}
private void btnRead_Click(object sender, EventArgs e)
{
if (ddlDB.SelectedValue.ToString().ToLower() == "select")
{
Global.ShowSysInfo("请选择数据库！");
return;
}
if (ddlTable.SelectedValue.ToString().ToLower() == "select")
{
Global.ShowSysInfo("请选择数据表！");
return;
}
try
{
DataTable tabels = SqlBaseProvider.GetColumnByTable(Convert.ToInt32(ddlDB.SelectedValue), ddlTable.SelectedValue.ToString());
SqlBaseProvider.GetTableByCode(pTable, Convert.ToInt32(ddlDB.SelectedValue), ddlTable.SelectedValue.ToString());
txtSet.Text = pTable.TableSet;
}
catch (Exception ex)
{
Global.ShowSysInfo(ex.Message);
}
}
public ManMan()
{
InitializeComponent();
tsbFirst.Visible = false;
tsbLast.Visible = false;
tsbPrev.Visible = false;
tsbNext.Visible = false;
tssNav.Visible = false;
this.Text = "员工管理";
this.mCode = "0603";
CoreCtrls.SetDataGridView(dgvList, "P_Get_SysMan", Program.ManInfo);
ectDept.Tree.ComboTreeType = WinControls.ComboTreeType.All;
ectDept.Tree.TypeText = "所有部门";
ectDept.Tree.DataSource = SqlBaseProvider.GetSimpleValidDept();
ectDept.Tree.DisplayMember = "Dept_Name";
ectDept.Tree.ValueMember = "Dept_ID";
ectDept.Tree.ParentMember = "Dept_PID";
ectDept.Tree.Height = 200;
ectDept.AbsoluteChildrenSelectableOnly = false;
ml = SqlBaseProvider.GetSetManLevel();
if (Program.ManInfo.Man.ManLevel >= ml)
{
ectDept.Visible = false;
lblDept.Text = "属于部门：" + Program.ManInfo.Man.DeptName;
}
}
private void ddlDB_SelectedIndexChanged(object sender, EventArgs e)
{
int dbid = ddlDB.SelectedValue.ToString().ToLower() == "select" ? 0 : Convert.ToInt32(ddlDB.SelectedValue);
string manid = Program.ManInfo.Man.ManID;
Program.DBID = dbid;
BusProject project = SqlBaseProvider.GetBusProjectByDB(dbid);
Program.ProjectCode = project.ProjectCode;
CtrlHelper.SetDropDownList(ddlTable, SqlBaseProvider.GetTableNoPmtByDB(dbid), DropAddType.New, DropAddFlag.Select, String.Empty, "TableName,TableCode");
pTable.OnInit();
txtSet.Text = String.Empty;
txtResult.Text = String.Empty;
txtPackage.Text = String.Empty;
txtPrefix.Text = String.Empty;
txtCatalog.Text = String.Empty;
txtClassName.Text = String.Empty;
txtValue.Text = String.Empty;
BusHours hours = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (hours != null)
{
isHours = true;
}
else
{
isHours = false;
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(Program.NowLoginMan))
{
Global.ShowSysInfo("密码修改人未知！");
return;
}
if (String.IsNullOrEmpty(txtOld.Text))
{
Global.ShowSysInfo("原密码不能为空！");
return;
}
if (String.IsNullOrEmpty(txtNew.Text))
{
Global.ShowSysInfo("新密码不能为空！");
return;
}
if (String.IsNullOrEmpty(txtReNew.Text))
{
Global.ShowSysInfo("确认新密码不能为空！");
return;
}
if (txtOld.Text == txtNew.Text)
{
Global.ShowSysInfo("新密码和旧密码不能重复！");
return;
}
if (txtNew.Text != txtReNew.Text)
{
Global.ShowSysInfo("新密码和确认新密码不一致！");
return;
}
if (!SqlBaseProvider.ValidPassword(Program.NowLoginMan, txtOld.Text))
{
Global.ShowSysInfo("原密码输入错误！");
return;
}
try
{
SqlBaseProvider.FirstLogin(Program.NowLoginMan, Crypto.MD5Crypto(txtNew.Text));
Global.ShowSysInfo("密码修改成功！");
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Global.ShowSysError(ex);
}
}
public EditMan()
{
InitializeComponent();
this.Text = "员工管理";
this.mCode = "0603";
tssPrint.Visible = false;
tsbPreview.Visible = false;
tsbPrint.Visible = false;
ml = SqlBaseProvider.GetSetManLevel();
}
protected override bool OnSaveData()
{
try
{
SysMan item = new SysMan();
item.ManID = txtManID.Text;
item.ManName = txtManName.Text;
item.CoID = Program.ManInfo.Man.CoID;
item.DeptID = ectDept.SelectValue;
item.ManType = Convert.ToInt16(ddlManType.SelectedValue);
item.CrtDate = DateTime.Now;
item.CrtOper = Program.ManInfo.Man.ManID;
item.ManTele = txtManTele.Text;
item.ManDate = DateTime.Now;
item.ManLevel = Convert.ToInt16(ddlManLevel.SelectedValue);
item.ManTitle = Convert.ToInt16(ddlManTitle.SelectedValue);
item.ManSex = 1;
item.ManStatus = Convert.ToInt16(ddlManStatus.SelectedValue);
item.OperPassword = Crypto.MD5Crypto(txtManID.Text);
item.OperSerial = 1;
item.WorkDate = DateTime.Now.ToString("yyyyMMdd");
item.PreWorkDate = item.WorkDate;
if (String.IsNullOrEmpty(id))
{
SqlBaseProvider.SaveSysMan(item, DataProviderAction.Create);
id = item.ManID;
}
else
{
SqlBaseProvider.SaveSysMan(item, DataProviderAction.Update);
}
this.OnDisplayAllCtrls(false);
Global.DisableComboxTree(ectDept);
tsbSave.Visible = false;
tsbCancel.Visible = false;
fState = FormState.Detail;
if (parentForm != null)
{
parentForm.RefreshForm();
}
}
catch (Exception ex)
{
Global.ShowSysError(ex);
return(false);
}
return(true);
}
private void btnRegister_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(ectDept.SelectValue.ToString()))
{
MessageBox.Show("您没有选择需要注册的部门，请重新选择！");
return;
}
try
{
SysRegister rg = SqlBaseProvider.GetSysRegister(Publics.GetRegisterNumber(Program.CpuInfo));
if (String.IsNullOrEmpty(rg.DeptID))
{
rg.DeptID = ectDept.SelectValue.ToString();
rg.CpuCode = Program.CpuInfo;
rg.CrtDate = DateTime.Now;
rg.RegNumber = Publics.GetRegisterNumber(Program.CpuInfo);
rg.RegCode = rg.RegNumber;
SqlBaseProvider.SaveSysRegister(rg, DataProviderAction.Create);
if (rg.RegID > 0)
{
MessageBox.Show("该终端已经在系统里注册成功！");
this.DialogResult = DialogResult.OK;
}
else
{
throw new Exception("注册时数据库发生错误！");
}
}
else
{
if (rg.DeptID != ectDept.SelectValue.ToString())
{
MessageBox.Show("该终端已经在系统里被其它部门注册完成，不能被重复注册！");
return;
}
else
{
MessageBox.Show("该终端已经在系统里注册完成，不需要再次注册，确认后直接进入系统！");
this.DialogResult = DialogResult.OK;
}
}
}
catch (Exception ex)
{
MessageBox.Show("注册时产生错误，请与系统管理员联系！" + ex.Message);
return;
}
}
protected override void OnInitData()
{
base.OnInitData();
clMan.Items.Clear();
tblMan = SqlBaseProvider.GetDeveloper(id);
foreach (DataRow mandr in tblMan.Rows)
{
clMan.Items.Add(mandr["Man_Name"], Convert.ToBoolean(mandr["Is_Select"]));
}
}
public EditHours()
{
InitializeComponent();
this.Text = "工时管理";
this.mCode = "0401";
tssPrint.Visible = false;
tsbPreview.Visible = false;
tsbPrint.Visible = false;
this.WorkStart.CustomFormat = "yyyy年MM月dd日 HH:mm:ss";
this.WorkEnd.CustomFormat = "yyyy年MM月dd日 HH:mm:ss";
ml = SqlBaseProvider.GetSetManLevel();
}
private void btnExit_Click(object sender, EventArgs e)
{
BusHours item = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (item != null)
{
item.DBID = Program.DBID;
item.WorkEnd = DateTime.Now;
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Update);
}
this.Close();
}
protected override void OnInitData()
{
base.OnInitData();
clRole.Items.Clear();
tblRole = SqlBaseProvider.GetSysRoleByMan(Program.ManInfo.Man.ManID, id);
foreach (DataRow roledr in tblRole.Rows)
{
clRole.Items.Add(roledr["Role_Name"], Convert.ToBoolean(roledr["Is_Select"]));
}
}
protected override bool OnSaveData()
{
if (menudt == null)
{
return(false);
}
if (navdt == null)
{
return(false);
}
try
{
SysRole item = new SysRole();
item.RoleName = txtRoleName.Text;
item.AuthBound = Convert.ToInt16(ddlData.SelectedValue);
item.CrtDate = DateTime.Now;
item.RoleMan = Program.ManInfo.Man.ManID;
item.RoleDesc = txtRoleDesc.Text;
if (id == 0)
{
SqlBaseProvider.SaveSysRole(item, menudt, navdt, DataProviderAction.Create);
id = item.RoleID;
}
else
{
item.RoleID = id;
SqlBaseProvider.SaveSysRole(item, menudt, navdt, DataProviderAction.Update);
}
this.OnDisplayAllCtrls(false);
tsbSave.Visible = false;
tsbCancel.Visible = false;
fState = FormState.Detail;
if (parentForm != null)
{
parentForm.RefreshForm();
}
}
catch (Exception ex)
{
Global.ShowSysError(ex);
return(false);
}
return(true);
}
private void Change_Click(object sender, EventArgs e)
{
string ManID = Program.ManInfo.Man.ManID;
short RegID = Program.ManInfo.Register.RegID;
try
{
SqlBaseProvider.LoginOutSysOnline(ManID, RegID);
}
catch (Exception)
{
}
Application.Restart();
}
private void tmOnline_Tick(object sender, EventArgs e)
{
try
{
SysOnline so = SqlBaseProvider.ContinueOnline(Program.ManInfo.Man.ManID, Program.ManInfo.Register.RegID);
if (String.IsNullOrEmpty(so.ManID))
{
Application.Exit();
}
}
catch (Exception)
{
}
}
private void MainForm_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
SqlBaseProvider.LoginOutSysOnline(Program.ManInfo.Man.ManID, Program.ManInfo.Register.RegID);
BusHours item = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (item != null)
{
item.DBID = Program.DBID;
item.WorkEnd = DateTime.Now;
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Update);
}
}
catch (Exception)
{
}
}
private void MybatisCode_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
BusHours item = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (item != null)
{
item.DBID = Program.DBID;
item.WorkEnd = DateTime.Now;
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Update);
Program.DBID = -1;
}
}
catch (Exception)
{
}
}
public Register()
{
InitializeComponent();
ectDept.Tree.ComboTreeType = GuFun.WinControls.ComboTreeType.None;
ectDept.Tree.TypeText = "";
ectDept.Tree.DataSource = SqlBaseProvider.GetSimpleValidDept();
ectDept.Tree.DisplayMember = "Dept_Name";
ectDept.Tree.ValueMember = "Dept_ID";
ectDept.Tree.ParentMember = "Dept_PID";
ectDept.Tree.Height = 200;
ectDept.AbsoluteChildrenSelectableOnly = false;
ctbInfo.BackColor = Color.FromArgb(255, 250, 205);
btnClose.BackColor = SystemColors.Control;
btnRegister.BackColor = SystemColors.Control;
}
protected override void OnBindData()
{
string sql = String.Empty;
string projectname = String.Empty;
string projectManager = Program.ManInfo.Man.ManID;
if (!String.IsNullOrEmpty(txtProjectName.Text))
{
sql += " and a.ProjectName like '%" + txtProjectName.Text + "%' ";
}
if (!String.IsNullOrEmpty(projectManager))
{
sql += " and a.ProjectManager = '" + projectManager + "' ";
}
dgvList.DataSource = SqlBaseProvider.SearchBusProject(sql);
}
protected void OnBindData()
{
tvDept.ComboTreeType = WinControls.ComboTreeType.None;
tvDept.DataSource = SqlBaseProvider.SelectSysDept(true);
tvDept.DisplayMember = "Dept_Name";
tvDept.ValueMember = "Dept_ID";
tvDept.ParentMember = "Dept_PID";
tvDept.ExpandAll();
if (isRefresh)
{
TreeNode[] tns = tvDept.Nodes.Find(txtDeptID.Text, true);
if (tns.Length > 0)
{
tvDept.SelectedNode = tns[0];
}
}
}
protected override void OnDeleteData()
{
SqlConnection conn = DBUtils.GetConnection();
SqlCommand cmd = DBUtils.GetCommand();;
try
{
base.OnDeleteData();
if (dgvList.SelectedRows.Count != 1)
{
Global.ShowSysInfo("请选择需要修改的数据行！");
return;
}
BusProject item = new BusProject();
string id = dgvList.SelectedRows[0].Cells["ProjectID"].Value.ToString();
item.ProjectID = id;
SqlBaseProvider.SaveBusProject(item, DataProviderAction.Delete);
PdmDatabase db = SqlBaseProvider.GetDBByProject(id);
if (db != null)
{
cmd.Transaction = conn.BeginTransaction();
ArrayList paras = new ArrayList();
if (db.DBID > 0)
{
paras.Clear();
paras.Add(DBUtils.MakeInParam("DBID", SqlDbType.Int, db.DBID));
DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, "dbo.P_Delete_Info", paras);
}
cmd.Transaction.Commit();
}
RefreshForm();
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
protected override bool OnLoadData(bool isLoad)
{
if ((etcMain.SelectedIndex == 1) && (String.IsNullOrEmpty(txtCoID.Text)))
{
MessageBox.Show("请返回列表选择需要进行修改的数据！", PublicConsts.PC_Tip);
return(false);
}
if (dgvList.SelectedRows.Count != 1)
{
return(false);
}
try
{
txtCoID.Text = dgvList.SelectedRows[0].Cells["Co_ID"].Value.ToString();
SysCompany sc = SqlBaseProvider.GetSysCompany(txtCoID.Text);
txtCoName.Text = sc.CoName;
txtCoAddress.Text = sc.CoAddress;
txtCoFax.Text = sc.CoFax;
txtCoTele.Text = sc.CoTele;
txtCoFax.Text = sc.CoFax;
txtCoEMail.Text = sc.CoEMail;
txtCoOrder.Text = sc.SortOrder.ToString();
txtCoPost.Text = sc.CoPost;
txtCoMan.CodeText = sc.CoMan;
if (!String.IsNullOrEmpty(txtCoMan.CodeText))
{
txtCoMan.NameText = SqlBaseProvider.GetManName(txtCoMan.CodeText);
}
CtrlHelper.SelectDropDownList(ddlCoStatus, sc.CoStatus.ToString());
}
catch (Exception ex)
{
Global.ShowSysError(ex);
}
return(true);
}
protected override void OnBindData()
{
PageBusHours page = new PageBusHours();
string sql = String.Empty;
string projectname = String.Empty;
bool isSearch = false;
page.Start = this.CurrentPage * this.PageRows + 1;
page.End = (this.CurrentPage + 1) * this.PageRows;
if (!String.IsNullOrEmpty(txtProjectCode.Text))
{
page.Search += ToolUtils.GetAndSearch(page.Search) + "b.ProjectCode like '%" + txtProjectCode.Text + "%' ";
isSearch = true;
}
if (!String.IsNullOrEmpty(txtManName.Text))
{
page.Search += ToolUtils.GetAndSearch(page.Search) + "c.Man_Name like '%" + txtManName.Text + "%' ";
isSearch = true;
}
if (isSearch)
{
page.GetAction = Convert.ToString(ActionType.Full);
}
DataTable dt = SqlBaseProvider.SearchBusHours(page);
if ((dt != null) && (dt.Rows.Count > 0))
{
if (isSearch)
{
DataRow dr = dt.NewRow();
dr["ProjectCode"] = "合计：" + dt.Compute("Count(WorkCount)", null) + "人/日";
dr["WorkCount"] = dt.Compute("Sum(WorkCount)", null);
dt.Rows.Add(dr.ItemArray);
}
dgvList.DataSource = dt;
this.AllCount = page.Total;
}
}
protected override bool OnSaveData()
{
try
{
BusProject item = new BusProject();
item.ProjectID = id;
item.ProjectCode = txtProjectCode.Text;
item.ProjectName = txtProjectName.Text;
item.ProjectType = ddlProjectType.SelectedValue.ToString();
item.ProjectStatus = ddlProjectStatus.SelectedValue.ToString();
item.ProjectManager = ddlProjectManager.SelectedValue.ToString();
item.WorkDate = Double.Parse(txtWorkDate.Text);
item.WorkUnit = ddlWorkUnit.SelectedValue.ToString();
item.ProjectDesc = txtProjectDesc.Text;
item.TranDate = DateTime.Now;
item.TranUser = Program.ManInfo.Man.ManID;
if (String.IsNullOrEmpty(id))
{
SqlBaseProvider.SaveBusProject(item, DataProviderAction.Create);
id = item.ProjectID;
}
else
{
SqlBaseProvider.SaveBusProject(item, DataProviderAction.Update);
}
this.OnDisplayAllCtrls(false);
tsbSave.Visible = false;
tsbCancel.Visible = false;
fState = FormState.Detail;
if (parentForm != null)
{
parentForm.RefreshForm();
}
}
catch (Exception ex)
{
Global.ShowSysError(ex);
return(false);
}
return(true);
}
private void EditMan_Load(object sender, EventArgs e)
{
ectDept.Tree.ComboTreeType = WinControls.ComboTreeType.All;
ectDept.Tree.TypeText = "所有部门";
ectDept.Tree.DataSource = SqlBaseProvider.GetSimpleValidDept();
ectDept.Tree.DisplayMember = "Dept_Name";
ectDept.Tree.ValueMember = "Dept_ID";
ectDept.Tree.ParentMember = "Dept_PID";
ectDept.Tree.Height = 200;
ectDept.AbsoluteChildrenSelectableOnly = false;
CtrlHelper.SetDropDownList(ddlManType, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Man_Type order by Man_Type", SqlTextType.Text, "Man_Type_Name,Man_Type"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlManTitle, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Man_Title order by Man_Title", SqlTextType.Text, "Man_Title_Name,Man_Title"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlManLevel, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Man_Level order by Man_Level", SqlTextType.Text, "Man_Level_Name,Man_Level"), DropAddType.New, DropAddFlag.Select);
CtrlHelper.SetDropDownList(ddlManStatus, CoreCtrls.GetComboBoxItems("Select * from T_Pmt_Man_Status order by Man_Status", SqlTextType.Text, "Man_Status_Name,Man_Status"), DropAddType.New, DropAddFlag.Select);
this.allCtrls = new object[] { txtManID, txtManName, txtManTele, ddlManLevel, ddlManStatus, ddlManTitle, ddlManType, ectDept };
this.editCtrls = new object[] { txtManID };
OnInitData();
}
private void tmTime_Tick(object sender, EventArgs e)
{
sslTime.Text = " 当前时间：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string NowDate = DateTime.Now.ToString("yyyy-MM-dd");
if (Program.LoginDate != NowDate)
{
BusHours item = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (item != null)
{
item.DBID = Program.DBID;
item.ManID = Program.ManInfo.Man.ManID;
item.WorkEnd = Convert.ToDateTime(Program.LoginDate + " 23:59:59");
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Update);
Program.LoginDate = NowDate;
// 跨天的情况，将WorkEnd作为临时变量，传递到后台，判断过12点后是否有打卡记录，如果没有，则会补打
item.WorkEnd = Convert.ToDateTime(Program.LoginDate);
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Create);
}
}
}
protected void OnLoadData()
{
try
{
SysDept sd = SqlBaseProvider.GetSysDept(tvDept.SelectedValue.ToString());
txtDeptID.Text = sd.DeptID;
txtDeptPID.Text = sd.DeptPID;
txtDeptAddress.Text = sd.DeptAddress;
txtDeptName.Text = sd.DeptName;
if (!String.IsNullOrEmpty(sd.DeptMan))
{
txtDeptMan.CodeText = sd.DeptMan;
SysMan sm = SqlBaseProvider.GetSysMan(sd.DeptMan);
txtDeptMan.NameText = sm.ManName;
}
else
{
txtDeptMan.CodeText = String.Empty;
txtDeptMan.NameText = String.Empty;
}
txtDeptEMail.Text = sd.DeptEMail;
txtDeptFax.Text = sd.DeptFax;
txtDeptPost.Text = sd.DeptPost;
txtDeptTele.Text = sd.DeptTele;
txtSortOrder.Text = sd.SortOrder.ToString();
txtDeptShort.Text = sd.DeptShort;
CtrlHelper.SelectDropDownList(ddlCoID, sd.CoID);
CtrlHelper.SelectDropDownList(ddlDeptType, sd.DeptType.ToString());
CtrlHelper.SelectDropDownList(ddlDeptStatus, sd.DeptStatus.ToString());
CtrlHelper.SelectDropDownList(ddlDeptLevel, sd.DeptLevel.ToString());
}
catch (Exception ex)
{
Global.ShowSysError(ex);
}
}
