protected void btn_submit_Click(object sender, EventArgs e)
{
int ID = Convert.ToInt32(Request.QueryString["id"]);
WebModels.Tbl_ProjectArchive archive = WebBLL.Tbl_ProjectArchiveManager.GetTbl_ProjectArchiveById(ID);
archive.PA_Type1 = this.PA_Type1.SelectedValue;
archive.PA_Type2 = this.PA_Type2.SelectedValue;
archive.ParentID = 0;
archive.PA_Name = this.PA_Name.Value;
if (PA_File.FileName != "")
{
archive.PA_File = WebCommon.Public.UploadFile(PA_File, "ProjectArchive");
}
archive.PA_Limit = this.PA_Limit.SelectedValue;
archive.PA_FileNo = this.PA_FileNo.Value;
archive.PA_Info = this.PA_Info.Value;;
archive.Status = this.Status.SelectedValue;
archive.DealUser = WebCommon.Public.GetUserName();
int count = WebBLL.Tbl_ProjectArchiveManager.UpdateTbl_ProjectArchive(archive);
if (count > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('修改成功!');window.external.reload();window.external.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('修改失败!');", true);
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
WebModels.Tbl_ProjectArchive archive = new WebModels.Tbl_ProjectArchive();
archive.ProjectID = Convert.ToInt32(this.ProjectID.SelectedValue);
archive.ClassName1 = this.ClassName1.SelectedItem.Text;
archive.ClassName2 = this.ClassName2.SelectedItem.Text;
archive.ClassName3 = this.ClassName3.SelectedItem.Text;
archive.PA_Type1 = this.PA_Type1.SelectedValue;
archive.PA_Type2 = this.PA_Type2.SelectedValue;
archive.ParentID = 0;
archive.PA_Limit = this.PA_Limit.SelectedValue;
archive.PA_Name = this.PA_Name.Value;
archive.PA_File = WebCommon.Public.UploadFile(PA_File, "ProjectArchive");
archive.PA_FileNo = this.PA_FileNo.Value;
archive.PA_Info = this.PA_Info.Value;;
archive.Status = this.Status.SelectedValue;
archive.DealUser = WebCommon.Public.GetUserName();
int count = WebBLL.Tbl_ProjectArchiveManager.AddTbl_ProjectArchive(archive);
if (count > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('添加成功!');window.external.reload();window.external.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('添加失败!');", true);
}
}
public void Bind()
{
int ID = Convert.ToInt32(Request.QueryString["id"]);
WebModels.Tbl_ProjectArchive project = WebBLL.Tbl_ProjectArchiveManager.GetTbl_ProjectArchiveById(ID);
this.ProjectID.Text = project.ProjectID.ToString();
this.ClassName1.Value = project.ClassName1;
this.ClassName2.Value = project.ClassName2;
this.ClassName3.Value = project.ClassName3;
this.PA_Type1.Text = project.PA_Type1;
this.PA_Type2.Text = project.PA_Type2;
PA_FilePath = project.PA_File;
this.ParentID.SelectedValue = project.ParentID.ToString();
this.PA_Limit.SelectedValue = project.PA_Limit;
this.PA_Name.Value = project.PA_Name;
this.PA_FileNo.Value = project.PA_FileNo;
this.PA_Info.Value = project.PA_Info;;
this.Status.Text = project.Status;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//删除
if (Request.QueryString["limit"] == "del")
{
string ids = Request.QueryString["id"].ToString();
WebModels.Tbl_ProjectArchive archive = WebBLL.Tbl_ProjectArchiveManager.GetTbl_ProjectArchiveById(Convert.ToInt32(ids));
if (archive.Status == "已审核")
{
WebCommon.Script.AlertAndGoBack("不允许删除！");
}
else
{
int count = WebCommon.Public.DataTableDel("tbl_ProjectArchive", "id in(" + ids + ")");
if (count > 0)
{
WebCommon.Script.Redirect(WebCommon.Public.GetFromUrl());
}
else
{
WebCommon.Script.AlertAndGoBack("删除失败！");
}
}
}
//绑定列表
Bind();
//管理权限
if (WebBLL.Tbl_ConfigManager.GetTbl_ConfigById(1).C_Set1.Contains(WebCommon.Public.GetUserName()))
{
limitShow = "";
}
else
{
limitShow = "none";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string typeStr = WebCommon.Public.ToString(Request.QueryString["Type"]);
int ProjectID = WebCommon.Public.ToInt(Request.QueryString["ProjectID"]);
//如果领导未审撤回
if (typeStr == "cancel")
{
WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(ProjectID);
project.NodeNo = "项目撤回";
project.NodeUser = project.UserName;
project.Status = "结束";
WebBLL.Tbl_ProjectManager.UpdateTbl_Project(project);
WebCommon.Script.AlertAndGoBack("撤回成功");
}
//项目结束并存档
if (typeStr == "save")
{
int count = 0;
int DesignTaskID = 0;// WebCommon.Public.ToInt(WebBLL.Tbl_DesignTaskManager.GetDataTableByPage(1, 1, "ProjectID=" + ProjectID.ToString(), "id desc").Rows[0]["ID"]);
foreach (System.Data.DataRow dr in WebBLL.Tbl_DesignTaskManager.GetDataTableByPage(100, 1, "ProjectID=" + ProjectID.ToString(), "id desc").Rows)
{
DesignTaskID = Convert.ToInt32(dr["ID"]);
WebModels.Tbl_DesignTask designtask = WebBLL.Tbl_DesignTaskManager.GetTbl_DesignTaskById(DesignTaskID);
WebModels.Tbl_ProjectArchive archive = new WebModels.Tbl_ProjectArchive();
archive.ProjectID = designtask.ProjectID;
archive.ClassName1 = designtask.ClassName1;
archive.ClassName2 = designtask.ClassName2;
archive.ClassName3 = designtask.ClassName3;
archive.PA_Type1 = "项目档案";
archive.PA_Type2 = "电子版";
archive.ParentID = 0;
archive.PA_Limit = "普通";
archive.PA_Name = designtask.ClassName3;
archive.PA_File = WebBLL.Tbl_DesignCorrectManager.GetDataTableByPage(1, 1, "DesignTaskID=" + designtask.ID + " and Tbl_DesignCorrect.status='结束'", "Tbl_DesignCorrect.id desc").Rows[0]["DC_File"].ToString();
archive.PA_FileNo = "";
archive.PA_Info = "项目流程自动存档";
archive.Status = "已审核";
archive.DealUser = WebCommon.Public.GetUserName();
WebBLL.Tbl_ProjectArchiveManager.AddTbl_ProjectArchive(archive);
count++;
}
if (count > 0)
{
WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(ProjectID);
project.Status = "结束";
WebBLL.Tbl_ProjectManager.UpdateTbl_Project(project);
WebCommon.Script.AlertAndGoBack("项目自动存档成功");
}
else
{
WebCommon.Script.AlertAndGoBack("存档失败");
}
}
//绑定项目工作
string username = WebCommon.Public.GetUserName();
//进行中的节点用户或如果是设计工作处理节点的任务工作者
string whereStr = "status='进行中' and (nodeuser like '%" + username + "%' or (nodeno='设计工作处理' and (select count(*) from tbl_designtask where projectid=tbl_project.id and (dt_shejiren='" + username + "' or dt_jiaoduiren='" + username + "' or dt_shenheren='" + username + "' or dt_shendingren='" + username + "'))>0))";
Rep_List.DataSource = WebBLL.Tbl_ProjectManager.GetDataTableByPage(30, 1, whereStr, "id desc");
Rep_List.DataBind();
//绑定任务工作//按单个任务罗列
//string strWhere = "status<>'结束' and status<>'任务录入' and status<>'任务审批' and NodeUser like '%" + WebCommon.Public.GetUserName() + "%'";
//Rep_List2.DataSource = WebBLL.Tbl_DesignTaskManager.GetDataTableByPage(30, 1, strWhere, "id desc");
//Rep_List2.DataBind();
//绑定任务工作//按单个项目罗列
string strWhere = "id in (select projectid from tbl_designtask where status<>'结束' and status<>'任务录入' and status<>'任务审批' and NodeUser like '%" + WebCommon.Public.GetUserName() + "%')";
Rep_List2.DataSource = WebBLL.Tbl_ProjectManager.GetDataTableByPage(30, 1, strWhere, "");
Rep_List2.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//会签发送
string pddesigner = WebCommon.Public.ToString(Request.QueryString["Designer"]);
int DesignTaskID = WebCommon.Public.ToInt(Request.QueryString["ID"]);
if (pddesigner != "")
{
//转入审定
if (pddesigner == "审核")
{
WebModels.Tbl_DesignTask Task = WebBLL.Tbl_DesignTaskManager.GetTbl_DesignTaskById(DesignTaskID);
Task.Status = "等待审核";
if (Task.DT_ShenHeRen != "")
{
Task.NodeUser = Task.DT_ShenHeRen;
WebBLL.Tbl_DesignTaskManager.UpdateTbl_DesignTask(Task);
WebCommon.Public.DataTableUpdate("tbl_designcorrect", "NodeUser='******',status='等待审核'", "designtaskid=" + DesignTaskID.ToString() + "");
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('转入审核成功');location.href='" + WebCommon.Public.GetFromUrl() + "';", true);
return;
}
else//没有审定人的话就结束任务并存档
{
Task.Status = "结束";
WebBLL.Tbl_DesignTaskManager.UpdateTbl_DesignTask(Task);
WebCommon.Public.DataTableUpdate("tbl_designcorrect", "status='结束'", "designtaskid=" + DesignTaskID.ToString());
WebModels.Tbl_ProjectArchive archive = new WebModels.Tbl_ProjectArchive();
archive.ProjectID = Task.ProjectID;
archive.ClassName1 = Task.ClassName1;
archive.ClassName2 = Task.ClassName2;
archive.ClassName3 = Task.ClassName3;
archive.PA_Type1 = "项目档案";
archive.PA_Type2 = "电子版";
archive.ParentID = 0;
archive.PA_Limit = "普通";
archive.PA_Name = Task.ClassName3;
archive.PA_File = WebBLL.Tbl_DesignCorrectManager.GetDataTableByPage(1, 1, "DesignTaskID=" + Task.ID + " and Tbl_DesignCorrect.status='结束'", "Tbl_DesignCorrect.id desc").Rows[0]["DC_File"].ToString();
archive.PA_FileNo = "";
archive.PA_Info = "项目流程自动存档";
archive.Status = "已审核";
archive.DealUser = WebCommon.Public.GetUserName();
WebBLL.Tbl_ProjectArchiveManager.AddTbl_ProjectArchive(archive);
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('没有审定人任务直接结束并存档成功');location.href='" + WebCommon.Public.GetFromUrl() + "';", true);
return;
}
}
else
{
//正常会签
//务必把NodeUserLast清空由此服务器端判断那个会签人不通过好下次修改设计直接返回会签人
WebCommon.Public.DataTableUpdate("tbl_designtask", "NodeUserLast='',NodeUser='******'", "id=" + DesignTaskID.ToString());
WebCommon.Public.DataTableUpdate("tbl_designcorrect", "NodeUser='******'", "designtaskid=" + DesignTaskID.ToString() + " and status='等待会签'");
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('发送会签成功');location.href='" + WebCommon.Public.GetFromUrl() + "';", true);
return;
}
}
//开始设计生成设计文件和属性文件
if (WebCommon.Public.ToString(Request.QueryString["type"]) == "开始设计")
{
int taskId = Convert.ToInt32(Request.QueryString["taskid"]);
WebModels.Tbl_DesignTask designtask = WebBLL.Tbl_DesignTaskManager.GetTbl_DesignTaskById(taskId);
//生成上传文件名
string RndName = WebBLL.Tbl_DesignTaskManager.GetTbl_DesignTasFileNamekByTaskId(taskId);
//获取专业编号
string ClassNo = WebBLL.Tbl_ClassManager.GetDataTableByPage(1, 1, "parentid=15 and classname='" + designtask.ClassName1 + "'", "").Rows[0]["remark"].ToString();
//获取项目资料生成属性
WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(designtask.ProjectID);
//生成属性文件
string folderpathStr = "/project/" + project.ProjectNo + "/" + ClassNo + "/" + designtask.DT_TuHao;
string folderPath = System.Web.HttpContext.Current.Server.MapPath(folderpathStr);
if (!System.IO.Directory.Exists(folderPath))
{
System.IO.Directory.CreateDirectory(folderPath);
}
string path = folderPath + "\\" + RndName + " - 属性.txt";
if (!System.IO.File.Exists(path))
{
System.IO.File.Create(path).Close();
}
System.Text.StringBuilder strBuilderErrorMessage = new System.Text.StringBuilder();
strBuilderErrorMessage.Append("工程名称：" + project.ProjectName + "\r\n");
strBuilderErrorMessage.Append("图纸名称：请手动输入\r\n");
strBuilderErrorMessage.Append("卷册检索号：" + designtask.ProjectNo + "|" + designtask.DT_TuHao + "\r\n");
strBuilderErrorMessage.Append("专业：" + designtask.ClassName1 + "\r\n");
strBuilderErrorMessage.Append("阶段：施工图\r\n");
strBuilderErrorMessage.Append("卷册名称：" + designtask.ClassName3);
System.IO.File.WriteAllText(path, strBuilderErrorMessage.ToString(), System.Text.Encoding.Default);
//using (System.IO.StreamWriter sw = System.IO.File.CreateText(path))
//{
// sw.Write(strBuilderErrorMessage);
// sw.Flush();
// sw.Close();
//}
//属性生成结束
string serverUrl = folderpathStr + "/" + RndName + " - 属性.txt|" + WebCommon.Public.Get_BlankFilePath;
string SaveUrl = folderpathStr + "/" + RndName + " - 属性.txt|" + folderpathStr + "/" + RndName + " - 设计.dwg";
//下载属性文件和空白CAD文件
//WebCommon.Script.ResponseScript("alert('" + serverUrl + " " + SaveUrl + "')");
WebCommon.Script.ResponseScript("window.external.download('" + serverUrl + "','" + SaveUrl + "',true)");
//WebCommon.Script.GoBack();
}
//开始提交设计文件
//if (WebCommon.Public.ToString(Request.QueryString["type"]) == "提交设计")
//{
// int taskId = Convert.ToInt32(Request.QueryString["taskid"]);
// //生成上传文件名
// string RndName = WebBLL.Tbl_DesignTaskManager.GetTbl_DesignTasFileNamekByTaskId(taskId);
// string ServerUrl = "/upload/DesignCorrect/" + RndName + " - 设计.txt";
// string ClientUrl = ServerUrl;
// //上传CAD设计文件
// WebCommon.Script.ResponseScript("window.external.download('" + ServerUrl + "','" + ClientUrl + "',true)");
// WebCommon.Script.GoBack();
//}
//绑定列表
Bind();
//绑定会签人员
WebBLL.Tbl_UserManager.GetUsersByDropDownList(Designer);
Designer.Items.Insert(0, new ListItem("选择会签人员", ""));
}
}
public void btnSave_Click(object sender, EventArgs e)
{
int CID = WebCommon.Public.ToInt(Request.QueryString["cid"]);
int TaskID = WebCommon.Public.ToInt(Request.QueryString["id"]);
if (CID > 0)
{
TaskID = WebBLL.Tbl_DesignCorrectManager.GetTbl_DesignCorrectById(CID).DesignTaskID;
}
string ClickType = WebCommon.Public.ToString(Request.QueryString["type"]);
string ActStr = "";
string FileStr = "";
switch (ClickType)
{
case "sheji":
ActStr = "校对";
FileStr = "设计";
break;
case "jiaodui":
ActStr = "会签";
if (CorrectInfo.Value != "")
{
ActStr = "设计";
}
FileStr = "校对";
break;
case "huiqian":
ActStr = "会签";
if (CorrectInfo.Value != "")
{
ActStr = "设计";
}
FileStr = "审核";
break;
case "shenhe":
ActStr = "审定";
if (CorrectInfo.Value != "")
{
ActStr = "设计";
}
FileStr = "审核";
break;
}
string FullName = WebCommon.Public.UploadFile(FileUrl, WebBLL.Tbl_DesignTaskManager.GetTbl_DesignTasFileFullNamekByTaskId(TaskID) + " - " + FileStr + FileUrl.FileName.Remove(0, FileUrl.FileName.LastIndexOf(".")));
string StatusStr = "等待";
if (FullName != "")
{
FullName = FullName.Replace("../", "/");
WebModels.Tbl_DesignTask model = WebBLL.Tbl_DesignTaskManager.GetTbl_DesignTaskById(TaskID);
StatusStr += ActStr;
switch (ClickType)
{
case "sheji":
model.NodeUser = model.DT_JiaoDuiRen;
if (model.StatusLast.Contains("校对"))
{
model.NodeUser = model.DT_JiaoDuiRen;
}
if (model.StatusLast.Contains("审核"))
{
model.NodeUser = model.DT_ShenHeRen;
}
if (model.StatusLast.Contains("审定"))
{
model.NodeUser = model.DT_ShenDingRen;
}
if (model.StatusLast.Contains("会签"))
{
model.NodeUser = model.DealUser;
}
if (model.StatusLast != "")
{
StatusStr = model.StatusLast;
}
break;
case "jiaodui":
model.NodeUser = model.DT_SheJiRen;
if (CorrectInfo.Value != "")
{
model.NodeUser = model.DT_SheJiRen;
model.StatusLast = "等待校对";
StatusStr = "等待设计";
}
break;
case "shenhe":
model.NodeUser = model.DT_ShenDingRen;
if (CorrectInfo.Value != "")
{
model.NodeUser = model.DT_SheJiRen;
model.StatusLast = "等待审核";
StatusStr = "等待设计";
}
else
{
if (model.DT_ShenDingRen == "")
{
StatusStr = "结束";
}
else
{
model.NodeUser = model.DT_ShenDingRen;
StatusStr = "等待审定";
}
}
break;
case "shending":
model.NodeUser = model.DT_SheJiRen;
if (CorrectInfo.Value != "")
{
model.NodeUser = model.DT_SheJiRen;
model.StatusLast = "等待审定";
StatusStr = "等待设计";
}
else
{
StatusStr = "结束";
}
break;
case "huiqian":
model.NodeUser = model.DT_JiaoDuiRen;
if (CorrectInfo.Value != "")
{
model.NodeUser = model.DT_SheJiRen;
model.StatusLast = "等待会签";
StatusStr = "等待设计";
}
else
{
model.NodeUser = model.DT_SheJiRen;
StatusStr = "等待会签";
}
break;
}
model.Status = StatusStr;
int count = WebBLL.Tbl_DesignTaskManager.UpdateTbl_DesignTask(model);
if (count > 0)
{
int count1 = 0;
if (ClickType == "sheji" && model.StatusLast == "")
{
WebModels.Tbl_DesignCorrect correct = new WebModels.Tbl_DesignCorrect();
correct.UserName = WebCommon.Public.GetUserName();
correct.DesignTaskID = Convert.ToInt32(TaskID);
correct.DC_Name = "";
correct.DC_File = FullName;
correct.DC_FileInfo = Correct.Value;
correct.DC_FileTime = DateTime.Now;
correct.NodeUser = model.NodeUser;
correct.Status = StatusStr;
count1 = WebBLL.Tbl_DesignCorrectManager.AddTbl_DesignCorrect(correct);
}
else
{
if (ClickType == "sheji")
{
CID = WebCommon.Public.ToInt(WebBLL.Tbl_DesignCorrectManager.GetDataTableByPage(1, 1, "designtaskid=" + TaskID.ToString(), "").Rows[0][0]);
}
WebModels.Tbl_DesignCorrect correct = WebBLL.Tbl_DesignCorrectManager.GetTbl_DesignCorrectById(CID);
switch (ClickType)
{
case "sheji":
correct.DC_File = FullName;
if (model.StatusLast.Contains("校对"))
{
correct.DC_File1Correct += Correct.Value + "<br>";
}
if (model.StatusLast.Contains("审核"))
{
correct.DC_File2Correct += Correct.Value + "<br>";
}
if (model.StatusLast.Contains("审定"))
{
correct.DC_File3Correct += Correct.Value + "<br>";
}
if (model.StatusLast.Contains("会签"))
{
correct.DC_File4Correct += Correct.Value + "<br>";
}
StatusStr = model.StatusLast;
break;
case "jiaodui":
correct.DC_File1 = FullName;
correct.DC_File1CorrectInfo += CorrectInfo.Value + "<br>";
break;
case "shenhe":
correct.DC_File2 = FullName;
correct.DC_File2CorrectInfo += CorrectInfo.Value + "<br>";
//更新评级
if (model.DT_ShenDingRen == "")
{
WebCommon.Public.ExcuteSql("update tbl_designtask set PaperNum1=" + PaperNum1.Text + ",PaperNum2=" + PaperNum2.Text + ",PaperNum3=" + PaperNum3.Text + ",CorrectLevel='" + CorrectLevel.Text + "' where id=" + TaskID.ToString());
}
break;
case "shending":
correct.DC_File3 = FullName;
correct.DC_File3CorrectInfo += CorrectInfo.Value + "<br>";
//更新评级
if (model.DT_ShenDingRen != "")
{
WebCommon.Public.ExcuteSql("update tbl_designtask set PaperNum1=" + PaperNum1.Text + ",PaperNum2=" + PaperNum2.Text + ",PaperNum3=" + PaperNum3.Text + ",CorrectLevel='" + CorrectLevel.Text + "' where id=" + TaskID.ToString());
}
break;
case "huiqian":
correct.DC_File4 = FullName;
correct.DC_File4CorrectInfo += CorrectInfo.Value + "<br>";
break;
}
correct.DC_FileTime = DateTime.Now;
correct.ErrorNum1 += WebCommon.Public.ToInt(ErrorNum1.Value);
correct.ErrorNum2 += WebCommon.Public.ToInt(ErrorNum2.Value);
correct.ErrorNum3 += WebCommon.Public.ToInt(ErrorNum3.Value);
correct.NodeUser = model.NodeUser;
correct.Status = StatusStr;
count1 = WebBLL.Tbl_DesignCorrectManager.UpdateTbl_DesignCorrect(correct);
if (correct.Status == "结束")
{
WebModels.Tbl_ProjectArchive archive = new WebModels.Tbl_ProjectArchive();
archive.ProjectID = model.ProjectID;
archive.ClassName1 = model.ClassName1;
archive.ClassName2 = model.ClassName2;
archive.ClassName3 = model.ClassName3;
archive.PA_Type1 = "项目档案";
archive.PA_Type2 = "电子版";
archive.ParentID = 0;
archive.PA_Limit = "普通";
archive.PA_Name = model.ClassName3;
archive.PA_File = correct.DC_File;
archive.PA_FileNo = "";
archive.PA_Info = "项目流程自动存档";
archive.Status = "已审核";
archive.DealUser = WebCommon.Public.GetUserName();
WebBLL.Tbl_ProjectArchiveManager.AddTbl_ProjectArchive(archive);
}
}
if (count1 > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('上传成功!');window.external.reload();window.external.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('写入失败2!');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('写入失败1!');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('上传失败!');", true);
}
}