protected override XResp Execute() { var r = new back(); var sc = DB.x_secode.FirstOrDefault(o => o.outcode == no); if (sc == null) { r.ct = -1; } else if (sc.user_id > 0) { if (sc.user_id == cu.user_id) { r.self = true; } r.lt = sc.stime?.ToString("yyyy-MM-dd HH:mm:ss"); r.ct = sc.scount ?? 0; sc.scount = r.ct + 1; sc.stime = DateTime.Now; } else { r.self = true; sc.user_id = cu.user_id; sc.stime = DateTime.Now; sc.scount = 1; } SubmitDBChanges(); return(r); }
public string Post(back Back) { Connection conn = new Connection(); MySqlConnection myConn = conn.GetConnection(); string getRecordId = string.Format("select count(*) from leaving_record where student_ID='{0}'", Back.student_ID); string health = string.Format("select count(*) from student where (student_ID='{0}' and (healthcode_color!='green' or currenthealth_status!=0))", Back.student_ID); MySqlCommand h = new MySqlCommand(health, myConn); MySqlDataReader heal = h.ExecuteReader(); heal.Read(); int y = heal.GetInt16(0); heal.Close(); if (y != 0) { return("fail,you have risk"); } MySqlCommand getIt = new MySqlCommand(getRecordId, myConn); MySqlDataReader reader = getIt.ExecuteReader(); reader.Read(); int x = reader.GetInt16(0); reader.Close(); //string time=DateTime.Now.ToShortDateString(); string updatesql = string.Format("update leaving_record set date_back='{0}',transport_back='{1}',back_num='{2}' where student_ID='{3}' and record_ID={4}", Back.date_back, Back.transport_back, Back.back_num, Back.student_ID, x.ToString()); MySqlCommand excute = new MySqlCommand(updatesql, myConn); int i = excute.ExecuteNonQuery(); conn.Close(); if (i != 0) { return("success"); } return("fail"); }
protected override XResp Execute() { var r = new back(); r.page = page; var q = from coop in DB.x_coop where coop.agent_id == cag.id orderby coop.time descending select new { coop.id, coop.agent_id, coop.x_agent.name, coop.x_agent.contract, coop.x_agent.tel, coop.house, //楼盘 coop.room_name, //室 coop.door_no_name, coop.intime_name, coop.floor, coop.onfloor, coop.floor_name, etime = coop.intime, coop.lea_room_name, more = coop.more.Substring(0, 20), coop.cover, //封面 coop.area, coop.pay_way, //付款方式 coop.pay_way_name, coop.lea_way, //出租方式(整租|合租) coop.lea_way_name, coop.price, //价格 coop.unit, //单位 coop.status, //状态 coop.status_name, coop.businessarea_name, coop.region_name }; if (st > 0) { q = q.Where(o => o.status == st); } if (!string.IsNullOrEmpty(key)) { q = q.Where(o => o.house.Contains(key)); } if (st == 2) { q = q.OrderBy(o => o.etime); } r.items = q.Skip((page - 1) * limit).Take(limit); r.count = q.Count(); r.st1 = q.Count(o => o.status == 1); r.st2 = q.Count(o => o.status == 2); r.st3 = q.Count(o => o.status == 3); return(r); }
private void show(back item) { try { if (item == null) { textBox1.Text = string.Empty; pictureBox1.BackgroundImage = null; fondo = new back(); return; } textBox1.Text = item.nombre; chkApellido.Checked = item.print_apellido; chkDocumento.Checked = item.print_documento; chkFoto.Checked = item.print_foto; chkLegajo.Checked = item.print_legajo; chkNombre.Checked = item.print_nombre; chkUpcode.Checked = item.print_upcode; lblUbicarItem.Text = "(ninguno)"; numLeft.Value = 0; numTop.Value = 0; lblPlaceLegajo.Top = Convert.ToInt32(item.legajo_top / ScaleY); lblPlaceLegajo.Left = Convert.ToInt32(item.legajo_left / ScaleX); lblPlaceDocumento.Top = Convert.ToInt32(item.documento_top / ScaleY); lblPlaceDocumento.Left = Convert.ToInt32(item.documento_left / ScaleX); lblPlaceNombre.Top = Convert.ToInt32(item.nombre_top / ScaleY); lblPlaceNombre.Left = Convert.ToInt32(item.nombre_left / ScaleX); lblPlaceApellido.Top = Convert.ToInt32(item.apellido_top / ScaleY); lblPlaceApellido.Left = Convert.ToInt32(item.apellido_left / ScaleX); lblPlaceUpcode.Top = Convert.ToInt32(item.upcode_top / ScaleY); lblPlaceUpcode.Left = Convert.ToInt32(item.upcode_left / ScaleX); lblPlaceFoto.Top = Convert.ToInt32(item.foto_top / ScaleY); lblPlaceFoto.Left = Convert.ToInt32(item.foto_left / ScaleX); if (item.image != null) { byte[] foto = item.image.ToArray(); if (foto.Length > 1) { var ms = new MemoryStream(); for (int i = 0; i < foto.Length; i++) { ms.WriteByte(foto[i]); } pictureBox1.BackgroundImage = Image.FromStream(ms); ms.Close(); } } else { pictureBox1.BackgroundImage = null; } fondo = item; } catch { MessageBox.Show("Error obteniendo foto."); } }
protected override XResp Execute() { var r = new back(); var q = from c in DB.x_coop where c.agent_id == cag.agent_id orderby c.up_time descending select new { house = c.house, c.region, c.area, c.type, c.type_name, cover = c.cover1, c.lea_way, c.door_no_name, c.toward_name, c.latitude, c.longitude, c.businessarea, c.room, c.onfloor, c.room_name, c.lea_room, c.lea_room_name, c.lea_way_name, c.price, more = c.more, c.status, c.coop_id, c.time, c.up_time, c.up_time_name, c.id }; //key:关键字 if (!string.IsNullOrEmpty(key)) { var dt = DB.x_dict.FirstOrDefault(o => o.code == "coop.dt" && o.name == key && o.upval != "0"); if (dt != null) { q = q.Where(o => o.house.Contains(key) || (DB.x_dict.Where(d => d.code == "code.qy" && d.name == key).Select(s => s.value)).Contains(o.businessarea + "") || DB.fnGetDistance((float)o.longitude, (float)o.latitude, (float)dt.pointx, (float)dt.pointy) < 1.5 * 1000 ); } else { q = q.Where(o => o.house.Contains(key) || (DB.x_dict.Where(d => d.code == "code.qy" && d.name == key).Select(s => s.value)).Contains(o.businessarea + "")); } } if (st > 0) { q = q.Where(o => o.status == st); } if (page > 0) { r.page = page; r.items = q .Skip((page - 1) * limit) .Take(limit) .Select(o => new { o.house, o.cover, o.area, o.coop_id, o.id, o.type_name, floor_name = o.onfloor + "层", price = o.price, unit = "元/月", o.room_name, o.toward_name, o.more, o.lea_way_name, o.lea_room_name, up_time = o.up_time_name, o.door_no_name, o.status } ).ToList(); } r.count = q.Count(); r.st1 = q.Count(o => o.status == 1); r.st2 = q.Count(o => o.status == 2); r.st3 = q.Count(o => o.status == 3); return(r); }