|
|
|
|
|
using System;
|
|
|
|
|
|
using System.Data;
|
|
|
|
|
|
using System.Collections.Generic;
|
|
|
|
|
|
using MySql.Data.MySqlClient;
|
|
|
|
|
|
using CommonFunc;
|
|
|
|
|
|
using System.Text;
|
|
|
|
|
|
using XGL.Models;
|
|
|
|
|
|
namespace XGL.Data
|
|
|
|
|
|
{
|
|
|
|
|
|
public class basedata_carrealinfoDb : IDisposable
|
|
|
|
|
|
{
|
|
|
|
|
|
public void Dispose()
|
|
|
|
|
|
{
|
|
|
|
|
|
Dispose(true);
|
|
|
|
|
|
GC.SuppressFinalize(true);
|
|
|
|
|
|
}
|
|
|
|
|
|
protected virtual void Dispose(bool disposing)
|
|
|
|
|
|
{
|
|
|
|
|
|
if (!disposing)
|
|
|
|
|
|
return;
|
|
|
|
|
|
}
|
|
|
|
|
|
///<summary>
|
|
|
|
|
|
///判断是否存在记录
|
|
|
|
|
|
///</summary>
|
|
|
|
|
|
public bool Exists(int id)
|
|
|
|
|
|
{
|
|
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
|
|
strSql.Append("select count(1) from role");
|
|
|
|
|
|
strSql.Append(" where ");
|
|
|
|
|
|
strSql.Append(" id = @id ");
|
|
|
|
|
|
MySqlParameter[] parameters = {
|
|
|
|
|
|
new MySqlParameter("@id", MySqlDbType.Int32)
|
|
|
|
|
|
};
|
|
|
|
|
|
parameters[0].Value = id;
|
|
|
|
|
|
return DbHelperSQLServer.Exists(strSql.ToString(), parameters);
|
|
|
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
|
|
|
/// 增加一条数据
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
public int Add(basedata_carrealinfoModel model)
|
|
|
|
|
|
{
|
|
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
|
|
strSql.Append("insert into basedata_carrealinfo(");
|
|
|
|
|
|
strSql.Append("CarNo,MaterialNo,MaterialBarNo,CurrNodeId,LocatorNodeId,OptDt,PlanDt,OffMaterialId,IsOver,TrayCode,StartAreaId,TargetAreaId,IsDirect,IsDeleted,CreateTime,CreateId,CreateBy,ModifyTime,ModifyId,ModifyBy)");
|
|
|
|
|
|
strSql.Append(" values (");
|
|
|
|
|
|
strSql.Append("@CarNo,@MaterialNo,@MaterialBarNo,@CurrNodeId,@LocatorNodeId,@OptDt,@PlanDt,@OffMaterialId,@IsOver,@TrayCode,@StartAreaId,@TargetAreaId,@IsDirect,@IsDeleted,@CreateTime,@CreateId,@CreateBy,@ModifyTime,@ModifyId,@ModifyBy)");
|
|
|
|
|
|
strSql.Append("; select @@IDENTITY");
|
|
|
|
|
|
MySqlParameter[] parameters = {
|
|
|
|
|
|
new MySqlParameter("@CarNo",model.CarNo),
|
|
|
|
|
|
new MySqlParameter("@MaterialNo",model.MaterialNo),
|
|
|
|
|
|
new MySqlParameter("@MaterialBarNo",model.MaterialBarNo),
|
|
|
|
|
|
new MySqlParameter("@CurrNodeId",model.CurrNodeId),
|
|
|
|
|
|
new MySqlParameter("@LocatorNodeId",model.LocatorNodeId),
|
|
|
|
|
|
new MySqlParameter("@OptDt",model.OptDt),
|
|
|
|
|
|
new MySqlParameter("@PlanDt",model.PlanDt),
|
|
|
|
|
|
new MySqlParameter("@OffMaterialId",model.OffMaterialId),
|
|
|
|
|
|
new MySqlParameter("@IsOver",model.IsOver),
|
|
|
|
|
|
new MySqlParameter("@TrayCode",model.TrayCode),
|
|
|
|
|
|
new MySqlParameter("@StartAreaId",model.StartAreaId),
|
|
|
|
|
|
new MySqlParameter("@TargetAreaId",model.TargetAreaId),
|
|
|
|
|
|
new MySqlParameter("@IsDirect",model.IsDirect),
|
|
|
|
|
|
new MySqlParameter("@Id",model.Id),
|
|
|
|
|
|
new MySqlParameter("@IsDeleted",model.IsDeleted),
|
|
|
|
|
|
new MySqlParameter("@CreateTime",model.CreateTime),
|
|
|
|
|
|
new MySqlParameter("@CreateId",model.CreateId),
|
|
|
|
|
|
new MySqlParameter("@CreateBy",model.CreateBy),
|
|
|
|
|
|
new MySqlParameter("@ModifyTime",model.ModifyTime),
|
|
|
|
|
|
new MySqlParameter("@ModifyId",model.ModifyId),
|
|
|
|
|
|
new MySqlParameter("@ModifyBy",model.ModifyBy),
|
|
|
|
|
|
};
|
|
|
|
|
|
object obj = DbHelperSQLServer.ExecuteScalar(strSql.ToString(), parameters);
|
|
|
|
|
|
if (obj == null)
|
|
|
|
|
|
{
|
|
|
|
|
|
return 0;
|
|
|
|
|
|
}
|
|
|
|
|
|
else
|
|
|
|
|
|
{
|
|
|
|
|
|
return Convert.ToInt32(obj);
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
/// 修改一条数据
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
bool Update(basedata_carrealinfoModel model)
|
|
|
|
|
|
{
|
|
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
|
|
strSql.Append("update basedata_carrealinfo set");
|
|
|
|
|
|
strSql.Append(" CarNo = @CarNo , ");
|
|
|
|
|
|
strSql.Append(" MaterialNo = @MaterialNo , ");
|
|
|
|
|
|
strSql.Append(" MaterialBarNo = @MaterialBarNo , ");
|
|
|
|
|
|
strSql.Append(" CurrNodeId = @CurrNodeId , ");
|
|
|
|
|
|
strSql.Append(" LocatorNodeId = @LocatorNodeId , ");
|
|
|
|
|
|
strSql.Append(" OptDt = @OptDt , ");
|
|
|
|
|
|
strSql.Append(" PlanDt = @PlanDt , ");
|
|
|
|
|
|
strSql.Append(" OffMaterialId = @OffMaterialId , ");
|
|
|
|
|
|
strSql.Append(" IsOver = @IsOver , ");
|
|
|
|
|
|
strSql.Append(" TrayCode = @TrayCode , ");
|
|
|
|
|
|
strSql.Append(" StartAreaId = @StartAreaId , ");
|
|
|
|
|
|
strSql.Append(" TargetAreaId = @TargetAreaId , ");
|
|
|
|
|
|
strSql.Append(" IsDirect = @IsDirect , ");
|
|
|
|
|
|
strSql.Append(" IsDeleted = @IsDeleted , ");
|
|
|
|
|
|
strSql.Append(" CreateTime = @CreateTime , ");
|
|
|
|
|
|
strSql.Append(" CreateId = @CreateId , ");
|
|
|
|
|
|
strSql.Append(" CreateBy = @CreateBy , ");
|
|
|
|
|
|
strSql.Append(" ModifyTime = @ModifyTime , ");
|
|
|
|
|
|
strSql.Append(" ModifyId = @ModifyId , ");
|
|
|
|
|
|
strSql.Append(" ModifyBy = @ModifyBy");
|
|
|
|
|
|
strSql.Append(" where Id = @Id");
|
|
|
|
|
|
MySqlParameter[] parameters = {
|
|
|
|
|
|
new MySqlParameter("@CarNo", model.CarNo),
|
|
|
|
|
|
new MySqlParameter("@MaterialNo", model.MaterialNo),
|
|
|
|
|
|
new MySqlParameter("@MaterialBarNo", model.MaterialBarNo),
|
|
|
|
|
|
new MySqlParameter("@CurrN odeId", model.CurrNodeId),
|
|
|
|
|
|
new MySqlParameter("@LocatorNodeId", model.LocatorNodeId),
|
|
|
|
|
|
new MySqlParameter("@OptDt", model.OptDt),
|
|
|
|
|
|
new MySqlParameter("@PlanDt", model.PlanDt),
|
|
|
|
|
|
new MySqlParameter("@OffMaterialId", model.OffMaterialId),
|
|
|
|
|
|
new MySqlParameter("@IsOver", model.IsOver),
|
|
|
|
|
|
new MySqlParameter("@TrayCode", model.TrayCode),
|
|
|
|
|
|
new MySqlParameter("@StartAreaId", model.StartAreaId),
|
|
|
|
|
|
new MySqlParameter("@TargetAreaId", model.TargetAreaId),
|
|
|
|
|
|
new MySqlParameter("@IsDirect", model.IsDirect),
|
|
|
|
|
|
new MySqlParameter("@Id", model.Id),
|
|
|
|
|
|
new MySqlParameter("@IsDeleted", model.IsDeleted),
|
|
|
|
|
|
new MySqlParameter("@CreateTime", model.CreateTime),
|
|
|
|
|
|
new MySqlParameter("@CreateId", model.CreateId),
|
|
|
|
|
|
new MySqlParameter("@CreateBy", model.CreateBy),
|
|
|
|
|
|
new MySqlParameter("@ModifyTime", model.ModifyTime),
|
|
|
|
|
|
new MySqlParameter("@ModifyId", model.ModifyId),
|
|
|
|
|
|
new MySqlParameter("@ModifyBy", model.ModifyBy),
|
|
|
|
|
|
};
|
|
|
|
|
|
int rows = DbHelperSQLServer.ExecuteNonQuery(strSql.ToString(), parameters);
|
|
|
|
|
|
if (rows > 0)
|
|
|
|
|
|
{
|
|
|
|
|
|
return true;
|
|
|
|
|
|
}
|
|
|
|
|
|
else
|
|
|
|
|
|
{
|
|
|
|
|
|
return false;
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
|
|
|
/// 删除一条数据
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
public bool Delete(int id)
|
|
|
|
|
|
{
|
|
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
|
|
strSql.Append("delete from role ");
|
|
|
|
|
|
strSql.Append(" where id=@id");
|
|
|
|
|
|
MySqlParameter[] parameters = {
|
|
|
|
|
|
new MySqlParameter("@id", MySqlDbType.Int32)
|
|
|
|
|
|
};
|
|
|
|
|
|
parameters[0].Value = id;
|
|
|
|
|
|
int rows = DbHelperSQLServer.ExecuteNonQuery(strSql.ToString(), parameters);
|
|
|
|
|
|
if (rows > 0)
|
|
|
|
|
|
{
|
|
|
|
|
|
return true;
|
|
|
|
|
|
}
|
|
|
|
|
|
else
|
|
|
|
|
|
{
|
|
|
|
|
|
return false;
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
|
|
|
/// 得到一个对象实体
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
public basedata_carrealinfoModel GetModel(int id)
|
|
|
|
|
|
{
|
|
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
|
|
strSql.Append("select");
|
|
|
|
|
|
strSql.Append(" CarNo, MaterialNo, MaterialBarNo, CurrNodeId, LocatorNodeId, DATE_FORMAT(OptDt,'%Y-%m-%d %H:%i:%s') OptDt, PlanDt, OffMaterialId, IsOver, TrayCode, StartAreaId, TargetAreaId, IsDirect, Id, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
|
|
|
|
|
|
strSql.Append(" from basedata_carrealinfo");
|
|
|
|
|
|
strSql.Append(" where id=@id");
|
|
|
|
|
|
MySqlParameter[] parameters = {
|
|
|
|
|
|
new MySqlParameter("@id", MySqlDbType.Int32)
|
|
|
|
|
|
};
|
|
|
|
|
|
parameters[0].Value = id;
|
|
|
|
|
|
basedata_carrealinfoModel model = new basedata_carrealinfoModel();
|
|
|
|
|
|
DataSet ds = DbHelperSQLServer.Query(strSql.ToString(), parameters);
|
|
|
|
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
|
|
|
|
{
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["CarNo"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CarNo = Convert.ToString(ds.Tables[0].Rows[0]["CarNo"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["MaterialNo"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.MaterialNo = Convert.ToString(ds.Tables[0].Rows[0]["MaterialNo"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["MaterialBarNo"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.MaterialBarNo = Convert.ToString(ds.Tables[0].Rows[0]["MaterialBarNo"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["CurrNodeId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CurrNodeId = Convert.ToInt32(ds.Tables[0].Rows[0]["CurrNodeId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["LocatorNodeId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.LocatorNodeId = Convert.ToInt32(ds.Tables[0].Rows[0]["LocatorNodeId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["OptDt"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.OptDt = Convert.ToString(ds.Tables[0].Rows[0]["OptDt"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["PlanDt"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.PlanDt = Convert.ToInt32(ds.Tables[0].Rows[0]["PlanDt"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["OffMaterialId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.OffMaterialId = Convert.ToInt32(ds.Tables[0].Rows[0]["OffMaterialId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["IsOver"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.IsOver = Convert.ToInt32(ds.Tables[0].Rows[0]["IsOver"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["TrayCode"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.TrayCode = Convert.ToString(ds.Tables[0].Rows[0]["TrayCode"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["StartAreaId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.StartAreaId = Convert.ToInt32(ds.Tables[0].Rows[0]["StartAreaId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["TargetAreaId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.TargetAreaId = Convert.ToInt32(ds.Tables[0].Rows[0]["TargetAreaId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["IsDirect"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.IsDirect = Convert.ToInt32(ds.Tables[0].Rows[0]["IsDirect"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["Id"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Id"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["IsDeleted"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.IsDeleted = ds.Tables[0].Rows[0]["IsDeleted"].ToString() == "False" ? false : true;
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["CreateTime"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CreateTime = Convert.ToString(ds.Tables[0].Rows[0]["CreateTime"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["CreateId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CreateId = Convert.ToInt32(ds.Tables[0].Rows[0]["CreateId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["CreateBy"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CreateBy = Convert.ToString(ds.Tables[0].Rows[0]["CreateBy"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["ModifyTime"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.ModifyTime = Convert.ToString(ds.Tables[0].Rows[0]["ModifyTime"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["ModifyId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.ModifyId = Convert.ToInt32(ds.Tables[0].Rows[0]["ModifyId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (ds.Tables[0].Rows[0]["ModifyBy"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.ModifyBy = Convert.ToString(ds.Tables[0].Rows[0]["ModifyBy"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
return model;
|
|
|
|
|
|
}
|
|
|
|
|
|
else
|
|
|
|
|
|
{
|
|
|
|
|
|
return null;
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
|
|
|
/// 得到一个对象实体集合
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
public List<basedata_carrealinfoModel> GetList(string strWhere)
|
|
|
|
|
|
{
|
|
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
|
|
strSql.Append("select");
|
|
|
|
|
|
strSql.Append(" CarNo, MaterialNo, MaterialBarNo, CurrNodeId, LocatorNodeId, DATE_FORMAT(OptDt,'%Y-%m-%d %H:%i:%s') OptDt, PlanDt, OffMaterialId, IsOver, TrayCode, StartAreaId, TargetAreaId, IsDirect, Id, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
|
|
|
|
|
|
strSql.Append(" from basedata_carrealinfo");
|
|
|
|
|
|
if (!string.IsNullOrWhiteSpace(strWhere))
|
|
|
|
|
|
strSql.Append(" where " + strWhere);
|
|
|
|
|
|
List<basedata_carrealinfoModel> Items = new List<basedata_carrealinfoModel>();
|
|
|
|
|
|
DataSet ds = DbHelperSQLServer.Query(strSql.ToString());
|
|
|
|
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
|
|
|
|
{
|
|
|
|
|
|
foreach (DataRow row in ds.Tables[0].Rows)
|
|
|
|
|
|
{
|
|
|
|
|
|
basedata_carrealinfoModel model = new basedata_carrealinfoModel();
|
|
|
|
|
|
if (row["CarNo"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CarNo = Convert.ToString(row["CarNo"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["MaterialNo"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.MaterialNo = Convert.ToString(row["MaterialNo"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["MaterialBarNo"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.MaterialBarNo = Convert.ToString(row["MaterialBarNo"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["CurrNodeId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CurrNodeId = Convert.ToInt32(row["CurrNodeId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["LocatorNodeId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.LocatorNodeId = Convert.ToInt32(row["LocatorNodeId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["OptDt"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.OptDt = Convert.ToString(row["OptDt"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["PlanDt"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.PlanDt = Convert.ToInt32(row["PlanDt"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["OffMaterialId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.OffMaterialId = Convert.ToInt32(row["OffMaterialId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["IsOver"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.IsOver = Convert.ToInt32(row["IsOver"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["TrayCode"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.TrayCode = Convert.ToString(row["TrayCode"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["StartAreaId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.StartAreaId = Convert.ToInt32(row["StartAreaId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["TargetAreaId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.TargetAreaId = Convert.ToInt32(row["TargetAreaId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["IsDirect"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.IsDirect = Convert.ToInt32(row["IsDirect"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["Id"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.Id = Convert.ToInt32(row["Id"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["IsDeleted"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.IsDeleted = row["IsDeleted"].ToString() == "False" ? false : true;
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["CreateTime"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CreateTime = Convert.ToString(row["CreateTime"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["CreateId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CreateId = Convert.ToInt32(row["CreateId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["CreateBy"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CreateBy = Convert.ToString(row["CreateBy"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["ModifyTime"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.ModifyTime = Convert.ToString(row["ModifyTime"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["ModifyId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.ModifyId = Convert.ToInt32(row["ModifyId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["ModifyBy"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.ModifyBy = Convert.ToString(row["ModifyBy"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
Items.Add(model);
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
return Items;
|
|
|
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
|
|
|
/// 得到一个对象实体集合
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
public List<basedata_carrealinfoModel> GetList(string strWhere, MySqlParameter[] parameters)
|
|
|
|
|
|
{
|
|
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
|
|
strSql.Append("select");
|
|
|
|
|
|
strSql.Append(" CarNo, MaterialNo, MaterialBarNo, CurrNodeId, LocatorNodeId, DATE_FORMAT(OptDt,'%Y-%m-%d %H:%i:%s') OptDt, PlanDt, OffMaterialId, IsOver, TrayCode, StartAreaId, TargetAreaId, IsDirect, Id, IsDeleted, DATE_FORMAT(CreateTime,'%Y-%m-%d %H:%i:%s') CreateTime, CreateId, CreateBy, DATE_FORMAT(ModifyTime,'%Y-%m-%d %H:%i:%s') ModifyTime, ModifyId, ModifyBy");
|
|
|
|
|
|
strSql.Append(" from basedata_carrealinfo");
|
|
|
|
|
|
if (!string.IsNullOrWhiteSpace(strWhere))
|
|
|
|
|
|
strSql.Append(" where " + strWhere);
|
|
|
|
|
|
List<basedata_carrealinfoModel> Items = new List<basedata_carrealinfoModel>();
|
|
|
|
|
|
DataSet ds = DbHelperSQLServer.Query(strSql.ToString(), parameters);
|
|
|
|
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
|
|
|
|
{
|
|
|
|
|
|
foreach (DataRow row in ds.Tables[0].Rows)
|
|
|
|
|
|
{
|
|
|
|
|
|
basedata_carrealinfoModel model = new basedata_carrealinfoModel();
|
|
|
|
|
|
if (row["CarNo"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CarNo = Convert.ToString(row["CarNo"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["MaterialNo"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.MaterialNo = Convert.ToString(row["MaterialNo"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["MaterialBarNo"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.MaterialBarNo = Convert.ToString(row["MaterialBarNo"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["CurrNodeId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CurrNodeId = Convert.ToInt32(row["CurrNodeId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["LocatorNodeId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.LocatorNodeId = Convert.ToInt32(row["LocatorNodeId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["OptDt"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.OptDt = Convert.ToString(row["OptDt"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["PlanDt"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.PlanDt = Convert.ToInt32(row["PlanDt"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["OffMaterialId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.OffMaterialId = Convert.ToInt32(row["OffMaterialId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["IsOver"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.IsOver = Convert.ToInt32(row["IsOver"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["TrayCode"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.TrayCode = Convert.ToString(row["TrayCode"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["StartAreaId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.StartAreaId = Convert.ToInt32(row["StartAreaId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["TargetAreaId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.TargetAreaId = Convert.ToInt32(row["TargetAreaId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["IsDirect"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.IsDirect = Convert.ToInt32(row["IsDirect"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["Id"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.Id = Convert.ToInt32(row["Id"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["IsDeleted"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.IsDeleted = row["IsDeleted"].ToString() == "False" ? false : true;
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["CreateTime"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CreateTime = Convert.ToString(row["CreateTime"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["CreateId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CreateId = Convert.ToInt32(row["CreateId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["CreateBy"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.CreateBy = Convert.ToString(row["CreateBy"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["ModifyTime"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.ModifyTime = Convert.ToString(row["ModifyTime"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["ModifyId"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.ModifyId = Convert.ToInt32(row["ModifyId"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
if (row["ModifyBy"] != DBNull.Value)
|
|
|
|
|
|
{
|
|
|
|
|
|
model.ModifyBy = Convert.ToString(row["ModifyBy"]);
|
|
|
|
|
|
}
|
|
|
|
|
|
Items.Add(model);
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
return Items;
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
/**************************************************************************************************************************************************************************/
|
|
|
|
|
|
|
|
|
|
|
|
public DataSet GetData(string strWhere)
|
|
|
|
|
|
{
|
|
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
|
|
strSql.Append(@"SELECT
|
|
|
|
|
|
basedata_carrealinfo.Id,
|
|
|
|
|
|
basedata_carrealinfo.CarNo,
|
|
|
|
|
|
basedata_carrealinfo.MaterialNo,
|
|
|
|
|
|
basedata_carrealinfo.MaterialBarNo,
|
|
|
|
|
|
basedata_carrealinfo.OptDt,
|
|
|
|
|
|
basedata_carrealinfo.PlanDt,
|
|
|
|
|
|
basedata_carrealinfo.OffMaterialId,
|
|
|
|
|
|
basedata_carrealinfo.IsOver,
|
|
|
|
|
|
basedata_carrealinfo.TrayCode,
|
|
|
|
|
|
basedata_carrealinfo.StartAreaId,
|
|
|
|
|
|
basedata_carrealinfo.TargetAreaId,
|
|
|
|
|
|
basedata_carrealinfo.IsDirect,
|
|
|
|
|
|
basedata_carrealinfo.LocatorNodeId,
|
|
|
|
|
|
basedata_carrealinfo.CurrNodeId,
|
|
|
|
|
|
basedata_linecatcharea.AreaNo,
|
|
|
|
|
|
basedata_linecatcharea.AreaNm,
|
|
|
|
|
|
basedata_linecatcharea.AreaType,
|
|
|
|
|
|
basedata_linecatcharea.AreaStorageType，
|
|
|
|
|
|
basedata_linecatcharea.MaxNumber
|
|
|
|
|
|
FROM
|
|
|
|
|
|
basedata_carrealinfo
|
|
|
|
|
|
LEFT JOIN basedata_linecatcharea ON basedata_carrealinfo.LocatorNodeId = basedata_linecatcharea.Id");
|
|
|
|
|
|
|
|
|
|
|
|
if (!string.IsNullOrWhiteSpace(strWhere))
|
|
|
|
|
|
strSql.Append(" where " + strWhere);
|
|
|
|
|
|
|
|
|
|
|
|
return DbHelperSQLServer.Query(strSql.ToString());
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
|
|
|
/// 获取每个区域小车汇总数量
|
|
|
|
|
|
/// </summary>
|
|
|
|
|
|
/// <param name="strWhere"></param>
|
|
|
|
|
|
/// <returns></returns>
|
|
|
|
|
|
public DataSet GetDataCount(string strWhere)
|
|
|
|
|
|
{
|
|
|
|
|
|
StringBuilder strSql = new StringBuilder();
|
|
|
|
|
|
strSql.Append(@"SELECT
|
|
|
|
|
|
basedata_carrealinfo.Id,
|
|
|
|
|
|
basedata_carrealinfo.CarNo,
|
|
|
|
|
|
basedata_carrealinfo.MaterialNo,
|
|
|
|
|
|
basedata_carrealinfo.MaterialBarNo,
|
|
|
|
|
|
basedata_carrealinfo.OptDt,
|
|
|
|
|
|
basedata_carrealinfo.PlanDt,
|
|
|
|
|
|
basedata_carrealinfo.OffMaterialId,
|
|
|
|
|
|
basedata_carrealinfo.IsOver,
|
|
|
|
|
|
basedata_carrealinfo.TrayCode,
|
|
|
|
|
|
basedata_carrealinfo.StartAreaId,
|
|
|
|
|
|
basedata_carrealinfo.TargetAreaId,
|
|
|
|
|
|
basedata_carrealinfo.IsDirect,
|
|
|
|
|
|
basedata_carrealinfo.LocatorNodeId,
|
|
|
|
|
|
basedata_carrealinfo.CurrNodeId,
|
|
|
|
|
|
basedata_linecatcharea.AreaNo,
|
|
|
|
|
|
basedata_linecatcharea.AreaNm,
|
|
|
|
|
|
basedata_linecatcharea.AreaType,
|
|
|
|
|
|
basedata_linecatcharea.AreaStorageType,
|
|
|
|
|
|
basedata_linecatcharea.MaxNumber,
|
|
|
|
|
|
Count(1) AS RealNum,
|
|
|
|
|
|
(basedata_linecatcharea.MaxNumber - COUNT(1)) AS LeftNum,
|
|
|
|
|
|
basedata_materialinfo.MaterialNm
|
|
|
|
|
|
FROM
|
|
|
|
|
|
basedata_carrealinfo
|
|
|
|
|
|
LEFT JOIN basedata_linecatcharea ON basedata_carrealinfo.LocatorNodeId = basedata_linecatcharea.Id
|
|
|
|
|
|
LEFT JOIN basedata_materialinfo ON basedata_carrealinfo.MaterialNo = basedata_materialinfo.MaterialNo");
|
|
|
|
|
|
if (!string.IsNullOrWhiteSpace(strWhere))
|
|
|
|
|
|
strSql.Append(" where " + strWhere);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
strSql.Append(@" GROUP BY
|
|
|
|
|
|
LocatorNodeId,
|
|
|
|
|
|
basedata_carrealinfo.MaterialNo");
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
return DbHelperSQLServer.Query(strSql.ToString());
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
