public List <string> GetList() { List <string> listcount = new List <string>(); wrench w = Wrench.selectByBarcode(_barcode); if (w == null || w.guid == null) { return(listcount); } for (int i = 1; i <= 12; i++) { string s = _datetime.Year.ToString() + "-" + string.Format("{0:00}", i); DateTime start = Convert.ToDateTime(s); DateTime lasts = start.AddMonths(1).AddMilliseconds(-1); List <torquechecktarget> tl = CheckTarget.SelectByDate(start, lasts, w.guid); if (tl != null) { listcount.Add(tl.Count.ToString()); } else { listcount.Add("0"); } datelist.Add(start.ToString("yyyy-MM")); } return(listcount); }
bool IsRepeat(wrench w) { if (w == null) { return(false); } wrench tempw = Wrench.selectByBarcode(this.tb_wrenchbarcode.Text.Trim()); if (tempw != null && w.guid != tempw.guid) { MessageBox.Show("工具条码号已经存在不能重复!"); return(true); } List <wrench> wl = Wrench.selectBycode(w.wrenchCode); if (wl != null && wl.Count > 0) { foreach (wrench wc in wl) { if (wc != null && wc.guid != w.guid) { MessageBox.Show("工具编号已经存在不能重复!"); return(true); } } } return(false); }
public List <string> GetList() { List <string> listcount = new List <string>(); DateTime first = new DateTime(); DateTime last = new DateTime(); if (GetDaysOfWeeks(Convert.ToInt32(_datetime.Year), getweek(_datetime), out first, out last)) { wrench w = Wrench.selectByBarcode(_barcode); if (w != null && w.guid != null) { for (int i = 0; i < 7; i++) { DateTime dt = first.AddDays(i); DateTime start = dt; DateTime lasts = dt.AddDays(1).AddMilliseconds(-1); List <torquechecktarget> tl = CheckTarget.SelectByDate(start, lasts, w.guid); if (tl != null) { listcount.Add(tl.Count.ToString()); } else { listcount.Add("0"); } datelist.Add(dt.ToString("yyyy-MM-dd")); } } } return(listcount); }
wrench getwrench(wrench w) { try { w.wrenchCode = this.tb_wrenchcode.Text.Trim(); w.wrenchBarCode = this.tb_wrenchbarcode.Text.Trim(); w.factory = this.tb_factory.Text.Trim(); w.rangeMax = Convert.ToDecimal(this.tb_max.Text.Trim()); w.rangeMin = Convert.ToDecimal(this.tb_min.Text.Trim()); w.comment = this.tb_com.Text.Trim(); w.offPset = this.tb_Pset.Text.Trim(); w.targetvalue = Convert.ToDecimal(this.tb_targetvalue.Text.Trim()); w.targetvalue1 = string.IsNullOrEmpty(this.tb_targetvalue1.Text.Trim()) ? 0 : Convert.ToDecimal(this.tb_targetvalue1.Text.Trim()); w.targetvalue2 = string.IsNullOrEmpty(this.tb_targetvalue2.Text.Trim()) ? 0 : Convert.ToDecimal(this.tb_targetvalue2.Text.Trim()); w.species = (cb_species.SelectedItem as wrenchspecies).id.ToString(); w.status = (cb_status.SelectedItem as wrenchstatus).id.ToString(); w.unit = "N.m"; w.createDate = Convert.ToDateTime(Convert.ToDateTime(this.dp_time.Text.Trim()).ToString("s")); w.lastrepair = Convert.ToDateTime(Convert.ToDateTime(this.dp_time_Copy.Text.Trim()).ToString("s")); return(w); } catch { MessageAlert.Alert("请输入正确的数字值!"); return(null); } }
private void cb_pages_SelectionChanged(object sender, SelectionChangedEventArgs e) { Dictionary <string, string> dict = new Dictionary <string, string>(); if (!string.IsNullOrEmpty(this.tb_wrenchbarcode.Text.Trim())) { wrench wl = Wrench.selectByBarcode(this.tb_wrenchbarcode.Text.Trim()); if (wl != null) { dict.Add("WrenchID_id", wl.guid); } } if (this.dp_starttime.SelectedDate != null) { dict.Add("starttime", this.dp_starttime.SelectedDate.ToString()); } if (this.dp_endtime.SelectedDate != null) { if (this.dp_endtime.SelectedDate.ToString() == this.dp_starttime.SelectedDate.ToString()) { dict.Add("endtime", this.dp_starttime.SelectedDate.Value.AddDays(1).AddSeconds(-1).ToString()); } else { dict.Add("endtime", this.dp_endtime.SelectedDate.ToString()); } } CheckResultSetPage.PageSize = Convert.ToInt32((this.cb_pages.SelectedItem as ComboBoxItem).Content.ToString()); CheckResultSetPage.Dictionary = dict; CheckResultSetPage.getTotalPage(); List <torquechecktarget> q = CheckResultSetPage.getTorquechecktarget(0); showdata(q); }
ToolModel GetToolMode(wrench w) { ToolModel tm = null; wrenchstatus ws = WrenchStatus.selectByguid(w.status); if (ws == null || ws.guid == null) { return(tm); } tm = new ToolModel() { wrenchBarCode = w.wrenchBarCode, wrenchCode = w.wrenchCode, comment = w.comment, createDate = w.createDate, cycletime = Convert.ToDecimal(w.cycletime.ToString("f0")), factory = w.factory, guid = w.guid, id = w.id, IP = w.IP, isallowcheck = w.isallowcheck, lastrepair = w.lastrepair, port = w.port, rangeMax = w.rangeMax, rangeMin = w.rangeMin, species = w.species, status = w.status, statusName = ws.statusName, targetvalue = w.targetvalue, unit = w.unit }; return(tm); }
void GetWrench(string wrenchbarcode) { if (borrowuser == null) { MessageAlert.Alert("没有借用人信息"); return; } if (borrowwrenchlist.FindIndex(p => p.wrenchbarcode == wrenchbarcode) >= 0) { MessageAlert.Alert("不能重复添加!"); return; } wrench w = Wrench.selectByBarcode(this.wrenchbarcode.Text.Trim()); if (w != null) { borrowwrenchlist.Add(new BorrowWrench() { wrenchbarcode = w.wrenchBarCode, wrenchcode = w.wrenchCode, factory = w.factory, borrowdate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), userguid = borrowuser.user.guid, username = borrowuser.user.username, operatorguid = SystData.userInfo.user.guid, options = SystData.userInfo.user.username, wrenchid = w.id.ToString() }); } ShowWrench(w); DgBind(borrowwrenchlist); }
public bool Add(List <Model.torquechecktarget> listtorquechecktarget) { try { string sql = ""; foreach (torquechecktarget torquechecktarget in listtorquechecktarget) { string sqldep = string.Format("select * from wrench where id='{0}'", torquechecktarget.wrenchID); DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { wrench dep = DataTableToList.GetList <wrench>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { torquechecktarget.wrenchID = dep.guid; } } sql += string.Format ( "INSERT INTO torquechecktarget(wrenchID_id,checkDate,qaID,operatorID,torqueTargetValue,errorRangeMax,errorRangeMin,count,arry,is_good,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;", torquechecktarget.wrenchID, torquechecktarget.checkDate, torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.errorRangeMin, torquechecktarget.count, torquechecktarget.arry, torquechecktarget.is_good == true?1:0, torquechecktarget.comment, torquechecktarget.guid ) + "\r"; } sql += " select last_insert_rowid()"; var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text); if (Convert.ToInt32(ds) > 0) { return(true); } return(false); } catch { return(false); } }
public string AddReturnGuid(Model.torquechecktarget torquechecktarget) { try { string sqldep = string.Format("select * from wrench where id='{0}'", torquechecktarget.wrenchID); DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text); if (dps != null && dps.Tables.Count > 0) { wrench dep = DataTableToList.GetList <wrench>(dps.Tables[0]).FirstOrDefault(); if (dep != null) { torquechecktarget.wrenchID = dep.guid; } } string sql = string.Format ( "INSERT INTO torquechecktarget(wrenchID_id,checkDate,qaID,operatorID,torqueTargetValue,errorRangeMax,errorRangeMin,count,arry,is_good,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;select last_insert_rowid()", torquechecktarget.wrenchID, torquechecktarget.checkDate, torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.errorRangeMin, torquechecktarget.count, torquechecktarget.arry, torquechecktarget.is_good == true?1:0, torquechecktarget.comment, torquechecktarget.guid ); var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text); return(ds.ToString()); } catch { return("-1"); } }
List <ReturnWrench> GetBorrowInfo(string userguid) { try { List <ReturnWrench> rwl = new List <ReturnWrench>(); List <borrow> bl = Borrow.SelectByUser(userguid, false); if (bl == null || bl.Count <= 0) { return(null); } foreach (borrow b in bl) { wrench w = Wrench.selectByguid(b.WrenchID); users u = User.SelectByguid(b.borrowUser); users operatos = User.SelectByguid(b.borrowOperator); rwl.Add(new ReturnWrench() { wrenchbarcode = w.wrenchBarCode, wrenchcode = w.wrenchCode, wrenchguid = w.guid, cardid = u.cardID, username = u.username, factory = w.factory, rang = w.rangeMin.ToString("f2") + "~" + w.rangeMin.ToString("f2"), borrowdate = b.borrowDate.Replace('T', ' '), operater = operatos.username, wrenchcommit = w.comment }); } return(rwl); } catch { return(null); } }
ReturnWrench GetReturnWrench(BorrowWrench br) { ReturnWrench rw = new ReturnWrench(); List <borrow> bl = Borrow.SelectByWrench(br.wrenchguid, br.userguid, false); if (bl != null && bl.Count > 0) { borrow b = bl.FirstOrDefault(); wrench w = Wrench.selectByguid(b.WrenchID); users u = User.SelectByguid(b.borrowUser); users operatos = User.SelectByguid(b.borrowOperator); _returnwrench.Add(new ReturnWrench() { wrenchbarcode = w.wrenchBarCode, wrenchcode = w.wrenchCode, wrenchguid = w.guid, cardid = u.cardID, username = u.username, factory = w.factory, rang = w.rangeMin.ToString("f2") + "~" + w.rangeMin.ToString("f2"), borrowdate = b.borrowDate.Replace('T', ' '), operater = operatos.username, wrenchcommit = w.comment }); return(rw); } return(null); }
public static PrintSingleCheckdata GetPrintSingleCheckdata(wrench wrenchmodel, List <ShowCheckresult> checkrecodelist, int configcount, decimal setvalue, userinfo juser, userinfo zuser, DateTime dt, bool wrenchgood) { if (printsinglecheckdata == null || !printsinglecheckdata.IsLoaded) { printsinglecheckdata = new PrintSingleCheckdata(wrenchmodel, checkrecodelist, configcount, setvalue, juser, zuser, dt, wrenchgood); } return(printsinglecheckdata); }
bool add(wrench w) { w.createDate = Convert.ToDateTime(this.dp_time.Text.Trim()); w.lastrepair = Convert.ToDateTime(this.dp_time_Copy.Text.Trim()); w.guid = Guid.NewGuid().ToString(); w.isallowcheck = true; w.cycletime = 0; return(Wrench.add(w)); }
private void Button_Click_18(object sender, RoutedEventArgs e) { wrench w = Wrench.selectByBarcode("222"); w.rangeMax = 200; w.species = "e8ad22ee-1f00-4b2a-94ee-a84d3b692f7d"; w.status = "123"; Wrench.updata(w); }
private void Button_Click_14(object sender, RoutedEventArgs e) { wrench w = new wrench() { createDate = DateTime.Now, factory = "nuba", rangeMax = Convert.ToDecimal(32.9), rangeMin = Convert.ToDecimal(0.5), species = "1", status = "2", wrenchBarCode = "1234", wrenchCode = "2345" }; MessageBox.Show(Wrench.add(w).ToString()); }
void ShowWrench(wrench e) { if (e == null) { return; } this.wrenchcode.Text = e.wrenchCode; this.cb_wrench.IsEnabled = true; }
private void editButtonClick(object sender, RoutedEventArgs e) { int i_index = dataGrid1.SelectedIndex; if (i_index >= 0) { _wrench = dataGrid1.SelectedItem as wrench; showwrench(_wrench); isadd = false; } }
public HandleData(users juser, userinfo zuser, wrench wrenchmodel, bool wrenchisgood, decimal setvalue = 0, decimal errorrangmin = 0, decimal errorrangmax = 0) { _wrench = wrenchmodel; //_checkdatashow = checkdatashow; _setvalue = setvalue; _errorrangmin = errorrangmin; _errorrangmax = errorrangmax; _systemset = GetSystem(); _juser = juser; _zuser = zuser; _wrenchisgood = wrenchisgood; }
void clear() { this.tb_factory.Clear(); this.tb_max.Clear(); this.tb_min.Clear(); this.tb_targetvalue.Clear(); this.tb_wrenchbarcode.Clear(); this.tb_wrenchcode.Clear(); isadd = true; _wrench = null; this.dp_time.Text = DateTime.Now.ToShortDateString(); getstatus(); }
PrintSingleCheckdata(wrench wrenchmodel, List <ShowCheckresult> checkrecodelist, int confgcount, decimal setvalue, userinfo juser, userinfo zuser, DateTime dt, bool wrenchgood) { InitializeComponent(); _wrench = wrenchmodel; _checkhistory = checkrecodelist; _zuser = zuser; _juser = juser; _dt = dt; confint = confgcount; _setvalue = setvalue; _iswrenchgood = wrenchgood; showdata(); }
private void bt_search_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(this.tb_wrenchbarcode.Text.Trim())) { MessageAlert.Alert("请填写工具条码!"); return; } if (this.dp_date.SelectedDate.ToString() == "") { MessageAlert.Alert("请选择时间!"); return; } List <string> strListy = new List <string>(); List <string> strListx = new List <string>(); DateTime time = Convert.ToDateTime(this.dp_date.SelectedDate.ToString()); wrench w = Wrench.selectByBarcode(this.tb_wrenchbarcode.Text.Trim()); if (rb_week.IsChecked != null && rb_week.IsChecked == true) { WeekCheckData weekcheckdata = new WeekCheckData(time, this.tb_wrenchbarcode.Text.Trim()); strListy = weekcheckdata.GetList(); strListx = weekcheckdata.datelist; } if (rb_year.IsChecked != null && rb_year.IsChecked == true) { YearCheckData weekcheckdata = new YearCheckData(time, this.tb_wrenchbarcode.Text.Trim()); strListy = weekcheckdata.GetList(); strListx = weekcheckdata.datelist; } int count = 0; foreach (string s in strListy) { count += Convert.ToInt32(s); } this.lb_count.Content = "校验总次数:" + count.ToString(); this.lb_bar.Content = "工具编码:" + (w != null ? w.wrenchCode : ""); ColumnSeries cs = new ColumnSeries(strListx, strListy); if (cs.CreateChar() != null) { this.chart.Children.Add(cs.CreateChar()); } }
ToolModel GetToolModel(wrench w) { wrenchspecies ws = WrenchSpecies.selectByGuid(w.species); return(new ToolModel() { wrenchBarCode = w.wrenchBarCode, wrenchCode = w.wrenchCode, speciesName = ws.speciesName, lastrepair = w.lastrepair, cycletime = Convert.ToDecimal(w.cycletime.ToString("f0")), isallowcheck = w.isallowcheck, guid = w.guid }); }
List <WrenchCheckOut> getshowdata(List <torquechecktarget> torquetargetlist) { GetUser gu = new GetUser(); List <WrenchCheckOut> tempwcolist = new List <WrenchCheckOut>(); if (torquetargetlist == null) { return(tempwcolist); } foreach (torquechecktarget t in torquetargetlist) { userinfo juser = new userinfo(); userinfo zuser = new userinfo(); juser = gu.getuserinfo(gu.getusers(t.operatorID)); if (juser == null || juser.user == null) { users jusers = new users(); jusers.username = t.operatorID; juser.user = jusers; department d = new department(); d.departmentName = t.operatorID; juser.department = d; } if (!string.IsNullOrEmpty(t.qaID)) { zuser = gu.getuserinfo(gu.getusers(t.qaID)); } wrench tempw = Wrench.selectByguid(t.wrenchID); tempwcolist.Add(new WrenchCheckOut() { wrenchcode = tempw.wrenchCode, wrenchbarcode = tempw.wrenchBarCode, jusername = (juser == null || juser.user == null)?"":juser.user.username, zusername = (zuser == null || zuser.user == null)?"":zuser.user.username, juserinfo = juser, zuserinfo = zuser, torquetargetvalue = t.torqueTargetValue.ToString(), errorrange = (t.torqueTargetValue * (1 + Convert.ToDecimal(t.errorRangeMin))).ToString("f2") + "~" + (t.torqueTargetValue * (1 + Convert.ToDecimal(t.errorRangeMax))).ToString("f2"), errormax = Convert.ToDecimal(t.errorRangeMax).ToString("f4"), errormin = Convert.ToDecimal(t.errorRangeMin).ToString("f4"), is_good = t.is_good, checkdate = t.checkDate.ToString().Replace('T', ' '), guid = t.guid }); } return(tempwcolist); }
void ShowWrench(wrench e) { if (e == null) { return; } IWrenchStatus WrenchStatus = DataAccess.CreateWrenchStatus(); wrenchstatus w = WrenchStatus.selectByguid(e.status); if (w != null) { this.wrenchstatus.Text = w.statusName; } this.wrenchcode.Text = e.wrenchCode; this.cb_wrench.IsEnabled = true; }
bool isexit(wrench w) { if (w == null) { return(true); } if (Wrench.selectByBarcode(w.wrenchBarCode) != null) { MessageBox.Show("工具条码号已经存在不能重复!"); return(true); } if (Wrench.selectBycode(w.wrenchCode) != null && Wrench.selectBycode(w.wrenchCode).Count > 0) { MessageBox.Show("工具编号已经存在不能重复!"); return(true); } return(false); }
bool update(wrench w) { //if (w.cycletime == null||w.cycletime<=0) // w.cycletime = 0; try { w.cycletime = Convert.ToDecimal(w.cycletime); } catch { w.cycletime = 0; } w.species = (cb_species.SelectedItem as wrenchspecies).guid.ToString(); w.status = (cb_status.SelectedItem as wrenchstatus).guid.ToString(); return(Wrench.updata(w)); }
void BindGrid(List <ToolModel> tl) { List <ToolModel> tempt = new List <ToolModel>(); foreach (ToolModel tm in tl) { wrench w = Wrench.selectByBarcode(tm.wrenchBarCode); ToolModel t = GetToolMode(w); if (t != null) { tempt.Add(t); } } this.dt_showdata.ItemsSource = null; this.dt_showdata.ItemsSource = tempt; tl.Clear(); }
public wrenchinfo GetWrenchinfo(string barcode) { wrench w = Wrench.selectByBarcode(barcode); if (w == null) { return(null); } wrenchspecies ws = WrenchSpecies.selectByGuid(w.species); wrenchstatus wss = WrenchStatus.selectByguid(w.status); wrenchinfo wi = new wrenchinfo(); wi.wrench = w; wi.species = ws; wi.status = wss; return(wi); }
bool updata(string type) { try { for (int i = 0; i < dt_showdata.Items.Count; i++) { var cntr = dt_showdata.ItemContainerGenerator.ContainerFromIndex(i); DataGridRow ObjROw = (DataGridRow)cntr; if (ObjROw != null) { FrameworkElement objElement = dt_showdata.Columns[0].GetCellContent(ObjROw); if (objElement != null) { System.Windows.Controls.CheckBox objChk = (System.Windows.Controls.CheckBox)objElement; if (objChk.IsChecked == true) { ToolModel tm = ObjROw.Item as ToolModel; if (tm == null || tm.guid == null) { continue; } wrench s = new wrench(); if (type == "001") { s = Wrench.selectByguid(tm.guid); wrenchstatus ws = WrenchStatus.selectByStatusDM(type); s.status = ws.guid; s.lastrepair = DateTime.Now; } if (type == "002") { s = Wrench.selectByguid(tm.guid); wrenchstatus ws = WrenchStatus.selectByStatusDM(type); s.status = ws.guid; } Wrench.updata(s); } } } } return(true); } catch { return(false); } }
private void delButtonClick(object sender, RoutedEventArgs e) { int i_index = dataGrid1.SelectedIndex; if (i_index >= 0) { _wrench = dataGrid1.SelectedItem as wrench; if (MessageAlert.Alter("是否删除该条记录")) { if (SqlietDelWrench(_wrench)) { getwrenchlist(Gettoolmodel(Wrench.selectPage(pagesize, pageno))); getstatus(); clear(); } } } }