public object AddField(Field field)
{
string token = null;
//获取请求
var request = HttpContext.Current.Request;
//声明响应
ResultMsg <Field> resultmsg = new ResultMsg <Field>();
HttpResponseMessage response = new HttpResponseMessage();
if (field == null || field.name == null || field.area <= 0 || field.currentcrop < -1 || field.sowdate > DateTime.Now.Date)//判断输入的数据格式是否正确
{
resultmsg.status = false;
resultmsg.msg = "输入的数据格式不正确,请检查后重新输入!";
resultmsg.data = null;
token = request.Headers["Token"];
//添加响应头
var resultObj1 = JsonConvert.SerializeObject(resultmsg, Formatting.Indented);
response.Headers.Add("Token", token);
response.Content = new StringContent(resultObj1);
return(response);
}
PostgreSQL.OpenCon(); //打开数据库
//查询用户所在农场编号
string strtoken = SunGolden.Encryption.DEncrypt.Decrypt(request.Headers["Token"]); //解密Token
string str_mobile = strtoken.Substring(0, strtoken.IndexOf(","));
//查询数据库tb_user
string str = string.Format("select * from tb_user where \"mobile\" =\'{0}\'", str_mobile);
//string str ="select farm from tb_user where \"mobile\" = \'@mobile\'}";
var para = new DbParameter[1];
para[0] = PostgreSQL.NewParameter("@moblie", str_mobile);
var qfarm = PostgreSQL.ExecuteTQuery <User>(str, null, para);
if (qfarm.farm != field.farm)//判断添加地块的农场是否是登录用户所在的农场
{
resultmsg.status = false;
resultmsg.msg = "此地块不属于这个农场,无法添加!";
resultmsg.data = null;
token = request.Headers["Token"];
}
else
{
////查询数据库
//string str_select = "select * from tb_field where \"name\" = @name and farm=@farm";
//var para1 = new DbParameter[2];
//para1[0] = PostgreSQL.NewParameter("@name", field.name);
//para1[1] = PostgreSQL.NewParameter("@farm", field.farm);
////var qField = PostgreSQL.ExecuteTableQuery(str_select, null, para1);
//var qField = PostgreSQL.ExecuteTQuery<Field>(str_select, null, para1);
////判断地块名是否存在
//if (qField != null)
//{
// resultmsg.status = false;
// resultmsg.msg = "地块名已经存在，请重新命名!";
// resultmsg.data = null;
// token = request.Headers["Token"];
//}
//else
//{
//数据检查
DataAuth auth = new DataAuth();
if (field.currentcrop == -1)
{
field.phenophase = -1;
field.sowdate = Convert.ToDateTime("0001/1/1 0:00:00");
#region//查询数据库
string str_insert = string.Format("insert into tb_field(farm,\"name\",geom,area,createdate,currentcrop,sowdate,phenophase,thumb) values(@farm,@name,st_geomfromtext(\'{0}\'),@area,@createdate,@currentcrop,@sowdate,@phenophase,@thumb);", field.geom);
//string str_insert = "insert into tb_field(farm,\"name\",geom,area,createdate,currentcrop,sowdate,phenophase,thumb) values(@farm,@name,@geom,@area,@createdate,@currentcrop,@sowdate,@phenophase,@thumb);";
var trans = PostgreSQL.BeginTransaction();
try
{
var para2 = new DbParameter[9];
para2[0] = PostgreSQL.NewParameter("@farm", field.farm);
para2[1] = PostgreSQL.NewParameter("@name", field.name);
para2[2] = PostgreSQL.NewParameter("@geom", field.geom);
para2[3] = PostgreSQL.NewParameter("@area", field.area);
para2[4] = PostgreSQL.NewParameter("@createdate", DateTime.Now.Date);
para2[5] = PostgreSQL.NewParameter("@currentcrop", field.currentcrop);
para2[6] = PostgreSQL.NewParameter("@sowdate", field.sowdate);
para2[7] = PostgreSQL.NewParameter("@phenophase", field.phenophase);
para2[8] = PostgreSQL.NewParameter("thumb", field.thumb);
var num = PostgreSQL.ExecuteNoneQuery(str_insert, trans, para2);
PostgreSQL.CommitTransaction(trans);
//返回信息
resultmsg.status = true;
resultmsg.msg = "添加地块成功!";
resultmsg.data = null;
token = request.Headers["Token"];
}
catch (Exception ex)
{
PostgreSQL.RollbackTransaction(trans);
//返回信息
resultmsg.status = false;
resultmsg.msg = "[ERROR] 数据库操作出现异常：" + ex.Message;
resultmsg.data = null;
token = request.Headers["Token"];
}
#endregion
}
else if (field.currentcrop != -1 && auth.crop(field.currentcrop))
{
if (field.sowdate.ToString() != "0001/1/1 0:00:00")
{
field.phenophase = auth.phentype(field.sowdate, field.currentcrop); //获取当前物候期
#region //查询数据库
string str_insert = string.Format("insert into tb_field(farm,\"name\",geom,area,createdate,currentcrop,sowdate,phenophase,thumb) values(@farm,@name,st_geomfromtext(\'{0}\'),@area,@createdate,@currentcrop,@sowdate,@phenophase,@thumb);", field.geom);
//string str_insert = "insert into tb_field(farm,\"name\",geom,area,createdate,currentcrop,sowdate,phenophase,thumb) values(@farm,@name,@geom,@area,@createdate,@currentcrop,@sowdate,@phenophase,@thumb);";
var trans = PostgreSQL.BeginTransaction();
try
{
var para2 = new DbParameter[9];
para2[0] = PostgreSQL.NewParameter("@farm", field.farm);
para2[1] = PostgreSQL.NewParameter("@name", field.name);
para2[2] = PostgreSQL.NewParameter("@geom", field.geom);
para2[3] = PostgreSQL.NewParameter("@area", field.area);
para2[4] = PostgreSQL.NewParameter("@createdate", DateTime.Now.Date);
para2[5] = PostgreSQL.NewParameter("@currentcrop", field.currentcrop);
para2[6] = PostgreSQL.NewParameter("@sowdate", field.sowdate);
para2[7] = PostgreSQL.NewParameter("@phenophase", field.phenophase);
para2[8] = PostgreSQL.NewParameter("thumb", field.thumb);
var num = PostgreSQL.ExecuteNoneQuery(str_insert, trans, para2);
PostgreSQL.CommitTransaction(trans);
//返回信息
resultmsg.status = true;
resultmsg.msg = "添加地块成功!";
resultmsg.data = null;
token = request.Headers["Token"];
}
catch (Exception ex)
{
PostgreSQL.RollbackTransaction(trans);
//返回信息
resultmsg.status = false;
resultmsg.msg = "[ERROR] 数据库操作出现异常：" + ex.Message;
resultmsg.data = null;
token = request.Headers["Token"];
}
#endregion
}
else
{
//返回信息
resultmsg.status = false;
resultmsg.msg = "输入的种植日期不符合要求,请重新输入!";
resultmsg.data = null;
token = request.Headers["Token"];
}
}
else
{
//返回信息
resultmsg.status = false;
resultmsg.msg = "输入的作物id不存在！";
resultmsg.data = null;
token = request.Headers["Token"];
}
}
//}
PostgreSQL.CloseCon();//关闭数据库
//添加响应头
var resultObj = JsonConvert.SerializeObject(resultmsg, Formatting.Indented);
response.Headers.Add("Token", token);
response.Content = new StringContent(resultObj);
return(response);
}
public object BatchField(Field field)
{
string token = null;
//获取请求
var request = HttpContext.Current.Request;
//声明响应
ResultMsg <Field> resultmsg = new ResultMsg <Field>();
HttpResponseMessage response = new HttpResponseMessage();
if (field == null || field.currentcrop < -1 || field.sowdate > DateTime.Now.Date) //判断输入的数据格式是否正确
{
resultmsg.status = false;
resultmsg.msg = "输入的数据格式不正确,请检查后重新输入!";
resultmsg.data = null;
token = request.Headers["Token"];
//添加响应头
var resultObj1 = JsonConvert.SerializeObject(resultmsg, Formatting.Indented);
response.Headers.Add("Token", token);
response.Content = new StringContent(resultObj1);
return(response);
}
PostgreSQL.OpenCon(); //打开数据库
//查询数据库tb_field
string str_select = "select * from tb_field where id = @id;"; //name = @name and farm = @farm;";
var para1 = new DbParameter[1];
para1[0] = PostgreSQL.NewParameter("@id", field.id);
var qField = PostgreSQL.ExecuteTQuery <Field>(str_select, null, para1);
if (qField == null) //判断地块是否存在
{
resultmsg.status = false;
resultmsg.msg = "地块不存在!";
resultmsg.data = null;
token = request.Headers["Token"];
}
else
{
//查询用户所在农场编号
string strtoken = SunGolden.Encryption.DEncrypt.Decrypt(request.Headers["Token"]); //解密Token
string str_mobile = strtoken.Substring(0, strtoken.IndexOf(","));
//查询数据库tb_user
string str = string.Format("select * from tb_user where \"mobile\" =\'{0}\'", str_mobile);
//string str ="select farm from tb_user where \"mobile\" = \'@mobile\'}";
var para = new DbParameter[1];
para[0] = PostgreSQL.NewParameter("@moblie", str_mobile);
var quser = PostgreSQL.ExecuteTQuery <User>(str, null, para);
if (quser.farm != qField.farm)
{
resultmsg.status = false;
resultmsg.msg = "此地块不属于这个农场,无法修改!";
resultmsg.data = null;
token = request.Headers["Token"];
}
else
{
//数据检查
DataAuth auth = new DataAuth();
if (field.currentcrop == -1)
{
//field.phenophase = -1;//获取当前物候期
field.sowdate = Convert.ToDateTime("0001/1/1 0:00:00");
#region //查询数据库
string str_update = "update tb_field set currentcrop = @currentcrop ,phenophase = @phenophase,sowdate=@sowdate,createdate= @createdate where id=@id;"; //currentcrop = @currentcrop and farm = @farm";
var trans = PostgreSQL.BeginTransaction();
try
{
var para2 = new DbParameter[5];
para2[0] = PostgreSQL.NewParameter("@currentcrop", field.currentcrop);
para2[1] = PostgreSQL.NewParameter("@id", field.id);
para2[2] = PostgreSQL.NewParameter("@sowdate", field.sowdate);
para2[3] = PostgreSQL.NewParameter("@phenophase", -1);
para2[4] = PostgreSQL.NewParameter("@createdate", DateTime.Now.Date);
var num = PostgreSQL.ExecuteNoneQuery(str_update, trans, para2);
PostgreSQL.CommitTransaction(trans);
//返回信息
resultmsg.status = true;
resultmsg.msg = "成功批量修改地块信息!";
resultmsg.data = null;
token = request.Headers["Token"];
}
catch (Exception ex)
{
PostgreSQL.RollbackTransaction(trans);
//返回信息
resultmsg.status = false;
resultmsg.msg = "[ERROR] 数据库操作出现异常：" + ex.Message;
resultmsg.data = null;
token = request.Headers["Token"];
}
#endregion
}
else if (field.currentcrop != -1 && auth.crop(field.currentcrop))
{
if (field.sowdate.ToString() != "0001/1/1 0:00:00")
{
field.phenophase = auth.phentype(field.sowdate, field.currentcrop); //获取当前物候期
#region //查询数据库
string str_update = "update tb_field set sowdate = @sowdate ,currentcrop = @currentcrop ,phenophase = @phenophase,createdate= @createdate where id=@id;"; //currentcrop = @currentcrop and farm = @farm";
var trans = PostgreSQL.BeginTransaction();
try
{
var para2 = new DbParameter[5];
para2[0] = PostgreSQL.NewParameter("@currentcrop", field.currentcrop);
para2[1] = PostgreSQL.NewParameter("@id", field.id);
para2[2] = PostgreSQL.NewParameter("@sowdate", field.sowdate);
para2[3] = PostgreSQL.NewParameter("phenophase", field.phenophase);
para2[4] = PostgreSQL.NewParameter("@createdate", DateTime.Now.Date);
var num = PostgreSQL.ExecuteNoneQuery(str_update, trans, para2);
PostgreSQL.CommitTransaction(trans);
//返回信息
resultmsg.status = true;
resultmsg.msg = "成功批量修改地块信息!";
resultmsg.data = null;
token = request.Headers["Token"];
}
catch (Exception ex)
{
PostgreSQL.RollbackTransaction(trans);
//返回信息
resultmsg.status = false;
resultmsg.msg = "[ERROR] 数据库操作出现异常：" + ex.Message;
resultmsg.data = null;
token = request.Headers["Token"];
}
#endregion
}
else
{
//返回信息
resultmsg.status = false;
resultmsg.msg = "输入的种植日期不符合要求,请重新输入!";
resultmsg.data = null;
token = request.Headers["Token"];
}
}
else
{
//返回信息
resultmsg.status = false;
resultmsg.msg = "输入的当前作物id不存在！";
resultmsg.data = null;
token = request.Headers["Token"];
}
}
}
PostgreSQL.CloseCon();//关闭数据库
//添加响应头
var resultObj = JsonConvert.SerializeObject(resultmsg, Formatting.Indented);
response.Headers.Add("Token", token);
response.Content = new StringContent(resultObj);
return(response);
}