public List <torquechecktarget> SelectByDate(DateTime first, DateTime last, string wrenchID)
{
//DateTime start=dt;
//DateTime last=dt.AddDays (1).AddMilliseconds (-1);
string condition = string.Format("checkDate>='{0}' and checkDate<='{1}' and wrenchID_id='{2}'", first, last, wrenchID);
return(ServerHelp.findDataByCondition <torquechecktarget>(condition, _webip));
}
public Model.wrench selectByBarcode(string barcode)
{
try
{
string contion = string.Format("wrenchBarCode='{0}'", barcode);
return(ServerHelp.findDataByCondition <wrench>(contion, _webip).FirstOrDefault());
}
catch { return(new wrench()); }
}
public List <wrench> selectByContion(Dictionary <string, string> dict)
{
string str = "";
foreach (var d in dict)
{
str += (string.Format("{0}='{1}'" + " and ", d.Key, d.Value));
}
string contion = str.Count() > 4? str.Remove(str.Count() - 4):"";
return(ServerHelp.findDataByCondition <wrench>(contion, _webip));
}
public duties SelectByGuid(string guid)
{
string contion = string.Format("guid='{0}'", guid);
List <duties> duty = new List <duties>();
duty = ServerHelp.findDataByCondition <duties>(contion, _webip);
if (duty.Count > 0)
{
return(duty.FirstOrDefault());
}
return(new duties());
}
public List <borrow> SelectByCondition(Dictionary <string, string> condition)
{
string tablename = typeof(borrow).Name;
string str = "";
foreach (var d in condition)
{
str += string.Format("{0}='{1}'" + " and ", d.Key, d.Value);
}
string scontion = str.Count() > 4 ? str.Remove(str.Count() - 4) : "";
return(ServerHelp.findDataByCondition <borrow>(scontion, _webip));
}
public List <torquechecktarget> SelectByContion(Dictionary <string, string> dict, int pagesize, int pageno)
{
string temp = "";
foreach (var d in dict)
{
if (d.Key == "starttime")
{
temp += string.Format("checkDate>='{0}' and ", d.Value);
continue;
}
if (d.Key == "endtime")
{
temp += string.Format("checkDate<'{0}' and ", d.Value);
continue;
}
temp += string.Format("{0}='{1}' and ", d.Key, d.Value);
}
string contion = temp.Count() > 4 ? temp.Remove(temp.Count() - 4) : "";
contion += string.Format("LIMIT {0},{1}", (pageno * pagesize), pagesize);
return(ServerHelp.findDataByCondition <torquechecktarget>(contion, _webip));
}
public List <wrench> SelectBarorcode(string contion)
{
string condition = string.Format("wrenchBarCode='{0}' or wrenchCode='{1}'", contion, contion);
return(ServerHelp.findDataByCondition <wrench>(condition, _webip));
}
public List <borrow> SelectByWrench(string wrench, string user, bool isreturn = true)
{
string contion = string.Format("WrenchID_id='{0}' and is_return={1} and borrowUser='******'", wrench, isreturn, user);
return(ServerHelp.findDataByCondition <borrow>(contion, _webip));
}
public List <borrow> SelectByUser(string user, bool isreturn = true)
{
string contion = string.Format("borrowUser='******' and is_return={1}", user, isreturn);
return(ServerHelp.findDataByCondition <borrow>(contion, _webip));
}
public List <borrow> SelectWrenchOrBUser(string stime, string etime)
{
string contion = string.Format(" (borrowDate>='{0}' and borrowDate<='{1}')", stime, etime);
return(ServerHelp.findDataByCondition <borrow>(contion, _webip));
}
public wrenchstatus selectByStatusDM(string statusDM)
{
string contion = string.Format("statusDM='{0}'", statusDM);
return(ServerHelp.findDataByCondition <wrenchstatus>(contion, _webip).FirstOrDefault());
}
public role SelectById(string id)
{
string contion = string.Format("id='{0}'", id);
return(ServerHelp.findDataByCondition <role>(contion, _webip).FirstOrDefault());
}
/// <summary>
/// SelectBySysGuid 根据项目的id
/// </summary>
/// <param name="guid"></param>
/// <returns></returns>
public List <role> SelectBySysGuid(string guid)
{
string condition = string.Format("system_id='{0}'", guid);
return(ServerHelp.findDataByCondition <role>(condition, _webip));
}
public wrenchspecies selectByGuid(string guid)
{
string contion = string.Format("guid='{0}'", guid);
return(ServerHelp.findDataByCondition <wrenchspecies>(contion, _webip).FirstOrDefault());
}
public List <borrow> SelectWrenchOrBUser(string stime, string etime, string guid, bool?isreturn = false)
{
string contion = string.Format(" (is_return={0} and borrowDate>='{1}' and borrowDate<='{2}') and (WrenchID_id='{3}' or borrowUser='******')", isreturn ?? false, stime, etime, guid, guid);
return(ServerHelp.findDataByCondition <borrow>(contion, _webip));
}
public List <borrow> SelectByUser(string user)
{
string contion = string.Format("borrowUser='******'", user);
return(ServerHelp.findDataByCondition <borrow>(contion, _webip));
}
public Model.torquechecktarget SelectByGuid(string guid)
{
string contion = string.Format("guid='{0}'", guid);
return(ServerHelp.findDataByCondition <torquechecktarget>(contion, _webip).FirstOrDefault());
}
public List <Model.wrench> selectByid(int id)
{
string contion = string.Format("wrenchCode='{0}'", id);
return(ServerHelp.findDataByCondition <wrench>(contion, _webip));
}
public List <torquechecktarget> SelectByWrench(string wrenchguid)
{
string condition = string.Format("wrenchID_id='{0}'", wrenchguid);
return(ServerHelp.findDataByCondition <torquechecktarget>(condition, _webip));
}
public List <wrench> selectPage(int page, int pageNo)
{
string condition = string.Format(" id <=(SELECT id FROM wrench ORDER BY id desc LIMIT {0}, {1}) ORDER BY id desc LIMIT {2}", (pageNo - 1) * page, 1, page);
return(ServerHelp.findDataByCondition <wrench>(condition, _webip));
}
public List <borrow> SelectByWrench(string wrench)
{
string contion = string.Format("WrenchID_id='{0}'", wrench);
return(ServerHelp.findDataByCondition <borrow>(contion, _webip));
}
public List <Model.department> Select(string name, bool delflag = false)
{
string contion = string.Format("departmentName='{0}' and parentDepartment='{1}'", name, delflag);
return(ServerHelp.findDataByCondition <Model.department>(contion, _webIp));
}
public List <wrenchspecies> selectbyname(string name)
{
string contion = string.Format("speciesName='{0}'", name);
return(ServerHelp.findDataByCondition <wrenchspecies>(contion, _webip));
}
public Model.department SelectByGuid(string guid)
{
string contion = string.Format("guid='{0}'", guid);
return(ServerHelp.findDataByCondition <Model.department>(contion, _webIp).FirstOrDefault());
}
public List <Model.systemcheckset> selectBySystemname(string systemname)
{
string contion = string.Format("systemname='{0}'", systemname);
return(ServerHelp.findDataByCondition <systemcheckset>(contion, _webip));
}
public List <department> SelectByDelFlag(string parentid = "", bool delflag = false)
{
string contion = string.Format("delDepartment={0} and parentDepartment='{1}'", delflag, parentid);
return(ServerHelp.findDataByCondition <Model.department>(contion, _webIp));
}
public role SelectByGuid(string guid)
{
string condition = string.Format("guid='{0}'", guid);
return(ServerHelp.findDataByCondition <Model.role>(condition, _webip).FirstOrDefault());
}
public List <department> SelectByFlag(bool flag = false)
{
string contion = string.Format("delDepartment={0}", flag);
return(ServerHelp.findDataByCondition <Model.department>(contion, _webIp));
}
public List <role> selectSysidandguid(string systemid, string guid)
{
string condition = string.Format("guid='{0}' and system_id='{1}'", guid, systemid);
return(ServerHelp.findDataByCondition <role>(condition, _webip));
}
public List <Model.errorrangset> selectByspeciesid(string guid)
{
string contion = string.Format("speciesID_id='{0}'", guid);
return(ServerHelp.findDataByCondition <errorrangset>(contion, _webip));
}