/// <summary>
/// 编辑台帐
/// </summary>
/// <param name="tztask"></param>
/// <returns></returns>
public int EditAccountTask(AccountTaskModel tztask, List <FileUploadClass> list)
{
using (Entities db = new Entities())
{
int count = 0;
tz_tztasks model = db.tz_tztasks.Where(t => t.taskid == tztask.taskid).FirstOrDefault();
if (model != null)
{
model.endtime = tztask.endtime;
model.remark = tztask.remark;
model.starttime = tztask.starttime;
model.taskname = tztask.taskname;
model.taskyear = tztask.taskyear;
model.tz_type = tztask.tz_type;
// model.tz_json = tztask.tz_json;
// model.sszd = tztask.sszd;
// IQueryable<tz_taskclasses> iqueryable = db.tz_taskclasses.Where(t => t.taskid == tztask.taskid);
//foreach (tz_taskclasses item in iqueryable)
//{
// db.tz_taskclasses.Remove(item);
//}
//foreach (var item in list_tzclass)
//{
// tz_taskclasses tz = new tz_taskclasses();
// tz.classid = item.classid;
// tz.sszd = item.sszd;
// tz.status = item.status;
// tz.tasktime = item.tasktime;
// tz.taskid = model.taskid;
// db.tz_taskclasses.Add(tz);
//}
foreach (var item in list)
{
tz_files file = new tz_files();
file.filename = item.OriginalName;
file.filepath = item.OriginalPath;
file.filetype = item.OriginalType;
file.filesource = 1;
file.sourceid = tztask.taskid;
file.filesize = item.size;
db.tz_files.Add(file);
}
count = db.SaveChanges();
}
return(count);
}
}
/// <summary>
/// 添加台帐任务
/// </summary>
/// <param name="tztask"></param>
/// <returns></returns>
public int AddAccountTask(AccountTaskModel tztask, List <FileUploadClass> list, List <tz_taskclasses> list_tzclass)
{
using (Entities db = new Entities())
{
tz_tztasks model = new tz_tztasks();
model.createtime = tztask.createtime;
model.createuserid = tztask.createuserid;
model.endtime = tztask.endtime;
model.remark = tztask.remark;
model.starttime = tztask.starttime;
model.taskname = tztask.taskname;
model.taskyear = tztask.taskyear;
model.tz_type = tztask.tz_type;
model.tz_json = tztask.tz_json;
model.sszd = tztask.sszd;
model.ssrw = tztask.ssrw;
db.tz_tztasks.Add(model);
db.SaveChanges();
foreach (var item in list_tzclass)
{
tz_taskclasses tz = new tz_taskclasses();
tz.classid = item.classid;
tz.sszd = item.sszd;
tz.status = item.status;
tz.tasktime = item.tasktime;
tz.taskid = model.taskid;
db.tz_taskclasses.Add(tz);
}
foreach (var item in list)
{
tz_files file = new tz_files();
file.filename = item.OriginalName;
file.filepath = item.OriginalPath;
file.filetype = item.OriginalType;
file.filesource = 1;
file.sourceid = model.taskid;
file.filesize = item.size;
db.tz_files.Add(file);
}
db.SaveChanges();
return(1);
}
}
public HttpResponseMessage AddAccountTask(AccountTaskModel model)
{
HttpRequestBase request = ((HttpContextWrapper)this.Request.Properties["MS_HttpContext"]).Request;
string[] fileClass = model.uploadpanelValue;
List <FileUploadClass> list = new List <FileUploadClass>();
if (fileClass != null && fileClass.Length > 0)
{
foreach (var item in fileClass)
{
FileUploadClass file = new FileUploadClass();
JObject jo = new JObject();
jo = (JObject)JsonConvert.DeserializeObject(item);
file.OriginalPath = jo["OriginalPath"] == null ? "" : jo["OriginalPath"].ToString();
file.OriginalName = jo["OriginalName"] == null ? "" : jo["OriginalName"].ToString();
file.OriginalType = jo["OriginalType"] == null ? "" : jo["OriginalType"].ToString();
file.size = jo["size"] == null ? 0 : (double)jo["size"];
list.Add(file);
}
}
List <tz_taskclasses> list_tzclass = new List <tz_taskclasses>();
string sszd = string.Empty;
if (!string.IsNullOrEmpty(model.tz_json))
{
JArray jo = new JArray();
jo = (JArray)JsonConvert.DeserializeObject(model.tz_json);
foreach (JObject item in jo)
{
if (item["zd_name"] == null)
{
continue;
}
else
{
string typeclassID = zdbll.GetIdByName(item["zd_name"].ToString(), "type_task");
string zd_name = item["zd_name"].ToString();
if (item["机动中队"] != null)
{
list_tzclass.Add(Gettz_taskclasses(item, "机动中队", typeclassID));
}
if (item["新城中队"] != null)
{
list_tzclass.Add(Gettz_taskclasses(item, "新城中队", typeclassID));
}
if (item["高照中队"] != null)
{
list_tzclass.Add(Gettz_taskclasses(item, "高照中队", typeclassID));
}
if (item["王店中队"] != null)
{
list_tzclass.Add(Gettz_taskclasses(item, "王店中队", typeclassID));
}
if (item["洪合中队"] != null)
{
list_tzclass.Add(Gettz_taskclasses(item, "洪合中队", typeclassID));
}
if (item["新塍中队"] != null)
{
list_tzclass.Add(Gettz_taskclasses(item, "新塍中队", typeclassID));
}
if (item["王江泾中队"] != null)
{
list_tzclass.Add(Gettz_taskclasses(item, "王江泾中队", typeclassID));
}
if (item["油车港中队"] != null)
{
list_tzclass.Add(Gettz_taskclasses(item, "油车港中队", typeclassID));
}
}
}
}
model.createtime = DateTime.Now;
if (!string.IsNullOrEmpty(request.Form["userid"]))
{
model.createuserid = Convert.ToInt32(request.Form["userid"]);
}
model.createtime = DateTime.Now;
int result = bll.AddAccountTask(model, list, list_tzclass);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html");
return(response);
}
/// <summary>
/// 编辑台帐任务
/// </summary>
/// <param name="tztask"></param>
/// <param name="list"></param>
/// <returns></returns>
public int EditAccountTask(AccountTaskModel tztask, List <FileUploadClass> list)
{
return(dal.EditAccountTask(tztask, list));
}
/// <summary>
/// 添加台帐任务
/// </summary>
/// <param name="tztask"></param>
/// <param name="TypeArr"></param>
public int AddAccountTask(AccountTaskModel tztask, List <FileUploadClass> list, List <tz_taskclasses> list_tzclass)
{
return(dal.AddAccountTask(tztask, list, list_tzclass));
}
