/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, FeenoticeEntity entity) { try { service.SaveForm(keyValue, entity); } catch (Exception) { throw; } }
public ActionResult SaveForm(string keyValue, FeenoticeEntity entity) { if (string.IsNullOrEmpty(keyValue)) { entity.CreatorId = OperatorProvider.Provider.Current().UserId; entity.CreatorName = OperatorProvider.Provider.Current().UserName != "" ? OperatorProvider.Provider.Current().UserName : OperatorProvider.Provider.Current().Account; entity.CreateDate = DateTime.Now; } feenoticebll.SaveForm(keyValue, entity); return(Success("操作成功。")); }
public ActionResult SaveClaimForm(string keyValue, FeenoticeEntity entity) { if (string.IsNullOrEmpty(keyValue)) { return(Error("操作错误!")); } if (feenoticebll.ExistIsClaim(keyValue)) { return(Error("该进账已经认领,请选择其他进账认领!")); } entity.checkuserid = OperatorProvider.Provider.Current().UserId; feenoticebll.SaveForm(keyValue, entity); return(Success("操作成功。")); }
public ActionResult ImportForm(string attfile) { if (!string.IsNullOrEmpty(attfile)) { DataTable dt = Util.Offices.ExcelHelper.ExcelImport(Utils.GetMapPath(attfile)); if (dt != null && dt.Rows.Count > 0) { try { if (dt.Columns.Contains("账单编号") && dt.Columns.Contains("账单单位") && dt.Columns.Contains("账单日期") && dt.Columns.Contains("账单金额")) { List <FeenoticeEntity> list = new List <FeenoticeEntity>(); string CreatorName = OperatorProvider.Provider.Current().UserName != "" ? OperatorProvider.Provider.Current().UserName : OperatorProvider.Provider.Current().Account; DateTime date = DateTime.Now; bool Ismemo = false, Isaccounts = false, Ispurpose = false; #region 判断 if (dt.Columns.Contains("账单备注")) { Ismemo = true; } if (dt.Columns.Contains("对方帐号")) { Isaccounts = true; } if (dt.Columns.Contains("用途")) { Ispurpose = true; } #endregion #region 赋值 for (int i = 0; i < dt.Rows.Count; i++) { if (!dt.Rows[i]["账单编号"].IsEmpty() && !dt.Rows[i]["账单单位"].IsEmpty() && !dt.Rows[i]["账单日期"].IsEmpty() && !dt.Rows[i]["账单金额"].IsEmpty()) { FeenoticeEntity ent = new FeenoticeEntity(); ent.CreatorId = OperatorProvider.Provider.Current().UserId; ent.CreatorName = CreatorName; ent.CreateDate = date; ent.accountcode = dt.Rows[i]["账单编号"].ToString(); ent.accountcompany = dt.Rows[i]["账单单位"].ToString(); ent.accountdate = dt.Rows[i]["账单日期"].ToDateOrNullToNow(); ent.account = dt.Rows[i]["账单金额"].ToDecimal(); if (Ismemo) { ent.memo = dt.Rows[i]["账单备注"].ToString(); } if (Isaccounts) { ent.accounts = dt.Rows[i]["对方帐号"].ToString(); } if (Ispurpose) { ent.purpose = dt.Rows[i]["用途"].ToString(); } list.Add(ent); } } #endregion if (list != null && list.Count > 0) { feenoticebll.ImportForm(list); return(Success("操作成功。")); } else { return(Error("请按照模式填写进账数据上传!")); } } else { return(Error("请按照模式填写进账数据上传!")); } } catch (Exception) { return(Error("请按照模式填写进账数据上传!")); } } else { return(Error("请上传有效导入进账文件!")); } } else { return(Error("请选择上传进账导出EXCEL文件!")); } }