public static bool ModifyStorageLocation(StorageLocationEntity entity)
{
long result = 0;
if (entity != null)
{
StorageLocationRepository mr = new StorageLocationRepository();
StorageLocationInfo StorageLocationInfo = TranslateStorageLocationInfo(entity);
if (entity.StorageLocationID > 0)
{
StorageLocationInfo.StorageLocationID = entity.StorageLocationID;
StorageLocationInfo.ChangeDate = DateTime.Now;
result = mr.ModifyStorageLocation(StorageLocationInfo);
}
else
{
StorageLocationInfo.ChangeDate = DateTime.Now;
StorageLocationInfo.CreateDate = DateTime.Now;
result = mr.CreateNew(StorageLocationInfo);
}
List <StorageLocationInfo> miList = mr.GetAllStorageLocation();//刷新缓存
Cache.Add("StorageLocationALL", miList);
}
return(result > 0);
}
public StorageLocationInfo GetStorageLocationByKey(long gid)
{
StorageLocationInfo result = new StorageLocationInfo();
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(StorageLocationStatement.GetStorageLocationByKey, "Text"));
command.AddInputParameter("@StorageLocationID", DbType.String, gid);
result = command.ExecuteEntity <StorageLocationInfo>();
return(result);
}
public static StorageLocationEntity GetStorageLocationById(long gid)
{
StorageLocationEntity result = new StorageLocationEntity();
StorageLocationRepository mr = new StorageLocationRepository();
StorageLocationInfo info = mr.GetStorageLocationByKey(gid);
result = TranslateStorageLocationEntity(info);
return(result);
}
public int ModifyStorageLocation(StorageLocationInfo StorageLocation)
{
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(StorageLocationStatement.Modify, "Text"));
command.AddInputParameter("@StorageID", DbType.String, StorageLocation.StorageID);
command.AddInputParameter("@StorageAreaNo", DbType.String, StorageLocation.StorageAreaNo);
command.AddInputParameter("@StorageLocationNo", DbType.String, StorageLocation.StorageLocationNo);
command.AddInputParameter("@IsLock", DbType.String, string.IsNullOrEmpty(StorageLocation.IsLock) ? "F" : StorageLocation.IsLock);
command.AddInputParameter("@Remark", DbType.String, StorageLocation.Remark);
command.AddInputParameter("@Status", DbType.String, StorageLocation.Status);
command.AddInputParameter("@OperatorID", DbType.String, StorageLocation.OperatorID);
command.AddInputParameter("@ChangeDate", DbType.DateTime, StorageLocation.ChangeDate);
command.AddInputParameter("@StorageLocationID", DbType.Int64, StorageLocation.StorageLocationID);
return(command.ExecuteNonQuery());
}
public long CreateNew(StorageLocationInfo StorageLocation)
{
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(StorageLocationStatement.CreateNew, "Text"));
command.AddInputParameter("@StorageID", DbType.String, StorageLocation.StorageID);
command.AddInputParameter("@StorageAreaNo", DbType.String, StorageLocation.StorageAreaNo);
command.AddInputParameter("@StorageSubAreaNo", DbType.String, StorageLocation.StorageSubAreaNo);
command.AddInputParameter("@StorageLocationNo", DbType.String, StorageLocation.StorageLocationNo);
command.AddInputParameter("@Remark", DbType.String, StorageLocation.Remark);
command.AddInputParameter("@IsLock", DbType.String, string.IsNullOrEmpty(StorageLocation.IsLock) ? "F" : StorageLocation.IsLock);
command.AddInputParameter("@Status", DbType.String, StorageLocation.Status);
command.AddInputParameter("@OperatorID", DbType.String, StorageLocation.OperatorID);
command.AddInputParameter("@CreateDate", DbType.DateTime, StorageLocation.CreateDate);
command.AddInputParameter("@ChangeDate", DbType.DateTime, StorageLocation.ChangeDate);
var o = command.ExecuteScalar <object>();
return(Convert.ToInt64(o));
}
private static StorageLocationInfo TranslateStorageLocationInfo(StorageLocationEntity entity)
{
StorageLocationInfo info = new StorageLocationInfo();
if (info != null)
{
info.StorageID = entity.StorageID;
info.StorageAreaNo = entity.StorageAreaNo;
info.StorageSubAreaNo = entity.StorageSubAreaNo;
info.StorageLocationNo = entity.StorageLocationNo;
info.Remark = entity.Remark;
info.OperatorID = entity.OperatorID;
info.Status = entity.Status;
info.IsLock = entity.IsLock;
info.CreateDate = entity.CreateDate;
info.ChangeDate = entity.ChangeDate;
info.StorageLocationID = entity.StorageLocationID;
}
return(info);
}
private static StorageLocationEntity TranslateStorageLocationEntity(StorageLocationInfo info)
{
StorageLocationEntity entity = new StorageLocationEntity();
if (info != null)
{
entity.StorageID = info.StorageID;
entity.StorageAreaNo = info.StorageAreaNo;
entity.StorageSubAreaNo = info.StorageSubAreaNo;
entity.StorageLocationNo = info.StorageLocationNo;
entity.Remark = info.Remark;
entity.IsLock = info.IsLock;
entity.OperatorID = info.OperatorID;
entity.Status = info.Status;
entity.CreateDate = info.CreateDate;
entity.ChangeDate = info.ChangeDate;
entity.StorageLocationID = info.StorageLocationID;
// 关联的仓库信息
entity.storages = StorageService.GetStorageEntityById(entity.StorageID);
}
return(entity);
}
