100 lines
3.3 KiB
C#
100 lines
3.3 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
using WMS.IData;using Oracle.ManagedDataAccess.Client;
|
|||
|
|
using System.Data;
|
|||
|
|
|
|||
|
|
using WMS.DBUtility;
|
|||
|
|
using WMS.Model.Base;
|
|||
|
|
using WMS.IData.IBase;
|
|||
|
|
|
|||
|
|
namespace WMS.SqlServerData.BaseData
|
|||
|
|
{
|
|||
|
|
public class LocAreaData : ILocArea
|
|||
|
|
{
|
|||
|
|
#region 获取库区库位关联
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取库区库位关联
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="model"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public DataTable GetLocAreaDT(LocAreaModel model)
|
|||
|
|
{
|
|||
|
|
StringBuilder strSql = new StringBuilder();
|
|||
|
|
strSql.AppendLine("select a.STORAGE_AREA_ID,a.LOCATION_ID,b.storage_area_name");
|
|||
|
|
strSql.AppendLine(" FROM T_BASE_LOC_AREA a left join t_base_storage_area b on a.storage_area_id = b.storage_area_id");
|
|||
|
|
strSql.AppendLine("where 1=1");
|
|||
|
|
if (!string.IsNullOrEmpty(model.STORAGE_AREA_ID))
|
|||
|
|
{
|
|||
|
|
strSql.AppendLine(" and a.STORAGE_AREA_ID = '" + model.STORAGE_AREA_ID + "' ");
|
|||
|
|
}
|
|||
|
|
if (!string.IsNullOrEmpty(model.LOCATION_ID))
|
|||
|
|
{
|
|||
|
|
strSql.AppendLine(" and a.LOCATION_ID = '" + model.LOCATION_ID + "' ");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 插入库区库位关联信息
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="LocAreaModel">库区库位关联Model</param>
|
|||
|
|
public void InsertLocArea(LocAreaModel model)
|
|||
|
|
{
|
|||
|
|
StringBuilder strSql = new StringBuilder();
|
|||
|
|
|
|||
|
|
//if (string.IsNullOrEmpty(model.STORAGE_AREA_ID))
|
|||
|
|
//{
|
|||
|
|
|
|||
|
|
//}
|
|||
|
|
//else
|
|||
|
|
//{
|
|||
|
|
|
|||
|
|
strSql.Append("insert into T_BASE_LOC_AREA(");
|
|||
|
|
|
|||
|
|
strSql.Append("STORAGE_AREA_ID,LOCATION_ID,STORAGE_ID)");
|
|||
|
|
|
|||
|
|
strSql.Append(" values (");
|
|||
|
|
|
|||
|
|
strSql.Append(":STORAGE_AREA_ID,:LOCATION_ID,:STORAGE_ID)");
|
|||
|
|
|
|||
|
|
OracleParameter[] parameters = {
|
|||
|
|
new OracleParameter(":STORAGE_AREA_ID",OracleDbType.Varchar2),
|
|||
|
|
new OracleParameter(":LOCATION_ID",OracleDbType.Varchar2),
|
|||
|
|
new OracleParameter(":STORAGE_ID",OracleDbType.Varchar2)};
|
|||
|
|
|
|||
|
|
parameters[0].Value = model.STORAGE_AREA_ID;
|
|||
|
|
parameters[1].Value = model.LOCATION_ID;
|
|||
|
|
parameters[2].Value = model.STORAGE_ID;
|
|||
|
|
SystemDataObject.Instance.ExecuteSqlCommit(strSql.ToString(), parameters);
|
|||
|
|
//}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 删除库区库位关联
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="ID"></param>
|
|||
|
|
public void DeleteLocArea(LocAreaModel model)
|
|||
|
|
{
|
|||
|
|
StringBuilder strSql = new StringBuilder();
|
|||
|
|
strSql.Append("delete from T_BASE_LOC_AREA ");
|
|||
|
|
strSql.AppendLine("where 1=1");
|
|||
|
|
if (!string.IsNullOrEmpty(model.STORAGE_AREA_ID))
|
|||
|
|
{
|
|||
|
|
strSql.AppendLine(" and STORAGE_AREA_ID = '" + model.STORAGE_AREA_ID + "' ");
|
|||
|
|
}
|
|||
|
|
if (!string.IsNullOrEmpty(model.LOCATION_ID))
|
|||
|
|
{
|
|||
|
|
strSql.AppendLine(" and LOCATION_ID = '" + model.LOCATION_ID + "' ");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString());
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|