public async Task <IHttpActionResult> PutDayBook(int id, DayBook dayBook)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != dayBook.DayBookID)
{
return(BadRequest());
}
db.Entry(dayBook).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DayBookExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
//返回到当前日期界面
protected void btnBackDay_Click(object sender, EventArgs e)
{
DayBook mDayBook = new DayBook();
DayBookController mDayBookController = new DayBookController();
mDayBook.HandleTime = this.txtHandleTime.Text;
Session["HandleDay"] = mDayBookController.GetHandleDay(mDayBook);
Response.Redirect("SA_DayBookDay.aspx");
}
public async Task <IHttpActionResult> GetDayBook(int id)
{
DayBook dayBook = await db.DayBooks.FindAsync(id);
if (dayBook == null)
{
return(NotFound());
}
return(Ok(dayBook));
}
public async Task <IHttpActionResult> PostDayBook(DayBook dayBook)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.DayBooks.Add(dayBook);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = dayBook.DayBookID }, dayBook));
}
public bool AddDayBook(DayBook model)
{
try
{
entities.DayBooks.Add(model);
entities.SaveChanges();
return true;
}
catch (Exception x)
{
FileLogger.LogError(x); return false;
}
}
public async Task <IHttpActionResult> DeleteDayBook(int id)
{
DayBook dayBook = await db.DayBooks.FindAsync(id);
if (dayBook == null)
{
return(NotFound());
}
db.DayBooks.Remove(dayBook);
await db.SaveChangesAsync();
return(Ok(dayBook));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DayBook mDayBook = new DayBook();
DayBookController mDayBookController = new DayBookController();
if (Session["HandleTime"] != null)
{
mDayBook.HandleTime = Session["HandleTime"].ToString();
string[] mDayBookInfo = mDayBookController.GetDayBookInfo(mDayBook);
this.txtStaffID.Text = mDayBookInfo[0];
this.txtUserName.Text = mDayBookInfo[1];
this.txtHandleTime.Text = mDayBookInfo[2];
this.txtHandleObjects.Text = mDayBookInfo[3];
this.txtDayBookType.Text = mDayBookInfo[4];
this.txtHandleContent.Text = mDayBookInfo[5];
}
}
}
public ActionResult Index(DateTime fromdate, DateTime todate)
{
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
Session["FromDate"] = fromdate.ToShortDateString();
Session["ToDate"] = todate.ToShortDateString();
foreach (DayBook2 daybook2 in db.DayBooks2.ToList())
{
db.DayBooks2.Remove(daybook2);
}
db.SaveChanges();
Company company = db.Companys.Include(c => c.CurrentCountry).Include(c => c.CurrentCity).Where(c => c.CompanyID == 1).FirstOrDefault();
List <DayBook> daybooks = new List <DayBook>();
List <DayBook2> daybooks2 = new List <DayBook2>();
DayBook2 daybook2head = new DayBook2();
daybook2head.Col1 = "Voucher No";
daybook2head.Col2 = "Particulars";
daybook2head.Col3 = "Credit Acc";
daybook2head.Col4 = "Debit Acc";
daybook2head.Col5 = "Credit Amt";
daybook2head.Col6 = "Debit Amt";
daybook2head.Col7 = Convert.ToDateTime(fromdate.ToString()).Day.ToString() + "-" + CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Convert.ToDateTime(fromdate.ToString()).Month) + "-" + Convert.ToDateTime(fromdate.ToString()).Year;;
daybook2head.Col8 = Convert.ToDateTime(todate.ToString()).Day.ToString() + "-" + CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Convert.ToDateTime(todate.ToString()).Month) + "-" + Convert.ToDateTime(todate.ToString()).Year;;
daybook2head.Col9 = "<b>" + company.Name + "</b><br/>Address: " + company.HouseNo + " " + company.BuildingName + " " + company.Street + " " + company.Area + " " + company.Location + " " + company.CurrentCity.Name + " " + company.CurrentCountry.Name + " " + company.PinCode + "<br/>Email: " + company.Email + " , Mobile: " + company.Mobile;
daybooks2.Add(daybook2head);
db.DayBooks2.Add(daybook2head);
db.SaveChanges();
try
{
decimal daytotdebit = 0;
decimal daytotcredit = 0;
decimal grandtotdebit = 0;
decimal grandtotcredit = 0;
int r = 0;
var accountjournaltrdates = db.AccountJournals.Where(t => t.TransactionDate >= fromdate && t.TransactionDate <= todate).OrderBy(t => t.TransactionDate).Select(t => t.TransactionDate).Distinct().ToList();
foreach (DateTime accountjournaltrdate in accountjournaltrdates)
{
var accountjournaldetails = db.AccountJournalDetails.Include(a => a.CurrentAccountJournal).Include(a => a.CurrentAccountHead).OrderByDescending(t => t.CurrentAccountJournal.TransactionDate).Where(t => t.CurrentAccountJournal.TransactionDate == accountjournaltrdate).OrderBy(t => t.AccountJournalDetailID).ToList();
r = 0;
daytotdebit = 0;
daytotcredit = 0;
foreach (AccountJournalDetail accountjournaldetail in accountjournaldetails)
{
DayBook daybook = new DayBook();
DayBook2 daybook2 = new DayBook2();
if (r == 0)
{
daybook.TransactionDate = Convert.ToDateTime(accountjournaldetail.CurrentAccountJournal.TransactionDate);
daybook2.Col1 = Convert.ToDateTime(daybook.TransactionDate.ToString()).Day.ToString() + "-" + CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Convert.ToDateTime(daybook.TransactionDate.ToString()).Month) + "-" + Convert.ToDateTime(daybook.TransactionDate.ToString()).Year;
daybook2.Col2 = "";
daybook2.Col3 = "";
daybook2.Col4 = "";
daybook2.Col5 = "";
daybook2.Col6 = "";
daybook2.Col7 = "";
daybook2.Col8 = "";
daybook2.Col9 = "";
daybooks2.Add(daybook2);
db.DayBooks2.Add(daybook2);
db.SaveChanges();
r = 1;
}
else
{
daybook.TransactionDate = null;
}
daybook.VoucherNo = accountjournaldetail.CurrentAccountJournal.VoucherType + " " + accountjournaldetail.CurrentAccountJournal.VoucherNo;
daybook.DetailParticulars = accountjournaldetail.Remarks;
if (accountjournaldetail.Amount >= 0)
{
daybook.DebitAccount = accountjournaldetail.CurrentAccountHead.Name;
daybook.Debit = accountjournaldetail.Amount;
daytotdebit += accountjournaldetail.Amount;
}
if (accountjournaldetail.Amount <= 0)
{
daybook.CreditAccount = accountjournaldetail.CurrentAccountHead.Name;
daybook.Credit = Convert.ToDecimal(Convert.ToString(accountjournaldetail.Amount).Replace("-", ""));
daytotcredit += Convert.ToDecimal(Convert.ToString(accountjournaldetail.Amount).Replace("-", ""));
}
daybook.DebitDayTotal = null;
daybook.CreditDayTotal = null;
daybook.DebitGrandTotal = null;
daybook.CreditGrandTotal = null;
daybooks.Add(daybook);
daybook2.Col1 = daybook.VoucherNo;
daybook2.Col2 = daybook.DetailParticulars;
daybook2.Col3 = daybook.CreditAccount;
daybook2.Col4 = daybook.DebitAccount;
daybook2.Col5 = Convert.ToDecimal(daybook.Credit).ToString("#,##0.00");
daybook2.Col6 = Convert.ToDecimal(daybook.Debit).ToString("#,##0.00");
daybook2.Col7 = "";
daybook2.Col8 = "";
daybook2.Col9 = "";
daybooks2.Add(daybook2);
db.DayBooks2.Add(daybook2);
db.SaveChanges();
}
DayBook daybookdaytot = new DayBook();
daybookdaytot.DetailParticulars = "DAY TOTAL";
daybookdaytot.DebitDayTotal = daytotdebit;
daybookdaytot.CreditDayTotal = daytotcredit;
daybooks.Add(daybookdaytot);
DayBook2 daybook2tot = new DayBook2();
daybook2tot.Col1 = "";
daybook2tot.Col2 = "";
daybook2tot.Col3 = "";
daybook2tot.Col4 = daybookdaytot.DetailParticulars;
daybook2tot.Col5 = Convert.ToDecimal(daybookdaytot.CreditDayTotal).ToString("#,##0.00");
daybook2tot.Col6 = Convert.ToDecimal(daybookdaytot.DebitDayTotal).ToString("#,##0.00");
daybook2tot.Col7 = "";
daybook2tot.Col8 = "";
daybook2tot.Col9 = "";
daybooks2.Add(daybook2tot);
db.DayBooks2.Add(daybook2tot);
db.SaveChanges();
grandtotdebit += daytotdebit;
grandtotcredit += daytotcredit;
Session["err"] = "";
Session["msg"] = "Generated Successfully";
}
DayBook daybookgrandtot = new DayBook();
daybookgrandtot.DetailParticulars = "GRAND TOTAL";
daybookgrandtot.DebitGrandTotal = grandtotdebit;
daybookgrandtot.CreditGrandTotal = grandtotcredit;
daybooks.Add(daybookgrandtot);
DayBook2 daybook22tot = new DayBook2();
daybook22tot.Col1 = "";
daybook22tot.Col2 = "";
daybook22tot.Col3 = "";
daybook22tot.Col4 = daybookgrandtot.DetailParticulars;
daybook22tot.Col5 = Convert.ToDecimal(daybookgrandtot.CreditGrandTotal).ToString("#,##0.00");
daybook22tot.Col6 = Convert.ToDecimal(daybookgrandtot.DebitGrandTotal).ToString("#,##0.00");
daybook22tot.Col7 = "";
daybook22tot.Col8 = "";
daybook22tot.Col9 = "";
daybooks2.Add(daybook22tot);
db.DayBooks2.Add(daybook22tot);
db.SaveChanges();
}
catch { }
ViewBag.Message = Session["msg"];
ViewBag.Error = Session["err"];
Session["err"] = "";
Session["msg"] = "";
return(View(daybooks));
}
/// <summary>
/// 改变时间格式
/// </summary>
/// <param name="lDayBoook"></param>
/// <returns></returns>
public string GetHandleDay(DayBook lDayBoook)
{
return(lDayBoook.ChangeHandleTime());
}
/// <summary>
/// 判断输入的操作时间是否存在
/// </summary>
/// <param name="mDayBook"></param>
/// <param name="mHandleTime"></param>
/// <returns></returns>
public bool GetHandleTime(DayBook mDayBook, string mHandleTime)
{
return(mDayBook.SelectHandleTime(mHandleTime));
}
/// <summary>
/// 得到每条日志的详细信息
/// </summary>
/// <param name="lDayBook"></param>
/// <returns></returns>
public string[] GetDayBookInfo(DayBook lDayBook)
{
return(lDayBook.DayBookInfo());
}
/// <summary>
/// 向日志表中添加记录
/// </summary>
/// <param name="mDayBook"></param>
/// <returns></returns>
public bool AddDayBook(DayBook mDayBook)
{
return(mDayBook.UpdateDayBook());
}
public ActionResult Index()
{
DateTime fromdate = Convert.ToDateTime(Request.QueryString["FromDate"]);
DateTime todate = Convert.ToDateTime(Request.QueryString["ToDate"].Remove(Request.QueryString["ToDate"].Length - 1));
List <DayBook> daybooks = new List <DayBook>();
try
{
decimal daytotdebit = 0;
decimal daytotcredit = 0;
decimal grandtotdebit = 0;
decimal grandtotcredit = 0;
int r = 0;
var accountjournaltrdates = db.AccountJournals.Where(t => t.TransactionDate >= fromdate && t.TransactionDate <= todate).OrderBy(t => t.TransactionDate).Select(t => t.TransactionDate).Distinct().ToList();
foreach (DateTime accountjournaltrdate in accountjournaltrdates)
{
var accountjournaldetails = db.AccountJournalDetails.Include(a => a.CurrentAccountJournal).Include(a => a.CurrentAccountHead).OrderByDescending(t => t.CurrentAccountJournal.TransactionDate).Where(t => t.CurrentAccountJournal.TransactionDate == accountjournaltrdate).OrderBy(t => t.AccountJournalDetailID).ToList();
r = 0;
daytotdebit = 0;
daytotcredit = 0;
foreach (AccountJournalDetail accountjournaldetail in accountjournaldetails)
{
DayBook daybook = new DayBook();
if (r == 0)
{
daybook.TransactionDate = Convert.ToDateTime(accountjournaldetail.CurrentAccountJournal.TransactionDate);
r = 1;
}
else
{
daybook.TransactionDate = null;
}
daybook.VoucherNo = accountjournaldetail.CurrentAccountJournal.VoucherType + " " + accountjournaldetail.CurrentAccountJournal.VoucherNo;
daybook.DetailParticulars = accountjournaldetail.Remarks;
if (accountjournaldetail.Amount >= 0)
{
daybook.DebitAccount = accountjournaldetail.CurrentAccountHead.Name;
daybook.Debit = accountjournaldetail.Amount;
daytotdebit += accountjournaldetail.Amount;
}
if (accountjournaldetail.Amount <= 0)
{
daybook.CreditAccount = accountjournaldetail.CurrentAccountHead.Name;
daybook.Credit = Convert.ToDecimal(Convert.ToString(accountjournaldetail.Amount).Replace("-", ""));
daytotcredit += Convert.ToDecimal(Convert.ToString(accountjournaldetail.Amount).Replace("-", ""));
}
daybook.DebitDayTotal = null;
daybook.CreditDayTotal = null;
daybook.DebitGrandTotal = null;
daybook.CreditGrandTotal = null;
daybooks.Add(daybook);
}
DayBook daybookdaytot = new DayBook();
daybookdaytot.DetailParticulars = "DAY TOTAL";
daybookdaytot.DebitDayTotal = daytotdebit;
daybookdaytot.CreditDayTotal = daytotcredit;
daybooks.Add(daybookdaytot);
grandtotdebit += daytotdebit;
grandtotcredit += daytotcredit;
Session["err"] = "";
Session["msg"] = "Generated Successfully";
}
DayBook daybookgrandtot = new DayBook();
daybookgrandtot.DetailParticulars = "GRAND TOTAL";
daybookgrandtot.DebitGrandTotal = grandtotdebit;
daybookgrandtot.CreditGrandTotal = grandtotcredit;
daybooks.Add(daybookgrandtot);
}
catch { }
//DataTable table = ConvertListToDataTable(daybooks);
//DataTable daybookstbl = CommanFunctions.ToDataTable(daybooks);
//ReportViewer reportViewer = new ReportViewer();
//reportViewer.ProcessingMode = ProcessingMode.Local;
//reportViewer.SizeToReportContent = true;
////reportViewer.Width = unit.Percentage(900);
////reportViewer.Height = Unit.Percentage(900);
//reportViewer.LocalReport.ReportPath = Server.MapPath("~/Reports/daybook.rdl");
//ReportDataSource datasource = new ReportDataSource("DataSet1", daybookstbl);
//reportViewer.LocalReport.DataSources.Clear();
//reportViewer.LocalReport.DataSources.Add(datasource);
//reportViewer.ShowPrintButton = true;
//ViewBag.ReportViewer = reportViewer;
return(View(daybooks));
}
public bool UpdateDayBook(DayBook model)
{
try
{
DayBook daybook = entities.DayBooks.Where(x => x.DayBookId == model.DayBookId).SingleOrDefault();
if (daybook != null)
{
entities.Entry(daybook).CurrentValues.SetValues(model);
entities.SaveChanges();
return true;
}
else
{
return false;
}
}
catch (Exception x)
{
FileLogger.LogError(x); return false;
}
}
