public ResultMsg MultiDefectRepair2([FromBody] Qccastt qccastt) { LogManager.SetCommonLog("Method Call"); List <Qccastt> q = new List <Qccastt>(); q.Add(qccastt); return(QccasttUtility.QCCASTT_MultiDefectRepair(q)); }
public ActionResult GetJCarDef(string _Vin) { Qccastt q = new Qccastt(); q.Vin = _Vin; List <QccasttLight> lstQccasttLight = QccasttUtility.GetCarDefectLight(_Vin); //SelectList list = CommonUtility.ToSelectList(QccasttUtility.GetCarDefect(q,).Tables[0], "Bdstlcode", "AliasName", false); return(Json(lstQccasttLight, JsonRequestBehavior.AllowGet)); }
public List <Qccastt> tstCarDefect() { Qccastt q = new Qccastt(); //q.Vin = "NAS411100G1205277"; q.deletedby = -1; q.DateType = "M"; q.ActAreaSrl = 94; q.ActBy = 4314; return(QccasttUtility.GetCarDefect(q)); }
public ActionResult FromLoadFileReport() { var formValues = StiMvcViewer.GetFormValues(this.HttpContext); CarModels cm = new CarModels(); if (formValues.Count != 0) { cm.Vin = formValues.GetValues("vin").GetValue(0).ToString(); } else { cm.Vin = "NAS0"; } try { Qccastt qccastt = new Qccastt(); qccastt.Vin = cm.GetVin(); DataSet dsCardInfo = new DataSet(); if (!string.IsNullOrEmpty(cm.Vin)) { Object[] obj = null; dsCardInfo = QccasttUtility.GetCarDefect(qccastt, out obj); dsCardInfo.Tables[0].TableName = "CarDefects"; } StiReport report = new StiReport(); report.Load(Server.MapPath("/Content/ReportsFile/QCCard2.mrt")); StiText stitxtVin = (StiText)report.GetComponentByName("txtVin"); stitxtVin.Text = cm.GetVin(); // BCVin StiBarCode stiBCVin = (StiBarCode)report.GetComponentByName("BCVin"); stiBCVin.Code = new StiBarCodeExpression(cm.GetVin()); //report.RegBusinessObject("driverReport", dsCardInfo.Tables[0]); //int i = dsCardInfo.Tables[0].Rows.Count; //report.Compile(); report.RegData(dsCardInfo); return(StiMvcViewer.GetReportSnapshotResult(HttpContext, report)); } catch (Exception ex) { // lblVinMessage.Text = "خطا در دریافت اطلاعات"; return(View()); } }
public static Car GetCarInfo(Car car) { try { if ((car != null)) // && (U.Macaddress == "48:13:7e:11:d7:1f")) { //Value cannot be null. car.ValidFormat = CheckFormatVin(car.Vin); car.VinWithoutChar = GetVinWithoutChar(car.Vin); if (car.ValidFormat) { List <Car> carinfo = new List <Car>(); string commandtext = string.Format(@"select c.vin,c.engineno,c.prodno,c.joinerydate,c.bdmdlcode,c.bdstlcode,c.bdstlaliasname ,c.fitypecode,c.finqccode,c.clrcode, (select q.toareasrl from qcqctrt q where vin =c.vin and passed=0) as CurAreaSrl, c.JoinaryTeamDesc,c.nasvin,c.shopcode,c.shopname,c.joinaryteam,c.assmteamwork,c.assemblytypecode,c.gearboxtypecode,c.forexport,c.grpcode,c.bdmdlaliasname, c.grpname,c.comanyname as companyname,c.companycode,c.fitypename,c.clralias,c.gearboxtypedesc,c.prodenddate,substr(c.prodenddate_fa,0,16) as prodenddate_fa,substr(c.joinerydate_fa,0,16) as joinerydate_fa,substr(c.bodyshopproddate,0,16)as bodyshopproddate,substr(c.paintshopproddate,0,16) as paintshopproddate,substr(asmshopproddate,0,16) as asmshopproddate, (select distinct (s.shopcode) from pt.cartrace ct join pt.station s on ct.stncode = s.stncode where ct.vin = c.vin and ct.passed=0) as PTCurrentShopCode, {1} as ActAreaSrl,{2} as ActBy, (select count(srl) from qccastt t where t.qcareat_srl ={1} and t.vin = c.vin and t.isdefected=1 and t.inuse=1 and t.deletedby is null and t.recordowner=1 ) CurrentAreaDefCount, TO_char(p.createddate,'YYYY/MM/DD HH24:MI:SS','nls_calendar=persian') as ProCreatedDateFa, u.fname ||' '|| u.lname as ProCreatedByDesc,decode(p.LocIsValid,null,-1,p.LocIsValid) as LocIsValid from qccariddt c left join qcprot p on c.vin = p.vin left join qcusert u on p.createdby = u.srl where c.vin ='{0}' " , car.VinWithoutChar, car.ActAreaSrl, car.ActBy); // carinfo = DBHelper.GetDBObjectByObj2_OnLive(new Car(), null, commandtext, "inspector").Cast <Car>().ToList(); if (carinfo.Count == 1) { carinfo[0].ValidFormat = car.ValidFormat; carinfo[0].Vin = car.Vin; carinfo[0].VinWithoutChar = car.VinWithoutChar; Qccastt q = new Qccastt(); q.Vin = car.Vin; q.ActAreaSrl = car.ActAreaSrl; q.ActBy = car.ActBy; q.VinWithoutChar = car.VinWithoutChar; carinfo[0].lstQcqctrt = QccasttUtility.GetCarTrace(q); carinfo[0].lstQccastt = QccasttUtility.GetCarDefect(q); carinfo[0].LastStopTime = QccasttUtility.GetLastStopTime(car.VinWithoutChar); carinfo[0].CurAreaDefectCount = QccasttUtility.GettCurrentAreaDefectCoun(car.VinWithoutChar, car.ActAreaSrl.ToString()); //--- return(carinfo[0]); } else { car.msg = "car not found" + commandtext; return(car); } } else { car.msg = "vin is not valid format"; return(car); } } else { car.msg = "Car Is Null"; return(car); } } catch (Exception ex) { car.msg = ex.Message.ToString(); //string message = string.Format("Time: {0}", DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss tt")); //message += Environment.NewLine; //message += "-----------------------------------------------------------"; //message += Environment.NewLine; //message += string.Format("Message: {0}", ex.Message); //message += Environment.NewLine; //message += string.Format("StackTrace: {0}", ex.StackTrace); //message += Environment.NewLine; //message += string.Format("Source: {0}", ex.Source); //message += Environment.NewLine; //message += string.Format("TargetSite: {0}", ex.TargetSite.ToString()); //message += Environment.NewLine; //message += "-----------------------------------------------------------"; //message += Environment.NewLine; //string path = @"C:/ErrorLog/ErrorLog.txt"; //StreamWriter writer = new StreamWriter(path, true); //writer.WriteLine(message); //writer.Close(); return(car); } }
public List <Summary> UserSammary([FromBody] Qccastt qccastt) { return(QccasttUtility.GetUserSammary(qccastt.ActAreaSrl, qccastt.ActAreaSrl, 0, qccastt.RepairedByDesc)); }
public ResultMsg DefectDetect([FromBody] Qccastt qccastt) { return(QccasttUtility.QCCASTT_DefectDetect(qccastt)); }
public ResultMsg DeleteQccastt([FromBody] Qccastt qccastt) { return(QccasttUtility.Delete_QCCASTT(qccastt)); }
public List <Qccastt> CarDefect([FromBody] Qccastt qccastt) { return(QccasttUtility.GetCarDefect(qccastt)); }
public ResultMsg PDIConfirm([FromBody] Qccastt qccastt) { return(QccasttUtility.PDIConfirm(qccastt)); }