/// <summary>
/// 把未读的条目直接改为已阅
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Btn_YY_Click(object sender, EventArgs e)
{
//得到button传递的值，拆分成数组
string _str = ((Button)sender).CommandArgument.ToString();
string[] _str_arr = _str.Split(',');
string _id = _str_arr[0].ToString();
string _CardName = _str_arr[1].ToString();
//调用已有的对象
Model.Cash_Message mCash_Message = new Dianda.Model.Cash_Message();
BLL.Cash_Message bCash_Message = new Dianda.BLL.Cash_Message();
try
{
mCash_Message = new Dianda.Model.Cash_Message();
mCash_Message = bCash_Message.GetModel(Int32.Parse(_id));
mCash_Message.IsRead = 1;
mCash_Message.ReadTime = DateTime.Now;
mCash_Message.DoNotes = "";
mCash_Message.DoUserID = ((Model.USER_Users)Session["USER_Users"]).USERNAME;
bCash_Message.Update(mCash_Message);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
bsyslog.addlogs(((Model.USER_Users)Session["USER_Users"]).REALNAME + "(" + ((Model.USER_Users)Session["USER_Users"]).USERNAME + ")", "阅读了" + _CardName, "确定阅读" + _CardName + ":已阅");
Read_data();
}
catch
{
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Dianda.Model.Cash_Message model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Cash_Message set ");
strSql.Append("CardName=@CardName,");
strSql.Append("CardholderID=@CardholderID,");
strSql.Append("DepartmentID=@DepartmentID,");
strSql.Append("ProjectID=@ProjectID,");
strSql.Append("LimitNums=@LimitNums,");
strSql.Append("ApproverIDs=@ApproverIDs,");
strSql.Append("DATETIME=@DATETIME,");
strSql.Append("SendUserID=@SendUserID,");
strSql.Append("Notes=@Notes,");
strSql.Append("IsRead=@IsRead,");
strSql.Append("ReadTime=@ReadTime,");
strSql.Append("DoNotes=@DoNotes,");
strSql.Append("DoUserID=@DoUserID,");
strSql.Append("Status=@Status,");
strSql.Append("SFOrderID=@SFOrderID");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@CardName", SqlDbType.VarChar, 100),
new SqlParameter("@CardholderID", SqlDbType.VarChar, 50),
new SqlParameter("@DepartmentID", SqlDbType.VarChar, 50),
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@LimitNums", SqlDbType.Float, 8),
new SqlParameter("@ApproverIDs", SqlDbType.VarChar, 50),
new SqlParameter("@DATETIME", SqlDbType.DateTime),
new SqlParameter("@SendUserID", SqlDbType.VarChar, 50),
new SqlParameter("@Notes", SqlDbType.VarChar, 1000),
new SqlParameter("@IsRead", SqlDbType.Int, 4),
new SqlParameter("@ReadTime", SqlDbType.DateTime),
new SqlParameter("@DoNotes", SqlDbType.VarChar, 1000),
new SqlParameter("@DoUserID", SqlDbType.VarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@SFOrderID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.CardName;
parameters[2].Value = model.CardholderID;
parameters[3].Value = model.DepartmentID;
parameters[4].Value = model.ProjectID;
parameters[5].Value = model.LimitNums;
parameters[6].Value = model.ApproverIDs;
parameters[7].Value = model.DATETIME;
parameters[8].Value = model.SendUserID;
parameters[9].Value = model.Notes;
parameters[10].Value = model.IsRead;
parameters[11].Value = model.ReadTime;
parameters[12].Value = model.DoNotes;
parameters[13].Value = model.DoUserID;
parameters[14].Value = model.Status;
parameters[15].Value = model.SFOrderID;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Dianda.Model.Cash_Message model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Cash_Message(");
strSql.Append("CardName,CardholderID,DepartmentID,ProjectID,LimitNums,ApproverIDs,DATETIME,SendUserID,Notes,IsRead,ReadTime,DoNotes,DoUserID,Status,SFOrderID)");
strSql.Append(" values (");
strSql.Append("@CardName,@CardholderID,@DepartmentID,@ProjectID,@LimitNums,@ApproverIDs,@DATETIME,@SendUserID,@Notes,@IsRead,@ReadTime,@DoNotes,@DoUserID,@Status,@SFOrderID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CardName", SqlDbType.VarChar, 100),
new SqlParameter("@CardholderID", SqlDbType.VarChar, 50),
new SqlParameter("@DepartmentID", SqlDbType.VarChar, 50),
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@LimitNums", SqlDbType.Float, 8),
new SqlParameter("@ApproverIDs", SqlDbType.VarChar, 50),
new SqlParameter("@DATETIME", SqlDbType.DateTime),
new SqlParameter("@SendUserID", SqlDbType.VarChar, 50),
new SqlParameter("@Notes", SqlDbType.VarChar, 1000),
new SqlParameter("@IsRead", SqlDbType.Int, 4),
new SqlParameter("@ReadTime", SqlDbType.DateTime),
new SqlParameter("@DoNotes", SqlDbType.VarChar, 1000),
new SqlParameter("@DoUserID", SqlDbType.VarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@SFOrderID", SqlDbType.Int, 4)
};
parameters[0].Value = model.CardName;
parameters[1].Value = model.CardholderID;
parameters[2].Value = model.DepartmentID;
parameters[3].Value = model.ProjectID;
parameters[4].Value = model.LimitNums;
parameters[5].Value = model.ApproverIDs;
parameters[6].Value = model.DATETIME;
parameters[7].Value = model.SendUserID;
parameters[8].Value = model.Notes;
parameters[9].Value = model.IsRead;
parameters[10].Value = model.ReadTime;
parameters[11].Value = model.DoNotes;
parameters[12].Value = model.DoUserID;
parameters[13].Value = model.Status;
parameters[14].Value = model.SFOrderID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dianda.Model.Cash_Message GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CardName,CardholderID,DepartmentID,ProjectID,LimitNums,ApproverIDs,DATETIME,SendUserID,Notes,IsRead,ReadTime,DoNotes,DoUserID,Status,SFOrderID from Cash_Message ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Dianda.Model.Cash_Message model = new Dianda.Model.Cash_Message();
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());
}
model.CardName = ds.Tables[0].Rows[0]["CardName"].ToString();
model.CardholderID = ds.Tables[0].Rows[0]["CardholderID"].ToString();
model.DepartmentID = ds.Tables[0].Rows[0]["DepartmentID"].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]["LimitNums"].ToString() != "")
{
model.LimitNums = decimal.Parse(ds.Tables[0].Rows[0]["LimitNums"].ToString());
}
model.ApproverIDs = ds.Tables[0].Rows[0]["ApproverIDs"].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.Notes = ds.Tables[0].Rows[0]["Notes"].ToString();
if (ds.Tables[0].Rows[0]["IsRead"].ToString() != "")
{
model.IsRead = int.Parse(ds.Tables[0].Rows[0]["IsRead"].ToString());
}
if (ds.Tables[0].Rows[0]["ReadTime"].ToString() != "")
{
model.ReadTime = DateTime.Parse(ds.Tables[0].Rows[0]["ReadTime"].ToString());
}
model.DoNotes = ds.Tables[0].Rows[0]["DoNotes"].ToString();
model.DoUserID = ds.Tables[0].Rows[0]["DoUserID"].ToString();
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["SFOrderID"].ToString() != "")
{
model.SFOrderID = int.Parse(ds.Tables[0].Rows[0]["SFOrderID"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 点击确定触发事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_sumbit_onclick(object sender, EventArgs e)
{
try
{
//项目ID
string projectid = Request["ID"];
project_model = project_bll.GetModel(int.Parse(projectid.ToString()));
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
string checkvalue = RadioButtonList_Check.SelectedValue.ToString();
string flag = "";
string urls = ""; //接受审核通过和不通过的地址：审核通过，到项目文档中，审核不通过到只做提示
if (checkvalue.Equals("1")) //表示审核通过
{
flag = "审核通过";
//预算表单的审核状态
project_model.TEMP1 = "1";
//如果审核通过将上传的预算表单保存到项目的目录中
string sql = "SELECT ID FROM Document_Folder WHERE (ProjectID = '" + projectid + "') AND (UpID = 38) and delflag='0'";
DataTable dt = pageControl.doSql(sql).Tables[0];
if (dt.Rows.Count > 0)
{
string id = dt.Rows[0]["ID"].ToString();
//如果审核通过将上传的预算表单保存到项目的目录中
if (null != project_model.BudgetList && !(project_model.BudgetList.ToString().Equals("")))
{
setAttachmentsToDocument(user_model.ID, id, project_model.BudgetList.ToString());
}
}
//选择资金卡
DataSet ds1 = cashmessage_bll.GetList(" ProjectID = " + project_model.ID);
DataSet ds2 = card_bll.GetList(" ProjectID = " + project_model.ID);
if (RB_CashCardID.Checked == true)//如果选择的是资金卡则设为资金卡的ID；
{
//如果在资金卡中以前本身就有该项目的。。则要将原来的该项目的资金卡的项目ID设空
if (ds2.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
Model.Cash_Cards card_model1 = new Dianda.Model.Cash_Cards();
BLL.Cash_Cards card_bll1 = new Dianda.BLL.Cash_Cards();
string id = ds2.Tables[0].Rows[i]["ID"].ToString();
card_model1 = card_bll1.GetModel(int.Parse(id));
card_model1.ProjectID = null;
card_bll1.Update(card_model1);
}
}
//资金卡ID
string cashcardid = DDL_CashCardID.SelectedValue.ToString();
card_model = card_bll.GetModel(int.Parse(cashcardid));
//将资金卡表中的项目ID改成当前项目
card_model.ProjectID = int.Parse(projectid);
card_bll.Update(card_model);
}
else//如果选择的是新建资金卡则设为0,并且需要向cash_message表中加一条记录
{
project_model.CashCardID = 0;
//如果原来就有记录,则修改
if (ds1.Tables[0].Rows.Count > 0)
{
//ID
string cashid = ds1.Tables[0].Rows[0]["ID"].ToString();
cashmessage_model = cashmessage_bll.GetModel(int.Parse(cashid));
//资金卡初始金额
cashmessage_model.LimitNums = Convert.ToDecimal(TB_LimitNums.Text);
//新建备注说明
cashmessage_model.Notes = TB_Notes.Text.ToString();
cashmessage_bll.Update(cashmessage_model);
}
else
{
//资金卡名称(暂时写的留空)
cashmessage_model.CardName = "";
//持卡人
cashmessage_model.CardholderID = project_model.SendUserID.ToString();
//项目的ID
cashmessage_model.ProjectID = project_model.ID;
//初始金额
cashmessage_model.LimitNums = Convert.ToDecimal(TB_LimitNums.Text.ToString());
//填写的时间
cashmessage_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString());
//发出这个消息的用户的ID
cashmessage_model.SendUserID = user_model.ID;
//备注说明
cashmessage_model.Notes = TB_Notes.Text.ToString();
//是否已经阅读
cashmessage_model.IsRead = 0;
//消息的状态
cashmessage_model.Status = 1;
Session["Cash_Message_temps"] = cashmessage_model;
//向信息表中添加一条新建资金卡的记录
cashmessage_bll.Add(cashmessage_model);
}
}
BLL.Document_Folder bllFolder = new Dianda.BLL.Document_Folder();
List <Model.Document_Folder> folderlist = bllFolder.GetModelList("UpID='38' and Types='public' and ProjectID='" + projectid + "' and delflag='0'");
if (folderlist.Count > 0)
{
urls = "<a href='/Admin/DocumentManage/manage.aspx?CID=" + folderlist[0].COLUMNSPATH.ToString() + "&tp=1' target='_self' title='预算表单审核：审核时间" + DateTime.Now.ToString() + "'>" + project_model.NAMES.ToString() + " 预算表单 " + flag + "</a>";
}
else
{
urls = project_model.NAMES.ToString() + " 预算表单 " + flag;
}
}
else
{
flag = "审核不通过";
//预算表单的审核状态
project_model.TEMP1 = "2";
urls = project_model.NAMES.ToString() + " 预算表单 " + flag;
}
project_bll.Update(project_model);
//给业务申请者发信息
Model.FaceShowMessage mFaceShowMessage = new Dianda.Model.FaceShowMessage();
BLL.FaceShowMessage bFaceShowMessage = new Dianda.BLL.FaceShowMessage();
mFaceShowMessage.DATETIME = DateTime.Now;
mFaceShowMessage.FromTable = "申请情况";
mFaceShowMessage.IsRead = 0;
mFaceShowMessage.NewsID = null;
mFaceShowMessage.NewsType = "申请情况";
mFaceShowMessage.ReadTime = null;
mFaceShowMessage.DELFLAG = 0;
mFaceShowMessage.ProjectID = project_model.ID;
mFaceShowMessage.Receive = project_model.SendUserID.ToString();//当前项目的创建人的ID
mFaceShowMessage.URLS = urls;
//mFaceShowMessage.URLS = "<a href='/Admin/budgetManage/manage.aspx?role=manager&Status=" + project_model.TEMP1 + "' target='_self' title='预算表单审核：审核时间" + DateTime.Now.ToString() + "'>" + project_model.NAMES.ToString() + " 预算表单 " + flag + "</a>";
bFaceShowMessage.Add(mFaceShowMessage);
//给业务申请者发信息
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入列表页面');javascript:location='manage.aspx?pageindex=" + Request["pageindex"] + "&Status=" + Request["Status"] + "&role=manager';</script>", false);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "预算管理", project_model.NAMES + " 预约表单" + flag);
//添加操作日志
}
catch
{
}
}
/// <summary>
/// 确定事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_sumbit_click(object sender, EventArgs e)
{
try
{
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
string ID = Request["ID"].ToString();
DataTable UserIDdt = new DataTable();
bool TnF = false;
tag.Text = "";
if (RBL_check.SelectedValue == "")
{
tag.Text = "请选择审批权限！";
return;
}
order_model = order_bll.GetModel(int.Parse(ID));
//审核状态,如果审核状态是1，表示当前预算报告是审核通过后，由“预算管理”人员进来重新修改的
//此时修改需要向（财务、秘书、审批过的分管领导（给于同意的）、申请人）发送信息
if (order_model.Status == 1)
{
TnF = true;
string UserIDStr = ""; //用户id字符串
string UserNameStr = ""; //用户名字符串
UserIDStr = order_model.Applyuser; //申请人id
if (!string.IsNullOrEmpty(order_model.TEMP1))
{
UserIDStr += "," + order_model.TEMP1; //上一审批人id
}
string CheckerHistory = order_model.CheckerHistory.TrimStart(';'); //审核的历史记录
string[] CHarr = CheckerHistory.Split(';');
//找出所有审核过的人员
for (int i = 0; i < CHarr.Length; i++)
{
string[] s = CHarr[i].Split(':');
UserNameStr += s[0] + ",";
}
UserNameStr = UserNameStr.TrimEnd(',');
UserIDStr = UserIDStr.Replace(",", "','");
UserNameStr = UserNameStr.Replace(",", "','");
string sql = "select distinct a.id from USER_Users a " +
" left outer join USER_Groups b on a.groups like '%'+b.id+'%' " +
" where (b.tags='普通组' and b.name in ('财务','秘书'))" +
" or a.id in ('" + UserIDStr + "') or a.username in ('" + UserNameStr + "')";
UserIDdt = pageControl.doSql(sql).Tables[0];
}
//室主任审批
if (RBL_check.SelectedValue.Equals("1"))
{
//专项资金
int special;
if (int.TryParse(DDL_SpecialFundsID.SelectedValue.ToString(), out special))
{
order_model.SpecialFundsID = special;
}
//order_model.SpecialFundsID = int.Parse(DDL_SpecialFundsID.SelectedValue.ToString());
//指定经费审批人
order_model.AssignChecker = DDL_AssignChecker.SelectedValue.ToString();
}
//实际确认预算金额
if (tr_BudgetAmount.Visible == true)
{
order_model.ActualAmount = decimal.Parse(TB_ActualAmount.Text.Trim().ToString());
}
//实际确认预算金额单位
order_model.AAUNIT = RB_AAUNIT.SelectedValue.ToString();
if (FileUpload_list.FileName.Length > 2)
{
string[] content = fileup.UpFile_COMMONS(FileUpload_list, "/AllFileUp/fileup", "");
//1-成功；0-失败；2-类型不支持；3-大小不符合;文件的路径；文件名称；文件类型；图标；大小；操作结果
if (content[0] == "0")
{
tag.Text = "文件上传失败，请重新上传！";
return;
}
else if (content[0] == "2")
{
tag.Text = "系统不允许此类文件上传,文件上传失败，请重新上传！";
return;
}
else if (content[0] == "3")
{
tag.Text = "文件上传大小不符合，文件上传失败，请重新上传！";
return;
}
//备注信息
order_model.Note = order_model.Note + "<br>" + user_model.REALNAME + " " + DateTime.Now + "上传预算报告：<a href='" + content[1].ToString() + "' target='_blank'>" + FileUpload_list.FileName.ToString() + "</a><br>";
order_model.BudgetList = content[1];
}
string check = ""; //审核结果
if (RBL_check.SelectedIndex == 0)
{
if (RBL_Checker.SelectedValue == "0")
{
check = "3"; //如果是分管领导审核通过 那么把状态 status改为 3 （分管领导审核通过） 陈雨 2012年7月20日12:31:34
}
else if (RBL_Checker.SelectedValue == "2")
{
check = "23";
}
}
else
{
check = RBL_Checker.SelectedValue.ToString();
}
order_model.Status = int.Parse(check);
string checkvalue = RBL_Checker.SelectedItem.Text.ToString();
if (check.Equals("3"))//表示需要继续审核
{
//如果有一下审批人，那么则要将原来的审批人变成上一审批人存储起来，因为需要发送信息
order_model.TEMP1 = order_model.Checker;
//下一审核人
order_model.Checker = DDL_Checker.SelectedValue.ToString();
//如果是继续审核则显示指定的下一审批人
checkvalue = checkvalue + "(" + DDL_Checker.SelectedItem.ToString() + ")";
}
else
{
//预算审批人
order_model.Checker = user_model.ID;
if (check.Equals("1"))//如果是审核通过，需要发送新建资金卡的通知
{
Dianda.Model.Cash_Message cashmessage_model = new Dianda.Model.Cash_Message();
Dianda.BLL.Cash_Message cashmessage_bll = new Dianda.BLL.Cash_Message();
//资金卡名称,加入的就是预算报告
cashmessage_model.CardName = "《" + order_model.NAMES.ToString() + "》的新建资金卡通知！";
//持卡人
cashmessage_model.CardholderID = "";
//项目的ID
cashmessage_model.ProjectID = order_model.ProjectID;
//初始金额
cashmessage_model.LimitNums = (order_model.ActualAmount) * (order_model.AAUNIT.Equals("元") ? 1 : 10000);
//填写的时间
cashmessage_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString());
//发出这个消息的用户的ID
cashmessage_model.SendUserID = user_model.ID;
//备注说明
cashmessage_model.Notes = "预算报告：‘" + order_model.NAMES.ToString() + "’的新建资金卡通知！发送人：" + user_model.REALNAME;
//是否已经阅读
cashmessage_model.IsRead = 0;
//消息的状态
cashmessage_model.Status = 1;
//所属预算报告
cashmessage_model.SFOrderID = order_model.ID;
Session["Cash_Message_temps"] = cashmessage_model;
//向信息表中添加一条新建资金卡的记录
cashmessage_bll.Add(cashmessage_model);
}
else//如果是不通过并且有上一审批人，就要把审批人改回成上一审批人
{
if (null != order_model.TEMP1 && !order_model.TEMP1.Equals(""))//说明有上一审批人，则退回到上一审批人
{
order_model.Checker = order_model.TEMP1;
}
}
}
//历史审核结果
order_model.CheckerHistory = order_model.CheckerHistory + ";" + user_model.USERNAME.ToString() + ":" + checkvalue;
//审核时间
order_model.CheckTime = DateTime.Now;
//备注信息
order_model.TEMP2 = Overviews.Value.ToString();
//执行审批操作
order_bll.Update(order_model);
/************************给业务申请者发信息***********************/
// 1).首先给预算申请者发送信息
Model.FaceShowMessage mFaceShowMessage = new Dianda.Model.FaceShowMessage();
BLL.FaceShowMessage bFaceShowMessage = new Dianda.BLL.FaceShowMessage();
mFaceShowMessage.DATETIME = DateTime.Now;
mFaceShowMessage.FromTable = "预算审批";
mFaceShowMessage.IsRead = 0;
mFaceShowMessage.NewsID = null;
mFaceShowMessage.NewsType = "预算审批";
mFaceShowMessage.ReadTime = null;
mFaceShowMessage.DELFLAG = 0;
mFaceShowMessage.ProjectID = order_model.ProjectID;
if (TnF)
{
mFaceShowMessage.URLS = user_model.REALNAME + "(" + user_model.USERNAME.ToString() + ")修改了已通过审核的预算申请<a href='/Admin/budgetManage/budgetmanage.aspx?role=lister' target='_self' title='编辑时间:" + DateTime.Now + "'> 点击查看</a>";
if (UserIDdt.Rows.Count > 0)
{
foreach (DataRow dr in UserIDdt.Rows)
{
mFaceShowMessage.Receive = dr["id"].ToString();
bFaceShowMessage.Add(mFaceShowMessage);
}
}
}
else
{
//这里接受者应该是这个预算的申请者
mFaceShowMessage.Receive = order_model.Applyuser;//（区别在这里: 接收人不一样）
//这里的URL要带上审批的状态，以便查看时直接进入该状态下的列表中
mFaceShowMessage.URLS = ((Model.USER_Users)Session["USER_Users"]).REALNAME + "(" + ((Model.USER_Users)Session["USER_Users"]).USERNAME.ToString() + ")审批了您的预算申请<a href='/Admin/budgetManage/budgetmanage.aspx?Status=" + order_model.Status.ToString() + "' target='_self' title='审批时间:" + DateTime.Now + "'> 点击查看</a>";
bFaceShowMessage.Add(mFaceShowMessage);
// 2).如果有下一审核人则要给下一审核人发送信息
if (check.Equals("0"))//表示需要继续审核
{
//这里接受者应该是选择的下一审批人
mFaceShowMessage.Receive = order_model.Checker;//（区别在这里: 接收人不一样）
//这里的URL要带上审批的状态，以便查看时直接进入该状态下的列表中，并且指定的下一审核人肯定是领导权限的，也就是有审核权限的，所以需要带上role
mFaceShowMessage.URLS = ((Model.USER_Users)Session["USER_Users"]).REALNAME + "(" + ((Model.USER_Users)Session["USER_Users"]).USERNAME.ToString() + ")给您发送预算审批<a href='/Admin/budgetManage/budgetmanage.aspx?Status=" + order_model.Status.ToString() + "&role=manager' target='_self' title='发送时间:" + DateTime.Now + "'> 点击处理</a>";
bFaceShowMessage.Add(mFaceShowMessage);
// 3).如果有下一审核人则要给上一审核人发送信息
//这里接受者应该是选择的上一审批人
mFaceShowMessage.Receive = order_model.TEMP1;//（区别在这里: 接收人不一样,TEMP1暂存了上一审批人）
//这里的URL要带上审批的状态，以便查看时直接进入该状态下的列表中，并且指定的下一审核人肯定是领导权限的，也就是有审核权限的，所以需要带上role
mFaceShowMessage.URLS = ((Model.USER_Users)Session["USER_Users"]).REALNAME + "(" + ((Model.USER_Users)Session["USER_Users"]).USERNAME.ToString() + ")审批了您发送的预算报告<a href='/Admin/budgetManage/budgetmanage.aspx?Status=" + order_model.Status.ToString() + "&role=manager' target='_self' title='审批时间:" + DateTime.Now + "'> 点击查看</a>";
bFaceShowMessage.Add(mFaceShowMessage);
}
// 4).如果有没有下一审核人并且审核通过，需要给指定经费审核人发送信息
if (check.Equals("1"))//表示需要审核通过
{
//这里接受者应该是选择的下一审批人
mFaceShowMessage.Receive = order_model.AssignChecker;//（区别在这里: 接收人不一样）
//这里的URL要带上审批的状态，以便查看时直接进入该状态下的列表中
mFaceShowMessage.URLS = ((Model.USER_Users)Session["USER_Users"]).REALNAME + "(" + ((Model.USER_Users)Session["USER_Users"]).USERNAME.ToString() + ")将您指定为 " + order_model.NAMES + " 的经费审批人<a href='/Admin/budgetManage/budgetmanage.aspx?Status=" + order_model.Status.ToString() + "&role=lister' target='_self' title='指定时间:" + DateTime.Now + "'> 点击查看</a>";
bFaceShowMessage.Add(mFaceShowMessage);
}
// 5).如果审核不通过，需要给指定经费审核人发送信息
if (check.Equals("2"))//表示需要审核不通过
{
//这里返回给创建人
mFaceShowMessage.Receive = order_model.Applyuser;
//这里的URL要带上审批的状态，以便查看时直接进入该状态下的列表中
mFaceShowMessage.URLS = ((Model.USER_Users)Session["USER_Users"]).REALNAME + "(" + ((Model.USER_Users)Session["USER_Users"]).USERNAME.ToString() + ")将您的申请预算 " + order_model.NAMES + " 审核不通过<a href='/Admin/budgetManage/budgetmanage.aspx?Status=2' target='_self' title='退回时间:" + DateTime.Now + "'> 点击查看</a>";
bFaceShowMessage.Add(mFaceShowMessage);
}
/************************给业务申请者发信息************************/
}
string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"budgetmanage.aspx?pageindex=" + Request["pageindex"] + "&Status=" + Request["Status"].ToString() + "&role=" + Request["role"].ToString() + "\";</script>";
Response.Write(coutws);
}
catch
{
}
}
