public void EditTest()
{
EnterpriseFinanceInfo v = new EnterpriseFinanceInfo();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
context.Set <EnterpriseFinanceInfo>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Edit(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(EnterpriseFinanceInfoVM));
EnterpriseFinanceInfoVM vm = rv.Model as EnterpriseFinanceInfoVM;
v = new EnterpriseFinanceInfo();
v.ID = vm.Entity.ID;
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
_controller.Edit(vm);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <EnterpriseFinanceInfo>().FirstOrDefault();
Assert.AreEqual(data.UpdateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
}
}
public void LoadEnterpriseInfo()
{
EnterpriseFinanceInfo = new EnterpriseFinanceInfo();
EnterpriseBusinessinfo = new EnterpriseBusinessinfo();
EnterpriseContacts = new List <EnterpriseContact>();
EnterpriserYearYields = new List <EnterpriserYearYield>();
}
public void DeleteTest()
{
EnterpriseFinanceInfo v = new EnterpriseFinanceInfo();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
context.Set <EnterpriseFinanceInfo>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Delete(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(EnterpriseFinanceInfoVM));
EnterpriseFinanceInfoVM vm = rv.Model as EnterpriseFinanceInfoVM;
v = new EnterpriseFinanceInfo();
v.ID = vm.Entity.ID;
vm.Entity = v;
_controller.Delete(v.ID.ToString(), null);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
Assert.AreEqual(context.Set <EnterpriseFinanceInfo>().Count(), 0);
}
}
public void BatchDeleteTest()
{
EnterpriseFinanceInfo v1 = new EnterpriseFinanceInfo();
EnterpriseFinanceInfo v2 = new EnterpriseFinanceInfo();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
context.Set <EnterpriseFinanceInfo>().Add(v1);
context.Set <EnterpriseFinanceInfo>().Add(v2);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.BatchDelete(new string[] { v1.ID.ToString(), v2.ID.ToString() });
Assert.IsInstanceOfType(rv.Model, typeof(EnterpriseFinanceInfoBatchVM));
EnterpriseFinanceInfoBatchVM vm = rv.Model as EnterpriseFinanceInfoBatchVM;
vm.Ids = new string[] { v1.ID.ToString(), v2.ID.ToString() };
_controller.DoBatchDelete(vm, null);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
Assert.AreEqual(context.Set <EnterpriseFinanceInfo>().Count(), 0);
}
}
public void DoDeleteFinanceInfo(EnterpriseFinanceInfo financeinfo)
{
var data = DC.Set <EnterpriseFinanceInfo>().Where(x => x.EnterpriseBasicId == financeinfo.EnterpriseBasicId).FirstOrDefault();
if (data != null)
{
DC.Set <EnterpriseFinanceInfo>().Remove(data);
DC.SaveChanges();
}
}
public string GetEnterpriseFinanceInfoByEnterpriseId(string enterpriseId)
{
string reply = null;
var sql = string.Format(@"select
ty.Total as thiszcze,ty.Liabilities as thisfzze,ty.SaleIncome as thisxssr,ty.Receivable as thisyszk,ty.RetainedProfits as thissyzqy,ty.[Year] as thisyear,ty.Jinlirun as thisjlr,
ly.Total as lzcze,ly.Liabilities as lfzze,ly.SaleIncome as lxssr,ly.Receivable as lyszk,ly.RetainedProfits as lsyzqy,ly.[Year] as lyear,ly.Jinlirun as ljlr,
lly.Total as llzcze,lly.Liabilities as llfzze,lly.SaleIncome as llxssr,lly.Receivable as llyszk,lly.RetainedProfits as llsyzqy,lly.[Year] as llyear,lly.Jinlirun as lljlr
from RZFinance rzf
join SysUser u on u.EnterpriseId=rzf.EnterpriseId
left join RZFinanceYear ty on ty.Id=rzf.Finance
left join RZFinanceYear ly on ly.Id=rzf.FinanceLY
left join RZFinanceYear lly on lly.Id=rzf.FinanceLLY
where u.EnterpriseId='{0}'", enterpriseId);
var dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
var dr = dt.Rows[0];
var efi = new EnterpriseFinanceInfo
{
llzcze = dr["llzcze"].ToString(),
lzcze = dr["lzcze"].ToString(),
thiszcze = dr["thiszcze"].ToString(),
llfzze = dr["llfzze"].ToString(),
lfzze = dr["lfzze"].ToString(),
thisfzze = dr["thisfzze"].ToString(),
llxssr = dr["llxssr"].ToString(),
lxssr = dr["lxssr"].ToString(),
thisxssr = dr["thisxssr"].ToString(),
llyszk = dr["llyszk"].ToString(),
lyszk = dr["lyszk"].ToString(),
thisyszk = dr["thisyszk"].ToString(),
lljlr = dr["lljlr"].ToString(),
ljlr = dr["ljlr"].ToString(),
thisjlr = dr["thisjlr"].ToString(),
llsyzqy = dr["llsyzqy"].ToString(),
lsyzqy = dr["lsyzqy"].ToString(),
thissyzqy = dr["thissyzqy"].ToString(),
llyear = dr["llyear"].ToString(),
lyear = dr["lyear"].ToString(),
thisyear = dr["thisyear"].ToString()
};
reply = JsonHelper.SerializeObject(efi);
}
else
{
reply = "";
}
return(reply);
}
public void DoEditFinanceInfo(EnterpriseFinanceInfo financeinfo)
{
//check exist
var data = DC.Set <EnterpriseFinanceInfo>().Where(x => x.EnterpriseBasicId == financeinfo.EnterpriseBasicId).FirstOrDefault();
bool exist = data != null ? true : false;
if (exist)
{
DC.Set <EnterpriseFinanceInfo>().Remove(data);
}
DC.Set <EnterpriseFinanceInfo>().Add(financeinfo);
DC.SaveChanges();
}
public void DetailsTest()
{
EnterpriseFinanceInfo v = new EnterpriseFinanceInfo();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
context.Set <EnterpriseFinanceInfo>().Add(v);
context.SaveChanges();
}
PartialViewResult rv = (PartialViewResult)_controller.Details(v.ID.ToString());
Assert.IsInstanceOfType(rv.Model, typeof(IBaseCRUDVM <TopBasePoco>));
Assert.AreEqual(v.ID, (rv.Model as IBaseCRUDVM <TopBasePoco>).Entity.GetID());
}
public void CreateTest()
{
PartialViewResult rv = (PartialViewResult)_controller.Create();
Assert.IsInstanceOfType(rv.Model, typeof(EnterpriseFinanceInfoVM));
EnterpriseFinanceInfoVM vm = rv.Model as EnterpriseFinanceInfoVM;
EnterpriseFinanceInfo v = new EnterpriseFinanceInfo();
vm.Entity = v;
_controller.Create(vm);
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <EnterpriseFinanceInfo>().FirstOrDefault();
Assert.AreEqual(data.CreateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
}
}
public string EditNewEnterpriseInfo(params string[] parameters)
{
var basicInfo = new EnterpriseBasicInfo();
var businessInfoList = new List <EnterpriseBusinessinfo>();
var contactList = new List <EnterpriseContact>();
var yearYieldList = new List <EnterpriserYearYield>();
var financeInfo = new EnterpriseFinanceInfo();
if (parameters[0] != null && parameters[0].Length > 2 && !string.IsNullOrEmpty(parameters[0]))
{
basicInfo = JsonConvert.DeserializeObject <EnterpriseBasicInfo>(parameters[0]);
DC.Set <EnterpriseBasicInfo>().Update(basicInfo);
}
if (parameters[1] != null && parameters[1].Length > 2 && !string.IsNullOrEmpty(parameters[1]))
{
businessInfoList = JsonConvert.DeserializeObject <List <EnterpriseBusinessinfo> >(parameters[1]);
DC.Set <EnterpriseBusinessinfo>().UpdateRange(businessInfoList);
}
if (parameters[2] != null && parameters[2].Length > 2 && !string.IsNullOrEmpty(parameters[2]))
{
financeInfo = JsonConvert.DeserializeObject <EnterpriseFinanceInfo>(parameters[2]);
DC.Set <EnterpriseFinanceInfo>().Update(financeInfo);
}
if (parameters[3] != null && parameters[3].Length > 2 && !string.IsNullOrEmpty(parameters[3]))
{
contactList = JsonConvert.DeserializeObject <List <EnterpriseContact> >(parameters[3]);
DC.Set <EnterpriseContact>().UpdateRange(contactList);
}
if (parameters[4] != null && parameters[4].Length > 2 && !string.IsNullOrEmpty(parameters[4]))
{
yearYieldList = JsonConvert.DeserializeObject <List <EnterpriserYearYield> >(parameters[4]);
DC.Set <EnterpriserYearYield>().UpdateRange(yearYieldList);
}
DC.SaveChanges();
return(DC.SaveChanges().ToString());
}
public void DoAddFinanceInfo(EnterpriseFinanceInfo financeinfo)
{
DC.Set <EnterpriseFinanceInfo>().Add(financeinfo);
DC.SaveChanges();
}
public bool SaveEnterpriseFianceInfo(EnterpriseFinanceInfo efi)
{
return(_es.SaveEnterpriseFianceInfo(efi));
}
public bool SaveEnterpriseFianceInfo(EnterpriseFinanceInfo efi)
{
var sql = string.Format(@"select EnterpriseId from SysUser where UserName='******'", efi.username.Trim());
var ent = DBHelper.GetScalar(sql) as int?;
if (ent == null)
{
return(false);
}
sql = @"
insert into RZFinanceYear(EnterpriseId,Total,Liabilities,SaleIncome,Receivable,RetainedProfits,[Year],Jinlirun)
values (@eid,@tt,@lia,@sal,@rec,@ret,@yr,@jlr)
SELECT @@IDENTITY";
var thisid = DBHelper.GetScalar(sql,
new SqlParameter("@eid", ent),
new SqlParameter("@tt", efi.thiszcze.Trim()),
new SqlParameter("@lia", efi.thisfzze.Trim()),
new SqlParameter("@sal", efi.thisxssr.Trim()),
new SqlParameter("@rec", efi.thisyszk.Trim()),
new SqlParameter("@ret", efi.thissyzqy.Trim()),
new SqlParameter("@yr", efi.thisyear.Trim()),
new SqlParameter("@jlr", efi.thisjlr.Trim()));
if (thisid == null)
{
return(false);
}
var lid = DBHelper.GetScalar(sql,
new SqlParameter("@eid", ent),
new SqlParameter("@tt", efi.lzcze.Trim()),
new SqlParameter("@lia", efi.lfzze.Trim()),
new SqlParameter("@sal", efi.lxssr.Trim()),
new SqlParameter("@rec", efi.lyszk.Trim()),
new SqlParameter("@ret", efi.lsyzqy.Trim()),
new SqlParameter("@yr", efi.lyear.Trim()),
new SqlParameter("@jlr", efi.ljlr.Trim()));
if (lid == null)
{
return(false);
}
var llid = DBHelper.GetScalar(sql,
new SqlParameter("@eid", ent),
new SqlParameter("@tt", efi.llzcze.Trim()),
new SqlParameter("@lia", efi.llfzze.Trim()),
new SqlParameter("@sal", efi.llxssr.Trim()),
new SqlParameter("@rec", efi.llyszk.Trim()),
new SqlParameter("@ret", efi.llsyzqy.Trim()),
new SqlParameter("@yr", efi.llyear.Trim()),
new SqlParameter("@jlr", efi.lljlr.Trim()));
if (llid == null)
{
return(false);
}
sql = @"insert into RZFinance(EnterpriseId,FinanceYear,Finance,FinanceLY,FinanceLLY)
values(@eid,@fy,@fn,@fnl,@fnll)";
var id = DBHelper.Execute(sql, new SqlParameter("@eid", ent),
new SqlParameter("@fy", efi.thisyear.Trim()),
new SqlParameter("@fn", thisid),
new SqlParameter("@fnl", lid),
new SqlParameter("@fnll", llid));
return(id > 0);
}
public string GetEnterpriseFinanceInfoByUserName(string userName, int?enterpriseId = null)
{
string reply = null;
// var sql = string.Format(@"select
//ty.Total as thiszcze,ty.Liabilities as thisfzze,ty.SaleIncome as thisxssr,ty.Receivable as thisyszk,ty.RetainedProfits as thissyzqy,ty.[Year] as thisyear,ty.Jinlirun as thisjlr,
//ly.Total as lzcze,ly.Liabilities as lfzze,ly.SaleIncome as lxssr,ly.Receivable as lyszk,ly.RetainedProfits as lsyzqy,ly.[Year] as lyear,ly.Jinlirun as ljlr,
//lly.Total as llzcze,lly.Liabilities as llfzze,lly.SaleIncome as llxssr,lly.Receivable as llyszk,lly.RetainedProfits as llsyzqy,lly.[Year] as llyear,lly.Jinlirun as lljlr
//from RZFinance rzf
//join SysUser u on u.EnterpriseId=rzf.EnterpriseId
//left join RZFinanceYear ty on ty.Id=rzf.Finance
//left join RZFinanceYear ly on ly.Id=rzf.FinanceLY
//left join RZFinanceYear lly on lly.Id=rzf.FinanceLLY
//where {0}", enterpriseId == null ? string.Format("u.UserName='******'", userName.Trim()) : string.Format("rzf.EnterpriseId={0}", enterpriseId));
var sql = string.Format(@"select a.Total as zcze,a.Liabilities as fzze,a.SaleIncome as xssr,a.Receivable as yszk,a.RetainedProfits as syzqy,
a.Jinlirun as jlr,a.[Year] as [year]
from RZFinanceYear a left join SysUser u on a.EnterpriseId = u.EnterpriseId
where {0}", enterpriseId == null ? string.Format("u.UserName='******' order by a.[Year] desc", userName.Trim()) : string.Format("a.EnterpriseId={0} order by a.[Year] desc", enterpriseId));
var dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
var efi = new EnterpriseFinanceInfo();
for (var i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
if (i == 0)
{
efi.thisyear = dr["year"].ToString();
efi.thiszcze = dr["zcze"].ToString();
efi.thisfzze = dr["fzze"].ToString();
efi.thisxssr = dr["xssr"].ToString();
efi.thisyszk = dr["yszk"].ToString();
efi.thissyzqy = dr["syzqy"].ToString();
efi.thisjlr = dr["jlr"].ToString();
}
else if (i == 1)
{
efi.lyear = dr["year"].ToString();
efi.lzcze = dr["zcze"].ToString();
efi.lfzze = dr["fzze"].ToString();
efi.lxssr = dr["xssr"].ToString();
efi.lyszk = dr["yszk"].ToString();
efi.lsyzqy = dr["syzqy"].ToString();
efi.ljlr = dr["jlr"].ToString();
}
else
{
efi.llyear = dr["year"].ToString();
efi.llzcze = dr["zcze"].ToString();
efi.llfzze = dr["fzze"].ToString();
efi.llxssr = dr["xssr"].ToString();
efi.llyszk = dr["yszk"].ToString();
efi.llsyzqy = dr["syzqy"].ToString();
efi.lljlr = dr["jlr"].ToString();
}
}
//var dr = dt.Rows[0];
//var efi = new EnterpriseFinanceInfo
//{
// llzcze = dr["llzcze"].ToString(),
// lzcze = dr["lzcze"].ToString(),
// thiszcze = dr["thiszcze"].ToString(),
// llfzze = dr["llfzze"].ToString(),
// lfzze = dr["lfzze"].ToString(),
// thisfzze = dr["thisfzze"].ToString(),
// llxssr = dr["llxssr"].ToString(),
// lxssr = dr["lxssr"].ToString(),
// thisxssr = dr["thisxssr"].ToString(),
// llyszk = dr["llyszk"].ToString(),
// lyszk = dr["lyszk"].ToString(),
// thisyszk = dr["thisyszk"].ToString(),
// lljlr = dr["lljlr"].ToString(),
// ljlr = dr["ljlr"].ToString(),
// thisjlr = dr["thisjlr"].ToString(),
// llsyzqy = dr["llsyzqy"].ToString(),
// lsyzqy = dr["lsyzqy"].ToString(),
// thissyzqy = dr["thissyzqy"].ToString(),
// llyear = dr["llyear"].ToString(),
// lyear = dr["lyear"].ToString(),
// thisyear = dr["thisyear"].ToString()
//};
reply = JsonHelper.SerializeObject(efi);
}
else
{
reply = "";
}
return(reply);
}
