public virtual ActionResult AddMonthlyReport(MonthlyReportModel model)
{
JsonResultData response = null;
try
{
if (!model.IsValid())
{
response = new JsonResultData
{
Code = HttpStatusCode.BadRequest,
Message = new MessageBox
{
Message = Texts.Error_InputInvalid,
Title = Texts.ErrorInValidation,
Type = MessageBoxType.danger.ToString()
}
};
return(Json((object)response));
}
//var result = _goalService.Validate(model.StartDate, model.EndDate,
// 0f, model.Amount, model.TimeType);
//if (result.Errors.Any())
//{
// response = new JsonResultData
// {
// Code = JsonResultDataCode.Error,
// Messages = new MessageBox
// {
// Messages = String.Join(" ", result.Errors),
// Title = "Error",
// Type = MessageBoxType.danger.ToString()
// }
// };
//}
//else
//{
// response = null;
//}
}
catch (Exception ex)
{
response = new JsonResultData
{
Code = HttpStatusCode.InternalServerError,
Message = new ValidationUIException(ex.Message).MessageBox
};
}
return(Json((object)response));
}
public ActionResult ExcelMonthlyReport(MonthlyReportModel model)
{
DateTime fromDate;
if (!DateTime.TryParse(model.YearMonth + "-01", out fromDate))
{
ViewBag.ErrorMessage = "必须选中一个月份才能导出月份报表";
return(View("Error"));
}
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "GBK";
Response.ContentEncoding = Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + model.YearMonth + ".xls");
model = businessProvider.QueryTransportModel(string.Empty, "ALL", "ALL", "ALL", fromDate, fromDate.AddMonths(1).AddDays(-1));
return(View("ExportMonthlyReport", model));
}
public MonthlyReportModel QueryTransportModel(string clientName, string received, string paid, string error, DateTime fromDate, DateTime toDate)
{
MonthlyReportModel listModel = new MonthlyReportModel();
using (SQLDBDataContext context = new SQLDBDataContext())
{
listModel.ItemList = (from x in context.TransportRecords
orderby x.ID descending
where (string.IsNullOrEmpty(clientName) || x.ClientName == clientName) &&
x.DeliverDate.Date >= fromDate && x.DeliverDate <= toDate &&
((received == "Y" && x.Received) || (received == "N" && !x.Received) || (received != "Y" && received != "N")) &&
((paid == "Y" && x.Paid) || (paid == "N" && !x.Paid) || (paid != "Y" && paid != "N")) &&
((error == "Y" && x.Error) || (error == "N" && !x.Error) || (error != "Y" && error != "N"))
select new TransportRecordModel()
{
ID = x.ID,
AccountPayble = x.AccountPayble,
CarLicense = x.CarLicense,
ClientName = x.ClientName,
Comment = x.Comment,
Deductions = x.Deductions,
DeliverDate = x.DeliverDate,
DeliverPrice = x.DeliverPrice,
DeliverType = x.DeliverType,
Driver = x.Driver,
FromLocation = x.FromLocation,
HandlingFee = x.HandlingFee,
PackageName = x.PackageName,
PayDate = x.PayDate,
PrePay = x.PrePay,
Quantity = x.Quantity,
Reparations = x.Reparations,
ShortBargeFee = x.ShortBargeFee,
Status = x.Status,
ToLocation = x.ToLocation,
Volume = x.Volume,
TrayNo = x.TrayNo,
OilCard = x.OilCard,
BusinessArea = x.BusinessArea,
Error = x.Error,
Paid = x.Paid,
Received = x.Received,
ReceivedDate = x.ReceivedDate
}).ToList();
}
return(listModel);
}
public JsonResult getMonthlyReport(string FinYear)
{
using (SqlConnection con = DBConnection.getConnection())
{
List <MonthlyReportModel> list = new List <MonthlyReportModel>();
string sql = "Select * from Jct_Asset_Dep_IT_Monthly_Dep_Record WHERE FinYear='" + FinYear + "' and Status='A'";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader read = cmd.ExecuteReader();
if (read.HasRows)
{
read.Close();
SqlCommand cmd2 = new SqlCommand("Jct_Asset_Dep_ITAct_MonthWise_Dep_Fetch", con);
cmd2.Parameters.AddWithValue("@FinYear", FinYear);
cmd2.CommandType = CommandType.StoredProcedure;
SqlDataReader read2 = cmd2.ExecuteReader();
if (read2.HasRows)
{
while (read2.Read())
{
MonthlyReportModel model = new MonthlyReportModel();
model.GroupCode = read2["GroupCode"].ToString();
model.SubGroupCode = read2["SubGroupCode"].ToString();
//model.AssetCode = read2["AssetCode"].ToString();
model.Apr = (float)Convert.ToDouble(read2["Apr"].ToString());
model.May = (float)Convert.ToDouble(read2["May"].ToString());
model.Jun = (float)Convert.ToDouble(read2["Jun"].ToString());
model.Jul = (float)Convert.ToDouble(read2["Jul"].ToString());
model.Aug = (float)Convert.ToDouble(read2["Sep"].ToString());
model.Sep = (float)Convert.ToDouble(read2["Sep"].ToString());
model.Oct = (float)Convert.ToDouble(read2["Oct"].ToString());
model.Nov = (float)Convert.ToDouble(read2["Nov"].ToString());
model.Dec = (float)Convert.ToDouble(read2["Dec"].ToString());
model.Jan = (float)Convert.ToDouble(read2["Jan"].ToString());
model.Feb = (float)Convert.ToDouble(read2["Feb"].ToString());
model.Mar = (float)Convert.ToDouble(read2["Mar"].ToString());
model.TotalDepreciation = (float)Convert.ToDouble(read2["TotalDepreciation"].ToString());
list.Add(model);
}
read2.Close();
var jsonData = new
{
records = list.Count,
rows = list
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
}
else
{
read.Close();
SqlCommand cmd1 = new SqlCommand("Jct_Asset_Dep_ITAct_MonthWise_Dep_Cal", con);
cmd1.CommandType = CommandType.StoredProcedure;
SqlDataReader read1 = cmd1.ExecuteReader();
if (read1.HasRows)
{
while (read1.Read())
{
MonthlyReportModel model = new MonthlyReportModel();
model.GroupCode = read1["GroupCode"].ToString();
model.SubGroupCode = read1["SubroupCode"].ToString();
model.AssetCode = read1["AssetCode"].ToString();
model.Apr = (float)Convert.ToDouble(read1["Apr"].ToString());
model.May = (float)Convert.ToDouble(read1["May"].ToString());
model.Jun = (float)Convert.ToDouble(read1["Jun"].ToString());
model.Jul = (float)Convert.ToDouble(read1["Jul"].ToString());
model.Aug = (float)Convert.ToDouble(read1["Sep"].ToString());
model.Sep = (float)Convert.ToDouble(read1["Sep"].ToString());
model.Oct = (float)Convert.ToDouble(read1["Oct"].ToString());
model.Nov = (float)Convert.ToDouble(read1["Nov"].ToString());
model.Dec = (float)Convert.ToDouble(read1["Dec"].ToString());
model.Jan = (float)Convert.ToDouble(read1["Jan"].ToString());
model.Feb = (float)Convert.ToDouble(read1["Feb"].ToString());
model.Mar = (float)Convert.ToDouble(read1["Mar"].ToString());
list.Add(model);
}
read1.Close();
var jsonData = new
{
records = list.Count,
rows = list
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
}
}
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
