/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Tunnel.Model.Tunnel_bumf model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@b_id", SqlDbType.BigInt, 8),
new SqlParameter("@b_title", SqlDbType.VarChar, 200),
new SqlParameter("@b_sort", SqlDbType.Int, 4),
new SqlParameter("@b_time", SqlDbType.DateTime),
new SqlParameter("@b_state", SqlDbType.Int, 4),
new SqlParameter("@b_user", SqlDbType.Int, 4),
new SqlParameter("@b_suser", SqlDbType.Int, 4),
new SqlParameter("@b_content", SqlDbType.Text),
new SqlParameter("@b_formcontent", SqlDbType.Text),
new SqlParameter("@b_datefield", SqlDbType.Text),
new SqlParameter("@b_stype", SqlDbType.Int),
new SqlParameter("@b_file", SqlDbType.VarChar, 3000)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.b_title;
parameters[2].Value = model.b_sort;
parameters[3].Value = model.b_time;
parameters[4].Value = model.b_state;
parameters[5].Value = model.b_user;
parameters[6].Value = model.b_suser;
parameters[7].Value = model.b_content;
parameters[8].Value = model.b_formcontent;
parameters[9].Value = model.b_datefield;
parameters[10].Value = model.b_stype;
parameters[11].Value = model.b_file;
DbHelperSQL.RunProcedure("UP_Tunnel_bumf_TitleADD", parameters, out rowsAffected);
return(Convert.ToInt32(parameters[0].Value));
}
/// <summary>
/// 显示当前步骤
/// </summary>
/// <param name="name">步骤名称</param>
/// <param name="id">步骤ID</param>
/// <returns></returns>
public string ShowCurr(string name, string id)
{
//下一步骤ID
string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbid", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
if ("".Equals(currbid))
{
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " order by s_num asc");
}
mts = bts.GetModel(Convert.ToInt32(currbid));
if (mts != null)
{
if (long.Parse(id) == mts.s_id)
{
return("<font color='red'>" + name + "</font>→");
}
else if (Convert.ToInt32(mts.s_id) > Convert.ToInt32(id))
{
return("<font color='green'>" + name + "</font>→");
}
else
{
return(name + "→");
}
}
else
{
return(name + "→");
}
}
void ShowInit()
{
if (!string.IsNullOrEmpty(Request.Params["File_Id"]))
{
try
{
Tunnel.BLL.Tunnel_bumf btb = new Tunnel.BLL.Tunnel_bumf();
Tunnel.Model.Tunnel_bumf mtb = new Tunnel.Model.Tunnel_bumf();
Tunnel.BLL.Tunnel_form tf = new Tunnel.BLL.Tunnel_form();
Tunnel.Model.Tunnel_form mtf = new Tunnel.Model.Tunnel_form();
Tunnel.Common.Form_Class fc = new Tunnel.Common.Form_Class();
Tunnel.BLL.UserLogin ul = new Tunnel.BLL.UserLogin();
mtb = btb.GetModel(Convert.ToInt32(Request.Params["File_Id"]));
formfile = getFile(mtb.b_file);//附件
Label1.Text = mtb.b_title;
Label2.Text = fc.From_Content(mtb.b_formcontent, mtb.b_content, true);//取得替换后的表单数据
ul.UsbnLogin = ul.getUserModel(mtb.b_user);
Label3.Text = "发布人：" + ul.UsbnLogin.m_name + " 发布时间：" + mtb.b_time.ToString();
}
catch
{
Tunnel.Common.Message.back("不正确的ID"); return;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!string.IsNullOrEmpty(Request.Params["delid"]))
{
mb = tb.GetModel(Convert.ToInt32(Request.Params["delid"]));
if ("issure".Equals(Request.Params["mod"]))
{
tmt.Title = mb.b_title;
tmt.TypeId = 5;
tmt.HtmlSource = fc.From_Content(mb.b_formcontent, mb.b_content, true);//取得替换后的表单数据
tmt.UserId = mb.b_user;
Tunnel.BLL.Tunnel_information bllf = new Tunnel.BLL.Tunnel_information();
int relt = -1;
relt = bllf.Add(tmt);
}
tb.Delete(mb.b_id);
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM TUNNEL_EXAM WHERE E_GID=" + mb.b_id);
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM Tunnel_Advice WHERE A_GID=" + mb.b_id);
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM Tunnel_Remind WHERE m_type=1 and m_typeid=" + mb.b_id);
Tunnel.Common.Del_File delfile = new Tunnel.Common.Del_File();
delfile.FileDelete(mb.b_file);
Tunnel.Common.Message.Show("操作成功！", "Other_Manage.aspx");
}
this.ShowInit("");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Tunnel.Model.Tunnel_bumf GetModel(long b_id)
{
SqlParameter[] parameters =
{
new SqlParameter("@b_id", SqlDbType.BigInt)
};
parameters[0].Value = b_id;
Tunnel.Model.Tunnel_bumf model = new Tunnel.Model.Tunnel_bumf();
DataSet ds = DbHelperSQL.RunProcedure("UP_Tunnel_bumf_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["b_id"].ToString() != "")
{
model.b_id = long.Parse(ds.Tables[0].Rows[0]["b_id"].ToString());
}
if (ds.Tables[0].Rows[0]["b_sort"].ToString() != "")
{
model.b_sort = int.Parse(ds.Tables[0].Rows[0]["b_sort"].ToString());
}
if (ds.Tables[0].Rows[0]["b_time"].ToString() != "")
{
model.b_time = DateTime.Parse(ds.Tables[0].Rows[0]["b_time"].ToString());
}
model.b_file = ds.Tables[0].Rows[0]["b_file"].ToString();
if (ds.Tables[0].Rows[0]["b_state"].ToString() != "")
{
model.b_state = int.Parse(ds.Tables[0].Rows[0]["b_state"].ToString());
}
if (ds.Tables[0].Rows[0]["b_user"].ToString() != "")
{
model.b_user = int.Parse(ds.Tables[0].Rows[0]["b_user"].ToString());
}
if (ds.Tables[0].Rows[0]["b_suser"].ToString() != "")
{
model.b_suser = int.Parse(ds.Tables[0].Rows[0]["b_suser"].ToString());
}
else
{
model.b_suser = 0;
}
if (ds.Tables[0].Rows[0]["b_stype"].ToString() != "")
{
model.b_stype = int.Parse(ds.Tables[0].Rows[0]["b_stype"].ToString());
}
model.b_title = ds.Tables[0].Rows[0]["b_title"].ToString();
model.b_content = ds.Tables[0].Rows[0]["b_content"].ToString();
model.b_datefield = ds.Tables[0].Rows[0]["b_datefield"].ToString();
model.b_formcontent = ds.Tables[0].Rows[0]["b_formcontent"].ToString();
return(model);
}
else
{
return(null);
}
}
protected void Button4_Click(object sender, EventArgs e)
{
Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
if (!Tunnel.Data.DESEncrypt.Encrypt(spPassword.Text.Trim()).Equals(tm.m_spassword))
{
Tunnel.Common.Message.back("审批密码错误"); return;
}
else
{
//这里为存储当前步骤
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
mf = bf.GetModel(mtb.b_sort);
if (mtb.b_state == 3)
{
Tunnel.Common.Message.back("此流程己审批结束,请勿重复审批!"); return;
}
else
{
//将当前步骤存入数据库表:Tunnel_exam
Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam();
Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
mte.e_bid = 0;
mte.e_endtime = DateTime.Now;
mte.e_gid = Convert.ToInt32(Request.Params["bid"]);
mte.e_user = ul.LoginID;
mte.e_nextbuser = m_value.Value;
string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
if (!string.IsNullOrEmpty(lastendtime))
{
mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间
}
else
{
mte.e_time = mtb.b_time;
}
mte.e_nextbid = 1;
bte.Add(mte);
string contents = FCKeditor1.Value;
//添加审批意见
if (!string.IsNullOrEmpty(contents))
{
Tunnel.BLL.Tunnel_Advice ta = new Tunnel.BLL.Tunnel_Advice();
Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice();
ma.a_content = contents;
ma.a_bid = Convert.ToInt32(mts.s_id);
ma.a_gid = Convert.ToInt32(mtb.b_id);
ma.a_time = DateTime.Now;
ma.a_user = ul.LoginID;
string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=1024 and a_gid=" + Request.Params["bid"]);
ta.Add(ma);
}
Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=3 WHERE B_ID=" + Request.Params["bid"]); //改变公文状态
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=1 and m_touser="******" and m_typeid=" + mtb.b_id); //删除待办事项
Tunnel.Common.Message.Show("流程结束成功!", "../MyApply/Apply_Sp.aspx");
}
}
}
void Bind()
{
mtb = btb.GetModel(Convert.ToInt32(Request.Params["bid"]));
mf = bf.GetModel(mtb.b_sort);
mtf = tf.GetModel(mf.f_form);
if (mtf == null)
{
Tunnel.Common.Message.back("表单不存在或已删除,请与管理员联系"); return;
}
Label1.Text = fc.From_Content(mtf.f_content, mtb.b_content, false);//取得替换后的表单数据
if (mf.f_isfile.ToString() == "1")
{
isuploads = false;
}
TextBox1.Text = mtb.b_title;
if (mtb.b_suser == 0)
{
RadioButtonList3.SelectedIndex = 0;
isusered = false;
}
else
{
TextBox2.Text = Tunnel.Common.GetValue.getDataValue("Tunnel_menber", "m_name", "m_id=" + mtb.b_suser);
RadioButtonList3.SelectedIndex = 1;
isusered = true;
}
m_value.Value = mtb.b_suser.ToString();
hfile.Value = mtb.b_file;
if (!"".Equals(mtb.b_file))
{
string[] filelist = mtb.b_file.Split(',');
foreach (string list in filelist)
{
string flist = list.Substring(list.LastIndexOf('/') + 1, list.Length - list.LastIndexOf('/') - 1);
hfilelist += "<span><img src=\"../../image/attach.png\">" + flist + "<img style='cursor:hand' onclick=\"del(this,'" + list + "')\" alt='删除附件' src=\"../../image/remove.png\">;</span>";
}
}
if (mf.f_state.ToString() == "0")
{
scontent = "审核→"; issheng = true;
}
else
{
scontent = ""; issheng = false;
}
Repeater1.DataSource = bs.GetList("s_lid=" + mf.f_id);
Repeater1.DataBind();
if (Repeater1.Items.Count <= 0)
{
Label2.Text = "本申请未设置流程,将不能保存!"; HiddenField2.Value = "0"; scontent = "";
}
else
{
Label2.Text = ""; HiddenField2.Value = "1";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
//下一步骤ID
string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + mtb.b_sort + " and s_num=1");
//如果流程没有预设步骤
if ("".Equals(currbid))
{
Tunnel.Common.Message.back("本流程未预设步骤,请与管理员联系!"); return;
}
//将当前步骤存入数据库表:Tunnel_exam
Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam();
Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
mte.e_bid = 0;
mte.e_endtime = DateTime.Now;
mte.e_gid = Convert.ToInt32(mtb.b_id);
mte.e_user = ul.LoginID;
mte.e_time = DateTime.Now;
mte.e_nextbuser = "";
mte.e_nextbid = Convert.ToInt32(currbid);
bte.Add(mte);
if (!string.IsNullOrEmpty(curruser))
{
Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind();
string[] users = curruser.Split(',');
foreach (string user in users)
{
if (!string.IsNullOrEmpty(user))
{
tr.m_title = mtb.b_title + "<font color=red>(待审批)</font>";
tr.m_url = "N_WorkFlow/MyApply/Apply_zSp.aspx?bid=" + mtb.b_id;
tr.m_touser = Convert.ToInt32(user);
tr.m_time = DateTime.Now;
tr.m_type = 1;
tr.m_typeid = Convert.ToInt32(mtb.b_id);
tr.m_bid = Convert.ToInt32(currbid);
tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
tr.m_isread = 0;
long messge = br.Add(tr);
}
}
}
Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=2 WHERE B_ID=" + mtb.b_id); //改变公文状态
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=0 and m_typeid=" + mtb.b_id); //删除待办事项
Tunnel.Common.Message.Show("操作成功,审核通过!", "Apply_SP.aspx");
}
catch
{
Tunnel.Common.Message.back("流程审核错误,请与管理员联系!");
}
}
private void sava()
{
mtb = btb.GetModel(Convert.ToInt32(Request.Params["bid"]));
ArrayList list = new ArrayList();
string datalist = "";
string datafield = "";
System.Collections.Specialized.NameObjectCollectionBase.KeysCollection keys = Request.Params.Keys;//取得所有Request的Key值
for (int i = 0; i < keys.Count; i++)
{
//过滤其它Request的Key值留以DATA_开头的Key
if (keys[i].ToString().IndexOf("DATA_") >= 0)
{
list.Add(keys[i].ToString()); //将key值存入数组
datafield += keys[i].ToString() + ","; //将key值存入字符串
}
}
//获取表单提交过来的值
for (int j = 0; j < list.Count; j++)
{
datalist += Request.Form[list[j].ToString()] + "<@Sep@>";//值用<@Sep@>隔开以便存入数据库
}
mtb.b_content = datalist;
if (!string.IsNullOrEmpty(datafield))
{
datafield = datafield.Substring(0, datafield.Length - 1);//去掉最后的的','
}
mtb.b_datefield = datafield;
if (!"".Equals(this.SaveFiles()))
{
if (null != Request.Form["hfile"] && !"".Equals(Request.Form["hfile"]))
{
mtb.b_file = Request.Form["hfile"] + "," + this.SaveFiles();//批量附件上传
}
else
{
mtb.b_file = this.SaveFiles();//批量附件上传
}
}
else
{
if (null != Request.Form["hfile"] && !"".Equals(Request.Form["hfile"]))
{
mtb.b_file = Request.Form["hfile"];
}
else
{
mtb.b_file = "";
}
}
mf = bf.GetModel(mtb.b_sort);
mtb.b_title = TextBox1.Text.Trim();
mtb.b_state = (mf.f_state == 0 ? 1 : 2);
mtb.b_suser = (RadioButtonList3.SelectedValue == "1" ? int.Parse(m_value.Value) : 0);
btb.Update(mtb);
}
void Bind()
{
try
{
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
mf = bf.GetModel(mtb.b_sort);
mtf = tf.GetModel(mf.f_form);
if (mtf == null)
{
Tunnel.Common.Message.back("表单不存在或已删除,请与管理员联系"); return;
}
Label1.Text = fc.From_Content(mtf.f_content, mtb.b_content, true);//取得替换后的表单数据
Label4.Text = mtb.b_title + " (" + mtb.b_time + ")";
Label5.Text = "<font color=red>(注：红色代表当前执行步骤,<font color=green>绿色代表已经审批通过</font>)</font>";
formfile = Tunnel.Common.GetValue.getFile(mtb.b_file);
if (mf.f_isfile.ToString() == "1")
{
isuploads = false;
}
if (mf.f_state.ToString() == "0" && mf.f_sort != 18)
{
scontent = "<font color='green'>审核→</font>";
}
else
{
scontent = "";
}
Repeater1.DataSource = bts.GetList("s_lid=" + mf.f_id);
Repeater1.DataBind();
Button4.Visible = false;
Button5.Visible = false;
string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbid", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
if ("".Equals(currbid) || "0".Equals(currbid))
{
currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
}
mts = bts.GetModel(Convert.ToInt32(currbid));
if (mts.s_isbak == 1)
{
Button5.Visible = true;
Button1.Visible = false;
Button2.Visible = false;
spPassword.Enabled = false;
spPassword.TextMode = TextBoxMode.SingleLine;
spPassword.Text = "不需填写审批密码";
}
}
catch
{
Tunnel.Common.Message.back("不正确的ID"); return;
}
}
void Bind()
{
try
{
string suser = "";
mtb = btb.GetModel(int.Parse(Tunnel.Data.DESEncrypt.Decrypt(Request.Params["lid"])));
Label1.Text = mtb.b_content; //取得替换后的表单数据
formfile = getFile(mtb.b_file); //附件
formdvice = getAdvice(mtb.b_id.ToString()); //意见
Page.Title = Label2.Text = mtb.b_title;
DataSet ds = bte.GetList("e_gid=" + mtb.b_id + " and e_user<>0 order by e_id asc");
if (mtb.b_state == 3)
{
nextb = ""; isend = true;
}
else
{
if (mtb.b_state > 0)
{
string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbuser", "e_gid=" + mtb.b_id + " order by e_id desc");
string currtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_time", "e_gid=" + mtb.b_id + " order by e_id desc");
int currnum = Convert.ToInt32(Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "count(*)", "e_user<>0 and e_gid=" + mtb.b_id));
StringBuilder text = new StringBuilder();
text.Append("<tr>");
text.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>" + (currnum + 1) + "</font>步</td>");
text.Append("<td align=\"left\" style=\"height: 30px; width: 30%\"> 审批</td>");
text.Append("<td align=\"left\" style=\"height: 50%\"> <strong style=\"color:Red\">" + getallUname(curruser) + " 主办</strong> [<font color=blue>办理中</font>]");
text.Append("<br /> 开始于：" + currtime + "</td>");
text.Append("</tr> ");
nextb = text.ToString();
}
}
Repeater1.DataSource = ds;
Repeater1.DataBind();
if (ds.Tables[0].Rows.Count > 0 || nextb != "")
{
isliu = true;
}
}
catch
{
Tunnel.Common.Message.back("无效参数");
}
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <param name="pb">分页基本信息</param>
/// <param name="count">返回总数</param>
/// <returns></returns>
public List <Tunnel.Model.Tunnel_bumf> GetList(PageBase pb, ref int count)
{
DataTable dt = dal.GetList(pb, ref count).Tables[0];
List <Tunnel.Model.Tunnel_bumf> modelList = new List <Tunnel.Model.Tunnel_bumf>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0 && pb.DoCount == 0)
{
Tunnel.Model.Tunnel_bumf model;
for (int n = 0; n < rowsCount; n++)
{
model = new Tunnel.Model.Tunnel_bumf();
model.b_title = dt.Rows[n]["b_title"].ToString();
model.b_file = dt.Rows[n]["b_file"].ToString();
model.b_id = int.Parse(dt.Rows[n]["b_id"].ToString());
if (dt.Rows[n]["b_sort"].ToString() != "")
{
model.b_sort = int.Parse(dt.Rows[n]["b_sort"].ToString());
}
if (dt.Rows[n]["b_time"].ToString() != "")
{
model.b_time = DateTime.Parse(dt.Rows[n]["b_time"].ToString());
}
model.b_file = dt.Rows[n]["b_file"].ToString();
if (dt.Rows[n]["b_state"].ToString() != "")
{
model.b_state = int.Parse(dt.Rows[n]["b_state"].ToString());
}
if (dt.Rows[n]["b_user"].ToString() != "")
{
model.b_user = int.Parse(dt.Rows[n]["b_user"].ToString());
}
if (dt.Rows[n]["b_stype"].ToString() != "")
{
model.b_stype = int.Parse(dt.Rows[n]["b_stype"].ToString());
}
model.b_content = dt.Rows[n]["b_content"].ToString();
model.b_datefield = dt.Rows[n]["b_datefield"].ToString();
model.b_formcontent = dt.Rows[n]["b_formcontent"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
void bindflow()
{
string suser = "";
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
Page.Title = mtb.b_title;
DataSet ds = bte.GetList("e_gid=" + mtb.b_id + " and e_user<>0 order by e_id asc");
StringBuilder texttop = new StringBuilder();
texttop.Append("<tr>");
texttop.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>1</font>步</td>");
texttop.Append("<td align=\"left\" style=\"height: 30px; width: 30%\"> 发起</td>");
texttop.Append("<td align=\"left\" style=\"height: 50%\"> <strong style=\"color:Red\">" + getUname(mtb.b_user.ToString()) + "</strong> [<font color=Green>发起</font>]");
texttop.Append("<br /> 发起于：" + mtb.b_time.ToString() + "</td>");
texttop.Append("<td align=\"left\" style=\"height: 30px; width: 40%\"> </td>");
texttop.Append("</tr> ");
if (mtb.b_state == 3)
{
nextb = ""; isend = true;
}
else
{
if (mtb.b_state > 0)
{
string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbuser", "e_gid=" + mtb.b_id + " order by e_id desc");
string currtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_time", "e_gid=" + mtb.b_id + " order by e_id desc");
int currnum = Convert.ToInt32(Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "count(*)", "e_user<>0 and e_gid=" + mtb.b_id));
StringBuilder text = new StringBuilder();
text.Append("<tr>");
text.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>" + (currnum + 2) + "</font>步</td>");
text.Append("<td align=\"left\" style=\"height: 30px; width: 30%\"> 审批</td>");
text.Append("<td align=\"left\" style=\"height: 50%\"> <strong style=\"color:Red\">" + getallUname(curruser) + " 主办</strong> [<font color=blue>办理中</font>]");
text.Append("<br /> 开始于：" + currtime + "</td>");
text.Append("<td align=\"left\" style=\"height: 30px; width: 40%\"> </td>");
text.Append("</tr> ");
nextb = text.ToString();
}
}
toptb = texttop.ToString();
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.ShowInit("");
Tunnel.BLL.Tunnel_flow tf = new Tunnel.BLL.Tunnel_flow();
DataSet dds = tf.GetList("f_sort=18");
ListItem list = new ListItem();
//list.Text = "所有流程类型";
//list.Value = "0";
//DropDownList1.Items.Add(list);
foreach (DataRow drds in dds.Tables[0].Rows)
{
list = new ListItem();
list.Text = drds["f_name"].ToString();
list.Value = drds["f_id"].ToString();
DropDownList1.Items.Add(list);
}
if (!string.IsNullOrEmpty(Request.Params["delid"]))
{
mb = tb.GetModel(Convert.ToInt32(Request.Params["delid"]));
if ("issure".Equals(Request.Params["mod"]))
{
tmt.Title = mb.b_title;
tmt.TypeId = 5;
tmt.HtmlSource = fc.From_Content(mb.b_formcontent, mb.b_content, true);//取得替换后的表单数据
tmt.UserId = mb.b_user;
Tunnel.BLL.Tunnel_information bllf = new Tunnel.BLL.Tunnel_information();
int relt = -1;
relt = bllf.Add(tmt);
}
tb.Delete(mb.b_id);
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM TUNNEL_EXAM WHERE E_GID=" + mb.b_id);
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM Tunnel_Advice WHERE A_GID=" + mb.b_id);
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM Tunnel_Remind WHERE m_type=1 and m_typeid=" + mb.b_id);
Tunnel.Common.Del_File delfile = new Tunnel.Common.Del_File();
delfile.FileDelete(mb.b_file);
Tunnel.Common.Message.Show("操作成功！");
}
}
}
void Bind()
{
try
{
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
mf = bf.GetModel(mtb.b_sort);
mtf = tf.GetModel(mf.f_form);
Label1.Text = fc.From_Content(mtf.f_content, mtb.b_content, true);//取得替换后的表单数据
Label4.Text = mtb.b_title + " (" + mtb.b_time + ")";
formfile = Tunnel.Common.GetValue.getFile(mtb.b_file);
if (mf.f_isfile.ToString() == "1")
{
isuploads = false;
}
Repeater1.DataSource = bts.GetList("s_lid=" + mf.f_id);
Repeater1.DataBind();
}
catch {
Tunnel.Common.Message.back("不正确的ID"); return;
}
}
void Bind()
{
try
{
if (!string.IsNullOrEmpty(Request.Params["bid"]))
{
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
Label1.Text = mtb.b_content;
Label4.Text = mtb.b_title + " (" + mtb.b_time + ")";
Button4.Visible = true;
formfile = Tunnel.Common.GetValue.getFile(mtb.b_file);
}
else
{
Tunnel.Common.Message.back("不正确的ID"); return;
}
}
catch
{
Tunnel.Common.Message.back("不正确的ID"); return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!string.IsNullOrEmpty(Request.Params["bid"]))
{
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
TextBox1.Text = mtb.b_title;
FCKeditor1.Value = mtb.b_content;
hfile.Value = mtb.b_file;
if (!"".Equals(mtb.b_file))
{
string[] filelist = mtb.b_file.Split(',');
foreach (string list in filelist)
{
string flist = list.Substring(list.LastIndexOf('/') + 1, list.Length - list.LastIndexOf('/') - 1);
hfilelist += "<span><img src=\"../../image/attach.png\">" + flist + "<img style='cursor:hand' onclick=\"del(this,'" + list + "')\" alt='删除附件' src=\"../../image/remove.png\">;</span>";
}
}
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
#region 消息提示
Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind();
tr.m_title = mtb.b_title + "<font color=red>(审核没有通过)</font>";
tr.m_url = "N_WorkFlow/MyApply/Apply_Edit.aspx?Bid=" + mtb.b_id + "&Flow=" + mtb.b_sort;
tr.m_touser = Convert.ToInt32(mtb.b_user);
tr.m_time = DateTime.Now;
tr.m_type = 1;
tr.m_typeid = Convert.ToInt32(mtb.b_id);
tr.m_bid = -1;
tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
tr.m_isread = 0;
long messge = br.Add(tr);
#endregion
Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=-1 WHERE B_ID=" + mtb.b_id); //改变公文状态
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=0 and m_typeid=" + mtb.b_id); //删除待办事项
Tunnel.Common.Message.Show("操作成功,审核不通过!", "Apply_SP.aspx");
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Tunnel.Model.Tunnel_bumf> DataTableToList(DataTable dt)
{
List <Tunnel.Model.Tunnel_bumf> modelList = new List <Tunnel.Model.Tunnel_bumf>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Tunnel.Model.Tunnel_bumf model;
for (int n = 0; n < rowsCount; n++)
{
model = new Tunnel.Model.Tunnel_bumf();
model.b_id = int.Parse(dt.Rows[n]["b_id"].ToString());
if (dt.Rows[n]["b_sort"].ToString() != "")
{
model.b_sort = int.Parse(dt.Rows[n]["b_sort"].ToString());
}
if (dt.Rows[n]["b_time"].ToString() != "")
{
model.b_time = DateTime.Parse(dt.Rows[n]["b_time"].ToString());
}
model.b_file = dt.Rows[n]["b_file"].ToString();
if (dt.Rows[n]["b_state"].ToString() != "")
{
model.b_state = int.Parse(dt.Rows[n]["b_state"].ToString());
}
if (dt.Rows[n]["b_user"].ToString() != "")
{
model.b_user = int.Parse(dt.Rows[n]["b_user"].ToString());
}
model.b_content = dt.Rows[n]["b_content"].ToString();
model.b_datefield = dt.Rows[n]["b_datefield"].ToString();
model.b_formcontent = dt.Rows[n]["b_formcontent"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Tunnel.Model.Tunnel_bumf model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@b_id", SqlDbType.BigInt, 8),
new SqlParameter("@b_title", SqlDbType.VarChar, 200),
new SqlParameter("@b_state", SqlDbType.Int, 4),
new SqlParameter("@b_suser", SqlDbType.Int, 4),
new SqlParameter("@b_content", SqlDbType.Text),
new SqlParameter("@b_datefield", SqlDbType.Text),
new SqlParameter("@b_file", SqlDbType.VarChar, 3000)
};
parameters[0].Value = model.b_id;
parameters[1].Value = model.b_title;
parameters[2].Value = model.b_state;
parameters[3].Value = model.b_suser;
parameters[4].Value = model.b_content;
parameters[5].Value = model.b_datefield;
parameters[6].Value = model.b_file;
DbHelperSQL.RunProcedure("UP_Tunnel_bumf_Update", parameters, out rowsAffected);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Tunnel.Model.Tunnel_bumf model)
{
dal.Update(model);
}
protected void Button2_Click(object sender, EventArgs e)
{
Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
if (!Tunnel.Data.DESEncrypt.Encrypt(spPassword.Text.Trim()).Equals(tm.m_spassword))
{
Tunnel.Common.Message.back("审批密码错误"); return;
}
else
{
//这里为存储当前步骤
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
if (mtb.b_state == 3)
{
Tunnel.Common.Message.back("此公文己审批结束,请勿重复审批!"); return;
}
else
{
//将当前步骤存入数据库表:Tunnel_exam
Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam();
Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
mte.e_bid = 0;
mte.e_endtime = DateTime.Now;
mte.e_gid = Convert.ToInt32(Request.Params["bid"]);
mte.e_user = ul.LoginID;
string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + mtb.b_id + " order by e_id desc");
if (!string.IsNullOrEmpty(lastendtime))
{
mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间
}
else
{
mte.e_time = mtb.b_time;
}
mte.e_nextbid = 0;
bte.Add(mte);
#region 消息提示
Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind();
tr.m_title = mtb.b_title + "<font color=red>(审批没有通过)</font>";
tr.m_url = "N_WorkFlow/OtherDocument/Other_Edit.aspx?bid=" + Request.Params["bid"];
tr.m_touser = Convert.ToInt32(mtb.b_user);
tr.m_time = DateTime.Now;
tr.m_type = 1;
tr.m_typeid = Convert.ToInt32(mtb.b_id);
tr.m_bid = -1;
tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
tr.m_isread = 0;
long messge = br.Add(tr);
#endregion
string contents = FCKeditor1.Value;
//添加审批意见
if (!string.IsNullOrEmpty(contents))
{
Tunnel.BLL.Tunnel_Advice ta = new Tunnel.BLL.Tunnel_Advice();
Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice();
ma.a_content = contents;
ma.a_bid = 1024;//1024代表是其它申请 没有步骤ID的
ma.a_gid = Convert.ToInt32(mtb.b_id);
ma.a_time = DateTime.Now;
ma.a_user = ul.LoginID;
string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=1024 and a_gid=" + mtb.b_id);
ta.Add(ma);
}
Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=0 WHERE B_ID=" + mtb.b_id); //改变公文状态
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=1 and m_touser="******" and m_typeid=" + mtb.b_id); //删除待办事项
Tunnel.Common.Message.Show("操作成功!", "../MyApply/Apply_Sp.aspx");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
System.Web.HttpFileCollection uploadFiles = Request.Files;
System.Web.HttpPostedFile theFile;
for (int i = 0; i < uploadFiles.Count; i++)
{
theFile = uploadFiles[i];
if (Convert.ToDouble(theFile.ContentLength) / 1024 / 1024 > 10)
{
Tunnel.Common.Message.back("附件大小不能大于10MB");
return;
}
else
{
continue;
}
}
this.sava();
Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
mtb = btb.GetModel(Convert.ToInt32(Request.Params["bid"]));
//下一步骤ID
string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + mtb.b_sort + " and s_num=1");
//如果流程没有预设步骤
if ("".Equals(currbid))
{
Tunnel.Common.Message.back("本流程未预设步骤,请与管理员联系!"); return;
}
//将当前步骤存入数据库表:Tunnel_exam
Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam();
Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
mte.e_bid = 0;
mte.e_endtime = DateTime.Now;
mte.e_gid = Convert.ToInt32(mtb.b_id);
mte.e_user = ul.LoginID;
mte.e_time = DateTime.Now;
mte.e_nextbid = Convert.ToInt32(currbid);
bte.Add(mte);
Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind();
string[] users = curruser.Split(',');
foreach (string user in users)
{
if (!string.IsNullOrEmpty(user))
{
tr.m_title = TextBox1.Text.Trim() + "<font color=red>(待审批)</font>";
tr.m_url = "N_WorkFlow/MyApply/Apply_zSp.aspx?bid=" + mte.e_gid;
tr.m_touser = Convert.ToInt32(user);
tr.m_time = DateTime.Now;
tr.m_type = 1;
tr.m_typeid = mte.e_gid;
tr.m_bid = Convert.ToInt32(currbid);
tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
tr.m_isread = 0;
long messge = br.Add(tr);
}
}
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=-1 and m_typeid=" + mtb.b_id);//删除待办事项
Tunnel.Common.Message.Show("操作成功!", "Document_Add.aspx");
}
catch
{
Tunnel.Common.Message.back("流程错误,请与管理员联系!");
}
}
void bindflow()
{
string bWhere = "";
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
mf = bf.GetModel(mtb.b_sort);
if (mf.f_sort == 18)
{
bWhere = " and e_bid<>0";
}
else
{
bWhere = "";
}
Page.Title = mtb.b_title;
DataSet ds = bte.GetList("e_gid=" + mtb.b_id + bWhere + " order by e_id asc");
StringBuilder text = new StringBuilder();
StringBuilder texttop = new StringBuilder();
texttop.Append("<tr>");
texttop.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>1</font>步</td>");
texttop.Append("<td align=\"left\" style=\"height: 30px; width: 20%\"> 发起</td>");
texttop.Append("<td align=\"left\" style=\"height: 30%\"> <strong style=\"color:Red\">" + getUname(mtb.b_user.ToString()) + "</strong> [<font color=Green>发起</font>]");
texttop.Append("<br /> 发起于：" + mtb.b_time.ToString() + "</td>");
texttop.Append("<td align=\"left\" style=\"height: 30px; width: 40%\"> <td>");
texttop.Append("</tr> ");
if (mtb.b_state == 3)
{
nextb = ""; isend = true;
}
else if (mtb.b_state == 1)
{
string suser = "";
if (mtb.b_suser == 0)
{
ul.UsbnLogin = bm.GetModel(mtb.b_user);
DataSet dss = new DataSet();
dss = bm.GetList("m_bum=" + ul.UsbnLogin.m_bum);
foreach (DataRow dr in dss.Tables[0].Rows)
{
if (Tunnel.BLL.Permission.IfHasPrimision(dr["m_id"].ToString(), "流程审核", "我的工作", false))
{
suser += dr["m_id"].ToString() + ",";
}
}
if (!string.IsNullOrEmpty(suser))
{
text.Append("<tr>");
text.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>2</font>步</td>");
text.Append("<td align=\"left\" style=\"height: 30px; width: 20%\"> 审核</td>");
text.Append("<td align=\"left\" style=\"height: 30%\"> <strong style=\"color:Red\">" + getallUname(suser) + " 主办</strong> [<font color=blue>审核中</font>]");
text.Append("<br /> 开始于：" + mtb.b_time.ToString() + "</td>");
text.Append("<td align=\"left\" style=\"height: 30px; width: 40%\"> </td>");
text.Append("</tr> ");
}
else
{
text.Append("<tr>");
text.Append("<td align=\"center\" colspan='4' style=\"height: 30px; width: 10%;color:red\">没有设置审核人,请与管理员联系!</td>");
text.Append("</tr> ");
}
}
else
{
text.Append("<tr>");
text.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>2</font>步</td>");
text.Append("<td align=\"left\" style=\"height: 30px; width: 20%\"> 审核</td>");
text.Append("<td align=\"left\" style=\"height: 30%\"> <strong style=\"color:Red\">" + getUname(mtb.b_suser.ToString()) + " 主办</strong> [<font color=blue>审核中</font>]");
text.Append("<br /> 开始于：" + mtb.b_time.ToString() + "</td>");
text.Append("<td align=\"left\" style=\"height: 30px; width: 40%\"> </td>");
text.Append("</tr> ");
}
nextb = text.ToString();
}
else
{
if (mtb.b_state > 0)
{
string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbid", "e_gid=" + mtb.b_id + " order by e_id desc");
string currtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_time", "e_gid=" + mtb.b_id + " order by e_id desc");
int currnum = Convert.ToInt32(Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "count(*)", "e_gid=" + mtb.b_id));
if ("".Equals(currbid) || "0".Equals(currbid))
{
currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
}
mts = ts.GetModel(Convert.ToInt32(currbid));
string nextnum = "";
string nextname = "";
string nextuser = "";
if (mts != null)
{
nextnum = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_num", "s_id=" + mts.s_id);
nextname = getname(mts.s_id.ToString());
nextuser = getallUname(mts.s_zid.ToString());
}
else
{
nextname = "步骤不存在或已删除";
nextuser = nextnum = "无";
}
text.Append("<tr>");
text.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>" + (currnum + (bWhere == "" ? 2 : 1)) + "</font>步</td>");
text.Append("<td align=\"left\" style=\"height: 30px; width: 20%\"> " + "序号" + nextnum + "：" + nextname + "</td>");
text.Append("<td align=\"left\" style=\"height: 30%\"> <strong style=\"color:Red\">" + nextuser + " 主办</strong> [<font color=blue>办理中</font>]");
text.Append("<br /> 开始于：" + currtime + "</td>");
text.Append("<td align=\"left\" style=\"height: 30px; width: 40%\"> </td>");
text.Append("</tr> ");
nextb = text.ToString();
}
}
toptb = texttop.ToString();
Repeater2.DataSource = ds;
Repeater2.DataBind();
}
protected void Button5_Click(object sender, EventArgs e)
{
//这里为存储当前步骤
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
mf = bf.GetModel(mtb.b_sort);
if (mtb.b_state == 3)
{
Tunnel.Common.Message.back("此流程己审批结束,请勿重复审批!"); return;
}
else
{
string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbid", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
if ("".Equals(currbid) || "0".Equals(currbid))
{
currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
}
mts = bts.GetModel(Convert.ToInt32(currbid));
int cunum = mts.s_num;
bool iscshened = true;
int sum = bts.GetCount("s_lid=" + mtb.b_sort);
string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_id=" + mts.s_id);
if (!string.IsNullOrEmpty(curruser))
{
string[] users = curruser.Split(',');
foreach (string user in users)
{
if (!string.IsNullOrEmpty(user))
{
if (user == ul.LoginID.ToString())
{
iscshened = false;
}
}
}
}
if (!iscshened || ul.JiaoSe(ul.LoginID) == "系统管理员")
{
//将当前步骤存入数据库表:Tunnel_exam
Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam();
Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
mte.e_bid = Convert.ToInt32(mts.s_id);
mte.e_endtime = DateTime.Now;
mte.e_gid = Convert.ToInt32(Request.Params["bid"]);
mte.e_user = ul.LoginID;
string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
if (!string.IsNullOrEmpty(lastendtime))
{
mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间
}
else
{
mte.e_time = mtb.b_time;
}
//如果为最后一步则结束流程
if (cunum == sum)
{
mte.e_nextbid = 0;
string pid = Tunnel.Common.GetValue.getDataValue("Tunnel_flow", "f_sort", "f_id=" + mtb.b_sort);
//插入到公司发文
if ("18".Equals(pid))
{
tmt.Title = mtb.b_title;
tmt.TypeId = 5;
tmt.HtmlSource = fc.From_Content(mtb.b_formcontent, mtb.b_content, true);//取得替换后的表单数据
tmt.UserId = mtb.b_user;
Tunnel.BLL.Tunnel_information bllf = new Tunnel.BLL.Tunnel_information();
int relt = -1;
relt = bllf.Add(tmt);
}
Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=3 WHERE B_ID=" + Request.Params["bid"]);
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=" + currbid + " and m_typeid=" + mtb.b_id);//删除待办事项
Tunnel.Common.Message.Show("流程结束成功!", "Apply_Sp.aspx");
}
else
{
string currs = "";
if (!"".Equals(currbid) || !"0".Equals(currbid))
{
string nid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num>" + mts.s_num + " order by s_num asc");
currs = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + mtb.b_sort + " and s_num>" + mts.s_num + " order by s_num asc");
if (string.IsNullOrEmpty(nid))
{
nid = "0";
}
mte.e_nextbid = long.Parse(nid);
}
else
{
mte.e_nextbid = 0;
}
if (!string.IsNullOrEmpty(currs))
{
Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind();
string[] users = currs.Split(',');
foreach (string user in users)
{
if (!string.IsNullOrEmpty(user))
{
tr.m_title = mtb.b_title + "<font color=red>(待审批)</font>";
tr.m_url = "N_WorkFlow/MyApply/Apply_zSp.aspx?bid=" + mtb.b_id;
tr.m_touser = Convert.ToInt32(user);
tr.m_time = DateTime.Now;
tr.m_type = 1;
tr.m_typeid = Convert.ToInt32(mtb.b_id);
tr.m_bid = Convert.ToInt32(mte.e_nextbid);
tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
tr.m_isread = 0;
long messge = br.Add(tr);
}
}
}
}
bte.Add(mte);
string contents = FCKeditor1.Value;
//添加审批意见
if (!string.IsNullOrEmpty(contents))
{
Tunnel.BLL.Tunnel_Advice ta = new Tunnel.BLL.Tunnel_Advice();
Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice();
ma.a_content = contents;
ma.a_bid = Convert.ToInt32(mts.s_id);
ma.a_gid = Convert.ToInt32(mtb.b_id);
ma.a_time = DateTime.Now;
ma.a_user = ul.LoginID;
string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=" + mf.f_id + " and a_gid=" + Request.Params["bid"]);
if (int.Parse(count) > 0)
{
ta.Update(ma);
}
else
{
ta.Add(ma);
}
}
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=" + currbid + " and m_typeid=" + mtb.b_id);//删除待办事项
Tunnel.Common.Message.Show("操作成功!", "Apply_Sp.aspx");
}
else
{
Tunnel.Common.Message.back("此流程己审批通过,请勿重复审批!"); return;
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
if (!Tunnel.Data.DESEncrypt.Encrypt(spPassword.Text.Trim()).Equals(tm.m_spassword))
{
Tunnel.Common.Message.back("审批密码错误"); return;
}
else
{
//这里为存储当前步骤
mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
mf = bf.GetModel(mtb.b_sort);
if (mtb.b_state == 3)
{
Tunnel.Common.Message.back("此公文己审批结束,请勿重复审批!"); return;
}
else
{
string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbid", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
if ("".Equals(currbid) || "0".Equals(currbid))
{
currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
}
mts = bts.GetModel(Convert.ToInt32(currbid));
bool iscshened = true;
int sum = bts.GetCount("s_lid=" + mtb.b_sort);
string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_id=" + mts.s_id);
if (!string.IsNullOrEmpty(curruser))
{
string[] users = curruser.Split(',');
foreach (string user in users)
{
if (!string.IsNullOrEmpty(user))
{
if (user == ul.LoginID.ToString())
{
iscshened = false;
}
}
}
}
if (!iscshened || ul.JiaoSe(ul.LoginID) == "系统管理员")
{
//将当前步骤存入数据库表:Tunnel_exam
Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam();
Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
mte.e_bid = 0;
mte.e_endtime = DateTime.Now;
mte.e_gid = Convert.ToInt32(Request.Params["bid"]);
mte.e_user = ul.LoginID;
string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + mtb.b_id + " order by e_id desc");
if (!string.IsNullOrEmpty(lastendtime))
{
mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间
}
else
{
mte.e_time = mtb.b_time;
}
mte.e_nextbid = 0;
bte.Add(mte);
#region 消息提示
Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind();
tr.m_title = mtb.b_title + "<font color=red>(审批没有通过)</font>";
string flowtype = Tunnel.Common.GetValue.getDataValue("Tunnel_flow", "f_sort", "f_id=" + mtb.b_sort);
if ("18".Equals(flowtype))
{
tr.m_url = "N_WorkFlow/ODocument/Document_Edit.aspx?Bid=" + mtb.b_id;
}
else
{
tr.m_url = "N_WorkFlow/MyApply/Apply_Edit.aspx?Bid=" + mtb.b_id + "&Flow=" + mtb.b_sort;
}
tr.m_touser = Convert.ToInt32(mtb.b_user);
tr.m_time = DateTime.Now;
tr.m_type = 1;
tr.m_typeid = Convert.ToInt32(mtb.b_id);
tr.m_bid = -1;
tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
tr.m_isread = 0;
long messge = br.Add(tr);
#endregion
string contents = FCKeditor1.Value;
//添加审批意见
if (!string.IsNullOrEmpty(contents))
{
Tunnel.BLL.Tunnel_Advice ta = new Tunnel.BLL.Tunnel_Advice();
Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice();
ma.a_content = contents;
ma.a_bid = Convert.ToInt32(mts.s_id);
ma.a_gid = Convert.ToInt32(mtb.b_id);
ma.a_time = DateTime.Now;
ma.a_user = ul.LoginID;
string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=" + mf.f_id + " and a_gid=" + mtb.b_id);
if (int.Parse(count) > 0)
{
ta.Update(ma);
}
else
{
ta.Add(ma);
}
}
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=" + currbid + " and m_typeid=" + mtb.b_id); //删除待办事项
Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=0 WHERE B_ID=" + mtb.b_id); //改变公文状态
Tunnel.Common.Message.Show("操作成功!", "Apply_Sp.aspx");
}
else
{
Tunnel.Common.Message.back("此流程己审批通过,请勿重复审批!"); return;
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
System.Web.HttpFileCollection uploadFiles = Request.Files;
System.Web.HttpPostedFile theFile;
for (int i = 0; i < uploadFiles.Count; i++)
{
theFile = uploadFiles[i];
if (Convert.ToDouble(theFile.ContentLength) / 1024 / 1024 > 10)
{
Tunnel.Common.Message.back("附件大小不能大于10MB");
return;
}
else
{
continue;
}
}
Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
//下一步骤ID
string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + Request.Params["Flow"] + " and s_num=1");
string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + Request.Params["Flow"] + " and s_num=1");
//如果流程没有预设步骤
if ("".Equals(currbid))
{
Tunnel.Common.Message.back("本流程未预设步骤,请与管理员联系!"); return;
}
Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind();
mtb = btb.GetModel(Convert.ToInt32(Request.Params["bid"]));
mf = bf.GetModel(mtb.b_sort);
if (mf.f_state.ToString() == "0")
{
isshen = true;
}
else
{
isshen = false;
}
this.sava();
if (!isshen)
{
//将当前步骤存入数据库表:Tunnel_exam
Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam();
Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
mte.e_bid = 0;
mte.e_endtime = DateTime.Now;
mte.e_gid = Convert.ToInt32(mtb.b_id);
mte.e_user = ul.LoginID;
mte.e_time = DateTime.Now;
mte.e_nextbid = Convert.ToInt32(currbid);
bte.Add(mte);
string[] users = curruser.Split(',');
foreach (string user in users)
{
if (!string.IsNullOrEmpty(user))
{
tr.m_title = TextBox1.Text.Trim() + "<font color=red>(待审批)</font>";
tr.m_url = "N_WorkFlow/MyApply/Apply_zSp.aspx?bid=" + mte.e_gid;
tr.m_touser = Convert.ToInt32(mtb.b_user);
tr.m_time = DateTime.Now;
tr.m_type = 1;
tr.m_typeid = mte.e_gid;
tr.m_bid = Convert.ToInt32(currbid);
tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
tr.m_isread = 0;
long messge = br.Add(tr);
}
}
}
else
{
ul.UsbnLogin = bm.GetModel(ul.LoginID);
DataSet dss = bm.GetList("m_bum=" + ul.UsbnLogin.m_bum);
string userlist = "";
foreach (DataRow dr in dss.Tables[0].Rows)
{
if (Tunnel.BLL.Permission.IfHasPrimision(dr["m_id"].ToString(), "流程审核", "我的工作", false))
{
userlist = dr["m_id"].ToString();
}
}
tr.m_title = TextBox1.Text.Trim() + "<font color=red>(待审核)</font>";
tr.m_url = "N_WorkFlow/MyApply/Apply_zSh.aspx?bid=" + mtb.b_id;
tr.m_touser = (RadioButtonList3.SelectedValue == "1" ? int.Parse(m_value.Value) : Convert.ToInt32(userlist));
tr.m_time = DateTime.Now;
tr.m_type = 1;
tr.m_typeid = Convert.ToInt32(mtb.b_id);
tr.m_bid = 0;
tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
tr.m_isread = 0;
long messge = br.Add(tr);
}
Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=-1 and m_typeid=" + mtb.b_id);//删除待办事项
Tunnel.Common.Message.Show("提交成功!", "Apply_Add.aspx?Flow=" + Request.Params["Flow"]);
}
catch
{
Tunnel.Common.Message.back("流程错误,请与管理员联系!");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Tunnel.Model.Tunnel_bumf model)
{
return(dal.Add(model));
}