public Result <List <TaskItem> > List(string mgcode)
{
Result <List <TaskItem> > result = new Result <List <TaskItem> >();
try
{
if (!string.IsNullOrWhiteSpace(mgcode))
{
using (TN db = new TN())
{
List <TCom.EF.Task> ts = (from t in db.Tasks
where ((from tr in db.TaskRecvers
where tr.mcode == mgcode
select tr.idtask).Contains(t.idtask))
select t).ToList();
result.Data = TaskItem.gets(ts);
result.Code = R.Ok;
}
}
}
catch (Exception e)
{
result.Code = R.Error;
result.Msg = "出现异常" + e.Message;
}
return(result);
}
public Result <MercInfo> GetAll()
{
Result <MercInfo> result = new Result <MercInfo>();
try
{
using (TN db = new TN())
{
MercInfo m = new MercInfo()
{
Merc = db.Mercs.Where(mr => mr.inuse == true).ToList(),
Spec = db.Specs.Where(mr => mr.inuse == true).ToList(),
Discount = db.Discounts.Where(mr => mr.inuse == true).ToList()
};
result.Data = m;
result.Code = R.Ok;
}
}
catch (Exception)
{
result.Code = R.Error;
result.Msg = "出现异常";
}
return(result);
}
public static List <Setup> GetByIdTypes(List <string> idtypes)
{
TN db = new TN();
List <Setup> setups = db.Setups.Where(en => idtypes.Contains(en.idtype)).ToList();
return(setups);
}
/// <summary>
/// Parse the TN from the XmlReader <paramref name="s"/>.
/// </summary>
/// <param name="s">XmlReader stream to parse from.</param>
/// <returns>Parsed TN.</returns>
public object Parse(System.Xml.XmlReader s, DatatypeFormatterParseResult result)
{
ANYFormatter baseFormatter = new ANYFormatter();
TN tn = baseFormatter.Parse <TN>(s, result);
// Parse the mixed content and add it to the list.
if (!s.IsEmptyElement)
{
string oldName = s.LocalName;
ENXP tnPart = new ENXP("");
while (s.Read() && s.NodeType != System.Xml.XmlNodeType.EndElement && s.LocalName != oldName)
{
if (s.NodeType == System.Xml.XmlNodeType.Text || s.NodeType == System.Xml.XmlNodeType.CDATA)
{
tnPart.Value += s.Value;
}
else if (s.NodeType == System.Xml.XmlNodeType.Element)
{
result.AddResultDetail(new NotImplementedElementResultDetail(ResultDetailType.Warning,
s.LocalName,
s.NamespaceURI,
s.ToString(), null));
}
}
tn.Part.Add(tnPart);
}
return(tn);
}
public static Setup Get(string idsetup)
{
TN db = new TN();
List <Setup> setups = db.Setups.Where(en => en.idsetup == idsetup).ToList();
return((setups != null && setups.Count() > 0)?setups.First():null);
}
public static List <Setup> GetByIdType(string idtype)
{
TN db = new TN();
List <Setup> setups = db.Setups.Where(en => en.idtype == idtype).ToList();
return(setups);
}
public static TCom.EF.User Get(long iduser)
{
List <TCom.EF.User> entities = new List <TCom.EF.User>();
TN db = new TN();
return(db.Users.Where(en => en.iduser == iduser).First());
}
public static Business Edit(Business business)
{
TN db = new TN();
Business oldBusiness = db.Businesses.Where(en => en.idbuss == business.idbuss).FirstOrDefault();
oldBusiness.idbuss = business.idbuss;
oldBusiness.buss = business.buss;
oldBusiness.contact = business.contact;
oldBusiness.phone = business.phone;
oldBusiness.city = business.city;
oldBusiness.addr = business.addr;
oldBusiness.sellpt = business.sellpt;
oldBusiness.cretime = business.cretime;
oldBusiness.busstime = business.busstime;
oldBusiness.price = business.price;
oldBusiness.longitude = business.longitude;
oldBusiness.latitude = business.latitude;
oldBusiness.runtime = business.runtime;
oldBusiness.notes = business.notes;
oldBusiness.blevel = business.blevel;
oldBusiness.inuse = business.inuse;
db.SaveChanges();
return(oldBusiness);
}
public static List <TaskViewModel> Search(DateTime?startDate, DateTime?endDate, string orderno = "", string idsend = "", string idrevc = "")
{
IQueryable <Task> queryable = CommonSearch(startDate, endDate, orderno, idsend, idrevc);
List <Task> entities = queryable.ToList();
List <TaskViewModel> viewModels = new List <TaskViewModel>();
viewModels = entities.Select(mod =>
{
TaskViewModel viewModel = new TaskViewModel();
viewModel.CopyFromBase(mod);
return(viewModel);
}).ToList();
viewModels = viewModels.Distinct(new TaskViewModel()).ToList();
TN db = new TN();
List <TaskRecver> taskRecvers = db.TaskRecvers.ToList();
List <TaskRecverViewModel> taskRecverViewModels = taskRecvers.Select(mod =>
{
TaskRecverViewModel viewModel = new TaskRecverViewModel();
viewModel.CopyFromBase(mod);
return(viewModel);
}).ToList();
viewModels = viewModels.Select(mod =>
{
mod.TaskRecvers = taskRecverViewModels.Where(en => en.idtask == mod.idtask).ToList();
return(mod);
}).ToList();
return(viewModels);
}
public static City Get(string idcity)
{
TN db = new TN();
List <City> cities = db.Cities.Where(en => en.idcity == idcity).ToList();
return((cities != null && cities.Count > 0) ? cities.First() : null);
}
public Result <NoticeDetail> GetDetail(string idNotice)
{
Result <NoticeDetail> result = new Result <NoticeDetail>();
try
{
if (!string.IsNullOrWhiteSpace(idNotice))
{
using (TN db = new TN())
{
result.Data = (from n in db.Notices
where (n.idnotice == idNotice)
select new NoticeDetail()
{
idnotice = n.idnotice,
title = n.title,
publish_time = n.publish_time,
content = n.content
}).FirstOrDefault();
result.Code = R.Ok;
}
}
}
catch (Exception)
{
result.Code = R.Error;
}
return(result);
}
public Result <List <NoticeBaseItem> > GetList(string city)
{
Result <List <NoticeBaseItem> > result = new Result <List <NoticeBaseItem> >();
try
{
using (TN db = new TN())
{
DateTime s = DateTime.Now;// DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
result.Data = (from n in db.Notices
where (n.start_time <= s && n.end_time >= s)
select new NoticeBaseItem()
{
idnotice = n.idnotice,
title = n.title,
publish_time = n.publish_time
}).ToList();
result.Code = R.Ok;
}
}
catch (Exception)
{
result.Code = R.Error;
}
return(result);
}
public Result <List <TCom.EF.City> > GetCity()
{
Result <List <TCom.EF.City> > result = new Result <List <TCom.EF.City> >();
result.Data = Cache.Mgr.Get <List <TCom.EF.City> >(Cache.Key.City);
if (result.Data == null)
{
try
{
using (TN db = new TN())
{
result.Data = db.Cities.Where(mr => mr.inuse == true).OrderByDescending(m => m.isdefault).OrderByDescending(m => m.sortno).ToList();
result.Code = R.Ok;
}
}
catch (Exception)
{
result.Code = R.Error;
result.Msg = "出现异常";
}
}
else
{
result.Code = R.Ok;
}
return(result);
}
public Result <MercDataSingle> GetMercSingle(string idmerc)
{
Result <MercDataSingle> result = new Result <MercDataSingle>();
try
{
if (!string.IsNullOrWhiteSpace(idmerc))
{
int _idmerc = int.Parse(idmerc);
using (TN db = new TN())
{
MercDataSingle m = new MercDataSingle()
{
Merc = db.Mercs.First(mr => mr.inuse == true && mr.idmerc == _idmerc),
Spec = db.Specs.Where(mr => mr.inuse == true && mr.idmerc == _idmerc).ToList(),
Discount = db.Discounts.Where(mr => mr.inuse == true && mr.idmerc == _idmerc).ToList(),
Imgs = (from im in db.MercImages where (im.idmerc == _idmerc) select im.Path).ToList()
};
if (m.Merc != null)
{
m.Setups = db.Setups.Where(mr => mr.inuse == true && mr.idtype == m.Merc.idtype.ToString()).ToList();
m.SetupAddrs = db.SetupAddrs.Where(mr => mr.inuse == true && mr.idtype == m.Merc.idtype.ToString()).ToList();
}
result.Data = m;
result.Code = R.Ok;
}
}
}
catch (Exception e)
{
result.Code = R.Error;
result.Msg = "出现异常" + e.Message;
}
return(result);
}
public static Merc GetMerc(int idmerc)
{
TN db = new TN();
List <Merc> mercs = db.Mercs.Where(en => en.idmerc == idmerc).ToList();
return((mercs != null && mercs.Count > 0) ? mercs.First() : null);
}
public static MyOrder Edit(MyOrder order)
{
TN db = new TN();
MyOrder oldOrder = db.MyOrders.Where(en => en.orderno == order.orderno).FirstOrDefault();
oldOrder.orderno = order.orderno;
oldOrder.iduser = order.iduser;
oldOrder.idmerc = order.idmerc;
oldOrder.merc = order.merc;
oldOrder.idspec = order.idspec;
oldOrder.spec = order.spec;
oldOrder.month = order.month;
oldOrder.attmonth = order.attmonth;
oldOrder.count = order.count;
oldOrder.price = order.orderno;
oldOrder.contact = order.contact;
oldOrder.addr = order.addr;
oldOrder.phone = order.phone;
oldOrder.cretime = order.cretime;
oldOrder.stime = order.stime;
oldOrder.entime = order.entime;
oldOrder.otype = order.otype;
oldOrder.status = order.status;
oldOrder.img = order.img;
oldOrder.notes = order.notes;
oldOrder.idc = order.idc;
oldOrder.idc_img1 = order.idc_img1;
oldOrder.idc_img2 = order.idc_img2;
oldOrder.inuse = order.inuse;
db.SaveChanges();
return(oldOrder);
}
public static List <Merc> GetALL()
{
TN db = new TN();
return((from mo in db.Mercs join mt in db.MercTypes on mo.idtype equals mt.idtype orderby mt.sortno descending, mo.sortno descending select mo).ToList());
//return db.Mercs.ToList();
}
public static Advertise Get(string idav)
{
TN db = new TN();
List <Advertise> advertises = db.Advertises.Where(en => en.idav == idav).ToList();
return((advertises != null && advertises.Count > 0) ? advertises.First() : null);
}
private static List <AdvertiseViewModel> ConvertToViewModel(List <Advertise> entities)
{
List <AdvertiseViewModel> viewModels = new List <AdvertiseViewModel>();
List <string> idtypes = entities.Select(mod => {
return(mod.idat);
}).ToList();
idtypes = idtypes.Distinct().ToList();
TN db = new TN();
List <AdvertiseType> advertiseTypes = db.AdvertiseTypes.Where(en => idtypes.Contains(en.idat)).ToList();
viewModels = entities.Select(mod => {
AdvertiseViewModel viewModel = new AdvertiseViewModel();
viewModel.CopyFromBase(mod);
if (advertiseTypes != null && advertiseTypes.Count > 0)
{
List <AdvertiseType> tempAdvertiseTypes = advertiseTypes.Where(en => en.idat == viewModel.idat).ToList();
AdvertiseType tempAdvertiseType = (tempAdvertiseTypes != null && tempAdvertiseTypes.Count > 0) ? tempAdvertiseTypes.First() : null;
AdvertiseTypeViewModel tempAdvertiseTypeModel = new AdvertiseTypeViewModel();
if (tempAdvertiseType != null)
{
tempAdvertiseTypeModel.CopyFromBase(tempAdvertiseType);
viewModel.AdvertiseType = tempAdvertiseTypeModel;
}
}
return(viewModel);
}).ToList();
return(viewModels);
}
/// <summary>
/// 获取表中的最大的主键值
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="expression"></param>
/// <returns></returns>
public static int GetMaxIdentifyID <T>(Expression <Func <T, int> > expression) where T : class
{
TN db = new TN();
Type type = typeof(T);
string efModelTypeName = type.Name;
string propertyName = string.Empty;
Type dbType = typeof(TN);
if (efModelTypeName == "Business")
{
propertyName = string.Format("{0}es", efModelTypeName);
}
else
{
propertyName = string.Format("{0}s", efModelTypeName);
}
DbSet <T> efModelList = (DbSet <T>)dbType.GetProperty(propertyName).GetValue(db);
if (efModelList == null || efModelList.Count() == 0)
{
return(999);
}
return(efModelList.Max(expression));
}
public Result <OrderListInfo> List(string iduser)
{
Result <OrderListInfo> result = new Result <OrderListInfo>();
try
{
if (!string.IsNullOrWhiteSpace(iduser))
{
long _iduser = long.Parse(iduser);
using (TN db = new TN())
{
result.Data = new OrderListInfo()
{
Order = db.MyOrders.Where(m => m.inuse == true && m.iduser == _iduser).OrderByDescending(m => m.cretime).ToList()
};
result.Code = R.Ok;
}
}
}
catch (Exception)
{
result.Code = R.Error;
result.Msg = "出现异常";
}
return(result);
}
public void TNUsePartTest()
{
TN a = new TN("Andy");
a.NullFlavor = null;
Assert.IsTrue(a.Validate());
}
public Result <TCom.EF.MyOrder> DetailFoyPay(string iduser, string orderno)
{
Result <TCom.EF.MyOrder> result = new Result <TCom.EF.MyOrder>();
try
{
if (!string.IsNullOrWhiteSpace(iduser) && !string.IsNullOrWhiteSpace(orderno))
{
long _iduser = long.Parse(iduser);
long _orderno = long.Parse(orderno);
using (TN db = new TN())
{
TCom.EF.MyOrder o = db.MyOrders.Where(m => m.inuse == true && m.iduser == _iduser && m.orderno == _orderno).FirstOrDefault();
result.Data = o;
result.Code = R.Ok;
}
}
}
catch (Exception)
{
result.Code = R.Error;
result.Msg = "出现异常";
}
return(result);
}
public static SetupAddr Get(string idaddr)
{
TN db = new TN();
List <SetupAddr> setupAddrs = db.SetupAddrs.Where(en => en.idaddr == idaddr).ToList();
return((setupAddrs != null && setupAddrs.Count() > 0) ? setupAddrs.First() : null);
}
public void TNPart2NullFlavorTest()
{
TN a = new TN("Hiro");
a.NullFlavor = NullFlavor.NotAsked;
Assert.IsFalse(a.Validate());
}
public void TNUsePartNullFlavorTest()
{
TN a = new TN("Andy");
a.NullFlavor = NullFlavor.NotAsked;
Assert.IsFalse(a.Validate());
}
public static List <SetupAddr> GetByIdSetup(string idsetup)
{
TN db = new TN();
List <SetupAddr> setupAddrs = db.SetupAddrs.Where(en => en.idsetup == idsetup).ToList();
return(setupAddrs);
}
public static CityRelation Get(string idrelation)
{
TN db = new TN();
List <CityRelation> cityRelations = db.CityRelations.Where(en => en.idrelation == idrelation).ToList();
return((cityRelations != null && cityRelations.Count > 0) ? cityRelations.First() : null);
}
public void NameAndDOB(string FirstName, string Surname, string DateofBirth, string Telephonenumber)
{
FN.SendKeys(FirstName);
SN.SendKeys(Surname);
DOB.SendKeys(DateofBirth);
TN.SendKeys(Telephonenumber);
}
public void TNPart2Test()
{
TN a = new TN("Yoshi");
a.NullFlavor = null;
Assert.IsTrue(a.Validate());
}
public void TNMultiplePartsTest()
{
TN a = new TN();
String s1 = "Andria";
String s2 = "Samples";
a.Part.Add(new ENXP(s1));
a.Part.Add(new ENXP(s2));
a.NullFlavor = null;
Assert.IsFalse(a.Validate());
}
public void TNPartENXPTypeTest()
{
TN a = new TN();
a.Part.Add(new ENXP("Yoshi", EntityNamePartType.Family));
a.NullFlavor = null;
Assert.IsFalse(a.Validate());
}
public void TNUsePartNullFlavorTest()
{
TN a = new TN( "Andy");
a.NullFlavor = NullFlavor.NotAsked;
Assert.IsFalse(a.Validate());
}
public void TNUsePartTest()
{
TN a = new TN("Andy");
a.NullFlavor = null;
Assert.IsTrue(a.Validate());
}
public void TNPart2NullFlavorTest()
{
TN a = new TN("Hiro");
a.NullFlavor = NullFlavor.NotAsked;
Assert.IsFalse(a.Validate());
}
public void R2TNQualifierParseTest()
{
TN inti = new TN("Sir Dr. John Jacob Jingleheimer-Schmidt III") { Flavor = "EN.TN" };
string actualXml = R2SerializationHelper.SerializeAsString(inti);
var int2 = R2SerializationHelper.ParseString<TN>(actualXml);
Assert.AreEqual(inti, int2);
}
public _Runnable_308(TN _enclosing)
{
this._enclosing = _enclosing;
}
public void TNNullTest()
{
TN a = new TN();
a.NullFlavor = null;
a.Part.Clear();
Assert.IsFalse(a.Validate());
}
public void TNPartNullFlavorTest()
{
TN a = new TN();
a.Part.Add(new ENXP("Hiro"));
a.NullFlavor = NullFlavor.NotAsked;
Assert.IsFalse(a.Validate());
}
public void TNPart2Test()
{
TN a = new TN("Yoshi");
a.NullFlavor = null;
Assert.IsTrue(a.Validate());
}
public void TNNullFlavorTest()
{
TN a = new TN();
a.Part.Clear();
a.NullFlavor = NullFlavor.NotAsked;
Assert.IsTrue(a.Validate());
}
public void R2TNQualifierSerializationTest()
{
TN inti = new TN("Sir Dr. John Jacob Jingleheimer-Schmidt III");
string expectedXml = @"<test xmlns=""urn:hl7-org:v3"" xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" flavorId=""EN.TN""><part value=""Sir Dr. John Jacob Jingleheimer-Schmidt III""/></test>";
string actualXml = R2SerializationHelper.SerializeAsString(inti);
R2SerializationHelper.XmlIsEquivalent(expectedXml, actualXml);
}
public void TNPartTest()
{
TN a = new TN();
String s = "Yoshi";
a.Part.Add(new ENXP(s));
a.NullFlavor = null;
Assert.IsTrue(a.Validate());
}
public MainProgram()
{
#region Set Dependencies
sfun = new SFUN();
monit = new MONIT();
ztime = new ZTIME();
stpmax = new STPMAX();
modz = new MODZ();
cnvtst = new CNVTST();
crash = new CRASH();
negvec = new NEGVEC();
lsout = new LSOUT();
mchpr1 = new MCHPR1();
ssbfgs = new SSBFGS();
getptc = new GETPTC();
ddot = new DDOT();
daxpy = new DAXPY();
dnrm2 = new DNRM2();
dcopy = new DCOPY();
dxpy = new DXPY();
gtims = new GTIMS(SUBSCR);
setpar = new SETPAR(SUBSCR);
ndia3 = new NDIA3(ddot);
step1 = new STEP1(mchpr1);
chkucp = new CHKUCP(mchpr1, dnrm2);
setucr = new SETUCR(ddot);
mslv = new MSLV(ddot, ssbfgs);
msolve = new MSOLVE(mslv, SUBSCR);
initp3 = new INITP3(ddot, dcopy);
initpc = new INITPC(initp3, SUBSCR);
modlnp = new MODLNP(ddot, initpc, ztime, msolve, gtims, ndia3, daxpy, negvec, dcopy);
linder = new LINDER(ddot, getptc, lsout, dcopy);
lmqn = new LMQN(dnrm2, step1, ddot, setpar, chkucp, setucr, modlnp, dcopy, linder, dxpy
, SUBSCR);
mainc = new MAINC(sfun, lmqn);
tn = new TN(mchpr1, lmqn);
mains = new MAINS(sfun, tn);
lmqnbc = new LMQNBC(ddot, dnrm2, step1, crash, setpar, chkucp, setucr, ztime, monit, modlnp
, dcopy, stpmax, linder, modz, cnvtst, dxpy, SUBSCR);
maincb = new MAINCB(sfun, lmqnbc);
tnbc = new TNBC(mchpr1, lmqnbc);
mainsb = new MAINSB(sfun, tnbc);
#endregion
}
