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