public async Task <ApiResult> PlanItemCha(int id, APIProjectPlanViewmodel p)
{
// 以接口的形式返回数据
var res = new ApiResult();
try
{
ProjectPlanInfo m = plandb.GetId(id);
//m.ProjectID = p.ProjectID;
//m.ProjectNodeID = p.ProjectNodeID;
m.Principal = p.Principal;
m.ProjectModifyID = p.ProjectModifyID;
m.BeginDate = C.DateTimes(p.BeginDate);
m.EndDate = C.DateTimes(p.EndDate);
m.CompleteDate = C.DateTimes(p.CompleteDate);
m.IsComplete = p.IsComplete;
m.IsEnable = p.IsEnable;
m.Sorting = p.Sorting;
m.Contents = p.Contents;
res.success = plandb.Update(m) > 0;
}
catch (Exception ex)
{
res.statusCode = (int)ApiEnum.Error;
res.msg = ApiEnum.Error.GetEnumText() + ex.Message;
}
// {"success":true,"message":null,"statusCode":200,"data":null}
return(await Task.Run(() => res));
}
public async Task <ApiResult> PlanItemCha(APIProjectPlanViewmodel p)
{
// 以接口的形式返回数据
var res = new ApiResult();
try
{
ProjectPlanInfo m = new ProjectPlanInfo()
{
ProjectID = p.ProjectID,
ProjectNodeID = p.ProjectNodeID,
Principal = p.Principal,
UserID = p.Principal,
ProjectModifyID = p.ProjectModifyID,
BeginDate = C.DateTimes(p.BeginDate),
EndDate = C.DateTimes(p.EndDate),
CompleteDate = C.DateTimes(p.CompleteDate),
Sorting = p.Sorting,
IsComplete = p.IsComplete,
Contents = p.Contents,
AddDate = DateTime.Now,
IsEnable = p.IsEnable
};
res.success = plandb.Add(m) > 0;
}
catch (Exception ex)
{
res.statusCode = (int)ApiEnum.Error;
res.msg = ApiEnum.Error.GetEnumText() + ex.Message;
}
// {"success":true,"message":null,"statusCode":200,"data":null}
return(await Task.Run(() => res));
}
/// <summary>
/// 获取Excel数据
/// </summary>
/// <param name="fileName"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
private static List <ProjectPlanInfo> GetExcelData(string fileName)
{
var list = new List <ProjectPlanInfo>();
var url = System.AppDomain.CurrentDomain.BaseDirectory + fileName;
Workbook book = new Workbook(url);
Worksheet sheet = book.Worksheets[0];
Cells cells = sheet.Cells;
DataTable dt = cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1, true);
if (dt.Rows.Count > 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
var i = 0;
var dr = dt.Rows[j];
var model = new ProjectPlanInfo();
model.LineId = Convert.ToInt64(dr[i++].ToString());
model.ProjectNo = dr[i++].ToString();
model.Province = dr[i++].ToString();
model.Company = dr[i++].ToString();
model.CLevel = dr[i++].ToString();
model.ProjectName = dr[i++].ToString();
model.Catagory = dr[i++].ToString();
model.PType = dr[i++].ToString();
model.Nature = dr[i++].ToString();
model.IsBegin = dr[i++].ToString();
model.IsWork = dr[i++].ToString();
model.Vlength = dr[i++].ToString();
model.Volume = dr[i++].ToString();
model.CycleNum = dr[i++].ToString();
model.GroupNum = dr[i++].ToString();
model.Address = dr[i++].ToString();
model.Pre_fno = dr[i++].ToString();
var tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Pre_bdt = Convert.ToDateTime(tempStr);
}
model.Pre_yno = dr[i++].ToString();
model.Pre_sno = dr[i++].ToString();
model.Pre_isable = dr[i++].ToString();
model.Pre_hno = dr[i++].ToString();
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Pre_hdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Pre_pdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Pre_sdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_zdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_kdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_sdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_fdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_ydt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_wdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_bdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_jdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_gdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_xdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_ldt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_pdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_cdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_hdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_ddt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Start_rdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Build_bdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Build_sdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Build_xdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Build_ydt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Build_hdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Build_cdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Build_tdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Finish_jdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Finish_fdt = Convert.ToDateTime(tempStr);
}
tempStr = dr[i++].ToString();
if (!string.IsNullOrEmpty(tempStr) && tempStr.ToLower() != "null")
{
model.Finish_zdt = Convert.ToDateTime(tempStr);
}
model.DynamicNum = Convert.ToDecimal(dr[i++].ToString());
model.DemandNum = Convert.ToDecimal(dr[i++].ToString());
model.TotalNum = Convert.ToDecimal(dr[i++].ToString());
model.PlanNum = Convert.ToDecimal(dr[i++].ToString());
model.Progress = dr[i++].ToString();
model.Remark = dr[i++].ToString();
model.Important_high = dr[i++].ToString();
model.Important_assort = dr[i++].ToString();
model.Important_strong = dr[i++].ToString();
model.Important_iron = dr[i++].ToString();
model.Important_rail = dr[i++].ToString();
model.Important_wind = dr[i++].ToString();
model.Important_light = dr[i++].ToString();
model.Important_give = dr[i++].ToString();
model.Important_farmer = dr[i++].ToString();
model.Important_summary = dr[i++].ToString();
model.Months = dr[i++].ToString();
model.WorkReady = dr[i++].ToString();
model.WorkSet = dr[i++].ToString();
model.WorkStart = dr[i++].ToString();
model.WorkBid = dr[i++].ToString();
model.WorkCheck = dr[i++].ToString();
list.Add(model);
}
}
return(list);
}
/// <summary>
/// function insert/update project plan information
/// </summary>
/// <param name="data">ProjectPlanInfo</param>
/// <returns>number of record is update/insert</returns>
public int EditProjectPlanData(ProjectPlanInfo data)
{
return(this._repository.EditProjectPlanData(data));
}
