private void ValidateExpenditure(Expend model)
{
if (model.Amount <= 0)
{
ModelState.AddModelError("Amount", "Số tiền quá ít!");
}
}
public ActionResult DeleteConfirmed(int id)
{
Expend expend = db.Expends.Find(id);
db.Expends.Remove(expend);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Date,Amount,Note")] Expend expend)
{
if (ModelState.IsValid)
{
db.Entry(expend).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(expend));
}
/// <summary>
/// 实体赋值
/// </summary>
/// <param name="entity">实体</param>
private void Set_Entity(Expend entity)
{
if (entity != null)
{
_Expend_Entity = entity;
ExpendDate_DateTimePicker.Value = entity.ExpendDate;
ExpendType_ComboBox.SelectedValue = entity.ExpendType;
ItemName_TextBox.Text = entity.ItemName;
Amount_NumericUpDown.Value = entity.Amount;
Reason_TextBox.Text = entity.Reason;
Remarks_TextBox.Text = entity.Remarks;
}
}
/// <summary>
/// 返回实体
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
private Expend Get_Entity(Expend entity)
{
entity.ExpendDate = ExpendDate_DateTimePicker.Value;
entity.Year_Date = ExpendDate_DateTimePicker.Value.Year.ToString();
entity.Month_Date = ExpendDate_DateTimePicker.Value.Month.ToString();
entity.Day_Date = ExpendDate_DateTimePicker.Value.Day;
entity.ExpendType = ExpendType_ComboBox.SelectedValue.ToString();
entity.ItemName = ItemName_TextBox.Text;
entity.Amount = Amount_NumericUpDown.Value;
entity.Reason = Reason_TextBox.Text;
entity.Remarks = Remarks_TextBox.Text;
return(entity);
}
// GET: /Expenditure/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Expend expend = db.Expends.Find(id);
if (expend == null)
{
return(HttpNotFound());
}
return(View(expend));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public JsonResult Update(Expend entity)
{
ModelState.Remove("UpdaterID");
ModelState.Remove("UpdatedTime");
ModelState.Remove("CreatedTime");
if (ModelState.IsValid)
{
var result = WebService.Update_Expend(entity);
return(JResult(result));
}
else
{
return(ParamsErrorJResult(ModelState));
}
}
public ActionResult Create(Expend expend)
{
if (expend.Amount < 1)
{
ModelState.AddModelError("Amount", "Số tiền quá ít!");
}
if (ModelState.IsValid)
{
expend.Date = DateTime.Now;
db.Expends.Add(expend);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(expend));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Update(Expend entity)
{
if (dr == null)
{
dr = new CallDatabase();
}
dr.InitiCommand("Update Expend set [ExpendDate]=@ExpendDate,[Year_Date]=@Year_Date,[Month_Date]=@Month_Date,[Day_Date]=@Day_Date,[ExpendType]=@ExpendType,[ItemName]=@ItemName,[Amount]=@Amount,[Reason]=@Reason,[Remarks]=@Remarks where [Id]=@Id ");
dr.AddParameters("ExpendDate", DbType.DateTime, entity.ExpendDate);
dr.AddParameters("Year_Date", DbType.String, 20, entity.Year_Date);
dr.AddParameters("Month_Date", DbType.String, 20, entity.Month_Date);
dr.AddParameters("Day_Date", DbType.Int32, entity.Day_Date);
dr.AddParameters("ExpendType", DbType.String, 50, entity.ExpendType);
dr.AddParameters("ItemName", DbType.String, 72, entity.ItemName);
dr.AddParameters("Amount", DbType.Decimal, entity.Amount);
dr.AddParameters("Reason", DbType.String, 250, entity.Reason);
dr.AddParameters("Remarks", DbType.String, 500, entity.Remarks);
dr.AddParameters("Id", DbType.Int32, entity.Id);
return(dr.ExecuteNonQuery());
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public WebResult <bool> Update_Expend(Expend model)
{
using (DbRepository entities = new DbRepository())
{
var oldEntity = entities.Expend.Find(model.ID);
if (oldEntity != null)
{
oldEntity.ThingID = model.ThingID;
oldEntity.Money = model.Money;
oldEntity.AddDate = model.AddDate;
oldEntity.Remark = model.Remark;
oldEntity.NO = model.NO;
oldEntity.UpdatedTime = DateTime.Now;
oldEntity.UpdaterID = Client.LoginUser.ID;
}
else
{
return(Result(false, ErrorCode.sys_param_format_error));
}
if (entities.SaveChanges() > 0)
{
var list = Cache_Get_ExpendList();
var index = list.FindIndex(x => x.ID.Equals(model.ID));
if (index > -1)
{
list[index] = oldEntity;
}
else
{
list.Add(oldEntity);
}
return(Result(true));
}
else
{
return(Result(false, ErrorCode.sys_fail));
}
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int Add(Expend entity)
{
if (dr == null)
{
dr = new CallDatabase();
}
int value = -1;
try
{
dr.InitiCommand("insert into Expend([ExpendDate],[Year_Date],[Month_Date],[Day_Date],[ExpendType],[ItemName],[Amount],[Reason],[Remarks])values(@ExpendDate,@Year_Date,@Month_Date,@Day_Date,@ExpendType,@ItemName,@Amount,@Reason,@Remarks);SELECT @@IDENTITY;");
dr.AddParameters("ExpendDate", DbType.DateTime, entity.ExpendDate);
dr.AddParameters("Year_Date", DbType.String, 20, entity.Year_Date);
dr.AddParameters("Month_Date", DbType.String, 20, entity.Month_Date);
dr.AddParameters("Day_Date", DbType.Int32, entity.Day_Date);
dr.AddParameters("ExpendType", DbType.String, 50, entity.ExpendType);
dr.AddParameters("ItemName", DbType.String, 72, entity.ItemName);
dr.AddParameters("Amount", DbType.Decimal, entity.Amount);
dr.AddParameters("Reason", DbType.String, 250, entity.Reason);
dr.AddParameters("Remarks", DbType.String, 500, entity.Remarks);
object id = dr.ExecuteScalar();
entity.Id = Convert.ToInt32(id);
value = 1;
}
catch (Exception ex)
{
using (ILog_Error log = new Log_Error_Generate())
{
log.Title = ex.Message;
log.Content = ex.StackTrace;
log.Generatelog();
}
value = -1;
}
return(value);
}
