/// <summary> /// 导入工人当天工作信息 /// </summary> /// <param name="selectName"></param> /// <param name="date"></param> /// <param name="selectWorkSite"></param> /// <param name="work">当天工时</param> /// <param name="workMore">加班工时</param> /// <param name="remark">工作日志</param> /// <returns></returns> public HttpResponseMessage GetImportWork(string selectWeather, string selectName, string date, string selectWorkSite, string work, string workMore, string remark) { using (WorkDataClassesDataContext db = new WorkDataClassesDataContext()) { string workId = BasicMethods.GetWorkerId(selectName); int workSiteId = BasicMethods.GetWorkerSiteId(selectWorkSite); Attendance att = new Attendance { RecordTime = DateTime.Now, WorkId = workId, WorkSiteId = workSiteId, WorkDate = Convert.ToDateTime(date), WorkTime = Convert.ToDouble(work), WorkMore = Convert.ToDouble(workMore), WorkQuality = remark, Weather = selectWeather }; string json = InsertAttendance(att); json = JsonConvert.SerializeObject(json); return(HttpResponseMessageToJson.ToJson(json)); } }
/// <summary> /// 导入工人工资支付情况 /// </summary> /// <param name="selectName"></param> /// <param name="date"></param> /// <param name="selectWorkSite"></param> /// <param name="wageCard">CCB、JS、Cash </param> /// <param name="pay">金额</param> /// <param name="payType">支付方式</param> /// <param name="remark">缘由</param> /// <returns></returns> public HttpResponseMessage GetImportPay(string selectName, string date, string selectWorkSite, string wageCard, string pay, string payType, string remark) { using (WorkDataClassesDataContext db = new WorkDataClassesDataContext()) { string workId = BasicMethods.GetWorkerId(selectName); int workSiteId = BasicMethods.GetWorkerSiteId(selectWorkSite); Payment p = new Payment { RecordTime = DateTime.Now, WorkId = workId, WorkSiteId = workSiteId, WagePaymentDate = Convert.ToDateTime(date), WageAmount = Convert.ToInt16(pay), PaymentType = payType, WageCard = wageCard, Remark = remark }; string json = InsertPayment(p); json = JsonConvert.SerializeObject(json); return(HttpResponseMessageToJson.ToJson(json)); } }
/// <summary> /// 导入数据稽核表格数据请求 /// </summary> /// <param name="limit">页面大小</param> /// <param name="offset">偏移量</param> /// <param name="sort">排序字段</param> /// <param name="sortOrder">升序或降序</param> /// <returns></returns> public HttpResponseMessage GetCheckImport(int limit, int offset, string sort, string sortOrder) { string date = HttpContext.Current.Request["date"]; string workSite = HttpContext.Current.Request["workSite"]; int workSiteId = 0; bool siteEffect = false; if (workSite == "all") { siteEffect = true; workSiteId = 0; } else { workSiteId = BasicMethods.GetWorkerSiteId(workSite); } using (WorkDataClassesDataContext db = new WorkDataClassesDataContext()) { var data = from s in db.Attendance where s.WorkDate == Convert.ToDateTime(date) && (siteEffect || s.WorkSiteId == workSiteId) select new { wSiteName = s.WorkSite.WorkSiteName, wName = s.Worker.WorkName, wDate = s.WorkDate.ToString(), work = s.WorkTime, workMore = s.WorkMore, workQua = s.WorkQuality, s.Weather }; //sortName排序的名称 sortType排序类型 (desc asc) var orderExpression = string.Format("{0} {1}", sort, sortOrder); //此处应从数据库中取得数据: string json = "{ \"total\":"; var total = data.Count(); json += total + ",\"rows\":"; var rows = data.OrderBy(orderExpression).Skip(offset).Take(limit).ToList(); json += JsonConvert.SerializeObject(rows); json += "}"; return(HttpResponseMessageToJson.ToJson(json)); } }
/// <summary> /// 修改工人当天工作信息 /// </summary> /// <param name="selectName"></param> /// <param name="date"></param> /// <param name="selectWorkSite"></param> /// <param name="work">当天工时</param> /// <param name="workMore">加班工时</param> /// <param name="remark">工作日志</param> /// <returns></returns> public HttpResponseMessage GetUpdateWork(string name, string date, string selectWorkSite, string work, string workMore, string remark) { using (WorkDataClassesDataContext db = new WorkDataClassesDataContext()) { string workId = BasicMethods.GetWorkerId(name); int workSiteId = BasicMethods.GetWorkerSiteId(selectWorkSite); Attendance att = new Attendance { RecordTime = DateTime.Now, WorkId = workId, WorkSiteId = workSiteId, WorkDate = Convert.ToDateTime(date), WorkTime = Convert.ToDouble(work), WorkMore = Convert.ToDouble(workMore), WorkQuality = remark }; Attendance modifyAtt = db.Attendance.Where(n => n.WorkDate == att.WorkDate && n.WorkId == att.WorkId && n.WorkSiteId == att.WorkSiteId).SingleOrDefault(); string json; if (modifyAtt != null) { //不能直接更新在原表里,放在remark //modifyAtt.WorkTime = att.WorkTime; //modifyAtt.WorkMore = att.WorkMore; modifyAtt.Remark = att.RecordTime + "+" + att.WorkTime + "+" + att.WorkMore + "+" + att.WorkQuality; db.SubmitChanges(); json = "ok"; } else { json = "error"; } json = JsonConvert.SerializeObject(json); return(HttpResponseMessageToJson.ToJson(json)); } }