protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request["ID"] != null)
{
apply_model = apply_bll.GetModel(int.Parse(com.SafeString(Request["ID"])));
if (apply_model.Status != 0)
{
ListItem ls = new ListItem();
ls.Value = "2";
ls.Text = "已撤销";
RadioButtonList_Check.Items.Add(ls);
Button_sumbit.Visible = true;
}
}
//业务申请ID
string ID = Request["ID"];
ShowApplyInfo(ID);
//设置模板页中的管理值
(Master.FindControl("Label_navigation") as Label).Text = "管理 > 会议室管理 > 会议室审批 ";
//设置模板页中的管理值
}
}
/// <summary>
/// 点击撤销按钮触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_revoke_onclick(object sender, EventArgs e)
{
int num = 0;
int rows = GridView1.Rows.Count;
if (rows > 0)
{
for (int i = 0; i < rows; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox_choose");
if (cb.Checked)
{
num = num + 1;
}
}
if (num == 0)
{
tag.Text = "撤销时最少选择一条数据！";
}
else
{
tag.Text = "";
for (int j = 0; j < rows; j++)
{
CheckBox cb1 = (CheckBox)GridView1.Rows[j].Cells[0].FindControl("CheckBox_choose");
HiddenField hid = (HiddenField)GridView1.Rows[j].Cells[0].FindControl("Hid_ID");
if (cb1.Checked && cb1.Enabled)
{
//获取业务的基本信息
apply_model = apply_bll.GetModel(int.Parse(hid.Value.ToString()));
//将删除标记设为1
//apply_model.DELFLAG = 1;
//将状态调为不通过
apply_model.Status = 2;
//申请类型
string applytype = apply_model.AppType;
string tablename = "";
string typeflag = "";
if (applytype.Equals("orderFood"))
{
tablename = "Project_Apply_orderFood";
typeflag = "订饭申请";
}
else if (applytype.Equals("orderCar"))
{
tablename = "Project_Apply_orderCar";
typeflag = "订车申请";
}
else if (applytype.Equals("orderRoom"))
{
tablename = "Project_Apply_orderRoom";
typeflag = "订会议室申请";
}
else if (applytype.Equals("orderSignet"))
{
tablename = "Project_Apply_signet";
typeflag = "印章申请";
}
// string sql = " DELETE FROM " + tablename + " WHERE ApplyID = " + hid.Value.ToString();
apply_bll.Update(apply_model);
// pageControl.doSql(sql);
//添加操作日志
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
Dianda.Model.Project_Projects project_model = new Dianda.Model.Project_Projects();
Dianda.BLL.Project_Projects project_bll = new Dianda.BLL.Project_Projects();
project_model = project_bll.GetModel(Convert.ToInt16(Session["Work_ProjectId"]));
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "业务申请撤销", project_model.NAMES + "项目" + typeflag + "撤销:成功！");
//添加操作日志
}
}
//string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manage.aspx?pageindex=" + pageindexHidden.Value.ToString() + "&status=" + DDL_status.SelectedValue.ToString() + "\";</script>";
//Response.Write(coutws);
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入我的项目页面');javascript:location='manage.aspx?pageindex=" + pageindexHidden.Value.ToString() + "&type=" + DDL_type.SelectedValue + "&status=" + DDL_status.SelectedValue.ToString() + "';</script>", false);
}
}
}
/// <summary>
/// 点击确定触发事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_sumbit_onclick(object sender, EventArgs e)
{
try
{
DateTime now = DateTime.Now;
string flag = "已挂起";
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
//业务申请ID
string ID = Request["ID"];
apply_model = apply_bll.GetModel(int.Parse(ID));
//审批人员
apply_model.DoUserID = user_model.ID;
//审批时间
apply_model.ReadTime = now;
//审批意见
apply_model.DoNote = TB_DoNote.Text.ToString();
//审批结果
string Status = RadioButtonList_Check.SelectedValue;
if (Status.Equals("1"))
{
flag = "已确认";
}
apply_model.Status = int.Parse(Status);
apply_bll.Update(apply_model);
//给业务申请者发信息
Model.FaceShowMessage mFaceShowMessage = new Dianda.Model.FaceShowMessage();
BLL.FaceShowMessage bFaceShowMessage = new Dianda.BLL.FaceShowMessage();
mFaceShowMessage.DATETIME = now;
mFaceShowMessage.FromTable = "申请情况";
mFaceShowMessage.IsRead = 0;
mFaceShowMessage.NewsID = null;
mFaceShowMessage.NewsType = "申请情况";
mFaceShowMessage.ReadTime = null;
mFaceShowMessage.Receive = apply_model.SendUserID.ToString();
// mFaceShowMessage.URLS = user_model.REALNAME.ToString() + "(" + user_model.USERNAME.ToString() + ")审批了您[" + Session["ProjectNames"] + "]项目的会议室申请！<a href='/Admin/personalProjectManage/OAapply/show.aspx?ID=" + apply_model.ID + "' target='_self' rel='gb_page_center[726,400]' title='查看会议室申请情况'>点击查看</a>";
mFaceShowMessage.URLS = "<a href=\"javascript:window.showModalDialog('/Admin/personalProjectManage/OAapply/show.aspx?ID=" + apply_model.ID + "','','dialogWidth=726px;dialogHeight=400px');\" title='会议室预定审核'>" + Session["RoomName"] + "的预约" + flag + "</a> " + Session["Room_ApplyUserName"];
mFaceShowMessage.DELFLAG = 0;
mFaceShowMessage.ProjectID = apply_model.ProjectID;
bFaceShowMessage.Add(mFaceShowMessage);
//给业务申请者发信息
string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manage.aspx?pageindex=" + Request["pageindex"] + "&Status=" + Request["Status"] + "\";</script>";
Response.Write(coutws);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "申请管理", "会议室申请审核" + flag + "：成功！");
//添加操作日志
}
catch
{
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Dianda.Model.Project_Apply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Project_Apply(");
strSql.Append("ProjectID,DELFLAG,Status,AppType,Overviews,DATETIME,SendUserID,DepartmentID,ReadTime,DoUserID,CheckNote,TelNum,DoNote,Attachments,ApplyUserID,TEMP1,TEMP2,TEMP3,TEMP4)");
strSql.Append(" values (");
strSql.Append("@ProjectID,@DELFLAG,@Status,@AppType,@Overviews,@DATETIME,@SendUserID,@DepartmentID,@ReadTime,@DoUserID,@CheckNote,@TelNum,@DoNote,@Attachments,@ApplyUserID,@TEMP1,@TEMP2,@TEMP3,@TEMP4)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@DELFLAG", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@AppType", SqlDbType.VarChar, 50),
new SqlParameter("@Overviews", SqlDbType.Text),
new SqlParameter("@DATETIME", SqlDbType.DateTime),
new SqlParameter("@SendUserID", SqlDbType.VarChar, 50),
new SqlParameter("@DepartmentID", SqlDbType.VarChar, 150),
new SqlParameter("@ReadTime", SqlDbType.DateTime),
new SqlParameter("@DoUserID", SqlDbType.VarChar, 50),
new SqlParameter("@CheckNote", SqlDbType.Text),
new SqlParameter("@TelNum", SqlDbType.VarChar, 50),
new SqlParameter("@DoNote", SqlDbType.VarChar, 5000),
new SqlParameter("@Attachments", SqlDbType.VarChar, 200),
new SqlParameter("@ApplyUserID", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP1", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP2", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP3", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP4", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ProjectID;
parameters[1].Value = model.DELFLAG;
parameters[2].Value = model.Status;
parameters[3].Value = model.AppType;
parameters[4].Value = model.Overviews;
parameters[5].Value = model.DATETIME;
parameters[6].Value = model.SendUserID;
parameters[7].Value = model.DepartmentID;
parameters[8].Value = model.ReadTime;
parameters[9].Value = model.DoUserID;
parameters[10].Value = model.CheckNote;
parameters[11].Value = model.TelNum;
parameters[12].Value = model.DoNote;
parameters[13].Value = model.Attachments;
parameters[14].Value = model.ApplyUserID;
parameters[15].Value = model.TEMP1;
parameters[16].Value = model.TEMP2;
parameters[17].Value = model.TEMP3;
parameters[18].Value = model.TEMP4;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dianda.Model.Project_Apply GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ProjectID,DELFLAG,Status,AppType,Overviews,DATETIME,SendUserID,DepartmentID,ReadTime,DoUserID,CheckNote,TelNum,DoNote,Attachments,ApplyUserID,TEMP1,TEMP2,TEMP3,TEMP4 from Project_Apply ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Dianda.Model.Project_Apply model = new Dianda.Model.Project_Apply();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProjectID"].ToString() != "")
{
model.ProjectID = int.Parse(ds.Tables[0].Rows[0]["ProjectID"].ToString());
}
if (ds.Tables[0].Rows[0]["DELFLAG"].ToString() != "")
{
model.DELFLAG = int.Parse(ds.Tables[0].Rows[0]["DELFLAG"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
model.AppType = ds.Tables[0].Rows[0]["AppType"].ToString();
model.Overviews = ds.Tables[0].Rows[0]["Overviews"].ToString();
if (ds.Tables[0].Rows[0]["DATETIME"].ToString() != "")
{
model.DATETIME = DateTime.Parse(ds.Tables[0].Rows[0]["DATETIME"].ToString());
}
model.SendUserID = ds.Tables[0].Rows[0]["SendUserID"].ToString();
model.DepartmentID = ds.Tables[0].Rows[0]["DepartmentID"].ToString();
if (ds.Tables[0].Rows[0]["ReadTime"].ToString() != "")
{
model.ReadTime = DateTime.Parse(ds.Tables[0].Rows[0]["ReadTime"].ToString());
}
model.DoUserID = ds.Tables[0].Rows[0]["DoUserID"].ToString();
model.CheckNote = ds.Tables[0].Rows[0]["CheckNote"].ToString();
model.TelNum = ds.Tables[0].Rows[0]["TelNum"].ToString();
model.DoNote = ds.Tables[0].Rows[0]["DoNote"].ToString();
model.Attachments = ds.Tables[0].Rows[0]["Attachments"].ToString();
model.ApplyUserID = ds.Tables[0].Rows[0]["ApplyUserID"].ToString();
model.TEMP1 = ds.Tables[0].Rows[0]["TEMP1"].ToString();
model.TEMP2 = ds.Tables[0].Rows[0]["TEMP2"].ToString();
model.TEMP3 = ds.Tables[0].Rows[0]["TEMP3"].ToString();
model.TEMP4 = ds.Tables[0].Rows[0]["TEMP4"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Dianda.Model.Project_Apply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Project_Apply set ");
strSql.Append("ProjectID=@ProjectID,");
strSql.Append("DELFLAG=@DELFLAG,");
strSql.Append("Status=@Status,");
strSql.Append("AppType=@AppType,");
strSql.Append("Overviews=@Overviews,");
strSql.Append("DATETIME=@DATETIME,");
strSql.Append("SendUserID=@SendUserID,");
strSql.Append("DepartmentID=@DepartmentID,");
strSql.Append("ReadTime=@ReadTime,");
strSql.Append("DoUserID=@DoUserID,");
strSql.Append("CheckNote=@CheckNote,");
strSql.Append("TelNum=@TelNum,");
strSql.Append("DoNote=@DoNote,");
strSql.Append("Attachments=@Attachments,");
strSql.Append("ApplyUserID=@ApplyUserID,");
strSql.Append("TEMP1=@TEMP1,");
strSql.Append("TEMP2=@TEMP2,");
strSql.Append("TEMP3=@TEMP3,");
strSql.Append("TEMP4=@TEMP4");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@DELFLAG", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@AppType", SqlDbType.VarChar, 50),
new SqlParameter("@Overviews", SqlDbType.Text),
new SqlParameter("@DATETIME", SqlDbType.DateTime),
new SqlParameter("@SendUserID", SqlDbType.VarChar, 50),
new SqlParameter("@DepartmentID", SqlDbType.VarChar, 150),
new SqlParameter("@ReadTime", SqlDbType.DateTime),
new SqlParameter("@DoUserID", SqlDbType.VarChar, 50),
new SqlParameter("@CheckNote", SqlDbType.Text),
new SqlParameter("@TelNum", SqlDbType.VarChar, 50),
new SqlParameter("@DoNote", SqlDbType.VarChar, 5000),
new SqlParameter("@Attachments", SqlDbType.VarChar, 200),
new SqlParameter("@ApplyUserID", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP1", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP2", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP3", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP4", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ProjectID;
parameters[2].Value = model.DELFLAG;
parameters[3].Value = model.Status;
parameters[4].Value = model.AppType;
parameters[5].Value = model.Overviews;
parameters[6].Value = model.DATETIME;
parameters[7].Value = model.SendUserID;
parameters[8].Value = model.DepartmentID;
parameters[9].Value = model.ReadTime;
parameters[10].Value = model.DoUserID;
parameters[11].Value = model.CheckNote;
parameters[12].Value = model.TelNum;
parameters[13].Value = model.DoNote;
parameters[14].Value = model.Attachments;
parameters[15].Value = model.ApplyUserID;
parameters[16].Value = model.TEMP1;
parameters[17].Value = model.TEMP2;
parameters[18].Value = model.TEMP3;
parameters[19].Value = model.TEMP4;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 点击确定触发事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_sumbit_onclick(object sender, EventArgs e)
{
try
{
DateTime now = DateTime.Now;
string flag = "已挂起";
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
//业务申请ID
string ID = Request["ID"];
apply_model = apply_bll.GetModel(int.Parse(ID));
//审批人员
apply_model.DoUserID = user_model.ID;
//审批意见
apply_model.DoNote = TB_DoNote.Text.ToString();
//审批结果
string Status = RadioButtonList_Check.SelectedValue;
if (Status.Equals("4"))
{
flag = "盖章完成";
//执行人
apply_model.TEMP1 = user_model.REALNAME.ToString();
//执行时间
apply_model.TEMP2 = DateTime.Now.ToString();
}
else
{
//审批时间
apply_model.ReadTime = now;
}
if (Status.Equals("1"))
{
flag = "审核通过";
//将此附件上传到项目文档中
if (apply_model.Attachments.ToString().Contains("."))
{
List <Model.Document_Folder> documentfolderlist = bdocumentfolder.GetModelList("Upid='38' and Types='public' and ProjectID='" + apply_model.ProjectID.ToString() + "' and delflag='0'");
if (documentfolderlist.Count > 0)
{
setAttachmentsToDocument(apply_model.SendUserID.ToString(), documentfolderlist[0].ID.ToString(), apply_model.Attachments.ToString());
}
}
}
apply_model.Status = int.Parse(Status);
apply_bll.Update(apply_model);
//给业务申请者发信息
Model.FaceShowMessage mFaceShowMessage = new Dianda.Model.FaceShowMessage();
BLL.FaceShowMessage bFaceShowMessage = new Dianda.BLL.FaceShowMessage();
mFaceShowMessage.DATETIME = now;
mFaceShowMessage.FromTable = "申请情况";
mFaceShowMessage.IsRead = 0;
mFaceShowMessage.NewsID = null;
mFaceShowMessage.NewsType = "申请情况";
mFaceShowMessage.ReadTime = null;
mFaceShowMessage.Receive = apply_model.SendUserID.ToString();
mFaceShowMessage.URLS = "<a href=\"javascript:window.showModalDialog('/Admin/personalProjectManage/OAapply/show.aspx?ID=" + apply_model.ID + "','','dialogWidth=726px;dialogHeight=400px');\" target='_self' title='印章申请审核'>" + Session["SignetName"] + " 数量 " + Session["Signet_Nums"] + " " + flag + "</a> " + Session["Signet_ApplyUserName"];
mFaceShowMessage.DELFLAG = 0;
mFaceShowMessage.ProjectID = apply_model.ProjectID;
bFaceShowMessage.Add(mFaceShowMessage);
//给业务申请者发信息
string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manage.aspx?pageindex=" + Request["pageindex"] + "&Status=" + Request["Status"] + "\";</script>";
Response.Write(coutws);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "申请管理", "用印申请审核" + flag + "：成功！");
//添加操作日志
}
catch
{
}
}
