public List <wrench> select() { List <wrench> wrechlist = new List <wrench>(); ServerHelp.findList <wrench>(out wrechlist, _webip); return(wrechlist); }
public void ProcessRequest(HttpContext context) { //执形对应服务的方法 ServerDescription serverTypeDescription = ServerHelp.GetServiceController(this.currentServerActionPair.Server); if (serverTypeDescription == null) { ExceptionHelper.Throw404Exception(context); } //服务对应的Type Type type = serverTypeDescription.ServerType; //得到方法 MethodInfo method = type.GetMethod(this.currentServerActionPair.Action, BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Static | BindingFlags.Instance); if (method == null) { ExceptionHelper.Throw404Exception(context); } List <object> parameters = new List <object>(); foreach (ParameterInfo parameter in method.GetParameters()) { parameters.Add(this._modelBinder.BindModel(parameter.Name, parameter.ParameterType)); } object obj = Activator.CreateInstance(type); object content = method.Invoke(obj, parameters.ToArray()); context.Response.ContentType = "text/plain"; context.Response.Write(content); }
public List <Model.errorrangset> select() { List <errorrangset> el = new List <errorrangset> (); ServerHelp.findList <errorrangset>(out el, _webip); return(el); }
public List <Model.department> Select() { List <Model.department> dep = new List <Model.department>(); ServerHelp.findList <Model.department>(out dep, _webIp); return(dep); }
public List <Model.UserToRoleModel.usertorole> select() { List <QDDL.Model.UserToRoleModel.usertorole> url = new List <Model.UserToRoleModel.usertorole>(); ServerHelp.findList(out url, _webip); return(url); }
public List <wrenchspecies> select() { List <wrenchspecies> wp = new List <wrenchspecies> (); ServerHelp.findList <wrenchspecies>(out wp, _webip); return(wp); }
public List <Model.wrenchstatus> selectAll() { List <wrenchstatus> wrenchstatuslist = new List <wrenchstatus> (); ServerHelp.findList <wrenchstatus>(out wrenchstatuslist, _webip); return(wrenchstatuslist); }
public List <role> Select() { List <role> rolelist = new List <role>(); ServerHelp.findList <role>(out rolelist, _webip); return(rolelist); }
public List <Model.duties> Select() { List <duties> dl = new List <duties>(); ServerHelp.findList <duties>(out dl, _webip); return(dl); }
public List <users> Select() { List <Model.users> userlist = new List <Model.users>(); ServerHelp.findList <Model.users>(out userlist, _webserviceip); return(userlist); }
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 bool Update(Model.torquechecktarget torquechecktarget) { string tableName = typeof(torquechecktarget).Name; string contion = string.Format("guid='{0}'", torquechecktarget.guid); string sql = string.Format("wrenchID_id='{0}',checkDate='{1}',qaID='{2}',operatorID='{3}',torqueTargetValue='{4}',errorRangeMax='{5}',is_good='{6}',comment='{7}',errorRangeMin='{8}'", torquechecktarget.wrenchID, Convert.ToDateTime(torquechecktarget.checkDate), torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.is_good?1:0, torquechecktarget.comment, torquechecktarget.errorRangeMin); return(ServerHelp.updateByWhere(tableName, _webip, contion, sql)); }
public bool update(Model.wrenchstatus wrenchstatusmodel) { string tableName = typeof(wrenchstatus).Name; string contion = string.Format("guid='{0}'", wrenchstatusmodel.guid); string sql = string.Format("statusName='{0}',statusDM='{1}',comment='{2}'", wrenchstatusmodel.statusName, wrenchstatusmodel.statusDM, wrenchstatusmodel.comment); return(ServerHelp.updateByWhere(tableName, _webip, contion, sql)); }
public bool update(Model.UserToRoleModel.usertorole usertorolemodel) { string sql = string.Format("role_id='{0}'", usertorolemodel.role); string contion = string.Format("user_id='{0}'", usertorolemodel.user); string tablename = typeof(QDDL.Model.UserToRoleModel.usertorole).Name; return(ServerHelp.updateByWhere(tablename, _webip, contion, sql)); }
public bool Update(Model.duties duty) { string tableName = typeof(duties).Name; string contion = string.Format("guid='{0}'", duty.guid); string sql = string.Format("department_id='{0}',dutiesName='{1}',comment='{2}'", duty.department, duty.dutiesName, duty.comment); return(ServerHelp.updateByWhere(tableName, _webip, contion, sql)); }
public bool update(Model.borrowrecord borrowrecordmodel) { string tablename = typeof(borrowrecord).Name; string contion = string.Format("guid='{0}'", borrowrecordmodel.guid); string strsql = string.Format("WrenchID_id='{0}',returnDate='{1}',returnOperator='{2}',returnUser='******',is_return='{4}',comment='{5}'", borrowrecordmodel.WrenchID, borrowrecordmodel.returnDate = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), borrowrecordmodel.returnOperator, borrowrecordmodel.returnUser, borrowrecordmodel.is_return ?1:0, borrowrecordmodel.comment); return(ServerHelp.updateByWhere(tablename, _webip, contion, strsql)); }
public bool update(Model.errorrangset errorrangsetmodel) { string tableName = typeof(errorrangset).Name; string sql = string.Format("id='{0}',speciesID='{1}',rangmax='{2}',rangmin='{3}',unit='{4}',errorrangMax='{5}',comment='{6}',errorrangMin='{7}'", errorrangsetmodel.id, errorrangsetmodel.speciesID, errorrangsetmodel.rangmax, errorrangsetmodel.rangmin, errorrangsetmodel.unit, errorrangsetmodel.errorrangMax, errorrangsetmodel.comment, errorrangsetmodel.errorrangMin); string contion = string.Format("id='{0}'", errorrangsetmodel.id); return(ServerHelp.updateByWhere(tableName, _webip, contion, sql)); }
public bool update(Model.systemcheckset systemchecksetmodel) { string contion = string.Format("systemname='{0}'", systemchecksetmodel.systemname); string sql = string.Format("id='{0}',count='{1}',arry='{2}',boundaryvalue='{3}',throwvalue='{4}',comment='{5}'", systemchecksetmodel.id, systemchecksetmodel.count, systemchecksetmodel.arry, systemchecksetmodel.boundaryvalue, systemchecksetmodel.throwvalue, systemchecksetmodel.comment); string tablename = typeof(systemcheckset).Name; return(ServerHelp.updateByWhere(tablename, _webip, contion, sql)); }
public bool updata(Model.wrenchspecies species) { string tableName = typeof(wrenchspecies).Name; string sql = string.Format("speciesName='{0}',speciesCode='{1}',parentSpecies='{3}',comment='{2}'", species.speciesName, species.speciesCode, species.comment, species.parentSpecies); string contion = string.Format("guid='{0}'", species.guid); return(ServerHelp.updateByWhere(tableName, _webip, contion, sql)); }
public bool Update(borrow borrowmodel) { string tablename = typeof(borrow).Name; string strsql = string.Format("WrenchID_id='{0}',borrowUser='******',borrowOperator='{2}',returnUser='******',returnOperator='{4}',borrowDate='{5}',returnDate='{6}',comment='{7}',is_return={8}", borrowmodel.WrenchID, borrowmodel.borrowUser, borrowmodel.borrowOperator, borrowmodel.returnUser, borrowmodel.returnOperator, borrowmodel.borrowDate, borrowmodel.returnDate, borrowmodel.comment, borrowmodel.is_return); string contation = string.Format("guid='{0}'", borrowmodel.guid); return(ServerHelp.updateByWhere(tablename, _webip, contation, strsql)); }
public bool Update(Model.department departmentmodel) { string tableName = typeof(department).Name; string contion = string.Format("guid='{0}'", departmentmodel.guid); string sql = string.Format("departmentName='{0}',parentDepartment='{1}',comment='{2}',delDepartment={3}", departmentmodel.departmentName, departmentmodel.parentDepartment, departmentmodel.comment, departmentmodel.delDepartment); return(ServerHelp.updateByWhere(tableName, _webIp, contion, sql)); }
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 bool Update(role userrole) { // return ServerHelp.updateSingleInfo<role>(userrole.id ,userrole ,_webip ); string tbname = typeof(role).Name; string contion = string.Format("guid='{0}'", userrole.guid); string strsql = string.Format("roleName='{0}',system_id='{1}',roleDM='{2}',comment='{3}' ", userrole.roleName, userrole.system, userrole.roleDM, userrole.comment); return(ServerHelp.updateByWhere(tbname, _webip, contion, strsql)); }
public int SelectCount() { string condition = ""; return(ServerHelp.findListWhereCount(condition, _webip, typeof(wrench).Name)); // return Convert.ToInt16(ServerHelp.findDataByContion<int>(condition, "", _webip, typeof(wrench).Name).FirstOrDefault()); }
public bool Update(users user) { string tablename = typeof(users).Name; string strsql = string.Format("username='******',password='******',is_staff={2},empID='{3}',cardID='{4}',phoneNumber='{5}',IDNum='{6}',mail='{7}',department_id='{8}',comment='{9}',is_superuser={10},duties_id='{11}'", user.username, user.password, user.is_staff, user.empID, user.cardID, user.phoneNumber, user.IDNum, user.mail, user.department, user.comment, user.is_superuser, user.duties); string contation = string.Format("guid='{0}'", user.guid); return(ServerHelp.updateByWhere(tablename, _webserviceip, contation, strsql)); }
public bool updata(Model.wrench wrenchtool) { string tablename = typeof(wrench).Name; string contion = string.Format("guid='{0}'", wrenchtool.guid); string updatestr = string.Format( "wrenchCode='{0}',wrenchBarCode='{1}',rangeMin='{2}',rangeMax='{3}',factory='{4}',species_id='{5}',status_id='{6}',comment='{7}',targetvalue='{8}',unit='{9}',isallowcheck={10},cycletime={11},createDate='{12}' , targetvalue1='{13}',targetvalue2='{14}' , lastrepair='{15}'", wrenchtool.wrenchCode , wrenchtool.wrenchBarCode, wrenchtool.rangeMin, wrenchtool.rangeMax, wrenchtool.factory, wrenchtool.species, wrenchtool.status, wrenchtool.comment, wrenchtool.targetvalue, wrenchtool.unit, wrenchtool.isallowcheck, wrenchtool.cycletime, wrenchtool.createDate, wrenchtool.targetvalue1, wrenchtool.targetvalue2, wrenchtool.lastrepair); return(ServerHelp.updateByWhere(tablename, _webip, contion, updatestr)); }
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 <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 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)); }