/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Dianda.Model.Project_UserList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Project_UserList set ");
strSql.Append("ProjectID=@ProjectID,");
strSql.Append("UserID=@UserID,");
strSql.Append("Status=@Status,");
strSql.Append("DATETIME=@DATETIME");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@UserID", SqlDbType.VarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@DATETIME", SqlDbType.DateTime)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ProjectID;
parameters[2].Value = model.UserID;
parameters[3].Value = model.Status;
parameters[4].Value = model.DATETIME;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Dianda.Model.Project_UserList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Project_UserList(");
strSql.Append("ProjectID,UserID,Status,DATETIME)");
strSql.Append(" values (");
strSql.Append("@ProjectID,@UserID,@Status,@DATETIME)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@UserID", SqlDbType.VarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@DATETIME", SqlDbType.DateTime)
};
parameters[0].Value = model.ProjectID;
parameters[1].Value = model.UserID;
parameters[2].Value = model.Status;
parameters[3].Value = model.DATETIME;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dianda.Model.Project_UserList GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ProjectID,UserID,Status,DATETIME from Project_UserList ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Dianda.Model.Project_UserList model = new Dianda.Model.Project_UserList();
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());
}
model.UserID = ds.Tables[0].Rows[0]["UserID"].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]["DATETIME"].ToString() != "")
{
model.DATETIME = DateTime.Parse(ds.Tables[0].Rows[0]["DATETIME"].ToString());
}
return(model);
}
else
{
return(null);
}
}
///// <summary>
///// 根据项目负责人来动态显示资金卡下拉列表
///// </summary>
///// <param name="CashflagID"></param>
//protected void SetDDL_CashCardID(string CashflagID)
//{
// DataTable dt3 = new DataTable();
// string sql2 = " SELECT ID, CardNum, CardName, LimitNums FROM Cash_Cards WHERE (CardholderID = '" + CashflagID + "') ";
// dt3 = pagecontrol.doSql(sql2).Tables[0];
// if (dt3.Rows.Count > 0)
// {
// DDL_CashCardID.Enabled = true;
// DDL_CashCardID.Items.Clear();
// for (int j = 0; j < dt3.Rows.Count; j++)
// {
// string ID = dt3.Rows[j]["ID"].ToString();
// string CardNum = dt3.Rows[j]["CardNum"].ToString();
// string CardName = dt3.Rows[j]["CardName"].ToString();
// string LimitNums = dt3.Rows[j]["LimitNums"].ToString();
// string showinfo = CardName + "[" + CardNum + "," + LimitNums + "]";
// ListItem li = new ListItem(showinfo, ID);
// DDL_CashCardID.Items.Add(li);
// }
// Button_applyfor.Enabled = true;
// Button_reset.Enabled = true;
// Button_draft.Enabled = true;
// }
// else
// {
// DDL_CashCardID.Items.Clear();
// ListItem li = new ListItem("暂无可选资金卡", "");
// DDL_CashCardID.Items.Add(li);
// DDL_CashCardID.Enabled = false;
// Button_applyfor.Enabled = false;
// Button_reset.Enabled = false;
// Button_draft.Enabled = false;
// }
//}
/// <summary>
/// 资金卡选择切换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
//protected void RB_NewAddCashCard_CheckedChanged(object sender, EventArgs e)
//{
// RB_CashCardID.Checked = false;
// RB_NewAddCashCard.Checked = true;
// div_cash.Visible = true;
// Button_applyfor.Enabled = true;
// Button_reset.Enabled = true;
// Button_draft.Enabled = true;
//}
/// <summary>
/// 资金卡选择切换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
//protected void RB_CashCardID_CheckedChanged(object sender, EventArgs e)
//{
// RB_CashCardID.Checked = true;
// RB_NewAddCashCard.Checked = false;
// div_cash.Visible = false;
//}
/// <summary>
/// 根据项目负责人来动态显示资金卡下拉列表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
//protected void DDL_LeaderID_Changed(object sender, EventArgs e)
//{
// string ID = DDL_LeaderID.SelectedValue.ToString();
// SetDDL_CashCardID(ID);
//}
/// <summary>
/// 点击重置触发事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
//protected void Button_reset_Click(object sender, EventArgs e)
//{
// NAME.Text = "";
// for (int i = 0; i < CB_DepartmentID.Items.Count; i++)
// {
// if (CB_DepartmentID.Items[i].Selected == true)
// {
// CB_DepartmentID.Items[i].Selected = false;
// }
// }
// TB_StartTime.Value = "";
// TB_EndTime.Value = "";
// CashTotal.Text = "";
// RB_CashCardID.Checked = true;
// RB_NewAddCashCard.Checked = false;
// Overviews.Value = "";
// div_cash.Visible = false;
// TB_LimitNums.Text = "";
// TB_Notes.Text = "";
//}
/// <summary>
/// 点击申请触发事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_applyfor_Click(object sender, EventArgs e)
{
try
{
string ID = Request["ID"];
project_model = project_bll.GetModel(int.Parse(ID));
//项目审核人
string douserid = project_model.DoUserID.ToString();
string projectName = NAME.Text.ToString();
//检查是否有该项目名称
bool checkName = pagecontrol.Exists_Name("Project_Projects", "NAMES", projectName, "ID", ID);
if (checkName)
{
tag.Text = "该项目名称已经存在，请修改！";
}
else
{
if (FileUpload1.FileName.Length > 2)
{
string[] content = fileup.UpFile_COMMONS(FileUpload1, "/AllFileUp/fileup", HiddenField_oldpath.Value.ToString());
//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;
}
project_model.Attachments = content[1];
}
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
int statusflag = Convert.ToInt32(((Button)sender).CommandArgument.ToString());//获取到触发源
//项目名称
project_model.NAMES = NAME.Text.ToString();
//状态
project_model.Status = statusflag;
//项目负责人
project_model.LeaderID = DDL_LeaderID.SelectedValue.ToString().Split('|')[0].ToString();
////参与部门--参与部门的编辑工作放在了项目成员的功能处-唐春龙-2011-02-17
//project_model.DepartmentID = "";
////参与部门名称
//project_model.DepartmentNames = "";
//for (int i = 0; i < CB_DepartmentID.Items.Count; i++)
//{
// if (CB_DepartmentID.Items[i].Selected == true)
// {
// project_model.DepartmentID = project_model.DepartmentID + CB_DepartmentID.Items[i].Value + ",";
// project_model.DepartmentNames = project_model.DepartmentNames + CB_DepartmentID.Items[i].Text + ",";
// }
//}
///* 截掉最后一个逗号*/
//if (project_model.DepartmentID.Length > 0)
//{
// project_model.DepartmentID = project_model.DepartmentID.Substring(0, project_model.DepartmentID.Length - 1);
// project_model.DepartmentNames = project_model.DepartmentNames.Substring(0, project_model.DepartmentNames.Length - 1);
//}--参与部门的编辑工作放在了项目成员的功能处-唐春龙-2011-02-17
//项目预计起始时间
project_model.StartTime = Convert.ToDateTime(TB_StartTime.Value.ToString());
//项目预计结束时间
project_model.EndTime = Convert.ToDateTime(TB_EndTime.Value.ToString());
//预计经费
if (RL_ProjectType.SelectedValue.ToString().Equals("1"))//当项目类型为正常项目时才有预计经费项
{
//项目审核人
project_model.DoUserID = DDL_CheckUserID.SelectedValue.ToString();
if (!CashTotal.Text.ToString().Equals(""))
{
//project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString());
if (RB_cashtotal.SelectedValue.ToString().Equals("1"))//表示经费单位选择的是万元
{
//经费额度存放的是元
project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString()) * 10000;
//经费单位
project_model.CashDw = "万元";
}
else
{
project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString());
//经费单位
project_model.CashDw = "元";
}
}
else
{
project_model.CashTotal = null;
}
}
else
{
//项目审核人
project_model.DoUserID = "";
}
//资金卡选择
//DataSet ds1 = cashmessage_bll.GetList(" ProjectID = " + project_model.ID);
//if (RB_CashCardID.Checked == true)//如果选择的是资金卡则设为资金卡的ID；
//{
// project_model.CashCardID = Int16.Parse(DDL_CashCardID.SelectedValue.ToString());
// //如果编辑时选择的是资金卡，但是在cash_message表中发现有此项目的消息记录，则说明
// //在新建此项目时选择的是新建资金卡，而现在如果修改成资金卡，则要将这条消息记录删除
// if (ds1.Tables[0].Rows.Count > 0)
// {
// string cashid = ds1.Tables[0].Rows[0]["ID"].ToString();
// cashmessage_bll.Delete(int.Parse(cashid));
// }
//}
//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 = DDL_LeaderID.SelectedValue;
// //项目的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 = 0;
// Session["Cash_Message_temps"] = cashmessage_model;
// //向信息表中添加一条新建资金卡的记录
// cashmessage_bll.Add(cashmessage_model);
// }
//}
//项目概要
project_model.Overviews = Overviews.Value.ToString();
//申请时间
project_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString());
//所属分类
project_model.ColumnsID = int.Parse(DDL_COLUMN.SelectedValue);
//修改项目
project_bll.Update(project_model);
//根据项目负责人的改变来改变项目组成员
string sql_userlist = " SELECT ID, ProjectID, UserID, Status, DATETIME FROM Project_UserList WHERE (ProjectID = '" + ID + "') AND (UserID = '" + project_model.LeaderID + "') AND (Status = '1')";
DataTable dt = pagecontrol.doSql(sql_userlist).Tables[0];
if (!(dt.Rows.Count > 0))
{
Dianda.BLL.Project_UserList project_userlist_bll = new Dianda.BLL.Project_UserList();
Dianda.Model.Project_UserList project_userlist_model = new Dianda.Model.Project_UserList();
// project_userlist_model.ID = project_userlist_bll.GetMaxId();
//项目ID
project_userlist_model.ProjectID = project_model.ID;
//项目组成员
project_userlist_model.UserID = project_model.LeaderID;
//状态
project_userlist_model.Status = 1;
//时间
project_userlist_model.DATETIME = DateTime.Now;
//向Project_UserList加条记录
project_userlist_bll.Add(project_userlist_model);
}
//根据所选择的分类的改变来动态的改变项目审批人的下拉列表。这样原来这个项目的审核人就发生了更改则需要将原来审核表中的UserID改成新的
string sql_checkuser = "******" + DDL_CheckUserID.SelectedValue.ToString() + "' WHERE (ProjectID = " + project_model.ID + ") AND (Status = 0) AND (UserID = '" + douserid + "') ";
pagecontrol.doSql(sql_checkuser);
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入我的项目页面');javascript:location='manage.aspx?projectstatus=" + Request["status"] + "';</script>", false);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "修改立项申请", "修改" + project_model.NAMES + "项目申请修改成功");
//添加操作日志
//tag.Text = "操作成功! 点击“返回”按钮进入我的项目页面！";
//addproject.Visible = false;
//goback.Visible = true;
}
}
catch
{
}
}
/// <summary>
/// 根据项目负责人来动态显示资金卡下拉列表
/// </summary>
/// <param name="CashflagID"></param>
//protected void SetDDL_CashCardID(string CashflagID)
//{
// DataTable dt3 = new DataTable();
// string sql2 = " SELECT ID, CardNum, CardName, LimitNums FROM Cash_Cards WHERE (CardholderID = '" + CashflagID + "') ";
// dt3 = pagecontrol.doSql(sql2).Tables[0];
// if (dt3.Rows.Count > 0)
// {
// DDL_CashCardID.Enabled = true;
// DDL_CashCardID.Items.Clear();
// for (int j = 0; j < dt3.Rows.Count; j++)
// {
// string ID = dt3.Rows[j]["ID"].ToString();
// string CardNum = dt3.Rows[j]["CardNum"].ToString();
// string CardName = dt3.Rows[j]["CardName"].ToString();
// string LimitNums = dt3.Rows[j]["LimitNums"].ToString();
// string showinfo = CardName + "[" + CardNum + "," + LimitNums + "]";
// ListItem li = new ListItem(showinfo, ID);
// DDL_CashCardID.Items.Add(li);
// }
// Button_applyfor.Enabled = true;
// Button_reset.Enabled = true;
// Button_draft.Enabled = true;
// }
// else
// {
// DDL_CashCardID.Items.Clear();
// ListItem li = new ListItem("暂无可选资金卡", "");
// DDL_CashCardID.Items.Add(li);
// DDL_CashCardID.Enabled = false;
// Button_applyfor.Enabled = false;
// Button_reset.Enabled = false;
// Button_draft.Enabled = false;
// }
//}
/// <summary>
/// 资金卡选择切换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
//protected void RB_NewAddCashCard_CheckedChanged(object sender, EventArgs e)
//{
// RB_CashCardID.Checked = false;
// RB_NewAddCashCard.Checked = true;
// div_cash.Visible = true;
// Button_applyfor.Enabled = true;
// Button_reset.Enabled = true;
// Button_draft.Enabled = true;
//}
/// <summary>
/// 资金卡选择切换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
//protected void RB_CashCardID_CheckedChanged(object sender, EventArgs e)
//{
// RB_CashCardID.Checked = true;
// RB_NewAddCashCard.Checked = false;
// div_cash.Visible = false;
//}
/// <summary>
/// 点击申请触发事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_applyfor_Click(object sender, EventArgs e)
{
try
{
string projectName = NAME.Text.ToString();
//检查是否有该项目名称
bool checkName = pagecontrol.Exists_Name("Project_Projects", "NAMES", projectName, "ID", "");
if (checkName)
{
tag.Text = "该项目名称已经存在，请修改！";
}
else
{
//string content = FCL.UpFile(_FileUp, "/AllFileUp/fileup");
if (FileUpload1.FileName.Length > 2)
{
string[] content = fileup.UpFile_COMMONS(FileUpload1, "/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;
}
project_model.Attachments = content[1];
}
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
int statusflag = Convert.ToInt32(((Button)sender).CommandArgument.ToString());//获取到触发源
//ID
int ids = project_bll.GetMaxId();
project_model.ID = ids;
//项目类型
project_model.ProjectType = int.Parse(RL_ProjectType.SelectedValue.ToString());
//项目名称
project_model.NAMES = NAME.Text.ToString();
//删除标记
project_model.DELFLAG = 0;
//状态
if (RL_ProjectType.SelectedValue.ToString().Equals("1"))
{
project_model.Status = statusflag;
}
else
{
project_model.Status = 1;//项目状态设置为正常运行的项目
}
//项目负责人
//project_model.LeaderID = DDL_LeaderID.SelectedValue.ToString();
if (CheckBox_Newleader.Checked == true)
{
if (Session["new_leaderid"] != null && Session["new_leaderid"] != "")
{
project_model.LeaderID = Session["new_leaderid"].ToString();
}
else
{
tag.Text = "未设置项目创建人！无法新建项目！";
return;
}
}
else
{
string[] Leader = DDL_LeaderID.SelectedValue.ToString().Split('|');
project_model.LeaderID = Leader[0].ToString();
}
//参与部门
project_model.DepartmentID = "";
//参与部门名称
project_model.DepartmentNames = "";
for (int i = 0; i < CB_DepartmentID.Items.Count; i++)
{
if (CB_DepartmentID.Items[i].Selected == true)
{
project_model.DepartmentID = project_model.DepartmentID + CB_DepartmentID.Items[i].Value + ",";
project_model.DepartmentNames = project_model.DepartmentNames + CB_DepartmentID.Items[i].Text + ",";
}
}
/* 截掉最后一个逗号*/
if (project_model.DepartmentID.Length > 0)
{
project_model.DepartmentID = project_model.DepartmentID.Substring(0, project_model.DepartmentID.Length - 1);
project_model.DepartmentNames = project_model.DepartmentNames.Substring(0, project_model.DepartmentNames.Length - 1);
}
//项目预计起始时间
project_model.StartTime = Convert.ToDateTime(TB_StartTime.Value.ToString());
//项目预计结束时间
project_model.EndTime = Convert.ToDateTime(TB_EndTime.Value.ToString());
//预计经费
if (RL_ProjectType.SelectedValue.ToString().Equals("1"))//当项目类型为正常项目时才有预计经费项
{
//审核的用户ID
project_model.DoUserID = DDL_CheckUserID.SelectedValue.ToString();
if (!CashTotal.Text.ToString().Equals(""))
{
if (RB_cashtotal.SelectedValue.ToString().Equals("1"))//表示经费单位选择的是万元
{
//经费额度存放的是元
project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString()) * 10000;
//经费单位
project_model.CashDw = "万元";
}
else
{
project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString());
//经费单位
project_model.CashDw = "元";
}
}
}
else
{
//审核的用户ID
project_model.DoUserID = "";
}
//资金卡选择
project_model.CashCardID = 0;
//if (RB_CashCardID.Checked == true)//如果选择的是资金卡则设为资金卡的ID；
//{
// project_model.CashCardID = Int16.Parse(DDL_CashCardID.SelectedValue.ToString());
//}
//else//如果选择的是新建资金卡则设为0,并且需要向cash_message表中加一条记录
//{
// project_model.CashCardID = 0;
// //资金卡名称(暂时写的留空)
// cashmessage_model.CardName = "";
// //持卡人
// cashmessage_model.CardholderID = DDL_LeaderID.SelectedValue;
// //项目的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 = 0;
// Session["Cash_Message_temps"] = cashmessage_model;
// //向信息表中添加一条新建资金卡的记录
// cashmessage_bll.Add(cashmessage_model);
//}
//项目概要
project_model.Overviews = Overviews.Value.ToString();
//申请时间
project_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString());
//申请的用户的ID
project_model.SendUserID = user_model.ID;
//所属分类
project_model.ColumnsID = int.Parse(DDL_COLUMN.SelectedValue);
//向项目表中添加
project_bll.Add(project_model);
//******************在项目申请成功以后将项目负责人默认为项目组成员,即向Project_UserList加条记录
Dianda.BLL.Project_UserList project_userlist_bll = new Dianda.BLL.Project_UserList();
Dianda.Model.Project_UserList project_userlist_model = new Dianda.Model.Project_UserList();
// project_userlist_model.ID = project_userlist_bll.GetMaxId();
//项目ID
project_userlist_model.ProjectID = ids; // project_model.ID;
//项目组成员
project_userlist_model.UserID = project_model.LeaderID;
//状态
project_userlist_model.Status = 1;
//时间
project_userlist_model.DATETIME = DateTime.Now;
//向Project_UserList加条记录
project_userlist_bll.Add(project_userlist_model);
//再将项目的创建者添加到项目组成员列表中--唐春龙2011-02-17
project_userlist_model.ProjectID = ids;
project_userlist_model.UserID = project_model.SendUserID.ToString();
project_userlist_model.Status = 1;
project_userlist_model.DATETIME = DateTime.Now;
project_userlist_bll.Add(project_userlist_model);
//******************在项目申请成功以后要根据所选择的项目审批人，将此项目发送给这个人,即向Project_ShenheList加条记录
//如果项目类型是“正常项目”才做如下操作
if (RL_ProjectType.SelectedValue.ToString().Equals("1"))
{
Dianda.BLL.Project_ShenheList Shenhe_bll = new Dianda.BLL.Project_ShenheList();
Dianda.Model.Project_ShenheList Shenhe_model = new Dianda.Model.Project_ShenheList();
//ID
Shenhe_model.ID = Shenhe_bll.GetMaxId();
//需要审核的项目ID
Shenhe_model.ProjectID = project_model.ID;
//审核人的ID
Shenhe_model.UserID = DDL_CheckUserID.SelectedValue.ToString();
//审核状态（新建默认时默认为0：待审核）
Shenhe_model.Status = 0;
//是否到当前的用户审核:0表示未到；1表示到；2表示已经审核过
Shenhe_model.Isturn = 1;
//审核意见
Shenhe_model.Infors = "";
//向Project_ShenheList加条记录
Shenhe_bll.Add(Shenhe_model);
}
// ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入我的项目页面');javascript:location='manage.aspx?projecttype=4&projectStatus=0';</script>", false);
if (statusflag == 4)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入立项草稿箱页面');javascript:location='manage.aspx?projectStatus=4';</script>", false);
}
else
{
if (RL_ProjectType.SelectedValue.ToString().Equals("0"))//临时项目
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入我的项目页面');javascript:location='manage.aspx?projectStatus=1';</script>", false);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入我的项目页面');javascript:location='manage.aspx?projectStatus=0';</script>", false);
}
}
//清空Session new_leaderid
Session["new_leaderid"] = "";
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "添加立项申请", "添加" + project_model.NAMES + "项目申请成功");
//添加操作日志
//tag.Text = "操作成功! 点击“返回”按钮进入我的项目页面！";
//addproject.Visible = false;
// goback.Visible = true;
//添加立项申请的前台提醒信息
mFaceshowMessage.DATETIME = DateTime.Now;
mFaceshowMessage.FromTable = "立项申请";
mFaceshowMessage.IsRead = 0;
mFaceshowMessage.NewsType = "立项申请";
mFaceshowMessage.Receive = project_model.DoUserID.ToString();
mFaceshowMessage.DELFLAG = 0;
mFaceshowMessage.ProjectID = project_model.ID;
mFaceshowMessage.URLS = "<a href='/Admin/SystemProjectManage/ProjectCheck/check.aspx?ID=" + ids.ToString() + "&pageindex=1&Status=0' target='_self' title='新建项目：提交时间" + DateTime.Now.ToString() + "'>新建项目：" + NAME.Text.ToString() + "</a> (" + user_model.REALNAME + ")";
bFaceshowMessage.Add(mFaceshowMessage);
//如果是个人或者是临时项目的话，就没有审批一环了。所以就直接在创建项目时建一个档案目录
if (RL_ProjectType.SelectedValue.ToString().Equals("0"))
{
//项审批成功以后，要向Document_Folder中添加一个当前用户的顶级档案目录
Dianda.Model.Document_Folder docfolder_model = new Dianda.Model.Document_Folder();
Dianda.BLL.Document_Folder docfolder_bll = new Dianda.BLL.Document_Folder();
int id = docfolder_bll.GetMaxId();
docfolder_model.ID = id;
//目录名称
docfolder_model.FolderName = project_model.NAMES;
//上级目录
docfolder_model.UpID = 38;
//文件夹的属性
docfolder_model.Types = "public";
//是否共享
docfolder_model.IsShare = 0;
//创建的用户
docfolder_model.UserID = user_model.ID;
//删除标记
docfolder_model.DELFLAG = 0;
//当前时间
docfolder_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToShortDateString());
//栏目的路径记录（用/来隔开）
docfolder_model.COLUMNSPATH = "-1/38/" + docfolder_model.ID;
//项目ID
docfolder_model.ProjectID = ids;
//栏目显示的顺序
docfolder_model.SHUNXU = 0;
//栏目的路径名称
docfolder_model.PNAMES = "项目文档>" + project_model.NAMES;
//当前文件夹中文件的大小
docfolder_model.SizeOf = "0";
docfolder_bll.Add(docfolder_model);
if (null != project_model.Attachments && !(project_model.Attachments.ToString().Equals("")))
{
setAttachmentsToDocument(user_model.ID, id.ToString(), project_model.Attachments.ToString());//将立项申请时的上传附件保存到项目的目录中
}
//项审批成功以后往信息栏目表中添加一条记录
Dianda.BLL.News_ColumnsExt columnsext = new Dianda.BLL.News_ColumnsExt();
columnsext.addCloumns(project_model.NAMES, "PROJECT", project_model.ID.ToString(), 2);
}
}
}
catch
{
tag.Text = "立项过程中发生错误，请检查输入项是否正确！";
}
}
