/// <summary>
/// 点击重置按钮触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_reset_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 = "";
string info = "";
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");
string id = GridView1.DataKeys[j]["ID"].ToString();
string ApplierRealName = GridView1.DataKeys[j]["ApplierRealName"].ToString();
string GetDateTime = GridView1.DataKeys[j]["GetDateTime"].ToString();
string ApplyCount = GridView1.DataKeys[j]["ApplyCount"].ToString();
if (cb1.Checked)
{
mCash_Apply = new Dianda.Model.Cash_Apply();
mCash_Apply = bCash_Apply.GetModel(Int32.Parse(id));
mCash_Apply.Statas = 2;
mCash_Apply.DoUserID = ((Model.USER_Users)Session["USER_Users"]).ID;
bCash_Apply.Update(mCash_Apply);
info += ("(" + ApplierRealName + "申请额度" + ApplyCount + "在" + GetDateTime + ")");
tag.Text = "操作成功！";
// string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manage.aspx?pageindex=" + Request["pageindex"] + "\";</script>";
Model.Cash_Cards mCash_Cards = new Dianda.Model.Cash_Cards();
BLL.Cash_Cards bCash_Cards = new Dianda.BLL.Cash_Cards();
mCash_Cards = bCash_Cards.GetModel(Int32.Parse(mCash_Apply.CashCertificateID.ToString()));
/*给业务申请者发信息*/
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.Receive = mCash_Apply.ApplierID;
mFaceShowMessage.URLS = "<a href='/Admin/cashCardManage/manageCashApplyPerson.aspx' target='_self' title='经费预约：提交时间" + DateTime.Now + "'>" + mCash_Cards.CardName + "的经费预约 审核不通过 </a> (" + ((Model.USER_Users)Session["USER_Users"]).REALNAME + ")";
bFaceShowMessage.Add(mFaceShowMessage);
/*给业务申请者发信息*/
}
}
// 添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "审核经费预约", "审核预约" + info + "不通过：成功");
string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manageCashApply.aspx?pageindex=" + pageindexHidden.Value + "&date=" + DDList_RQ.SelectedValue + "&status=" + this.ddlStatas.SelectedValue + "\";</script>";
Response.Write(coutws);
}
}
}
/// <summary>
///点击确定按钮触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_sumbit_Click(object sender, EventArgs e)
{
try
{
string strLimitNums = (this.ddlCardName.SelectedItem.Text.Split(',')[1]).Split(']')[0];//cash表纪录的金额
strLimitNums = strLimitNums.Split(':')[1];
double dLimitNums = double.Parse(strLimitNums);
string strApplyCount = this.txtApplyCount.Text;
double dApplyCount = double.Parse(strApplyCount);
string strGetDateTime = this.txtGetDateTime.Value;
//DateTime dTimeInput = new DateTime(Int32.Parse(strGetDateTime.Split('-')[0]), Int32.Parse(strGetDateTime.Split('-')[1]), Int32.Parse(strGetDateTime.Split('-')[2]), Int32.Parse(this.ddlHour.SelectedValue), Int32.Parse(this.ddlMin.SelectedValue), 0);
DateTime dTimeInput = Convert.ToDateTime(strGetDateTime + RadioButtonList_shijian.SelectedValue.ToString());
//用途
string UserFor = this.txtUseFor.Text.Trim();
if (RBlist_YYLX.SelectedValue == "1")
{
if (dApplyCount > dLimitNums)
{
tag.Text = "申请数额不能超过所选资金卡的余额！";
return;
}
}
//用途拼接字符串
UserFor = "[" + RBlist_YYLX.SelectedItem.Text + "]" + UserFor;
if (Convert.ToDateTime(Convert.ToDateTime(strGetDateTime).ToString("yyyy-MM-dd")) < Convert.ToDateTime(DateTime.Now.AddDays(2).ToString("yyyy-MM-dd")))
{
tag.Text = "经费预约必须提前二天，请电话联系相关人员！";
return;
}
mCash_Apply = new Dianda.Model.Cash_Apply();
mCash_Apply.ProjectID = Int32.Parse(this.ddlProjectID.SelectedValue);
mCash_Apply.CashCertificateID = this.ddlCardName.SelectedValue;
mCash_Apply.ApplyCount = decimal.Parse(strApplyCount);
mCash_Apply.GetDateTime = dTimeInput;
mCash_Apply.UseFor = UserFor;
mCash_Apply.ApplierTel = this.txtApplierTel.Text;
mCash_Apply.ApplierID = ((Model.USER_Users)Session["USER_Users"]).ID;
mCash_Apply.DATETIME = DateTime.Now;
mCash_Apply.Statas = 0;//（0-待审核、1表示审核通过、2表示审核不通过）
mCash_Apply.DoUserID = ((Model.USER_Users)Session["USER_Users"]).ID;
bCash_Apply.Add(mCash_Apply);
/*给业务申请者发信息*/
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.Receive = "经费预约";
mFaceShowMessage.ProjectID = Int32.Parse(this.ddlProjectID.SelectedValue);
mFaceShowMessage.DELFLAG = 0;
//mFaceShowMessage.URLS = ((Model.USER_Users)Session["USER_Users"]).REALNAME + "(" + ((Model.USER_Users)Session["USER_Users"]).USERNAME.ToString() + ")经费预约<a href='/Admin/cashCardManage/manageCashApply.aspx' target='_self' title='经费预约：提交时间" + DateTime.Now + "'>点击处理</a>";
mFaceShowMessage.URLS = "<a href='/Admin/cashCardManage/manageCashApply.aspx' target='_self' title='经费预约：提交时间" + DateTime.Now + "'>经费预约 金额 " + dApplyCount + "</a>" + " " + dTimeInput + " (" + ((Model.USER_Users)Session["USER_Users"]).REALNAME + ")";
bFaceShowMessage.Add(mFaceShowMessage);
/*给业务申请者发信息*/
Model.Cash_Cards mCash_Cards = new Dianda.Model.Cash_Cards();
BLL.Cash_Cards bCash_Cards = new Dianda.BLL.Cash_Cards();
mCash_Cards = bCash_Cards.GetModel(Int32.Parse(this.ddlCardName.SelectedValue));
//添加操作日志
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 + ")", "添加经费预约", "预约" + dTimeInput + "时间取" + strApplyCount + "：成功");
//添加操作日志
//tag.Text = "操作成功！";
string coutws = "";
if (parentpage == "manageCashApplyPerson")
{
// coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manageCashApplyPerson.aspx?pageindex=" + Request["pageindex"] + "&status=" + Request["status"] + "&parentpage=" + Request["parentpage"] + "\";</script>";
coutws = "alert(\"操作成功！现在进入列表页面\"); location.href = \"manageCashApplyPerson.aspx?pageindex=" + Request["pageindex"] + "&status=" + Request["status"] + "&parentpage=" + Request["parentpage"] + "\";";
}
else
{
// coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manageCashApply.aspx?pageindex=" + Request["pageindex"] + "&status=" + Request["status"] + "\";</script>";
coutws = "alert(\"操作成功！现在进入列表页面\"); location.href = \"manageCashApply.aspx?pageindex=" + Request["pageindex"] + "&status=" + Request["status"] + "\";";
}
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", coutws, true);
// Response.Write(coutws);
}
catch
{
tag.Text = "操作失败，请重试！";
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Dianda.Model.Cash_Cards model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Cash_Cards(");
strSql.Append("CardNum,CardName,CardholderID,DepartmentID,ProjectID,Balance,LimitNums,ApproverIDs,DATETIME,Statas,DoUserID,EndTime,TEMP0,TEMP1,TEMP2,TEMP3,SpecialFundsID,SFOrderID,YEBalance)");
strSql.Append(" values (");
strSql.Append("@CardNum,@CardName,@CardholderID,@DepartmentID,@ProjectID,@Balance,@LimitNums,@ApproverIDs,@DATETIME,@Statas,@DoUserID,@EndTime,@TEMP0,@TEMP1,@TEMP2,@TEMP3,@SpecialFundsID,@SFOrderID,@YEBalance)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CardNum", SqlDbType.VarChar, 50),
new SqlParameter("@CardName", SqlDbType.VarChar, 50),
new SqlParameter("@CardholderID", SqlDbType.VarChar, 50),
new SqlParameter("@DepartmentID", SqlDbType.VarChar, 50),
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@Balance", SqlDbType.Float, 8),
new SqlParameter("@LimitNums", SqlDbType.Float, 8),
new SqlParameter("@ApproverIDs", SqlDbType.VarChar, 50),
new SqlParameter("@DATETIME", SqlDbType.DateTime),
new SqlParameter("@Statas", SqlDbType.Int, 4),
new SqlParameter("@DoUserID", SqlDbType.VarChar, 50),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@TEMP0", SqlDbType.VarChar, 5000),
new SqlParameter("@TEMP1", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP2", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP3", SqlDbType.VarChar, 50),
new SqlParameter("@SpecialFundsID", SqlDbType.Int, 4),
new SqlParameter("@SFOrderID", SqlDbType.Int, 4),
new SqlParameter("@YEBalance", SqlDbType.Float, 8)
};
parameters[0].Value = model.CardNum;
parameters[1].Value = model.CardName;
parameters[2].Value = model.CardholderID;
parameters[3].Value = model.DepartmentID;
parameters[4].Value = model.ProjectID;
parameters[5].Value = model.Balance;
parameters[6].Value = model.LimitNums;
parameters[7].Value = model.ApproverIDs;
parameters[8].Value = model.DATETIME;
parameters[9].Value = model.Statas;
parameters[10].Value = model.DoUserID;
parameters[11].Value = model.EndTime;
parameters[12].Value = model.TEMP0;
parameters[13].Value = model.TEMP1;
parameters[14].Value = model.TEMP2;
parameters[15].Value = model.TEMP3;
parameters[16].Value = model.SpecialFundsID;
parameters[17].Value = model.SFOrderID;
parameters[18].Value = model.YEBalance;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dianda.Model.Cash_Cards GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CardNum,CardName,CardholderID,DepartmentID,ProjectID,Balance,LimitNums,ApproverIDs,DATETIME,Statas,DoUserID,EndTime,TEMP0,TEMP1,TEMP2,TEMP3,SpecialFundsID,SFOrderID,YEBalance from Cash_Cards ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Dianda.Model.Cash_Cards model = new Dianda.Model.Cash_Cards();
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.CardNum = ds.Tables[0].Rows[0]["CardNum"].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]["Balance"].ToString() != "")
{
model.Balance = decimal.Parse(ds.Tables[0].Rows[0]["Balance"].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());
}
if (ds.Tables[0].Rows[0]["Statas"].ToString() != "")
{
model.Statas = int.Parse(ds.Tables[0].Rows[0]["Statas"].ToString());
}
model.DoUserID = ds.Tables[0].Rows[0]["DoUserID"].ToString();
if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "")
{
model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString());
}
model.TEMP0 = ds.Tables[0].Rows[0]["TEMP0"].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();
if (ds.Tables[0].Rows[0]["SpecialFundsID"].ToString() != "")
{
model.SpecialFundsID = int.Parse(ds.Tables[0].Rows[0]["SpecialFundsID"].ToString());
}
if (ds.Tables[0].Rows[0]["SFOrderID"].ToString() != "")
{
model.SFOrderID = int.Parse(ds.Tables[0].Rows[0]["SFOrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["YEBalance"].ToString() != "")
{
model.YEBalance = decimal.Parse(ds.Tables[0].Rows[0]["YEBalance"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Dianda.Model.Cash_Cards model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Cash_Cards set ");
strSql.Append("CardNum=@CardNum,");
strSql.Append("CardName=@CardName,");
strSql.Append("CardholderID=@CardholderID,");
strSql.Append("DepartmentID=@DepartmentID,");
strSql.Append("ProjectID=@ProjectID,");
strSql.Append("Balance=@Balance,");
strSql.Append("LimitNums=@LimitNums,");
strSql.Append("ApproverIDs=@ApproverIDs,");
strSql.Append("DATETIME=@DATETIME,");
strSql.Append("Statas=@Statas,");
strSql.Append("DoUserID=@DoUserID,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("TEMP0=@TEMP0,");
strSql.Append("TEMP1=@TEMP1,");
strSql.Append("TEMP2=@TEMP2,");
strSql.Append("TEMP3=@TEMP3,");
strSql.Append("SpecialFundsID=@SpecialFundsID,");
strSql.Append("SFOrderID=@SFOrderID,");
strSql.Append("YEBalance=@YEBalance");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@CardNum", SqlDbType.VarChar, 50),
new SqlParameter("@CardName", SqlDbType.VarChar, 50),
new SqlParameter("@CardholderID", SqlDbType.VarChar, 50),
new SqlParameter("@DepartmentID", SqlDbType.VarChar, 50),
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@Balance", SqlDbType.Float, 8),
new SqlParameter("@LimitNums", SqlDbType.Float, 8),
new SqlParameter("@ApproverIDs", SqlDbType.VarChar, 50),
new SqlParameter("@DATETIME", SqlDbType.DateTime),
new SqlParameter("@Statas", SqlDbType.Int, 4),
new SqlParameter("@DoUserID", SqlDbType.VarChar, 50),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@TEMP0", SqlDbType.VarChar, 5000),
new SqlParameter("@TEMP1", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP2", SqlDbType.VarChar, 50),
new SqlParameter("@TEMP3", SqlDbType.VarChar, 50),
new SqlParameter("@SpecialFundsID", SqlDbType.Int, 4),
new SqlParameter("@SFOrderID", SqlDbType.Int, 4),
new SqlParameter("@YEBalance", SqlDbType.Float, 8)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.CardNum;
parameters[2].Value = model.CardName;
parameters[3].Value = model.CardholderID;
parameters[4].Value = model.DepartmentID;
parameters[5].Value = model.ProjectID;
parameters[6].Value = model.Balance;
parameters[7].Value = model.LimitNums;
parameters[8].Value = model.ApproverIDs;
parameters[9].Value = model.DATETIME;
parameters[10].Value = model.Statas;
parameters[11].Value = model.DoUserID;
parameters[12].Value = model.EndTime;
parameters[13].Value = model.TEMP0;
parameters[14].Value = model.TEMP1;
parameters[15].Value = model.TEMP2;
parameters[16].Value = model.TEMP3;
parameters[17].Value = model.SpecialFundsID;
parameters[18].Value = model.SFOrderID;
parameters[19].Value = model.YEBalance;
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
{
//项目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
{
}
}