protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
txtCreatedBy.Text = ""; //从登录得到用户名
txtCreatedBy.Enabled = false;
ControlDataBind drp = new ControlDataBind(ConfigurationManager.ConnectionStrings["OA"].ToString());
drp.DropDownListBind(drpGuardSpec, "SOrdSpec", "SpecName", "SpecID", 1, "", txtCreatedBy.Text.Trim());
drp.DropDownListBind(drpOrder_ID, "SOrdEstate", "Order_ID", "Order_ID", 4, "StatusId = 4", txtCreatedBy.Text.Trim()); //完结状态的勤务
lblEnregisterTime.Text = System.DateTime.Now.Year.ToString() + "-" + System.DateTime.Now.Month.ToString() +
"-" + System.DateTime.Now.Day.ToString(); //得到当前的时间
if (Request.QueryString["Order_ID"] == null || Request.QueryString["Order_ID"].ToString() == "") //勤务编号
{
ViewState["State"] = "Insert";
}
else
{
// string Order_ID = Request.QueryString["Order_ID"].ToString();
string Order_ID = "200842001";
ViewState["Order_ID"] = Order_ID;
ViewState["State"] = "Update";
string selectSql = " SELECT [Order_ID],[EnregisterTime],[GuardSpec],[MoveDate],[MoveTomeFrom],[MoveTomeTo],[FrontUnit]," +
"[AppearedFugle],[CalendarArrange],[Principal],[Roster],[Remark],[Perform],[CreatedBy],[CreatedDate],[ModifiedBy],[ModifiedDate],[StatusId] " +
" FROM SOrdSynodBenregister where Order_ID = '" + Order_ID + "'";
DataRow selectRow = db.GetDataRow(selectSql);
ViewState["Order_ID"] = selectRow[0];
drpOrder_ID.SelectedValue = selectRow[0].ToString(); //勤务编号
drpOrder_ID.Enabled = false;
this.lblEnregisterTime.Text = selectRow[1].ToString(); //登记时间
drpGuardSpec.SelectedValue = selectRow[2].ToString(); ///警卫规格
txtMoveDate.Text = selectRow[3].ToString(); ///活动天数
txtMoveTomeFrom1.Text = GetDate(selectRow[4].ToString()); //得到日期
drpMoveTomeFrom2.SelectedValue = GetHour(selectRow[4].ToString()); //时
txtMoveTomeFrom3.Text = GetMinute(selectRow[4].ToString()); //分
txtMoveTomeTo1.Text = GetDate(selectRow[5].ToString()); //得到日期
drpMoveTomeTo2.SelectedValue = GetHour(selectRow[5].ToString()); //时
txtMoveTomeTo3.Text = GetMinute(selectRow[5].ToString()); //分
txtFrontUnit.Text = selectRow[6].ToString(); //主办单位
txtAppearedFugle.Text = selectRow[7].ToString(); // 省陪同领导：
txtCalendarArrange.Text = selectRow[8].ToString(); // 活动日程：
txtPrincipal.Text = selectRow[9].ToString(); // 负责人：
txtRoster.Text = selectRow[10].ToString(); // 值勤人员：
txtPerform.Text = selectRow[12].ToString(); // 情况
txtRemark.Text = selectRow[11].ToString(); // 备注
}
}
}
public void Search(string Title, string Writer, string Id, DataGrid DGrid, Button btnFirst, Button btnPrevious, Button btnNext, Button btnLast, Label Messge, string Str, Label totalPage, string SessionID)
{
try
{
sql = KnowledgeArticleSql.SearchAticleSql(Title, Writer, Id);
_Sds = db.GetDataSet(sql);
DGrid.CurrentPageIndex = 0;
DGrid.SelectedIndex = -1;
ControlDataBind.DataGridDSBind(DGrid, _Sds, btnFirst, btnPrevious, btnNext, btnLast, Messge, Str, totalPage, SessionID);
}
catch (Exception Err)
{
ErrorLog.LogInsert(Err.Message, "CS/KnowledgeBase/KnowledgeRule", SessionID);
return;
}
}
public void Search(string SearchType, string SearchContent, DataGrid DGrid, Button btnFirst, Button btnPrevious, Button btnNext, Button btnLast, Label message, string Str, Label totalPage, string SessionID)
{
try
{
sql = KnowledgeSql.SearchInfoSql(SearchType, SearchContent);
_Sds = db.GetDataSet(sql);
DGrid.CurrentPageIndex = 0;
DGrid.SelectedIndex = -1;
ControlDataBind.DataGridDSBind(DGrid, _Sds, btnFirst, btnPrevious, btnNext, btnLast, message, Str, totalPage, SessionID);
}
catch (Exception Err)
{
ErrorLog.LogInsert(Err.Message, "UI/Sys/Sysrepwd_Button1_Click", SessionID);
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Config Config = (Config)Session["Config"];
if (!this.IsPostBack)
{
//判断用户的角色
// string staff_Id = Config.Staff.Staff_Id; //得到登录的用户名
// string Role = Config.LoginRole.ToString(); //得到登录角色
// string selectRole = db.GetDataScalar("SELECT Name FROM SSysRole WHERE (Role_Id = '" + Role + "')"); //根据传来的角色ID得到角色的名称
string staff_Id = "00000001";
string selectRole = ""; //！！！！！ 先写死办公室值班室
ViewState["staff_Id"] = staff_Id; //用户名
ViewState["Role"] = selectRole; //角色
ControlDataBind drp = new ControlDataBind(ConfigurationManager.ConnectionStrings["OA"].ToString());
if (selectRole == "值班室")
{
drp.DropDownListBind(dropOrder, "STelEnrol", "Tel_ID", "Tel_ID", 4, "StatusId in ('1','2','4')", staff_Id);
}
else //如果不等于值班室，只能查看和自己相关的勤务
{
//查找该用户名做的所有勤务
//在流程表中查找下部执行人有该登录名的
DataTable OrderTable = new DataTable();
string staffOne = "select distinct Tel_ID from STelFlow where PExecute = '" + staff_Id + "'" +
" UNION " +
"select distinct Tel_ID from STelFlow left join SOrdArrangeMan on STelFlow.NExecute = SOrdArrangeMan.Guid where Man = '" + staff_Id + "'";
OrderTable = db.GetDataTable(staffOne);
DataRow dr = OrderTable.NewRow();
dr["Tel_ID"] = "0";
OrderTable.Rows.InsertAt(dr, 0);
dropOrder.DataSource = OrderTable;
dropOrder.DataValueField = "Tel_ID";
dropOrder.DataTextField = "Tel_ID";
dropOrder.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
ControlDataBind drp = new ControlDataBind(ConfigurationManager.ConnectionStrings["OA"].ToString());
string CreatedBy = "";
drp.DropDownListBind(drpOrder_ID, "SOrdEstate", "Order_ID", "Order_ID", 4, "StatusId = 4", CreatedBy); //完结状态的勤务
if (Request.QueryString["Order_ID"] == null || Request.QueryString["Order_ID"].ToString() == "") //勤务编号
{
ViewState["State"] = "Insert";
}
else
{
ViewState["State"] = "Update";
// string Order_ID = Request.QueryString["Order_ID"].ToString();
string Order_ID = "200842001";
ViewState["Order_ID"] = Order_ID;
drpOrder_ID.SelectedValue = Order_ID;
drpOrder_ID.Enabled = false;
string Strselect = "SELECT [NJGuard],[XVGuard],[WXGuard],[CZGuard],[SZGuard],[NTGuard],[LYGGuard],[HAGuard],[ZJGuard],[TZGuard],[SQGuard],[YCGuard],[YZGuard],[Remark]" +
" FROM SOrdSummarize where Order_ID = '" + ViewState["Order_ID"].ToString() + "'";
DataRow row = db.GetDataRow(Strselect);
SetCheck(row[0].ToString(), Chknj1, Chknj2, Chknj3, Chknj4, Chknj5, Chknj6, Chknj7, Chknj8, Chknj9, Chknj10, Chknj11, Chknj12);
SetCheck(row[1].ToString(), Chkxz1, Chkxz2, Chkxz3, Chkxz4, Chkxz5, Chkxz6, Chkxz7, Chkxz8, Chkxz9, Chkxz10, Chkxz11, Chkxz12);
SetCheck(row[2].ToString(), Chkwx1, Chkwx2, Chkwx3, Chkwx4, Chkwx5, Chkwx6, Chkwx7, Chkwx8, Chkwx9, Chkwx10, Chkwx11, Chkwx12);
SetCheck(row[3].ToString(), Chkcz1, Chkcz2, Chkcz3, Chkcz4, Chkcz5, Chkcz6, Chkcz7, Chkcz8, Chkcz9, Chkcz10, Chkcz11, Chkcz12);
SetCheck(row[4].ToString(), Chksz1, Chksz2, Chksz3, Chksz4, Chksz5, Chksz6, Chksz7, Chksz8, Chksz9, Chksz10, Chksz11, Chksz12);
SetCheck(row[5].ToString(), Chknt1, Chknt2, Chknt3, Chknt4, Chknt5, Chknt6, Chknt7, Chknt8, Chknt9, Chknt10, Chknt11, Chknt12);
SetCheck(row[6].ToString(), Chklyg1, Chklyg2, Chklyg3, Chklyg4, Chklyg5, Chklyg6, Chklyg7, Chklyg8, Chklyg9, Chklyg10, Chklyg11, Chklyg12);
SetCheck(row[7].ToString(), Chkha1, Chkha2, Chkha3, Chkha4, Chkha5, Chkha6, Chkha7, Chkha8, Chkha9, Chkha10, Chkha11, Chkha12);
SetCheck(row[8].ToString(), Chkzj1, Chkzj2, Chkzj3, Chkzj4, Chkzj5, Chkzj6, Chkzj7, Chkzj8, Chkzj9, Chkzj10, Chkzj11, Chkzj12);
SetCheck(row[9].ToString(), Chktz1, Chktz2, Chktz3, Chktz4, Chktz5, Chktz6, Chktz7, Chktz8, Chktz9, Chktz10, Chktz11, Chktz12);
SetCheck(row[10].ToString(), Chksq1, Chksq2, Chksq3, Chksq4, Chksq5, Chksq6, Chksq7, Chksq8, Chksq9, Chksq10, Chksq11, Chksq12);
SetCheck(row[11].ToString(), Chkyc1, Chkyc2, Chkyc3, Chkyc4, Chkyc5, Chkyc6, Chkyc7, Chkyc8, Chkyc9, Chkyc10, Chkyc11, Chkyc12);
SetCheck(row[12].ToString(), Chkyz1, Chkyz2, Chkyz3, Chkyz4, Chkyz5, Chkyz6, Chkyz7, Chkyz8, Chkyz9, Chkyz10, Chkyz11, Chkyz12);
TextBox1.Text = row[13].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string PFunction = "";
if (Request.QueryString["PFunction"] == null || Request.QueryString["PFunction"].ToString() == "") //编码
{
Response.Redirect("error2.htm");
}
else
{
PFunction = Request.QueryString["PFunction"].ToString();
}
ControlDataBind drp = new ControlDataBind(ConfigurationManager.ConnectionStrings["OA"].ToString());
string Sql = "";
if (PFunction == "1") //如果上步骤是电话登记，下步骤肯定是办公室审批
{
Sql = "select * from SOrdConfig where FunctionID = 2";
}
else if (PFunction == "2") //如果上步骤是办公室审批，下步骤肯定是领导批示
{
Sql = "select * from SOrdConfig where FunctionID = 3";
}
else if (PFunction == "3") //如果上步骤是领导批示，下步骤可能是领导批示可能是勤务安排还有可能是勤务分配
{
Sql = "select * from SOrdConfig where FunctionID = 3 or FunctionID = 4 or FunctionID = 5";
}
else if (PFunction == "4") //如果上步骤是勤务安排，下步骤肯定是领导批示
{
Sql = "select * from SOrdConfig where FunctionID = 3";
}
DropDownList1.DataSource = db.GetDataTable(Sql);
DropDownList1.DataTextField = "FunctionName";
DropDownList1.DataValueField = "FunctionID";
DropDownList1.DataBind();
}
}
static StringBuilder str; //显示区域用来放动态的table
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.CheckNet1.Checked = false;
this.CheckNet2.Checked = false;
this.CheckNet3.Checked = false;
this.radType1.Checked = false;
this.radType2.Checked = false;
this.radType3.Checked = false;
this.radType4.Checked = false;
Config Config = (Config)Session["Config"];
// string staff_Id = Config.Staff.Staff_Id; //得到登录的用户名
string Satff_ID = "00000001";
ViewState["Satff_Id"] = Satff_ID;
// string Role = Config.LoginRole.ToString(); //得到登录角色
// string selectRole = db.GetDataScalar("SELECT Name FROM SSysRole WHERE (Role_Id = '" + Role + "')"); //根据传来的角色ID得到角色的名称
string selectRole = "";
ControlDataBind drp = new ControlDataBind(ConfigurationManager.ConnectionStrings["OA"].ToString());
drp.DropDownListBind(drpOrder_ID, "SOrdEstate", "Order_ID", "Order_ID", 4, "StatusId = 4", Satff_ID); //完结状态的勤务
drp.DropDownListBind(dropOrderNotion, "SSFugleideaConfig", "IdeaContent", "IdeaID", 1, "", Satff_ID);
if (Request.QueryString["Order_ID"] == null || Request.QueryString["Order_ID"].ToString() == "") //勤务编号
{
ViewState["State"] = "Insert";
PanelYC();
this.panelsr.Visible = true; //显示panel
this.lblMan.Text = ""; //根据传来的编号显示姓名
this.lblTime.Text = System.DateTime.Now.Year.ToString() + "-" + System.DateTime.Now.Month.ToString() +
"-" + System.DateTime.Now.Day.ToString(); //得到当前的时间
btnPersonnel.Visible = false;
}
else
{
// ViewState["Order_ID"] = Request.QueryString["Order_ID"].ToString();
ViewState["Order_ID"] = "2008410001";
ViewState["Net_Guid"] = db.GetDataScalar("select Net_Guid from SOrdNet where Order_ID = '" + ViewState["Order_ID"].ToString() + "'"); //得到编号
string Count = db.GetDataScalar("select Count(*) from SOrdNet where StatusId = '3' and Order_ID = '" + ViewState["Order_ID"].ToString() + "'"); //编号为3说明到了领导处可
if (Count != "0") //领导审批阶段
{
PanelYC();
XS();
this.panelxs.Visible = true;
this.btnSave.Visible = false;
if (db.GetDataScalar("select Count(*) from SOrdNetAuditing where Net_Guid = '" +
ViewState["Net_Guid"].ToString() + "' and StatusId = '1'") != "0") //修改阶段
{
string Count5 = db.GetDataScalar("select Count(*) from SOrdNetAuditing where StatusId = '1' and Net_Guid = '"
+ ViewState["Net_Guid"].ToString() + "' and Per_ID = '" + ViewState["Satff_Id"].ToString() + "'"); //看看现在登录人是不是这步的操作人
if (Count5 != "0")
{
UpdateLDXG();
Label1.Text = "LDXG";
}
else
{
return; //不是，退出
}
}
else
{
string Count1 = db.GetDataScalar("select Count(*) from SOrdNet left join SOrdArrangeMan on SOrdNet.nextPer = SOrdArrangeMan.Guid where " +
" SOrdArrangeMan.Man = '" + ViewState["Satff_Id"].ToString() + "' and Order_ID = '" + ViewState["Order_ID"].ToString() + "'");
if (Count1 != "0")
{
this.panel1.Visible = true; //领导审批的页面显示
}
else //如果不一致
{
string Count2 = db.GetDataScalar("select Count(*) from (select top 1 A.* from SOrdNetAuditing A left join SOrdNet B on A.Net_Guid = B.Net_Guid " +
" where B.Order_ID = '" + ViewState["Order_ID"].ToString() + "' order by A.CreatedDate DESC) as C left join SOrdArrangeMan on SOrdNet.nextPer = SOrdArrangeMan.Guid where " +
" Man = '" + ViewState["Satff_Id"].ToString() + "'");
if (Count1 != "0") //如果领导审批表中有记录 //权限验证
{
this.panel1.Visible = true; //领导审批的页面显示
}
}
}
}
else //填写人修改，或者办公室部门核稿件
{
string Count3 = db.GetDataScalar("select StatusId from SOrdNet where Order_ID = '" + ViewState["Order_ID"].ToString() + "'"); //判断状态
drpOrder_ID.SelectedValue = ViewState["Order_ID"].ToString(); //勤务编号
drpOrder_ID.Enabled = false;
if (Count3 == "1") //填写人的修改状态
{
ViewState["State"] = "Update";
PanelYC();
this.panelsr.Visible = true;
EditSR();
btnPersonnel.Visible = false;
}
else if (Count3 == "2") //等待办公室审批
{
if (selectRole == "办公室")
{
PanelYC();
this.panelsr.Visible = true;
ViewState["State"] = "Update";
EditSR();
}
else
{
XS();
}
}
else if (Count3 == "4") //办公室审批完毕
{
PanelYC();
this.panelxs.Visible = true;
XS();
}
}
}
}
}
static StringBuilder str; //显示区域用来放动态的table
protected void Page_Load(object sender, EventArgs e)
{
Config Config = (Config)Session["Config"];
// string staff_Id = Config.Staff.Staff_Id; //得到登录的用户名
string staff_Id = "00000003";
ViewState["Satff_Id"] = staff_Id;
// string Role = Config.LoginRole.ToString(); //得到登录角色
// string selectRole = db.GetDataScalar("SELECT Name FROM SSysRole WHERE (Role_Id = '" + Role + "')"); //根据传来的角色ID得到角色的名称
string selectRole = "";
if (!this.IsPostBack)
{
if (Request.QueryString["Tel_ID"] == null || Request.QueryString["Tel_ID"].ToString() == "") //编码
{
Tel_ID = ""; //
}
else
{
Tel_ID = Request.QueryString["Tel_ID"].ToString();
}
ControlDataBind drp = new ControlDataBind(ConfigurationManager.ConnectionStrings["OA"].ToString());
drp.DropDownListBind(dropTelNotion, "SSFugleideaConfig", "IdeaContent", "IdeaID", 1, "", staff_Id);
drp.DropDownListBind(drpInceptMode, "SOrdInceptFashion", "FashionName", "FashionID", 1, "", staff_Id);
}
if (Tel_ID == "")
{
if (this.lblTel_ID.Text == "")
{
#region 编辑电话编号为空，就是首次登记的时候
//获取今天的年+月+日
string Day = System.DateTime.Today.Year.ToString() + System.DateTime.Today.Month.ToString() +
System.DateTime.Today.Day.ToString();
//查找出数据库中该天电话记录的最大的编号
string Sql = "select top 1 Tel_ID from STelEnrol where Tel_ID like '" + Day + "%' order by Tel_ID desc";
try
{
Day = db.GetDataScalar(Sql); //得到最大的ID
Tel_ID = Convert.ToString(Convert.ToInt32(Day) + 1); //在最大ID的基础上加1,确定本次勤务的编号，该编号贯彻真个程序
}
catch //报错说明查不到值
{
Tel_ID = Convert.ToString(Convert.ToInt32(Day) + "001");
}
PanelVisibleFalse(); //设置全部模板不可见
this.panelDJ.Visible = true; //登记
this.panelAN.Visible = true; //按钮
//电话登记的时候往流程表里写一条记录
string Number = Guid.NewGuid().ToString(); //该步骤编号,要在保存里用到
ViewState["Number"] = Number; //保存住这个值，在功能保存中要用到
ViewState["PFunction"] = "1"; //新建的勤务默认为电话登记功能
string SY = "insert into STelFlow(TelFlow_Guid,Tel_ID,Number,PFunction,PExecute,CreatedBy,CreatedDate,OperateStep) " +
" values('" + Number + "','" + Tel_ID + "','" + Number + "',1,'" + staff_Id + "','" + staff_Id + "',getdate(),1)"; //Insert语句
try
{
db.executeInsert(SY);
}
catch
{
}
#endregion
}
lblTel_ID.Text = Tel_ID; //显示勤务编号
}
else
{
#region 勤务编号不为空
//不显示勤务编号说明虽然不是新建的勤务，但是是第一次打开该勤务单
//用来控制显示的页面
if (this.lblTel_ID.Text == "")
{
string Number = Guid.NewGuid().ToString(); //该步骤编号,要在保存里用到
ViewState["Number"] = Number; //保存住这个值，在功能保存中要用到
PanelVisibleFalse(); //所有panel不可见
EditPanel(); //其他人员操作调用方法
if (selectRole != "办公室" || (ViewState["XS"] != null && ViewState["XS"].ToString() == "TRUE")) //如果角色是办公室或者办公室还没有对来电记录进行审批
{
panelXS.Visible = true; //用来显示的panel可见
XSTable(); //设置上面显示的table//只显示到下送过的，如果保存没有下送的不显示
}
}
lblTel_ID.Text = Tel_ID; //显示勤务编号
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
txtCreatedBy.Text = ""; //从登录得到用户名
txtCreatedBy.Enabled = false;
txtTaskName.Enabled = false; //勤务名称不能修改
ControlDataBind drp = new ControlDataBind(ConfigurationManager.ConnectionStrings["OA"].ToString());
drp.DropDownListBind(drpGuardSpec, "SOrdSpec", "SpecName", "SpecID", 1, "", txtCreatedBy.Text.Trim());
drp.DropDownListBind(drpOrder_ID, "SOrdEstate", "Order_ID", "Order_ID", 4, "StatusId = 4", txtCreatedBy.Text.Trim()); //完结状态的勤务
lblEnregisterTime.Text = System.DateTime.Now.Year.ToString() + "-" + System.DateTime.Now.Month.ToString() +
"-" + System.DateTime.Now.Day.ToString(); //得到当前的时间
if (Request.QueryString["Order_ID"] == null || Request.QueryString["Order_ID"].ToString() == "") //勤务编号
{
ViewState["State"] = "Insert";
}
else
{
string Order_ID = Request.QueryString["Order_ID"].ToString();
ViewState["Order_ID"] = Order_ID;
ViewState["State"] = "Update";
string selectSql = " SELECT [Order_ID],[EnregisterTime],[GuardSpec],[DayNumber],[ArrivalTime],[FromArea],[RiteVehicle]," +
" [ArrivalArea],[ArrivalTimeTwo],[FromAreaTwo],[RiteVehicleTwo],[ArrivalAreaTwo],[ReceiveArea],[AccompanyFugle],[MoveDate], " +
" [AccompanyPeo],[GuardCuston],[Principal],[Roster],[Perform],[Remark],[CreatedBy],[CreatedDate],[ModifiedBy],[ModifiedDate]," +
" [StatusId] FROM SOrdNWBenregister where Order_ID = '" + Order_ID + "'";
DataRow selectRow = db.GetDataRow(selectSql);
ViewState["Order_ID"] = selectRow[0];
drpOrder_ID.SelectedValue = selectRow[0].ToString(); //勤务编号
drpOrder_ID.Enabled = false;
this.lblEnregisterTime.Text = selectRow[1].ToString(); //登记时间
drpGuardSpec.SelectedValue = selectRow[2].ToString(); ///警卫规格
if (drpOrder_ID.SelectedValue != "0") //勤务名称
{
string Sql = "select Order_Name from SOrdEstate where Order_ID = '" + selectRow[0].ToString() + "'";
try
{
string Order_Name = db.GetDataScalar(Sql);
txtTaskName.Text = Order_Name;
}
catch { }
}
txtDayNumber.Text = selectRow[3].ToString(); ///警卫规格
txtArrivalTime1.Text = GetDate(selectRow[4].ToString()); //得到日期
drpArrivalTime2.SelectedValue = GetHour(selectRow[4].ToString()); //时
txtFromArea.Text = selectRow[5].ToString(); // 自
txtRiteVehicle.Text = selectRow[6].ToString(); // 乘
txtArrivalArea.Text = selectRow[7].ToString(); // 抵
txtArrivalTimeTwo1.Text = GetDate(selectRow[8].ToString()); //得到日期
drpArrivalTimeTwo2.SelectedValue = GetHour(selectRow[8].ToString()); //时
txtFromAreaTwo.Text = selectRow[9].ToString(); // 自
txtRiteVehicleTwo.Text = selectRow[10].ToString(); // 乘
txtArrivalAreaTwo.Text = selectRow[11].ToString(); // 抵
txtReceiveArea.Text = selectRow[12].ToString(); // 接待单位：
txtAccompanyFugle.Text = selectRow[13].ToString(); // 省陪同领导：
txtMoveDate.Text = selectRow[14].ToString(); // 活动日程：
txtAccompanyPeo.Text = selectRow[15].ToString(); // 随行人员(姓名/职务)：
txtGuardCuston.Text = selectRow[16].ToString(); // 警卫对象生活习惯：
txtPrincipal.Text = selectRow[17].ToString(); // 负责人：
txtRoster.Text = selectRow[18].ToString(); // 值勤人员：
txtPerform.Text = selectRow[19].ToString(); // 情况
txtRemark.Text = selectRow[20].ToString(); // 备注
}
}
}
public void btnLast(DataGrid DGrid, DataSet ds, Button btnFirst, Button btnPrevious, Button btnNext, Button btnLast, Label message, string Str, Label totalPage, string SessionID)
{
ControlDataBind.btnLast(DGrid, Sds, btnFirst, btnPrevious, btnNext, btnLast, message, Str, totalPage, SessionID);
}
protected void Page_Load(object sender, EventArgs e)
{
Config Config = (Config)Session["Config"];
string staff_Id = Config.Staff.Staff_Id; //得到登录的用户名
// string staff_Id = "";
string Order_ID = "";
string type = "";
string OrderArrange_Guid = "";
ViewState["Satff_Id"] = staff_Id;
if (Request.QueryString["Order_ID"] == null || Request.QueryString["Order_ID"].ToString() == "") //编码
{
Response.Redirect("error2.htm");
}
else
{
Order_ID = Request.QueryString["Order_ID"].ToString();
ViewState["Order_ID"] = Order_ID;
}
if (Request.QueryString["type"] == null || Request.QueryString["type"].ToString() == "") //状态 新建:1 修改:2
{
Response.Redirect("error2.htm");
}
else
{
type = Request.QueryString["type"].ToString();
ViewState["type"] = type;
}
//子勤务编号
if (Request.QueryString["OrderArrange_Guid"] == null || Request.QueryString["OrderArrange_Guid"].ToString() == "")
{
OrderArrange_Guid = "";
}
else
{
OrderArrange_Guid = Request.QueryString["OrderArrange_Guid"].ToString();
ViewState["OrderArrange_Guid"] = OrderArrange_Guid;
}
if (!this.IsPostBack)
{
ControlDataBind drp = new ControlDataBind(ConfigurationManager.ConnectionStrings["OA"].ToString());
drp.DropDownListBind(dropOrderNotion, "SSFugleideaConfig", "IdeaContent", "IdeaID", 1, "", staff_Id);
if (OrderArrange_Guid == "") //新增的情况
{
//权限验证
ButtonVisible();
Panelvisible();
this.panelAP.Visible = true;
this.panelAP1.Visible = true;
this.panelAN.Visible = true;
ViewState["state"] = "AP";
btnZCompere.Attributes.Add("onclick", "PopWindow1();");
btnFCompere.Attributes.Add("onclick", "PopWindow2();");
btnPrincipal.Attributes.Add("onclick", "PopWindow3();");
btnXGMan.Attributes.Add("onclick", "PopWindow4();");
}
else if (OrderArrange_Guid != "") //不是新增的情况下 有可能是领导批示／有可能是公文编写等功能
{
if (db.GetDataScalar("select Count(*) from SZOrdAuditing where Order_ID = '" +
Order_ID + "' and OrderArrange_Guid = '" + OrderArrange_Guid + "'") == "0") //查不到记录说明是勤务安排的修改阶段
{
//权限验证 得到第一次填写的人
string CreatedBy = db.GetDataScalar("select CreatedBy from SOrdCArrange where Order_ID = '" + Order_ID + "' and OrderArrange_Guid = '" + OrderArrange_Guid + "'");
if (CreatedBy != staff_Id)
{
ButtonVisible(); //如果没有权限修改，就只能看
Panelvisible();
this.panelXS.Visible = true;
XSAP(OrderArrange_Guid);
XSAP2(OrderArrange_Guid);
}
else
{
ButtonVisible();
Panelvisible();
ViewState["state"] = "EditAP";
this.panelAP.Visible = true;
this.panelAP1.Visible = true;
this.panelAN.Visible = true;
XGEditAP(OrderArrange_Guid);
XSAP2Edit(OrderArrange_Guid);
btnZCompere.Attributes.Add("onclick", "PopWindow1();");
btnFCompere.Attributes.Add("onclick", "PopWindow2();");
btnPrincipal.Attributes.Add("onclick", "PopWindow3();");
btnXGMan.Attributes.Add("onclick", "PopWindow4();");
}
}
else
{
string StrZOrdAuditing = "select PerNumber,OrderNotion,IsPer,StatusId,Per from SZOrdAuditing where Order_ID = '" +
Order_ID + "' and OrderArrange_Guid = '" + OrderArrange_Guid + "'"; //勤务审批信息
try
{
DataRow ZOrdAuditingRow = db.GetDataRow(StrZOrdAuditing);
string PerNumber = ZOrdAuditingRow[0].ToString();
string OrderNotion = ZOrdAuditingRow[1].ToString();
string IsPer = ZOrdAuditingRow[2].ToString();
string StatusId = ZOrdAuditingRow[3].ToString();
string Per = ZOrdAuditingRow[4].ToString();
if ((PerNumber != "" || PerNumber != null) && StatusId == "0") //审批后修改审批内容的状态
{
//权限验证 得到第一次填写的人
string CreatedBy = db.GetDataScalar("select CreatedBy from SZOrdAuditing where Order_ID = '" + Order_ID + "' and OrderArrange_Guid = '" + OrderArrange_Guid + "'");
if (CreatedBy != staff_Id)
{
ButtonVisible(); //如果没有权限修改，就只能看
Panelvisible();
this.panelXS.Visible = true;
XSAP(OrderArrange_Guid);
XSAP2(OrderArrange_Guid);
}
else
{
ViewState["state"] = "EditSP";
ButtonVisible();
Panelvisible();
XSAP(OrderArrange_Guid);
XSAP2(OrderArrange_Guid);
XGEditPS(OrderArrange_Guid);
this.panelPS.Visible = true;
this.panelAN.Visible = true;
this.panelXS.Visible = true;
this.btnSave.Visible = false;
this.Button5.Visible = false;
}
}
else if (PerNumber == "" || PerNumber == null) // 第一次审批
{
//用当前登陆的用户名去上步指定人中去查询，能查到，说名指定了
string CreatBy = "select Count(*) from SZOrdAuditing left join SOrdArrangeMan on SZOrdAuditing.Per = SOrdArrangeMan.Guid where " +
" Man = '" + ViewState["Satff_Id"].ToString() + "' and Order_ID = '" + Order_ID + "' and OrderArrange_Guid = '" + OrderArrange_Guid + "'";
if (db.GetDataScalar(CreatBy) == "0")
{
ButtonVisible(); //如果没有权限修改，就只能看勤务安排的内容
Panelvisible();
this.panelXS.Visible = true;
XSAP(OrderArrange_Guid);
XSAP2(OrderArrange_Guid);
}
else
{
ViewState["state"] = "SP";
ButtonVisible();
Panelvisible();
XSAP(OrderArrange_Guid);
XSAP2(OrderArrange_Guid);
this.panelPS.Visible = true;
this.panelAN.Visible = true;
this.panelXS.Visible = true;
this.btnSave.Visible = false;
this.Button5.Visible = false;
}
}
else if ((PerNumber != "" || PerNumber != null) && StatusId == "1") // 审批并且下送后
{
ViewState["state"] = "Write";
Panelvisible();
XSAP(OrderArrange_Guid);
XSAP2(OrderArrange_Guid);
XSPS(OrderArrange_Guid);
XSAP2Edit(OrderArrange_Guid);
this.panelXS.Visible = true;
this.panelAP1.Visible = true;
this.btnSave.Visible = false;
}
}
catch
{
}
}
}
}
txtZCompere.Value = hfStaffId1.Value.TrimEnd(',');
txtFCompere.Value = hfStaffId2.Value.TrimEnd(',');
txtPrincipal.Value = hfStaffId3.Value.TrimEnd(',');
txtXGMan.Value = hfStaffId4.Value.TrimEnd(',');
}
public ArticleAddRule(string ConnetionString)
{
ConnStr = ConnetionString;
db = new MDataBase(ConnStr);
ControlDBind = new ControlDataBind(ConnStr);
}
