/// <summary> /// 插入人员外出信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public bool InsertPersoOutInfo(PersonOutInfo info) { bool isresult = false; using (OleDbConnection connection = new OleDbConnection(DbHelperACE.connectionString)) { OleDbCommand command = new OleDbCommand(); command.Connection = connection; command.CommandText = @"Insert INTO PersonOutInfo (NAMEID,NAME,INCIDENT,OUTTIME,BACKTIME,BZ,OPERATOR,OPERATORTIME,OPERATORID,A1,A2,A3,OUTTIMEHOUR,OUTTIMEMINUTE,BACKTIMEHOUR,BACKTIMEMINUTE ) values ('" + info.NAMEID + "','" + info.NAME + "','" + info.INCIDENT + "','" + info.OUTTIME + "','" + info.BACKTIME + "','" + info.BZ + "','" + info.OPERATOR + "','" + info.OPERATORTIME + "','" + info.OPERATORID + "','" + info.A1 + "','" + info.A2 + "','" + info.A3 + "','" + info.OUTTIMEHOUR + "','" + info.OUTTIMEMINUTE + "','" + info.BACKTIMEHOUR + "','" + info.BACKTIMEMINUTE + "' )"; command.CommandType = CommandType.Text; try { connection.Open(); int rows = command.ExecuteNonQuery(); isresult = true; } catch (System.Data.OleDb.OleDbException E) { throw new Exception(E.Message); } finally { command.Dispose(); connection.Close(); } } return(isresult); }
public PersonOutInfoDialog(PersonOutInfo basicinfo, bool isReadOnly) { InitializeComponent(); InitControl(); IsReadOnly = isReadOnly; info = basicinfo; InitData(); this.grid_main.DataContext = info; if (IsReadOnly == true) { this.grid_main.IsEnabled = false; } else { IsModify = true; } }
/// <summary> /// 修改人员信息 /// </summary> /// <param name="obj"></param> /// <returns></returns> public bool ModifyPersonOutInfo(PersonOutInfo info) { bool isresult = false; using (OleDbConnection connection = new OleDbConnection(DbHelperACE.connectionString)) { OleDbCommand command = new OleDbCommand(); command.Connection = connection; command.CommandText = UpdatePersonOutInfoSql + @" NAMEID = '" + info.NAMEID + "'" + @" , NAME = '" + info.NAME + "'" + @" , INCIDENT = '" + info.INCIDENT + "'" + @" , OUTTIME = '" + info.OUTTIME + "'" + @" , BACKTIME = '" + info.BACKTIME + "'" + @" , BZ = '" + info.BZ + "'" + @" , OPERATOR = '" + info.OPERATOR + "'" + @" , OPERATORTIME = '" + info.OPERATORTIME + "'" + @" , OPERATORID = '" + info.OPERATORID + "'" + @" , A1 = '" + info.A1 + "'" + @" , A2 = '" + info.A2 + "'" + @" , A3 = '" + info.A3 + "'" + @" , OUTTIMEHOUR = '" + info.OUTTIMEHOUR + "'" + @" , OUTTIMEMINUTE = '" + info.OUTTIMEMINUTE + "'" + @" , BACKTIMEHOUR = '" + info.BACKTIMEHOUR + "'" + @" , BACKTIMEMINUTE = '" + info.BACKTIMEMINUTE + "'" + @" where ID =" + info.ID + ""; command.CommandType = CommandType.Text; try { connection.Open(); int rows = command.ExecuteNonQuery(); isresult = true; } catch (System.Data.OleDb.OleDbException E) { throw new Exception(E.Message); } finally { command.Dispose(); connection.Close(); } } return(isresult); }
public void dataGridTemplate_MouseDoubleClick(object sender, MouseButtonEventArgs e) { if (e.LeftButton == MouseButtonState.Pressed) { DataGridRow dgr = DataGridRow.GetRowContainingElement(e.OriginalSource as FrameworkElement); if (dgr != null) { PersonOutInfo personBasicInfo = dgr.DataContext as PersonOutInfo; if (personBasicInfo != null) { PersonOutInfoDialog dialog = new PlanDatabase.PersonOutInfoDialog(personBasicInfo, true); dialog.Show(); } } } }
/// <summary> /// 获取人员外出信息 /// </summary> /// <returns>所有人员外出信息</returns> public List <PersonOutInfo> GetPersonOutInfos(string nameid, string incident, string fromdate, string todate) { if (!string.IsNullOrEmpty(incident)) { SelectPersonOutInfoListSql += "and INCIDENT = '" + incident + "' "; } if (!string.IsNullOrEmpty(nameid)) { SelectPersonOutInfoListSql += "and NAMEID = '" + nameid + "' "; } if (!string.IsNullOrEmpty(fromdate)) { SelectPersonOutInfoListSql += "and Format(OUTTIME,\"yyyy-mm-dd\") >= '" + fromdate + "' "; } if (!string.IsNullOrEmpty(todate)) { SelectPersonOutInfoListSql += "and Format(BACKTIME,\"yyyy-mm-dd\") <= '" + todate + "' "; } SelectPersonOutInfoListSql += " order by OPERATORTIME desc"; DataSet ds = DbHelperACE.Query(SelectPersonOutInfoListSql); List <PersonOutInfo> list = new List <PersonOutInfo>(); DataRowCollection drs = ds.Tables[0].Rows; for (int i = 0; i < drs.Count; i++) { PersonOutInfo item = new PersonOutInfo(); item.ID = drs[i]["ID"].ToString().Trim(); item.NAMEID = drs[i]["NAMEID"].ToString().Trim(); item.NAME = drs[i]["NAME"].ToString().Trim(); item.INCIDENT = drs[i]["INCIDENT"].ToString().Trim(); item.OUTTIMEHOUR = drs[i]["OUTTIMEHOUR"].ToString().Trim(); if (string.IsNullOrEmpty(drs[i]["OUTTIMEMINUTE"].ToString())) { item.OUTTIMEMINUTE = "00"; } else { item.OUTTIMEMINUTE = drs[i]["OUTTIMEMINUTE"].ToString().Trim(); } item.BACKTIMEHOUR = drs[i]["BACKTIMEHOUR"].ToString().Trim(); if (string.IsNullOrEmpty(drs[i]["BACKTIMEMINUTE"].ToString())) { item.BACKTIMEMINUTE = "00"; } else { item.BACKTIMEMINUTE = drs[i]["BACKTIMEMINUTE"].ToString().Trim(); } try { if (drs[i]["OUTTIME"] != null && drs[i]["OUTTIME"].ToString() != string.Empty) { item.OUTTIME = Convert.ToDateTime(drs[i]["OUTTIME"]).ToString("yyyy-MM-dd") + " " + item.OUTTIMEHOUR + "时" + item.OUTTIMEMINUTE + "分"; } } catch { item.OUTTIME = drs[i]["OUTTIME"].ToString().Trim(); } try { if (drs[i]["BACKTIME"] != null && drs[i]["BACKTIME"].ToString() != string.Empty) { item.BACKTIME = Convert.ToDateTime(drs[i]["BACKTIME"]).ToString("yyyy-MM-dd") + " " + item.BACKTIMEHOUR + "时" + item.BACKTIMEMINUTE + "分"; } } catch { item.BACKTIME = drs[i]["BACKTIME"].ToString().Trim(); } item.BZ = drs[i]["BZ"].ToString().Trim(); item.OPERATOR = drs[i]["OPERATOR"].ToString().Trim(); if (drs[i]["OPERATORTIME"] != null && drs[i]["OPERATORTIME"].ToString() != string.Empty) { item.OPERATORTIME = Convert.ToDateTime(drs[i]["OPERATORTIME"]); } try { if (drs[i]["OPERATORTIME"] != null && drs[i]["OPERATORTIME"].ToString() != string.Empty) { item.OPERATORTIME = Convert.ToDateTime(drs[i]["OPERATORTIME"]).ToLocalTime(); } } catch { //item.OPERATORTIME =null; } item.OPERATORID = drs[i]["OPERATORID"].ToString().Trim(); item.A1 = drs[i]["A1"].ToString().Trim(); item.A2 = drs[i]["A2"].ToString().Trim(); item.A3 = drs[i]["A3"].ToString().Trim(); list.Add(item); } return(list); }