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();
}
}
