public DTOResponse InsertTaskStat(INF_JOBFEEDBACKEntity jobFeedBack)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
TaskStatEntity projTaskstatEntity = new TaskStatEntity();
projTaskstatEntity.TASKNO = jobFeedBack.JOBID;
projTaskstatEntity.STATITEMNAME = jobFeedBack.FEEDBACKSTATUS;
projTaskstatEntity.STATITEMDESC = jobFeedBack.FEEDBACKSTATUS;
projTaskstatEntity.STATITEMVALUE = "0";
projTaskstatEntity.CREATETIME = Utils.GetDatetime();
projTaskstatEntity.P01 = jobFeedBack.ENTERDATE;
projTaskstatEntity.P02 = Utils.GetDatetime();
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
dbConn.Save <TaskStatEntity>(projTaskstatEntity, false);
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "保存 PROJ_TASKSTAT成功！";
DCSInfService.logger.Info((object)dtoResponse);
return(dtoResponse);
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
DCSInfService.logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse SetP01(LocationStnRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConnection = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
using (IDbTransaction trans = dbConnection.OpenTransaction())
{
request.CONTROLMODE = 1;
dtoResponse = this.SetP01(request, dbConnection, trans);
if (dtoResponse.IsSuccess)
{
trans.Commit();
}
else
{
trans.Rollback();
}
return(dtoResponse);
}
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse GetList(MsgRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
string str1 = (string)null;
string str2 = (string)null;
DateTime dt1;
DateTime dt2;
if (!string.IsNullOrEmpty(request.datetimerange) && request.datetimerange.Length > 10)
{
string s1 = request.datetimerange.Substring(0, 10);
string s2 = request.datetimerange.Substring(13, 10);
DateTime.TryParse(s1, out dt1);
DateTime.TryParse(s2, out dt2);
str1 = dt1.ToString("yyyy-MM-dd HH:mm:ss");
str2 = dt2.ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
DateTime today = DateTime.Today;
dt1 = today.AddDays(-7.0);
today = DateTime.Today;
dt2 = today.AddDays(1.0);
str1 = dt1.ToString("yyyy-MM-dd HH:mm:ss");
str2 = dt2.ToString("yyyy-MM-dd HH:mm:ss");
}
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
SqlExpression <SysAlterInfoEntity> expression = dbConn.From <SysAlterInfoEntity>();
expression.And((Expression <Func <SysAlterInfoEntity, bool> >)(x => x.CREATEDATETIME >= dt1 && x.CREATEDATETIME <= dt2));
if (!string.IsNullOrEmpty(request.MSGTEXT))
{
expression.And((Expression <Func <SysAlterInfoEntity, bool> >)(x => x.MSGTEXT.Contains(request.MSGTEXT)));
}
if (!string.IsNullOrEmpty(request.MSGTYPE) && request.MSGTYPE != "0")
{
expression.And((Expression <Func <SysAlterInfoEntity, bool> >)(x => x.MSGTYPE == request.MSGTYPE));
}
if (!string.IsNullOrEmpty(request.MSGSTATE))
{
expression.And((Expression <Func <SysAlterInfoEntity, bool> >)(x => x.MSGSTATE == request.MSGSTATE));
}
long num = dbConn.Count <SysAlterInfoEntity>(expression);
List <SysAlterInfoEntity> list = dbConn.Select <SysAlterInfoEntity>(expression).OrderByDescending <SysAlterInfoEntity, long>((Func <SysAlterInfoEntity, long>)(x => x.ID)).ToList <SysAlterInfoEntity>().Skip <SysAlterInfoEntity>((request.page - 1) * request.limit).Take <SysAlterInfoEntity>(request.limit).ToList <SysAlterInfoEntity>();
dtoResponse.TotalCount = num;
dtoResponse.ResultObject = (object)list;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
MsgService.logger.Error((object)ex);
}
return(dtoResponse);
}
public static bool CheckSysScenceOrderDcsState()
{
bool ifOrder = false;
try
{
SysSceneEntity sysScene = null;
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
sysScene = dbConn.Select <SysSceneEntity>(x => x.SCENESTATE == "1").FirstOrDefault();
}
if (sysScene != null)
{
if (sysScene.ORDERDCSSTATE == 1)
{
ifOrder = true;
}
}
return(ifOrder);
}
catch (Exception ex)
{
throw ex;
}
}
public DTOResponse SaveSysparams(BasicRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
SysParams entity = HelperSerializer.GetObjectFromJsonString <SysParams>(request.PostData);
if (entity == null)
{
throw new Exception("传入的参数无法解析！");
}
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
SqlExpression <SysParams> expression1 = dbConn.From <SysParams>();
expression1.Where(x => x.ID == entity.ID);
expression1.UpdateFields.Add("PARAVALUE");
int count1 = dbConn.UpdateOnly <SysParams>(entity, expression1);
dtoResponse.TotalCount = count1;
dtoResponse.IsSuccess = count1 == 1 ? true : false;
//dtoResponse.IsSuccess = dbConn.Update<SysParams>(entity);
dtoResponse.MessageText = "操作完成：" + dtoResponse.IsSuccess;
return(dtoResponse);
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse OrderSenceMode(SceneRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConnection = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
using (IDbTransaction trans = dbConnection.OpenTransaction())
{
dtoResponse = this.OrderSenceMode(request, dbConnection, trans);
if (dtoResponse.IsSuccess)
{
trans.Commit();
}
else
{
trans.Rollback();
}
SysSceneService.logger.Info((object)dtoResponse.ToString());
return(dtoResponse);
}
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
SysSceneService.logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse SaveEntity(SceneRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
SysSceneEntity uldScene = JsonSerializer.DeserializeFromString <SysSceneEntity>(request.PostData);
if (request.PostData == null)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = "传入的数据为空！";
return(dtoResponse);
}
int num = 0;
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
num = dbConn.Update <SysSceneEntity>(uldScene, (Action <IDbCommand>)null);
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "保存数据操作成功！" + num.ToString();
return(dtoResponse);
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
SysSceneService.logger.Error((object)ex);
return(dtoResponse);
}
}
Product IProductDataService.GetProduct(int productID)
{
using (var connection = new SqlConnection(HelperConnection.Connection()))
{
Product product = new Product();
connection.Open();
var command = new SqlCommand("[dbo].[usp_ProductById_GETI]", connection)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.Add(new SqlParameter("@ProductId", productID));
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
product.ProductID = Convert.ToInt32(reader["ProductID"]);
product.ProductName = reader["ProductName"].ToString();
product.UnitPrice = Convert.ToDecimal(reader["UnitPrice"]);
product.QuantityPerUnit = reader["QuantityPerUnit"].ToString();
}
}
return(product);
}
}
public DTOResponse GetList(LocationStnRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
SqlExpression <LocStationInfoEntity> expression = dbConn.From <LocStationInfoEntity>();
if (!string.IsNullOrEmpty(request.STATIONTYPE) && request.STATIONTYPE != "0")
{
expression.And(x => x.STATIONTYPE == request.STATIONTYPE);
}
if (!string.IsNullOrEmpty(request.TECHNO) && request.TECHNO != "000")
{
expression.And(x => x.TECHNO == request.TECHNO);
}
List <LocStationInfoEntity> list = dbConn.Select <LocStationInfoEntity>(expression).OrderBy <LocStationInfoEntity, string>((Func <LocStationInfoEntity, string>)(x => x.ID)).ToList <LocStationInfoEntity>();
dtoResponse.ResultObject = (object)list;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
}
return(dtoResponse);
}
public DTOResponse GetList(PalletRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
SqlExpression <PalletEntity> expression = dbConn.From <PalletEntity>();
if (!string.IsNullOrEmpty(request.STOCKNO))
{
expression.And(x => x.STOCKNO == request.STOCKNO);
}
if (!string.IsNullOrEmpty(request.GROUPNO))
{
expression.And(x => x.GROUPNO == request.GROUPNO);
}
if (!string.IsNullOrEmpty(request.LOCATIONNO))
{
expression.And(x => x.LOCATIONNO == request.LOCATIONNO);
}
if (!string.IsNullOrEmpty(request.PALLETNO))
{
expression.And(x => x.PALLETNO == request.PALLETNO);
}
if (!string.IsNullOrEmpty(request.STATE))
{
expression.And(x => x.STATE == int.Parse(request.STATE));
}
if (!string.IsNullOrEmpty(request.PLANNO))
{
expression.And(x => x.PLANNO == request.PLANNO);
}
long count = dbConn.Count <PalletEntity>(expression);
List <PalletEntity> entityList = dbConn.Select <PalletEntity>(expression)
.OrderBy(x => x.ID)
.Skip((request.page - 1) * request.limit)
.Take(request.limit)
.ToList();
dtoResponse.TotalCount = count;
dtoResponse.ResultObject = (object)entityList;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
return(dtoResponse);
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse GetList <T>(DCSInfRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
string str1 = typeof(T).Name.Replace("Entity", "");
string str2 = "SELECT * FROM " + str1;
string str3 = " WHERE 1=1";
if (!string.IsNullOrEmpty(request.EQUIPMENTID) && str1 != "INF_JOBFEEDBACK")
{
str3 += string.Format(" AND EQUIPMENTID='{0}'", (object)request.EQUIPMENTID);
}
if (!string.IsNullOrEmpty(request.STATUS))
{
str3 += string.Format(" AND STATUS={0}", (object)request.STATUS);
}
if (!string.IsNullOrEmpty(request.JOBID))
{
str3 += string.Format(" AND JOBID='{0}'", (object)request.JOBID);
}
if (!string.IsNullOrEmpty(request.CREATEDATE))
{
DateTime dt1;
if (DateTime.TryParse(request.CREATEDATE, out dt1))
{
str3 += string.Format(" AND CREATEDATE LIKE '{0}%'", dt1.ToString("yyyy-MM-dd"));
}
else
{
dt1 = System.DateTime.Today;
str3 += string.Format(" AND CREATEDATE LIKE '{0}%'", dt1.ToString("yyyy-MM-dd"));
}
}
string str4 = " ORDER BY AUTOID DESC,CREATEDATE DESC";
long num = dbConn.Count <T>();
string sql = str2 + str3 + str4;
DCSInfService.logger.Debug((object)sql);
List <T> list = Enumerable.ToList <T>(Enumerable.Take <T>(Enumerable.Skip <T>(dbConn.Select <T>(sql), (request.page - 1) * request.limit), request.limit));
dtoResponse.TotalCount = num;
dtoResponse.ResultObject = (object)list;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
return(dtoResponse);
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
DCSInfService.logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse GetList(PlanDetailRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
SqlExpression <PlanDetailEntity> expression = dbConn.From <PlanDetailEntity>();
if (request.LINESTATE != null)
{
expression.And(x => x.LINESTATE == request.LINESTATE);
}
if (request.PLANTYPE != null)
{
expression.And(x => x.PLANTYPE == request.PLANTYPE);
}
if (!string.IsNullOrEmpty(request.PRODUCTTYPE) && request.PRODUCTTYPE != "0")
{
expression.And(x => x.PRODUCTTYPE == request.PRODUCTTYPE);
}
if (!string.IsNullOrEmpty(request.PRODUCTNO) && request.PRODUCTNO != "0")
{
expression.And(x => x.PRODUCTNO == request.PRODUCTNO);
}
if (!string.IsNullOrEmpty(request.PRODUCTNAME))
{
expression.And(x => x.PRODUCTNAME.Contains(request.PRODUCTNAME));
}
long count = dbConn.Count <PlanDetailEntity>(expression);
List <PlanDetailEntity> entityList = dbConn.Select <PlanDetailEntity>(expression)
.OrderByDescending(x => x.ID)
.Skip <PlanDetailEntity>((request.page - 1) * request.limit)
.Take <PlanDetailEntity>(request.limit)
.ToList <PlanDetailEntity>();
dtoResponse.TotalCount = count;
dtoResponse.ResultObject = (object)entityList;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
return(dtoResponse);
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
public static void AddRepositories(this IServiceCollection services, IConfiguration configuration, bool isDev)
{
services.AddDbContext <APINEXOSContext>(options =>
{
options.UseSqlServer(HelperConnection.GetConnectionSQL(configuration, isDev), sqlOptions =>
{
sqlOptions.EnableRetryOnFailure(3, TimeSpan.FromSeconds(30), null);
sqlOptions.CommandTimeout(60);
});
});
services.AddScoped(typeof(IBaseRepository <>), typeof(BaseRepository <>));
//services.AddTransient<IInvoiceRepository, InvoiceRepository>();
}
public static void InsertAlterInfo(string msgType, string msg, string msgState = "1")
{
SysAlterInfoEntity projAlertinfo = new SysAlterInfoEntity();
projAlertinfo.MSGSTATE = msgState;
projAlertinfo.MSGTYPE = msgType;
projAlertinfo.MSGTEXT = msg;
projAlertinfo.CREATEDATE = Utils.GetDatetime();
projAlertinfo.CREATEDATETIME = Utils.GetTodayDateTimeNow();
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
dbConn.Save <SysAlterInfoEntity>(projAlertinfo, false);
}
}
void IProductDataService.UpdateProduct(Product product)
{
using (var connection = new SqlConnection(HelperConnection.Connection()))
{
connection.Open();
var command = new SqlCommand("[dbo].[usp_UpdateProduct]", connection)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.Add(new SqlParameter("@ProductID", product.ProductID));
command.Parameters.Add(new SqlParameter("@ProductName", product.ProductName));
command.Parameters.Add(new SqlParameter("@QuantityPerUnit", product.QuantityPerUnit));
command.Parameters.Add(new SqlParameter("@UnitPrice", product.UnitPrice));
command.ExecuteNonQuery();
}
}
public DTOResponse GetDataFromDCS(List <long> jobidList)
{
DTOResponse dTOResponse = new DTOResponse();
try
{
string arg = jobidList.ToInString();
List <object> list = null;
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory("DCS").OpenDbConnection())
{
string sql = $"select wjid,rid,sc,tg,paid,st,ts,et,sct from sm_wcs_jb_ts_od where wjid in ({arg}) order by wjid,et";
list = dbConn.Select <object>(sql);
}
List <TaskStatEntity> list2 = new List <TaskStatEntity>();
foreach (dynamic item in list)
{
TaskStatEntity pROJ_TASKSTATEntity = new TaskStatEntity();
pROJ_TASKSTATEntity.TASKNO = item.wjid;
pROJ_TASKSTATEntity.STATITEMNAME = item.paid;
pROJ_TASKSTATEntity.STATITEMDESC = item.rid;
DateTime d = Convert.ToDateTime(item.et);
DateTime d2 = Convert.ToDateTime(item.sct);
pROJ_TASKSTATEntity.STATITEMVALUE = (d2 - d).Seconds.ToString();
pROJ_TASKSTATEntity.P01 = item.et;
pROJ_TASKSTATEntity.P02 = item.sct;
pROJ_TASKSTATEntity.CREATETIME = Utils.GetDatetime();
list2.Add(pROJ_TASKSTATEntity);
}
long num = 0L;
using (IDbConnection dbConn2 = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
num = dbConn2.SaveAll(list2);
}
dTOResponse.IsSuccess = true;
dTOResponse.MessageText = "获取tsorder成功！" + num.ToString();
logger.Info(dTOResponse);
return(dTOResponse);
}
catch (Exception ex)
{
dTOResponse.IsSuccess = false;
dTOResponse.MessageText = ex.Message;
logger.Error(ex);
return(dTOResponse);
}
}
public DTOResponse SetSTATIONSTATE(LocationStnRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
int num = 0;
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
using (IDbTransaction dbTransaction = dbConn.OpenTransaction())
{
LocStationInfoEntity stationinfoEntity = OrmLiteReadExpressionsApi.Single <LocStationInfoEntity>(dbConn, (Expression <Func <LocStationInfoEntity, bool> >)(x => x.STATIONNO == request.STATIONNO));
if (stationinfoEntity == null)
{
throw new Exception("未查询到" + request.STATIONNO + "的信息");
}
stationinfoEntity.STATIONSTATE = request.STATIONSTATE;
stationinfoEntity.OPBY = SysInfo.CurrentUserName;
stationinfoEntity.OPDATE = Utils.GetTodayNow();
stationinfoEntity.OPMESSAGE = "设置状态！";
SqlExpression <LocStationInfoEntity> sqlExpression = dbConn.From <LocStationInfoEntity>();
sqlExpression.Where(x => x.ID == stationinfoEntity.ID);
sqlExpression.UpdateFields.Add("STATIONSTATE");
sqlExpression.UpdateFields.Add("OPBY");
sqlExpression.UpdateFields.Add("OPDATE");
sqlExpression.UpdateFields.Add("OPMESSAGE");
num = dbConn.UpdateOnly <LocStationInfoEntity>(stationinfoEntity, sqlExpression);
dbTransaction.Commit();
}
}
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "设置状态成功！" + num.ToString();
return(dtoResponse);
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
public static void InsertOplog(string opMessage, string keyValue = "")
{
try
{
SysOplogEntity oplog = new SysOplogEntity();
oplog.CREATEDATE = System.DateTime.Now;
oplog.ENTERDATE = Utils.GetDatetime();
oplog.KEYVALUE = keyValue;
oplog.OPMESSAGE = opMessage;
using (IDbConnection dbCon = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
dbCon.Insert <SysOplogEntity>(oplog);
}
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
}
public EstatisticaGestaoFamiliaViewModel GetEstatisticasByEquipes(string ibge, string sqlFiltros, int competencia)
{
try
{
string sql = _command.GetEstatisticasByEquipes;
sql = sql.Replace(@"@filtros", sqlFiltros);
sql = sql.Replace(@"@competencia", competencia.ToString());
var item = HelperConnection.ExecuteCommand(ibge, conn =>
conn.QueryFirstOrDefault <EstatisticaGestaoFamiliaViewModel>(sql)
);
return(item);
}
catch (Exception ex)
{
throw ex;
}
}
List <Product> IProductDataService.GetProducts(int currentPageNumber, int pageSize, string sortExpression, string sortDirection, out int totalRows)
{
List <Product> list = new List <Product>();
int i = 0;
using (var connection = new SqlConnection(HelperConnection.Connection()))
{
connection.Open();
var command = new SqlCommand("[dbo].[usp_ProductALL_GETI]", connection)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.Add(new SqlParameter("@PageSize", pageSize));
command.Parameters.Add(new SqlParameter("@PageNumber", currentPageNumber - 1));
command.Parameters.Add(new SqlParameter("@sortExpression", sortExpression));
command.Parameters.Add(new SqlParameter("@sortDirection", sortDirection));
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new Product
{
ProductID = Convert.ToInt32(reader["ProductID"]),
ProductName = reader["ProductName"].ToString(),
UnitPrice = Convert.ToDecimal(reader["UnitPrice"]),
QuantityPerUnit = reader["QuantityPerUnit"].ToString()
}
);
i++;
}
}
}
}
totalRows = i;
return(list);
}
public DTOResponse GetCurrent(SceneRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
List <SysSceneEntity> uldSceneList = dbConn.Select <SysSceneEntity>((Expression <Func <SysSceneEntity, bool> >)(x => x.SCENESTATE == "1"));
dtoResponse.ResultObject = (object)uldSceneList;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
SysSceneService.logger.Error((object)ex);
}
return(dtoResponse);
}
public void Install()
{
try
{
Installer.logger.Debug((object)"创建数据库表……");
using (IDbConnection dbCon = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
using (IDbTransaction dbTransaction = dbCon.OpenTransaction())
{
dbCon.CreateTableIfNotExists <Entitys.INVENTORY>();
dbTransaction.Commit();
}
dbCon.Close();
}
Installer.logger.Debug((object)"创建表结束!");
}
catch (Exception ex)
{
Installer.logger.Error((object)ex.ToString());
throw ex;
}
}
public DTOResponse GetList(LedInfoRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
List <INF_LEDINFOEntity> list = dbConn.Select <INF_LEDINFOEntity>().OrderBy <INF_LEDINFOEntity, int>((Func <INF_LEDINFOEntity, int>)(x => x.ID)).ToList <INF_LEDINFOEntity>();
dtoResponse.ResultObject = (object)list;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
LedInfoService.logger.Error((object)ex);
}
return(dtoResponse);
}
public DTOResponse BatchChangeUseState(LocationRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
SqlExpression <LocDetailEntity> sqlExpression = dbConn.From <LocDetailEntity>();
sqlExpression.Where(x => request.ListLocatioNo.Contains(x.LOCATIONNO));
sqlExpression.UpdateFields.Add("USESTATE");
sqlExpression.UpdateFields.Add("OPBY");
sqlExpression.UpdateFields.Add("OPDATE");
sqlExpression.UpdateFields.Add("OPMESSAGE");
LocDetailEntity locDetailEntity = new LocDetailEntity();
locDetailEntity.USESTATE = request.USESTATE;
locDetailEntity.OPBY = SysInfo.GetCurrentUserInfo();
locDetailEntity.OPDATE = Utils.GetTodayNow();
locDetailEntity.OPMESSAGE = "修改使用状态！";
int count = dbConn.UpdateOnly <LocDetailEntity>(locDetailEntity, sqlExpression);
dtoResponse.IsSuccess = count > 0 ? true : false;
dtoResponse.MessageText = "操作完成，修改记录" + count.ToString() + "条 " + dtoResponse.IsSuccess.ToString();
HelperOplog.InsertOplog("位置使用状态更改：" + request.USESTATE + "/" + request.ListLocatioNo.ToJson());
HelperOplog.InsertOplog(dtoResponse);
return(dtoResponse);
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse GetSysparamsList(BasicRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
List <SysParams> list = dbConn.Select <SysParams>().OrderBy(x => x.ID).ToList();
dtoResponse.ResultObject = list;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "操作完成：" + dtoResponse.IsSuccess;
return(dtoResponse);
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse GetDetailList(PalletRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
SqlExpression <PalletDetailEntity> expression = dbConn.From <PalletDetailEntity>();
if (request.PALLETID > -1)
{
expression.And(x => x.PALLETID == request.PALLETID);
}
long count = dbConn.Count <PalletDetailEntity>(expression);
List <PalletDetailEntity> entityList = dbConn.Select <PalletDetailEntity>(expression)
.OrderBy(x => x.ID)
.Skip((request.page - 1) * request.limit)
.Take(request.limit)
.ToList();
dtoResponse.TotalCount = count;
dtoResponse.ResultObject = (object)entityList;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
return(dtoResponse);
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
private DTOResponse GetHistoryList(TaskRequest request)
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
DTOResponse dtoResponse = new DTOResponse();
SqlExpression <ZHISTaskEntity> expression = dbConn.From <ZHISTaskEntity>();
if (!string.IsNullOrEmpty(request.TASKTCLASS) && request.TASKTCLASS != "0")
{
expression.And((Expression <Func <ZHISTaskEntity, bool> >)(x => x.TASKTCLASS == request.TASKTCLASS));
}
if (!string.IsNullOrEmpty(request.PALLETNO))
{
expression.And((Expression <Func <ZHISTaskEntity, bool> >)(x => x.PALLETNO == request.PALLETNO));
}
if (!string.IsNullOrEmpty(request.RelateNo))
{
expression.And((Expression <Func <ZHISTaskEntity, bool> >)(x => x.RELATENO == request.RelateNo));
}
if (!string.IsNullOrEmpty(request.SourceNo))
{
expression.And((Expression <Func <ZHISTaskEntity, bool> >)(x => x.SOURCE02 == request.SourceNo));
}
if (!string.IsNullOrEmpty(request.DescNo))
{
expression.And((Expression <Func <ZHISTaskEntity, bool> >)(x => x.DESTINATION02 == request.DescNo));
}
long num = dbConn.Count <ZHISTaskEntity>(expression);
List <ZHISTaskEntity> list = dbConn.Select <ZHISTaskEntity>(expression).OrderByDescending <ZHISTaskEntity, long>((Func <ZHISTaskEntity, long>)(x => x.ID)).Skip <ZHISTaskEntity>((request.page - 1) * request.limit).Take <ZHISTaskEntity>(request.limit).ToList <ZHISTaskEntity>();
dtoResponse.TotalCount = num;
dtoResponse.ResultObject = (object)list;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
return(dtoResponse);
}
}
public DTOResponse SwitchEmexitState(LocationStnRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
int num = 0;
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
using (IDbTransaction dbTransaction = dbConn.OpenTransaction())
{
LocStationInfoEntity stationinfoEntity = OrmLiteReadExpressionsApi.Single <LocStationInfoEntity>(dbConn, (Expression <Func <LocStationInfoEntity, bool> >)(x => x.STATIONNO == request.STATIONNO));
if (stationinfoEntity == null)
{
throw new Exception("未查询到" + request.STATIONNO + "的信息");
}
stationinfoEntity.EMEXIT = request.EMEXIT;
stationinfoEntity.OPBY = SysInfo.CurrentUserName;
stationinfoEntity.OPDATE = Utils.GetTodayNow();
stationinfoEntity.OPMESSAGE = "设置紧急出口成功！";
num = dbConn.Update <LocStationInfoEntity>(stationinfoEntity, (Action <IDbCommand>)null);
dbTransaction.Commit();
}
}
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "设置状态成功！" + num.ToString();
return(dtoResponse);
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse ChangeGroupUseState(LocationRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
try
{
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
LocGroupEntity entity = dbConn.Select <LocGroupEntity>(x => x.GROUPNO == request.GROUPNO).FirstNonDefault();
if (entity == null)
{
throw new Exception(request.LOCATIONNO + "位置不存在！");
}
entity.USESTATE = int.Parse(request.USESTATE);
entity.OPBY = SysInfo.GetCurrentUserInfo();
entity.OPDATE = Utils.GetTodayNow();
entity.OPMESSAGE = "修改使用状态！";
int count = dbConn.UpdateOnly <LocGroupEntity>(
entity,
new string[4] {
"USESTATE", "OPBY", "OPDATE", "OPMESSAGE"
},
(x => x.GROUPNO == request.GROUPNO));
dtoResponse.IsSuccess = count > 0 ? true : false;
dtoResponse.MessageText = "操作成功！" + count.ToString();
return(dtoResponse);
}
}
catch (Exception ex)
{
dtoResponse.IsSuccess = false;
dtoResponse.MessageText = ex.Message;
logger.Error((object)ex);
return(dtoResponse);
}
}
public DTOResponse GetkanbanInfo(LedInfoRequest request)
{
DTOResponse dtoResponse = new DTOResponse();
string reportno = request.REPORTNO;
Report report = HelperDbOperation.Select <Report>((Expression <Func <Report, bool> >)(x => x.REPORTNO == reportno)).First <Report>();
if (report != null)
{
string datasource = report.DATASOURCE;
using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
{
List <object> objectList = dbConn.Select <object>(datasource);
dtoResponse.ResultObject = (object)objectList;
dtoResponse.IsSuccess = true;
dtoResponse.MessageText = "查询操作成功！";
return(dtoResponse);
}
}
else
{
dtoResponse.IsSuccess = false;
return(dtoResponse);
}
}