public ActionResult getDeclareInfo(FormCollection collect)
{
Model.declareViewModel d_project = new Model.declareViewModel();
d_project.project_name=Request["project_name"];
d_project.declarant_id = (string)SessionHelper.Get("ID");
// d_project.declarant_id = (string)Session["ID"];
d_project.phone = Request["mainer_phone"];
d_project.email=Request["mainer_email"];
d_project.leader=Request["mainer_name"];
d_project.p_type=Request["p_type"];
d_project.now_level=Request["now_level"];
d_project.target_level=Request["target_level"];
d_project.s_time=Convert.ToDateTime(Request["s_time"]);
d_project.f_time = Convert.ToDateTime(Request["f_time"]);
d_project.money = Convert.ToInt16(Request["money"]);
d_project.p_id = BLL.ProjectServer.getProjectNum() + 1;
d_project.create_time = DateTime.Now;
//d_project.belongs=(string)Session["belongs"];
d_project.belongs = SessionHelper.Get("p_belongs");
string[] ts_time = collect.GetValues("ts_time");
string[] tf_time = collect.GetValues("tf_time");
string[] t_content = collect.GetValues("t_content");
string[] member2 = collect.GetValues("member");
d_project.member = new List<Member>();
foreach (string m in member2)
{
Model.Member mem=new Model.Member();
mem.nickname = m;
mem.project_id = BLL.ProjectServer.getProjectNum()+1;
d_project.member.Add(mem);
}
d_project.task = new List<Task>();
for(int i=1;i<=ts_time.Count();i++){
Task t = new Task();
t.t_id = i;
t.s_time=Convert.ToDateTime(ts_time[i-1]);
t.f_time=Convert.ToDateTime(tf_time[i-1]);
t.task_content=t_content[i-1];
d_project.task.Add(t);
}
HttpPostedFileBase paper_file=Request.Files["paper_file"];
HttpPostedFileBase report_file = Request.Files["report_file"];
HttpPostedFileBase whole_file = Request.Files["whole_file"];
d_project.report_file = "~/Upload/" + d_project.p_id + "/" +"report/"+ report_file.FileName;
d_project.paper_file = "~/Upload/" + d_project.p_id + "/" + "paper/"+paper_file.FileName;
d_project.whole_file = "~/Upload/" + d_project.p_id + "/" + "wholefile/"+whole_file.FileName;
if (BLL.DeclareService.declareProject(d_project))
{
Common.UpLoadServer.UploadFile(d_project, report_file, report_file, whole_file);
}
return Content("a");
}
public ActionResult getDeclareInfo(FormCollection collect)
{
Model.declareViewModel d_project = new Model.declareViewModel();
d_project.project_name = Request["project_name"];
d_project.declarant_id = (string)SessionHelper.Get("ID");
// d_project.declarant_id = (string)Session["ID"];
d_project.phone = Request["mainer_phone"];
d_project.email = Request["mainer_email"];
d_project.leader = Request["mainer_name"];
d_project.p_type = Request["p_type"];
d_project.now_level = Request["now_level"];
d_project.target_level = Request["target_level"];
d_project.s_time = Convert.ToDateTime(Request["s_time"]);
d_project.f_time = Convert.ToDateTime(Request["f_time"]);
d_project.money = Convert.ToInt16(Request["money"]);
d_project.p_id = BLL.ProjectServer.getProjectNum() + 1;
d_project.create_time = DateTime.Now;
//d_project.belongs=(string)Session["belongs"];
d_project.belongs = SessionHelper.Get("p_belongs");
string[] ts_time = collect.GetValues("ts_time");
string[] tf_time = collect.GetValues("tf_time");
string[] t_content = collect.GetValues("t_content");
string[] member2 = collect.GetValues("member");
d_project.member = new List <Member>();
foreach (string m in member2)
{
Model.Member mem = new Model.Member();
mem.nickname = m;
mem.project_id = BLL.ProjectServer.getProjectNum() + 1;
d_project.member.Add(mem);
}
d_project.task = new List <Task>();
for (int i = 1; i <= ts_time.Count(); i++)
{
Task t = new Task();
t.t_id = i;
t.s_time = Convert.ToDateTime(ts_time[i - 1]);
t.f_time = Convert.ToDateTime(tf_time[i - 1]);
t.task_content = t_content[i - 1];
d_project.task.Add(t);
}
HttpPostedFileBase paper_file = Request.Files["paper_file"];
HttpPostedFileBase report_file = Request.Files["report_file"];
HttpPostedFileBase whole_file = Request.Files["whole_file"];
d_project.report_file = "~/Upload/" + d_project.p_id + "/" + "report/" + report_file.FileName;
d_project.paper_file = "~/Upload/" + d_project.p_id + "/" + "paper/" + paper_file.FileName;
d_project.whole_file = "~/Upload/" + d_project.p_id + "/" + "wholefile/" + whole_file.FileName;
if (BLL.DeclareService.declareProject(d_project))
{
Common.UpLoadServer.UploadFile(d_project, report_file, report_file, whole_file);
}
return(Content("a"));
}
public static void UploadFile(Model.declareViewModel project, HttpPostedFileBase report, HttpPostedFileBase paper, HttpPostedFileBase wholefile)
{
string report_path = "~/Upload/" + project.p_id + "/" + "report";
string paper_path = "~/Upload/" + project.p_id + "/" + "paper";
string whole_path = "~/Upload/" + project.p_id + "/" + "wholefile";
if (Directory.Exists(HttpContext.Current.Server.MapPath("~/Upload/" + project.p_id)) == false)
{
Directory.CreateDirectory(HttpContext.Current.Server.MapPath(report_path));
Directory.CreateDirectory(HttpContext.Current.Server.MapPath(paper_path));
Directory.CreateDirectory(HttpContext.Current.Server.MapPath(whole_path));
}
System.IO.DirectoryInfo DirInfo1 = new DirectoryInfo(HttpContext.Current.Server.MapPath(report_path));
DirInfo1.Attributes = FileAttributes.Normal & FileAttributes.Directory;
System.IO.DirectoryInfo DirInfo2 = new DirectoryInfo(HttpContext.Current.Server.MapPath(paper_path));
DirInfo2.Attributes = FileAttributes.Normal & FileAttributes.Directory;
System.IO.DirectoryInfo DirInfo3 = new DirectoryInfo(HttpContext.Current.Server.MapPath(whole_path));
DirInfo3.Attributes = FileAttributes.Normal & FileAttributes.Directory;
report.SaveAs(HttpContext.Current.Server.MapPath(report_path) + report.FileName);
paper.SaveAs(HttpContext.Current.Server.MapPath(paper_path) + paper.FileName);
wholefile.SaveAs(HttpContext.Current.Server.MapPath(whole_path) + wholefile.FileName);
}
public static bool declareProject(Model.declareViewModel project)
{
int result = 0;
string str = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
string sql = "insert into Project values(@p_id,@p_name,@declarant_id,@type,@now_level,@target_level,@start_time,@end_time,@money,@report_file,@paper_file,@whole_file,'a',@belongs,@create_time);"
+ "insert into Leader values(@p_id,@nickname,@phone,@email);";
string sqlmember = null;
string sqltask = null;
foreach (Model.Member m in project.member)
{
sqlmember += "insert into Member values(@p_id,'" + m.nickname + "');";
}
foreach (Model.Task t in project.task)
{
sqltask += "insert into Task values(" + t.t_id + ",@nickname,'" + t.s_time + "','" + t.f_time + "','" + t.task_content + "',@p_id,'a');";
}
sql = sql + sqltask + sqlmember;
SqlParameter[] pars =
{
new SqlParameter("@p_id", SqlDbType.Int, 32),
new SqlParameter("@p_name", SqlDbType.NVarChar, 32),
new SqlParameter("@declarant_id", SqlDbType.NVarChar, 32),
new SqlParameter("@type", SqlDbType.NVarChar, 32),
new SqlParameter("@now_level", SqlDbType.NVarChar, 32),
new SqlParameter("@target_level", SqlDbType.NVarChar, 32),
new SqlParameter("@start_time", SqlDbType.DateTime, 32),
new SqlParameter("@end_time", SqlDbType.DateTime, 32),
new SqlParameter("@money", SqlDbType.NVarChar, 32),
new SqlParameter("@report_file", SqlDbType.NVarChar, 32),
new SqlParameter("@paper_file", SqlDbType.NVarChar, 32),
new SqlParameter("@whole_file", SqlDbType.NVarChar, 32),
new SqlParameter("@belongs", SqlDbType.NVarChar, 32),
new SqlParameter("@create_time", SqlDbType.DateTime, 32),
new SqlParameter("@nickname", SqlDbType.NVarChar, 32),
new SqlParameter("@phone", SqlDbType.NVarChar, 32),
new SqlParameter("@email", SqlDbType.NVarChar, 32),
};
pars[0].Value = project.p_id;
pars[1].Value = project.project_name;
pars[2].Value = project.declarant_id;
pars[3].Value = project.p_type;
pars[4].Value = project.now_level;
pars[5].Value = project.target_level;
pars[6].Value = project.s_time;
pars[7].Value = project.f_time;
pars[8].Value = project.money;
pars[9].Value = project.report_file;
pars[10].Value = project.paper_file;
pars[11].Value = project.whole_file;
pars[12].Value = project.belongs;
pars[13].Value = project.create_time;
pars[14].Value = project.leader;
pars[15].Value = project.phone;
pars[16].Value = project.email;
// command.CommandText = "insert into Project values(1,'2','20131003612','4','5','6','2015/11/11','2015/11/12',100,'10','11','12','a','a','2015/11/11'); ";
result = SqlHelper.ExecuteNonquery(sql, CommandType.Text, pars);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool declareProject(Model.declareViewModel project)
{
return(DAL.DeclareDAL.declareProject(project));
}
