/// <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文件！"));
}
}
