/// <summary> /// 获取责任客服报减信息 /// </summary> /// <param name="zrUserId">责任客服ID</param> /// <param name="page">页码</param> /// <param name="rows">每页显示的行数</param> /// <param name="search">查询条件</param> /// <param name="total">结果集的总数</param> /// <returns>结果集</returns> public List <SingleStopPaymentView> GetListFromP(int zrUserId, int page, int rows, string search, ref int total) { int companyId = 0; string employeeName = string.Empty; string cardIds = string.Empty; Dictionary <string, string> queryDic = ValueConvert.StringToDictionary(search.GetString()); if (queryDic != null && queryDic.Count > 0) { foreach (var item in queryDic) { if (item.Key == "CardIDs") {//查询一对多关系的列名 cardIds = item.Value; continue; } if (item.Key == "EmployeeName") {//查询一对多关系的列名 employeeName = item.Value; continue; } if (item.Key == "CompanyID") {//查询一对多关系的列名 companyId = Convert.ToInt32(item.Value); continue; } } } List <SingleStopPaymentView> queryData = repository.GetListFromP(db, zrUserId, companyId, employeeName, cardIds, page, rows, ref total); return(queryData); }
public ActionResult Index(string url) { //Convert.ToInt16("dddd"); //系统名称 ViewBag.WebName = siteConfig.webname; //公司名称 ViewBag.ComName = siteConfig.webcompany; // ViewBag.CopyRight = siteConfig.webcopyright; #if DEBUG SysUser user = accountBLL.Login("admin", ValueConvert.MD5("zxczxc")); AccountModel account = new AccountModel(); account.Id = user.Id; account.TrueName = user.TrueName; account.Photo = string.IsNullOrEmpty(user.Photo) ? "/Images/Photo.jpg" : user.Photo; Session["Account"] = account; GetThemes(user.Id); //在线用户统计 //OnlineHttpModule.ProcessRequest(); return(RedirectToAction("Index", "Home")); #else return(View()); #endif }
/// <summary> /// 证书查询的数据 /// </summary> /// <param name="SysEntities">数据访问的上下文</param> /// <param name="order">排序字段</param> /// <param name="sort">升序asc(默认)还是降序desc</param> /// <param name="search">查询条件</param> /// <param name="listQuery">额外的参数</param> /// <returns></returns> public List <SUOSHUDANWEI_Result> GetDataDW(SysEntities db, string order, string sort, string search, params object[] listQuery) { Nullable <System.DateTime> sTARTDATE = null; Nullable <System.DateTime> eNDDATE = null; string dANWEI = string.Empty; Dictionary <string, string> queryDic = ValueConvert.StringToDictionary(search.GetString()); if (queryDic != null && queryDic.Count > 0) { foreach (var item in queryDic) { if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(Start_Time)) //开始时间 { sTARTDATE = Convert.ToDateTime(item.Value); continue; } if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(End_Time)) //结束时间+1 { eNDDATE = Convert.ToDateTime(item.Value).AddDays(1); continue; } } } if (sTARTDATE == null) { sTARTDATE = System.DateTime.Now.AddYears(-11); } if (eNDDATE == null) { eNDDATE = System.DateTime.Now.AddYears(11); } return(db.SUOSHUDANWEI(sTARTDATE, eNDDATE).ToList()); }
public JsonResult Create(SysUserModel model) { if (model != null && ModelState.IsValid) { model.Id = ResultHelper.NewId; model.CreateTime = ResultHelper.NowTime; model.Password = ValueConvert.MD5(model.Password); model.CreatePerson = GetUserTrueName(); model.State = true; if (m_BLL.Create(ref errors, model)) { LogHandler.WriteServiceLog(GetUserId(), "Id:" + model.Id + ",Name:" + model.UserName, "成功", "创建", "用户设置"); return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed), JsonRequestBehavior.AllowGet)); } else { string ErrorCol = errors.Error; LogHandler.WriteServiceLog(GetUserId(), "Id:" + model.Id + ",Name:" + model.UserName + "," + ErrorCol, "失败", "创建", "用户设置"); return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol), JsonRequestBehavior.AllowGet)); } } else { return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail), JsonRequestBehavior.AllowGet)); } }
public JsonResult EditPwd(string oldPwd, string newPwd) { SysUser user = accountBLL.Login(GetUserId(), ValueConvert.MD5(oldPwd)); if (user == null) { return(Json(JsonHandler.CreateMessage(0, "旧密码不匹配!"), JsonRequestBehavior.AllowGet)); } SysUserEditModel editModel = new SysUserEditModel(); editModel.Id = GetUserId(); editModel.Password = ValueConvert.MD5(newPwd); if (userBLL.EditPwd(ref errors, editModel)) { LogHandler.WriteServiceLog(GetUserId(), "Id:" + GetUserId() + ",密码:********", "成功", "初始化密码", "用户设置"); return(Json(JsonHandler.CreateMessage(1, Resource.EditSucceed), JsonRequestBehavior.AllowGet)); } else { string ErrorCol = errors.Error; LogHandler.WriteServiceLog(GetUserId(), "Id:" + GetUserId() + ",,密码:********" + ErrorCol, "失败", "初始化密码", "用户设置"); return(Json(JsonHandler.CreateMessage(0, Resource.EditFail + ":" + ErrorCol), JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="sql"></param> public bool Update(CarriageReturn model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("ReturnID", model.ReturnID)); parameters.Add(new QfParameter("DispatchID", model.DispatchID)); parameters.Add(new QfParameter("CarID", model.CarID)); parameters.Add(new QfParameter("ReturnDate", string.Format(@"'{0}'", model.ReturnDate))); parameters.Add(new QfParameter("EmployeeID", model.EmployeeID)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperatorID", model.OperatorID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string setStr = ""; foreach (var item in parameters) { if (item.Value != null && ValueConvert.ToString(item.Value) != "''") { setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value); } } setStr = setStr.Substring(0, setStr.LastIndexOf(",")); string sql = string.Format("update t_carriage_return set {0} where ReturnID = {1}", setStr, model.ReturnID); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
/// <summary> /// 确认保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnOK_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(oldPassword)) { if (string.IsNullOrEmpty(ValueConvert.ToString(textOld.EditValue))) { MessageBox.Show("请输入原密码"); return; } string old = Salt.Encrypt(ValueConvert.ToString(textOld.EditValue)); if (old != oldPassword) { MessageBox.Show("原密码错误!"); return; } string newPassword1 = ValueConvert.ToString(textNow1.EditValue); string newPassword2 = ValueConvert.ToString(textNow2.EditValue); if (newPassword1 != newPassword2) { MessageBox.Show("两次输入新密码需相同!"); return; } string newPassword = Salt.Encrypt(newPassword1); if (new EmployeeDao().ChangePassword(newPassword, curData.EmployeeID)) { MessageBox.Show("密码修改成功!"); this.DialogResult = DialogResult.OK; } } }
void simpleButton_yes_Click(object sender, EventArgs e) { int itype = 0; if (txt_CashAmount.Text == "") { MsgBox.ShowInfo("充值金额不为空"); return; } if (this.checkEdit_ISUse.Checked) { itype = 1; } else { itype = 0; } int? Amount = ValueConvert.ToNullableInt32(this.txt_CashAmount.Text); string note = txt_Note.Text; string StudentIDstr = StuCurrent.StudentID.ToString(); bool result = new AccountDao().query(StudentIDstr, Amount, itype, note, Program.CurrentEmployee.EmployeeID, DateTime.Now); if (result) { MsgBox.ShowInfo("充值成功"); this.Close(); } else { MsgBox.ShowInfo("充值失败"); this.Close(); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="sql"></param> public bool Update(CarApplySocialpeople model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("SocialPeopleID", model.SocialPeopleID)); parameters.Add(new QfParameter("ApplyID", model.ApplyID)); parameters.Add(new QfParameter("Name", string.Format(@"'{0}'", model.Name))); parameters.Add(new QfParameter("IdentityNo", string.Format(@"'{0}'", model.IdentityNo))); parameters.Add(new QfParameter("DriverLicense", string.Format(@"'{0}'", model.DriverLicense))); parameters.Add(new QfParameter("DriverLicenseType", string.Format(@"'{0}'", model.DriverLicenseType))); parameters.Add(new QfParameter("FileNumber", string.Format(@"'{0}'", model.FileNumber))); string setStr = ""; foreach (var item in parameters) { if (item.Value != null && ValueConvert.ToString(item.Value) != "''") { setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value); } } setStr = setStr.Substring(0, setStr.LastIndexOf(",")); string sql = string.Format("update t_car_apply_socialpeople set {0} where SocialPeopleID = {1}", setStr, model.SocialPeopleID); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="sql"></param> public bool Add(CarRepairRecord model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("CarID", model.CarID)); parameters.Add(new QfParameter("RepairID", model.RepairID)); parameters.Add(new QfParameter("RepairPlace", string.Format(@"'{0}'", model.RepairPlace))); parameters.Add(new QfParameter("RepairDate", string.Format(@"'{0}'", model.RepairDate))); parameters.Add(new QfParameter("ItemStr", string.Format(@"'{0}'", model.ItemStr))); parameters.Add(new QfParameter("RepairKil", model.RepairKil)); parameters.Add(new QfParameter("Result", string.Format(@"'{0}'", model.Result))); parameters.Add(new QfParameter("PartsCost", model.PartsCost)); parameters.Add(new QfParameter("CreatID", model.CreatID)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperateID", model.OperateID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName)); string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value)); string sql = string.Format("insert into t_car_repair_record({0}) values ({1})", colStr, atColStr); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
public void SaveChanges(SerialPortsUtils.Agents.Agent io) { System.Diagnostics.Debug.WriteLine("Begin apply modify on InjectorCorrection"); if (ChangedFlag == true) { byte[] data = new byte[25]; for (int i = 0; i < 16; i++) { data[i] = (byte)this.CorrectionValues[i]; } var temp1 = ValueConvert.TwoBitTimeByusValue(this.MinOpenTime); data[16] = temp1[0]; data[17] = temp1[1]; var temp2 = ValueConvert.TwoBitTimeByusValue(this.CorrectionTime); data[18] = temp2[0]; data[19] = temp2[1]; var temp3 = ValueConvert.TwoBitTimeByusValue(this.OpenKeepTime); data[20] = temp3[0]; data[21] = temp3[1]; data[22] = Convert.ToByte(this._InjectEmptyScale); var temp4 = ValueConvert.TwoBitTimeByusValue(this.MaxOpenTime); data[23] = temp4[0]; data[24] = temp4[1]; io.SendAndRead(InstructionSet.SetInjectorCorrectionSetting, data); } System.Diagnostics.Debug.WriteLine("End apply modify on InjectorCorrection"); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="sql"></param> public bool Add(Duty model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("DutyID", model.DutyID)); parameters.Add(new QfParameter("DutyCode", string.Format(@"'{0}'", model.DutyCode))); parameters.Add(new QfParameter("DutyName", string.Format(@"'{0}'", model.DutyName))); parameters.Add(new QfParameter("MnemonicCode", string.Format(@"'{0}'", model.MnemonicCode))); parameters.Add(new QfParameter("Array", model.Array)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperateID", model.OperateID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName)); string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value)); string sql = string.Format("insert into t_duty({0}) values ({1})", colStr, atColStr); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="sql"></param> public bool Update(Duty model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("DutyID", model.DutyID)); parameters.Add(new QfParameter("DutyCode", string.Format(@"'{0}'", model.DutyCode))); parameters.Add(new QfParameter("DutyName", string.Format(@"'{0}'", model.DutyName))); parameters.Add(new QfParameter("MnemonicCode", string.Format(@"'{0}'", model.MnemonicCode))); parameters.Add(new QfParameter("Array", model.Array)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperateID", model.OperateID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string setStr = ""; foreach (var item in parameters) { if (item.Value != null && ValueConvert.ToString(item.Value) != "''") { setStr += string.Format(" {0} = {1},", item.ParameterName, item.Value); } } setStr = setStr.Substring(0, setStr.LastIndexOf(",")); string sql = string.Format("update t_duty set {0} where DutyID = {1}", setStr, model.DutyID); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
/// <summary> /// 从报文提取 OBD状态 /// </summary> /// <param name="packet">报文</param> /// <returns>OBD状态</returns> public static Models.Feedback.OBDState ToODBState(byte[] packet) { //var data = packet.PacketData(1).ToArray(); //var model = new Models.Feedback.OBDState(); //model.ConnectState = ValueConvert.ODBConnectSateFrom(data[0]); //model.FailuresCount = data[1]; //model.Bank1ShortCorrection = ValueConvert.ConvetToSbyteSafe(data[2]); //model.Bank1LongCorrection = ValueConvert.ConvetToSbyteSafe(data[3]); //model.Bank2ShortCorrection = ValueConvert.ConvetToSbyteSafe(data[4]); //model.Bank2LongCorrection = ValueConvert.ConvetToSbyteSafe(data[5]); //return model; var data = packet.PacketData(1).ToArray(); var model = new Models.Feedback.OBDState(); model.ConnectState = ValueConvert.ODBConnectSateFrom(data[0]); model.FailuresCount = data[2]; model.Bank1ShortCorrection = (float)Math.Round(((float)data[6] - 128) / 1.28f, 1); model.Bank1LongCorrection = (float)Math.Round(((float)data[7] - 128) / 1.28f, 1); model.Bank2ShortCorrection = (float)Math.Round(((float)data[8] - 128) / 1.28f, 1); model.Bank2LongCorrection = (float)Math.Round(((float)data[9] - 128) / 1.28f, 1); model.Bank1Oxygen = (float)Math.Round((float)data[10] * 0.005f, 2); if (data.Count() >= 13) { model.GasCorrection = (SByte)data[12]; } return(model); }
public iTextSharp.text.Rectangle GetDocRectangle(decimal x, decimal y) { decimal xPixel = ValueConvert.MM2Pixel(x); decimal yPixel = ValueConvert.MM2Pixel(y); return(new iTextSharp.text.Rectangle((float)xPixel, (float)yPixel)); }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnSearch_Click(object sender, EventArgs e) { sql = " 1 = 1 "; string employeeCode = ValueConvert.ToString(textEmployeeCode.EditValue); if (!string.IsNullOrEmpty(employeeCode)) { sql += string.Format(" and EmployeeCode like '%{0}%'", employeeCode); } if (!string.IsNullOrEmpty(textEmployeeName.Text)) { sql += string.Format(" and EmployeeName like '%{0}%'", textEmployeeName.EditValue.ToString()); } if (cLDepartmentID.EditValue != null) { sql += string.Format(" and DepartmentID = {0} ", cLDepartmentID.EditValue); } string _sql = string.Format("select * from t_employee where {0}", sql); _list = new EmployeeDao().QueryGetList(_sql); gcEmployee.DataSource = _list; gcEmployee.RefreshDataSource(); }
public JsonResult Login(string UserName, string Password, string Code) { if (Session["Code"] == null) { return(Json(JsonHandler.CreateMessage(0, "请重新刷新验证码"), JsonRequestBehavior.AllowGet)); } if (Session["Code"].ToString().ToLower() != Code.ToLower()) { return(Json(JsonHandler.CreateMessage(0, "验证码错误"), JsonRequestBehavior.AllowGet)); } SysUser user = accountBLL.Login(UserName, ValueConvert.MD5(Password)); if (user == null) { LogHandler.WriteServiceLog(UserName, ResultHelper.NowTime + "登录系统,IP:" + ResultHelper.GetUserIP() + "账户或密码错误", "失败", "登录", "系统入口"); return(Json(JsonHandler.CreateMessage(0, "用户名或密码错误"), JsonRequestBehavior.AllowGet)); } else if (!Convert.ToBoolean(user.State))//被禁用 { return(Json(JsonHandler.CreateMessage(0, "账户被系统禁用"), JsonRequestBehavior.AllowGet)); } AccountModel account = new AccountModel(); account.Id = user.Id; account.TrueName = user.TrueName; account.Photo = string.IsNullOrEmpty(user.Photo)?"/Images/Photo.jpg":user.Photo; Session["Account"] = account; GetThemes(user.Id); //在线用户统计 //OnlineHttpModule.ProcessRequest(); LogHandler.WriteServiceLog(UserName, ResultHelper.NowTime + "登录系统,IP:" + ResultHelper.GetUserIP(), "成功", "登录", "系统入口"); return(Json(JsonHandler.CreateMessage(1, ""), JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询的数据 /// </summary> /// <param name="id">额外的参数</param> /// <param name="page">页码</param> /// <param name="rows">每页显示的行数</param> /// <param name="search">查询条件</param> /// <param name="total">结果集的总数</param> /// <returns>结果集</returns> public List <EmployeeApprove> GetApproveListByParam(int?id, int page, int rows, string search, ref int total) { string CompanyName = string.Empty; string Name = string.Empty; string CertificateNumber = string.Empty; Dictionary <string, string> queryDic = ValueConvert.StringToDictionary(search.GetString()); if (queryDic != null && queryDic.Count > 0) { foreach (var item in queryDic) { if (item.Key == "CertificateNumber") {//查询一对多关系的列名 CertificateNumber = item.Value; continue; } if (item.Key == "Name") {//查询一对多关系的列名 Name = item.Value; continue; } if (item.Key == "CompanyName") {//查询一对多关系的列名 CompanyName = item.Value;; continue; } } } List <EmployeeApprove> queryData = repository.GetApproveList(db, CertificateNumber, page, rows, search, out total); return(queryData); //return repository.GetApproveList(db, page, rows, search, out total); }
private void BindDate() { textCarNo.EditValue = ValueConvert.ToString(curCar.CarNo); textCarModel.EditValue = ValueConvert.ToString(curCar.CarModel); textChassisNumber.EditValue = ValueConvert.ToString(curCar.ChassisNumber); textCurrentKil.EditValue = ValueConvert.ToString(curCar.CurrentKil); textEngineNumber.EditValue = ValueConvert.ToString(curCar.EngineNumber); textLicenseCode.EditValue = ValueConvert.ToString(curCar.LicenseCode); textMaintenanceExp.EditValue = ValueConvert.ToString(curCar.MaintenanceExp); textRepairExpenses.EditValue = ValueConvert.ToString(curCar.RepairExpenses); textOilExpenses.EditValue = ValueConvert.ToString(curCar.OilExpenses); dateBuyTime.EditValue = ValueConvert.ToNullableDateTime(curCar.BuyTime); dateLicenseExpireDate.EditValue = ValueConvert.ToNullableDateTime(curCar.LicenseExpireDate); dateYearCheckExpDate.EditValue = ValueConvert.ToNullableDateTime(curCar.YearCheckExpDate); cLookEmployeeID.EditValue = ValueConvert.ToNullableInt32(curCar.EmployeeID); cLookOwnerID.EditValue = ValueConvert.ToNullableInt32(curCar.OwnerID); cLookDepartment1.EditValue = ValueConvert.ToNullableInt32(curCar.DepartmentID); if (curCar.Status != null) { comStatus.SelectedIndex = ValueConvert.ToInt32(curCar.Status.Value) - 1; } memoNote.EditValue = ValueConvert.ToString(curCar.Note); }
/// <summary> /// 确认保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnOK_Click(object sender, EventArgs e) { CarDispatchAudit model = new CarDispatchAudit { AuditID = new CommonDAO().GetIntUniqueNumber("t_car_dispatch_audit"), DispatchID = curData.DispatchID, EmployeeID = Program.CurrentEmployee.EmployeeID, CarID = curData.CarID, AuditDate = ValueConvert.ToDateTime(dateApplyDate.EditValue), Result = radioGroup1.SelectedIndex == 0 ? "通过" : "退回", Note = memoNote.Text, OperatorID = Program.CurrentEmployee.EmployeeID, OperateTime = DateTime.Now }; bool result = new CarDispatchAuditDao().Add(model); if (result) { //更新状态 if (model.Result == "通过") { new CarDispatchAuditDao().UpdateState(ValueConvert.ToInt32(curData.DispatchID), model.Result); new CarDispatchDao().UpdateAuditDate(model); } MessageBox.Show("保存成功"); this.DialogResult = DialogResult.OK; } }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnSearch_Click(object sender, EventArgs e) { sql = " 1 = 1 "; if (cLCar.EditValue != null) { sql += string.Format(" and a.CarID = {0}", ValueConvert.ToInt32(cLCar.EditValue)); } if (cLEmployeeID.EditValue != null) { sql += string.Format(" and a.EmployeeID = {0}", ValueConvert.ToInt32(cLEmployeeID.EditValue)); } if (dateApplyBegin.EditValue != null && dateApplyEnd.EditValue == null) { sql += string.Format(" and a.RegistraDate >= '{0}'", ValueConvert.ToDateTime(dateApplyBegin.EditValue).ToString("yyyy-MM-dd")); } if (dateApplyEnd.EditValue == null && dateApplyEnd.EditValue != null) { sql += string.Format(" and a.RegistraDate <= '{0}'", ValueConvert.ToDateTime(dateApplyEnd.EditValue).ToString("yyyy-MM-dd")); } if (dateApplyEnd.EditValue != null && dateApplyEnd.EditValue != null) { sql += string.Format(" and a.RegistraDate between '{0}' and '{1}'", ValueConvert.ToDateTime(dateApplyBegin.EditValue).ToString("yyyy-MM-dd"), ValueConvert.ToDateTime(dateApplyEnd.EditValue).ToString("yyyy-MM-dd")); } string _sql = string.Format(@"select a.*, b.EmployeeName, c.CarNo, d.EmployeeName OperatorName from t_car_out_registration a left join t_employee b on a.EmployeeID = b.EmployeeID left join t_car c on a.CarID = c.CarID left join t_employee d on a.OperatorID = d.EmployeeID where {0}", sql); _list = new CarOutRegistrationDao().QueryGetList(_sql); gcOut.DataSource = _list; gcOut.RefreshDataSource(); }
protected void TxtDate_TextChanged(object sender, EventArgs e) { try { if (TxtDate.Text.Length != 0) { StrSql = new StringBuilder(); StrSql.Length = 0; StrSql.AppendLine("Select D.Working_Date"); StrSql.AppendLine("From DailyAttendance D"); StrSql.AppendLine("Where D.EmpId=" + int.Parse(ddlEmployee.SelectedValue)); StrSql.AppendLine("And D.Working_Date='" + ValueConvert.ConvertDate(TxtDate.Text.ToString()) + "'"); dtTemp = new DataTable(); dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString()); if (dtTemp.Rows.Count != 0) { LblMsg.Text = "Attendance Entry Allready Done For " + TxtDate.Text.ToString() + "."; TxtDate.Text = ""; TxtDays.Text = ""; TxtMonth.Text = ""; TxtDate.Focus(); return; } LblMsg.Text = ""; GetDayMonth(); TxtInTime.Focus(); } } catch (Exception ex) { Response.Write(ex.ToString()); } }
private Models.Feedback.ECUWorkTime GetECUTime(SerialPortsUtils.Agents.Models.CustomActionContext context) { var packet = context.IO.SendAndRead(InstructionSet.GetECUTime); Models.Feedback.ECUWorkTime model = ValueConvert.ECUWorkTimeFrom(packet.PacketData(1).ToArray()); return(model); }
/// <summary> /// 查询的数据 /// </summary> /// <param name="SysEntities">数据访问的上下文</param> /// <param name="order">排序字段</param> /// <param name="sort">升序asc(默认)还是降序desc</param> /// <param name="search">查询条件</param> /// <param name="listQuery">额外的参数</param> /// <returns></returns> public IQueryable <Rule> GetData(SysEntities db, string order, string sort, string search, params object[] listQuery) { string where = string.Empty; int flagWhere = 0; Dictionary <string, string> queryDic = ValueConvert.StringToDictionary(search.GetString()); if (queryDic != null && queryDic.Count > 0) { foreach (var item in queryDic) { if (flagWhere != 0) { where += " and "; } flagWhere++; if (!string.IsNullOrWhiteSpace(item.Key) && !string.IsNullOrWhiteSpace(item.Value) && item.Key.Contains(DDL_Int)) //精确查询数值 { where += "it.[" + item.Key.Remove(item.Key.IndexOf(DDL_Int)) + "] =" + item.Value; continue; } } } return(((System.Data.Entity.Infrastructure.IObjectContextAdapter)db).ObjectContext .CreateObjectSet <Rule>().Where(string.IsNullOrEmpty(where) ? "true" : where) .OrderBy("it.[" + sort.GetString() + "] " + order.GetString()) .AsQueryable()); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="sql"></param> public bool Add(CarDispatch model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("DispatchID", model.DispatchID)); parameters.Add(new QfParameter("EmployeeID", model.EmployeeID)); parameters.Add(new QfParameter("DispatchReason", string.Format(@"'{0}'", model.DispatchReason))); parameters.Add(new QfParameter("CarID", model.CarID)); parameters.Add(new QfParameter("ApplyDate", string.Format(@"'{0}'", model.ApplyDate))); parameters.Add(new QfParameter("AuditDate", string.Format(@"'{0}'", model.AuditDate))); parameters.Add(new QfParameter("RegistraDate", string.Format(@"'{0}'", model.RegistraDate))); parameters.Add(new QfParameter("PlaceBackDate", string.Format(@"'{0}'", model.PlaceBackDate))); parameters.Add(new QfParameter("ReturnDate", string.Format(@"'{0}'", model.ReturnDate))); parameters.Add(new QfParameter("IntervalDate", model.IntervalDate)); parameters.Add(new QfParameter("Status", model.Status)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperatorID", model.OperatorID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName)); string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value)); string sql = string.Format("insert into t_car_dispatch({0}) values ({1})", colStr, atColStr); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnSearch_Click(object sender, EventArgs e) { sql = " 1 = 1 "; if (cLCar.EditValue != null) { sql += string.Format(" and a.CarID = {0}", ValueConvert.ToInt32(cLCar.EditValue)); } if (cLEmployeeID.EditValue != null) { sql += string.Format(" and a.CreatID = {0}", ValueConvert.ToInt32(cLEmployeeID.EditValue)); } if (dateRepairBegin.EditValue != null && dateRepairEnd.EditValue == null) { sql += string.Format(" and a.RepairDate >= '{0}'", ValueConvert.ToDateTime(dateRepairBegin.EditValue).ToString("yyyy-MM-dd")); } if (dateRepairEnd.EditValue == null && dateRepairEnd.EditValue != null) { sql += string.Format(" and a.RepairDate <= '{0}'", ValueConvert.ToDateTime(dateRepairEnd.EditValue).ToString("yyyy-MM-dd")); } if (dateRepairEnd.EditValue != null && dateRepairEnd.EditValue != null) { sql += string.Format(" and a.RepairDate between '{0}' and '{1}'", ValueConvert.ToDateTime(dateRepairBegin.EditValue).ToString("yyyy-MM-dd"), ValueConvert.ToDateTime(dateRepairEnd.EditValue).ToString("yyyy-MM-dd")); } string _sql = string.Format(@"select a.*, b.EmployeeName CreatName, c.CarNo, d.RepairName from t_car_repair_record a left join t_employee b on a.CreatID = b.EmployeeID left join t_car c on a.CarID = c.CarID left join t_car_repair_item d on a.ItemStr = d.ItemID where {0}", sql); _list = new CarRepairRecordDao().QueryGetList(_sql); gcApply.DataSource = _list; gcApply.RefreshDataSource(); }
public JsonResult Login(string UserName, string Password, string Code) { if (Session["Code"] == null) { return(Json(JsonHandler.CreateMessage(0, "请重新刷新验证码"), JsonRequestBehavior.AllowGet)); } if (Session["Code"].ToString().ToLower() != Code.ToLower()) { return(Json(JsonHandler.CreateMessage(0, "验证码错误"), JsonRequestBehavior.AllowGet)); } SysUser user = AccountBLL.Login(UserName, ValueConvert.MD5(Password)); if (user == null) { return(Json(JsonHandler.CreateMessage(0, "用户名或密码错误"), JsonRequestBehavior.AllowGet)); } else if (!Convert.ToBoolean(user.State))//被禁用了 { return(Json(JsonHandler.CreateMessage(0, "账户被系统禁用"), JsonRequestBehavior.AllowGet)); } AccountModel account = new AccountModel(); account.Id = user.Id; account.TrueName = user.TrueName; Session["Account"] = account; return(Json(JsonHandler.CreateMessage(1, ""), JsonRequestBehavior.AllowGet)); }
public JsonResult Create(SysUserModel model) { if (model != null && ModelState.IsValid) { Apps.IService.IServiceSession serviceSession = OpeCur.ServiceSession; string curUserId = OpeCur.AccountNow.Id; model.Id = ResultHelper.NewId; model.CreateTime = ResultHelper.NowTime; model.Password = ValueConvert.MD5(model.Password); model.CreatePerson = OpeCur.AccountNow.TrueName; model.State = true; serviceSession.SysUser.Create(ref errors, model); if (serviceSession.SaveChange() > 0) { LogHandler.WriteServiceLog(curUserId, "Id:" + model.Id + ",Name:" + model.UserName, "成功", "创建", "用户设置"); return(OpeCur.AjaxMsgOK("创建成功!")); } else { string ErrorCol = errors.Error; LogHandler.WriteServiceLog(curUserId, "Id:" + model.Id + ",Name:" + model.UserName + "," + ErrorCol, "失败", "创建", "用户设置"); return(OpeCur.AjaxMsgNOOK("创建失败!" + ErrorCol)); } } else { return(OpeCur.AjaxMsgNOOK(Resource.ModelStateValidFail)); } }
internal void CommitValue(object record, string propName, object value) { #if UWP PropertyInfoCollection descriptor = new PropertyInfoCollection(record.GetType()); #else PropertyDescriptorCollection descriptor = TypeDescriptor.GetProperties(record.GetType()); #endif var propertyinfo = descriptor.GetPropertyDescriptor(propName); object convertedValue = null; if (propertyinfo == null) { if (View.IsDynamicBound) { var type = (value == null) ? null : value.GetType(); convertedValue = ValueConvert.ChangeType(value, type, null); if (convertedValue != null || (NullableHelperInternal.IsNullableType(type) && convertedValue == null)) { SetValue(record, propName, convertedValue); } } return; } convertedValue = ValueConvert.ChangeType(value, propertyinfo.PropertyType, null); if (value != null || (NullableHelperInternal.IsNullableType(propertyinfo.PropertyType) && value == null)) { SetValue(record, propName, convertedValue); } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="sql"></param> public bool Add(Department model) { try { var parameters = new List <QfParameter>(); parameters.Add(new QfParameter("DepartmentID", model.DepartmentID)); parameters.Add(new QfParameter("DepartmentCode", string.Format(@"'{0}'", model.DepartmentCode))); parameters.Add(new QfParameter("DepartmentName", string.Format(@"'{0}'", model.DepartmentName))); parameters.Add(new QfParameter("ParentID", model.ParentID)); parameters.Add(new QfParameter("InChargeID", model.InChargeID)); parameters.Add(new QfParameter("EmployeeCount", model.EmployeeCount)); parameters.Add(new QfParameter("Note", string.Format(@"'{0}'", model.Note))); parameters.Add(new QfParameter("OperateID", model.OperateID)); parameters.Add(new QfParameter("OperateTime", string.Format(@"'{0}'", model.OperateTime))); string colStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.ParameterName)); string atColStr = string.Join(",", parameters.FindAll(m => ValueConvert.ToString(m.Value) != null && ValueConvert.ToString(m.Value) != "''").Select(n => n.Value)); string sql = string.Format("insert into t_department({0}) values ({1})", colStr, atColStr); int row = MysqlHelper.ExecuteNonQuery(sql); return(row == 1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }