📄 manualsignsearch.aspx.cs
字号:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using MyOffice.BLL;
using MyOffice.Models;
public partial class MonuoalSign_ManualSignSearch : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
ListItem li = new ListItem();
li.Text = "==请选择==";
li.Value = 0 + "";
ddlBranchs.Items.Add(li);
ListItem lis = new ListItem();
lis.Text = "==请选择==";
lis.Value = 0 + "";
ddlDeparts.Items.Add(lis);
Branch();
}
}
//查询所有机构
public void Branch() {
List<BranchInfoModel> liBrach = personManageBLL.AllSeBr();
foreach (BranchInfoModel bim in liBrach) {
ListItem list = new ListItem();
list.Text = bim.BranchName;
list.Value = bim.BranchId.ToString();
ddlBranchs.Items.Add(list);
}
}
//根据机构信息查询相应的部门信息
protected void ddlBranchs_SelectedIndexChanged(object sender, EventArgs e)
{
int brachId = int.Parse(ddlBranchs.SelectedValue);
List<DepartInfoModel> lisdeinfo = personManageBLL.SeDeBId(brachId);
ddlDeparts.Items.Clear();
foreach (DepartInfoModel dif in lisdeinfo) {
ListItem listm = new ListItem();
listm.Text = dif.DepartName;
listm.Value = dif.DepartId.ToString();
ddlDeparts.Items.Add(listm);
}
}
protected void chklstSelect_SelectedIndexChanged(object sender, EventArgs e)
{
if (chklstSelect.Items[0].Selected)
{
ddlBranchs.Enabled = true;
}
else {
ddlBranchs.Enabled = false;
}
if (chklstSelect.Items[1].Selected)
{
ddlDeparts.Enabled = true;
ddlBranchs.Enabled = true;
}
else {
ddlDeparts.Enabled = false;
}
if (chklstSelect.Items[2].Selected)
{
txtUserId.Enabled = true;
}
else {
txtUserId.Enabled = false;
}
if (chklstSelect.Items[3].Selected)
{
txtUserName.Enabled = true;
}
else {
txtUserName.Enabled = false;
}
}
protected void imgbtnSearch_Click(object sender, ImageClickEventArgs e)
{
if (txtBeginTime.Text == "" && txtEndTime.Text == "")
{
Response.Write("<script>alert('请填写搜索日期');</script>");
}
else {
string begin = txtBeginTime.Text;
string end = txtEndTime.Text;
string Branch = ddlBranchs.SelectedValue;
string Depart = ddlDeparts.SelectedValue;
string userId = txtUserId.Text;
string userName = txtUserName.Text;
List<ManualSignModel> limasim = companyBLL.SelectFine(begin,end,Branch,Depart,userId,userName);
gvUserSignInfo.Visible = true;
gvUserSignInfo.DataSource = limasim;
gvUserSignInfo.DataBind();
Unite(gvUserSignInfo);
}
}
//合并单元格
protected void Unite(GridView gv)
{
int i;
string LastType1;
int LastCell;
if (gv.Rows.Count > 0)
{
for (int j = 0; j < 6; j++)
{
if (j != 1 && j != 2 && j != 3)
{
LastType1 = gv.Rows[0].Cells[j].Text;
gv.Rows[0].Cells[j].RowSpan = 1;
LastCell = 0;
for (i = 1; i < gv.Rows.Count; i++)
{
if (gv.Rows[i].Cells[j].Text == LastType1)
{
gv.Rows[i].Cells[j].Visible = false;
gv.Rows[LastCell].Cells[j].RowSpan++;
}
else
{
LastType1 = gv.Rows[i].Cells[j].Text;
LastCell = i;
gv.Rows[i].Cells[j].RowSpan = 1;
}
}
}
}
}
}
protected void gvUserSignInfo_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int mauaId = int.Parse(gvUserSignInfo.DataKeys[e.Row.RowIndex].Value.ToString());
ManualSignModel mansm = companyBLL.SelectManualId(mauaId);
e.Row.Cells[0].Text = mansm.Usinfo.UserName;
e.Row.Cells[1].Text = mansm.SignTime.ToString();
if (mansm.SignTag == 0)
{
e.Row.Cells[2].Text = "签到";
}
else if (mansm.SignTag == 1)
{
e.Row.Cells[2].Text = "签退";
}
e.Row.Cells[3].Text = mansm.SignDes;
e.Row.Cells[4].Text = mansm.Usinfo.Depart.DepartName;
e.Row.Cells[5].Text = mansm.Usinfo.Depart.Branch.BranchName;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -