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