public async Task <HttpResponseMessage> SaveResultIssue(int userID, int termDetailID, string reason, string description) { try { ResultDAL dal = new ResultDAL(); JsonResponse response = await dal.SaveResultIssue(userID, termDetailID, reason, description); if (response != null && response.Flag) { return(Request.CreateResponse <JsonResponse>(HttpStatusCode.OK, response)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
/// <summary> /// 上传零件记录 /// </summary> public static void UploadMaterialTable() { try { string sql = string.Format("SELECT * FROM {0}", BaseVariable.ResultTableName); //获取当前产品的数据表 DataTable table = LocalDbDAL.GetDataTable(sql); if (table == null || table.Rows.Count == 0) { return; } //向服务器发送请求,数据上传并返回上传成功的数据TID string IDs = ResultDAL.Upload(BaseVariable.DeviceEntity.ProductType, BaseVariable.ResultTableName, table); if (!string.IsNullOrEmpty(IDs)) { sql = string.Format("DELETE FROM {0} WHERE tid IN ({1});", BaseVariable.ResultTableName, IDs); LocalDbDAL.ExecuteSql(sql);//上传后删除本地数据 CLog.WriteStationLog("Sys", "UploadMaterialTable:TID->{" + IDs + "},Time:{" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "}"); //string[] str = IDs.Split(','); } } catch (Exception ex) { CLog.WriteErrLog(ex.Message); } }
public async Task <HttpResponseMessage> GetResultDetail(int userID, string moduleCode, string moduleStatus, int termDetailID, int assignmentSubmissionID) { try { ResultDAL dal = new ResultDAL(); ResultDetailInfo data = await dal.GetResultDetail(userID, moduleCode, moduleStatus, termDetailID, assignmentSubmissionID); if (data != null) { return(Request.CreateResponse <ResultDetailInfo>(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
[ActionName("GetResultForAccessor")] // accessorID = 555 , BatchID = 6134 public async Task <HttpResponseMessage> GetResultForAccessor(int accessorID, string month = "", string year = "") { try { ResultDAL dal = new ResultDAL(); if (String.IsNullOrEmpty(month) || month == "\"\"") { DateTime dateTime = DateTime.Now; month = dateTime.ToString("MMM"); } if (String.IsNullOrEmpty(year) || year == "\"\"") { DateTime dateTime = DateTime.Now; year = dateTime.ToString("yyyy"); } List <ResultForReturnInfo> data = await dal.GetResultForAccessor(accessorID, month, year); if (data != null) { return(Request.CreateResponse <List <ResultForReturnInfo> >(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
[ActionName("GetResultForSuperAdmin")] //BatchID = 3080 public async Task <HttpResponseMessage> GetResultForSuperAdmin(int batchID) { try { ResultDAL dal = new ResultDAL(); List <ResultForReturnInfo> data = await dal.GetResultForSuperAdmin(batchID); if (data != null) { return(Request.CreateResponse <List <ResultForReturnInfo> >(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
/// <summary> /// 上传零件记录 /// </summary> private void UploadTable() { this.Invoke((EventHandler) delegate { try { Cursor.Current = Cursors.WaitCursor; progressBar.Value = 0; progressBar.Maximum = 1; string sql = string.Format("SELECT * FROM {0}", BaseVariable.ResultTableName); //获取当前产品的数据表 DataTable table = LocalDbDAL.GetDataTable(sql); if (table == null || table.Rows.Count < 1) { return; } //向服务器发送请求,数据上传并返回上传成功的数据TID string IDs = ResultDAL.Upload(BaseVariable.DeviceEntity.ProductType, BaseVariable.ResultTableName, table); if (!string.IsNullOrEmpty(IDs)) { sql = string.Format("DELETE FROM {0} WHERE tid IN ({1});", BaseVariable.ResultTableName, IDs); LocalDbDAL.ExecuteSql(sql);//上传后删除本地数据 string [] str = IDs.Split(','); uploadnum += str.Length; } ProgressTip(1);//更新进度 Cursor.Current = Cursors.Default; } catch (Exception ex) { CLog.WriteErrLog(ex.Message); } }); }
public static bool AddResult(ResultInsert result) { try { return(ResultDAL.AddResult(result)); } catch (Exception) { throw; } }
public static List <ResultSeach> SeachResultByStu(string stuNo) { try { return(ResultDAL.SeachResultByStu(stuNo)); } catch (Exception) { throw; } }
public static List <Result> GetResultByStu(string StuNo) { try { return(ResultDAL.GetResultByStu(StuNo)); } catch (Exception) { throw; } }
/// <summary> /// 应用更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnApply_Click(object sender, EventArgs e) { try { int rst = 0; if (Opt.GlobalNetStatus())//网络状态良好的情况下 { rst = ResultDAL.Update(BaseVariable.ResultTableName, this.lblHJCode.Text, this.lblProductCode.Text, "", "", "", RequestParam); rst = ResultDAL.Update(BaseVariable.ResultTableName, this.lblHJCode.Text, this.lblProductCode.Text, BaseVariable.DeviceEntity.ProductType, BaseVariable.UserEntity.UserID, BaseVariable.DeviceEntity.StationID, RequestParam); } if (rst == 1) { //重新加载数据 foreach (ListViewItem item in this.lvMaterial.Items) { item.SubItems[2].Text = "";//扫描条码 item.ForeColor = Color.Black; } this.lblTip.Text = "更新成功!请扫描合件条码"; Audio.SoundTip(2);//正确提示音 this.lblHJCode.Text = ""; this.lblMaterialCode.Text = ""; this.lblBarCode.Text = ""; scantype = ScanType.MATERIALCODE; IsHjScan = true; RequestParam.Clear(); } else if (rst == 201) { this.lblTip.Text = "合件不存在!"; Audio.SoundTip(0);//失败提示音 } else { this.lblTip.Text = "更新失败!"; Audio.SoundTip(0);//失败提示音 } } catch (Exception ex) { CLog.WriteErrLog(ex.Message); } }
public async Task <HttpResponseMessage> GetStudentDashboard(int userID, int batchID, string role, int currentIndex, int maxRows) { try { MIUEntities db = new MIUEntities(); StudentDashboardInfo data = new StudentDashboardInfo(); EventCalendarDAL dal = new EventCalendarDAL(); NewsDAL newsDAL = new NewsDAL(); ResultDAL resultDAL = new ResultDAL(); AnnouncementDAL announcementDAL = new AnnouncementDAL(); ReportAttendanceDAL reportAttendanceDAL = new ReportAttendanceDAL(); data.EventCalendar = await dal.GetAllEventCalendar(userID, role); data.News = await newsDAL.GetNews(userID, currentIndex, maxRows); string batchCode = db.Batches.Where(x => x.ID == batchID).Select(x => x.BatchCode).SingleOrDefault(); data.StudentDashboard = await resultDAL.GetResult(userID, batchCode); data.Announcement = await announcementDAL.GetLatestAnnouncement(); //data.AttRateAndPercent = await reportAttendanceDAL.GetAttRateAndPercent(batchID, userID); if (data != null) { return(Request.CreateResponse <StudentDashboardInfo>(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
public async Task <HttpResponseMessage> GetLectureDashboard(int accessorID, string role, int courseID = 0) { try { MIUEntities db = new MIUEntities(); LectureDashboardInfo data = new LectureDashboardInfo(); StudentDashboardDAL dal = new StudentDashboardDAL(); NewsDAL newsDAL = new NewsDAL(); ResultDAL resultDAL = new ResultDAL(); AnnouncementDAL announcementDAL = new AnnouncementDAL(); EventCalendarDAL eventDAL = new EventCalendarDAL(); //data.AttRateAndPercent = await reportAttendanceDAL.GetAttRateAndPercent(batchID, userID); data = await dal.GetLectureDashboard(accessorID, courseID); data.Announcement = await announcementDAL.GetLatestAnnouncement(); data.News = newsDAL.GetNews(accessorID, 1, 5).Result; data.EventCalendar = eventDAL.GetAllEventCalendar(accessorID, role).Result; //data.EventCalendar = eventDAL.GetEventCalendar(accessorID, 1, 5).Result; if (data != null) { return(Request.CreateResponse <LectureDashboardInfo>(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
public DataSet GetResult1(DateTime time, string flightno, string depAir, string arrAir) { ResultDAL dal = new ResultDAL(); return(dal.GetResult1(time, flightno, depAir, arrAir)); }
/// <summary> /// 防错追溯,将信息添加到数据库 /// </summary> private bool ScanResultToDb() { try { if (CurrnetScanType == 1 || (productModel.HaveSub && RequestParam.Count > 0)) { //获取批次信息 //GetBatchInfoToParam(); bool flag = false; //结果标识 if (Opt.GlobalNetStatus()) //网络状态良好的情况下 { DateTime time = DateTime.Now; flag = ResultDAL.Insert(BaseVariable.ResultTableName, this.lblHJCode.Text, this.lblProductCode.Text, this.productModel.ProductType, BaseVariable.UserEntity.UserID, BaseVariable.DeviceEntity.StationID, CurrnetScanType, RequestParam); this.WirteTimeSpanLog(DateTime.Now - time, LogType.RD); } else { flag = SaveToLocal();//存储到本地数据库中 } if (!flag) { flag = SaveToLocal();//存储到本地数据库中 } if (flag) { this.lblOK.Text = "OK"; this.Tip("扫描合件条码"); this.lblOK.ForeColor = Color.Green; CurrentCount++; this.lblCurrentCount.Text = CurrentCount.ToString(); return(true); } } this.lblOK.Text = "NG"; this.Tip("请重新操作"); this.lblOK.ForeColor = Color.Red; } catch (Exception ex) { bool rst = SaveToLocal();//存储到本地数据库中 if (rst) { this.lblOK.Text = "OK"; this.Tip("扫描合件条码"); this.lblOK.ForeColor = Color.Green; CurrentCount++; this.lblCurrentCount.Text = CurrentCount.ToString(); return(true); } else { this.lblOK.Text = "NG"; this.Tip("请重新操作"); this.lblOK.ForeColor = Color.Red; } CLog.WriteErrLog("[FrmScan.ScanResultToDB]" + ex.Message); } finally { this.WirteTimeSpanLog(new TimeSpan(0, 0, 0, 0, (int)watch.ElapsedMilliseconds), LogType.V1); watch.Reset(); //BatchTip();//批次信息提醒 } return(false); }
/// <summary> /// 获取当前条码是否存在 /// 1.合件号;2.零件号(是一一追溯的零件) /// </summary> /// <param name="type">1:合件,2:零件</param> /// <param name="barcode">要验证的条码</param> /// <param name="materialfiled">字段名</param> public bool ValidateScanIsExist(int Type, string BarCode, string Filed) { Stopwatch existWatch = new Stopwatch(); try { /* * 人物:xudy * 时间:2015-01-18 * 内容:修改了条件,讲userid、barcode换为tid */ if (Opt.GlobalNetStatus())//从服务器获取数据 { existWatch.Start(); //string requestUrl = BaseVariable.RequestURL + "Result.ashx"; //Dictionary<string, object> dict = new Dictionary<string, object>(); //dict.Add("do", "validate"); //dict.Add("Type", Type); //dict.Add("TableName", BaseVariable.ResultTableName); //dict.Add("BarCode", BarCode); //dict.Add("ProductCode", this.productModel.ProductCode); //dict.Add("Filed", Filed); //string str = Http.POST(requestUrl, dict); //var obj = JsonHelper.JsonDeSerializer<ReturnInfo>(str); //ReturnInfo ReturnData = (ReturnInfo)obj; //if (ReturnData != null && ReturnData.Code == "1") //{ // return true; //} return(ResultDAL.Validate(BaseVariable.ResultTableName, BarCode, this.productModel.ProductCode, Type, Filed)); } else//从本地获取数据 { string sql = ""; switch (Type) { case 1: //合件 sql = string.Format("select tid from {0} where barcode='{1}' and productcode='{2}'", BaseVariable.ResultTableName, BarCode, this.productModel.ProductCode); break; case 2: //子件 sql = string.Format("select tid from {0} where {2}='{1}'", BaseVariable.ResultTableName, BarCode, Filed); break; } object obj = LocalDbDAL.ExecuteScaler(sql); if (obj != null && !string.IsNullOrEmpty(obj.ToString())) { return(true); } } return(false); } catch (Exception ex) { CLog.WriteErrLog(ex.Message); return(false); } finally { LogType ty = LogType.Y1; switch (Type) { case 1: //合件 ty = LogType.Y1; break; case 2: //子件 ty = LogType.Y2; break; } this.WirteTimeSpanLog(new TimeSpan(0, 0, 0, 0, (int)existWatch.ElapsedMilliseconds), ty); existWatch.Stop(); } }