394 lines
12 KiB
C#
394 lines
12 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Data;
|
|
using WMS.IData;
|
|
|
|
namespace WMS.Business.Common
|
|
{
|
|
public class BussCommon : IBussFactory
|
|
{
|
|
public DataTable GetTable(string sql)
|
|
{
|
|
DataTable ds = null;
|
|
ds = DataProvider.Instance.Common.GetTable(sql);
|
|
return ds;
|
|
}
|
|
/// <summary>
|
|
/// 通过指定的字段属性查询数据
|
|
/// </summary>
|
|
/// <param name="tableName"></param>
|
|
/// <param name="clmValue"></param>
|
|
/// <param name="clmName"></param>
|
|
/// <returns></returns>
|
|
public DataTable GetCustomCtrlData(string tableName, string clmValue, string clmName, string clmWhere, string clmClassName)
|
|
{
|
|
DataTable ds = null;
|
|
ds = DataProvider.Instance.Common.GetCustomCtrlData(tableName, clmValue, clmName, clmWhere, clmClassName);
|
|
return ds;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 返回通用查询的数据
|
|
/// </summary>
|
|
/// <typeparam name="T">表名</typeparam>
|
|
/// <param name="column">查询的列</param>
|
|
/// <param name="clmValue">查询条件</param>
|
|
/// <param name="tableName">表名</param>
|
|
/// <returns></returns>
|
|
public DataTable GetListData(List<string> column, Dictionary<string, string> clmValue, string tableName)
|
|
{
|
|
DataTable listData = DataProvider.Instance.Common.GetListData(column, clmValue, tableName);
|
|
return listData;
|
|
}
|
|
/// <summary>
|
|
/// 获取商品信息
|
|
/// </summary>
|
|
/// <param name="strGooID">商品分类编号</param>
|
|
/// <param name="user_id">用户编号</param>
|
|
/// <returns></returns>
|
|
public DataSet Get_GoodsInfo(string strGooID, string user_id)
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.Get_GoodsInfo(strGooID, user_id);
|
|
return ds;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取商品分类
|
|
/// </summary>
|
|
/// <param name="status">1使用 0停用</param>
|
|
/// <param name="user_id">用户编号</param>
|
|
/// <returns></returns>
|
|
public DataSet GetGoods_Category(string status, string user_id)
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetGoods_Category(status, user_id);
|
|
|
|
return ds;
|
|
}
|
|
/// <summary>
|
|
/// 获取采购类型
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetPurchaseType()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetPurchaseType();
|
|
|
|
return ds;
|
|
}
|
|
/// <summary>
|
|
/// 获取来源类型
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetSourceType()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetSourceType();
|
|
|
|
return ds;
|
|
}
|
|
/// <summary>
|
|
/// 获取活动类型
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetActTypte()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetActTypte();
|
|
|
|
return ds;
|
|
}
|
|
/// <summary>
|
|
/// 获取仓库信息
|
|
/// </summary>
|
|
/// <param name="user_id">用户编号</param>
|
|
/// <returns></returns>
|
|
public DataSet GetStorage(string user_id)
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetStorage(user_id);
|
|
|
|
return ds;
|
|
}
|
|
/// <summary>
|
|
/// 获取库区信息
|
|
/// </summary>
|
|
/// <param name="user_id">用户编号</param>
|
|
/// <returns></returns>
|
|
public DataSet GetArea(string id, string user_id)
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetArea(id, user_id);
|
|
return ds;
|
|
}
|
|
/// <summary>
|
|
/// 根据仓库编号获取库位信息
|
|
/// </summary>
|
|
/// <param name="StorageID"></param>
|
|
/// <returns></returns>
|
|
public DataSet GetLocation(string StorageID)
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetLocation(StorageID);
|
|
return ds;
|
|
}
|
|
/// <summary>
|
|
/// 获取物流公司信息
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetLogisticsCom()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetLogisticsComInfo();
|
|
return ds;
|
|
}
|
|
public DataSet GetUnloadMan()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetUnloadMan();
|
|
return ds;
|
|
}
|
|
/// <summary>
|
|
/// 供应商信息
|
|
/// </summary>
|
|
/// <param name="user_id">用户编号</param>
|
|
/// <returns></returns>
|
|
public DataSet GetProviderType(string user_id)
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetProviderType(user_id);
|
|
|
|
return ds;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 付款方式类型
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetPayType()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetPayType();
|
|
|
|
return ds;
|
|
}
|
|
|
|
///// <summary>
|
|
///// 获取库存管理类型
|
|
///// </summary>
|
|
///// <param name="WMStype"></param>
|
|
///// <returns></returns>
|
|
//public DataSet GetWMSType(WMSType WMStype)
|
|
//{
|
|
// DataSet dt = null;
|
|
// dt = DataProvider.Instance.Common.GetWMSType(WMStype);
|
|
// return dt;
|
|
//}
|
|
|
|
/// <summary>
|
|
/// 物流公司信息
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetLogisticsComInfo()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetLogisticsComInfo();
|
|
|
|
return ds;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取结果集
|
|
/// </summary>
|
|
/// <param name="col">列名</param>
|
|
/// <param name="table">表名</param>
|
|
/// <param name="where">查询条件</param>
|
|
/// <returns></returns>
|
|
public DataSet GetDataSet(string col, string table, string where)
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetDataSet(col, table, where);
|
|
|
|
return ds;
|
|
}
|
|
|
|
/************************************ Start 杨斌 增加 2012-11-20 ********************************/
|
|
/// <summary>
|
|
/// 获取公司类型
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetCompanyType()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetCompanyType();
|
|
return ds;
|
|
}
|
|
/************************************ End 杨斌 增加 2012-11-20 **********************************/
|
|
|
|
/// <summary>
|
|
/// 获取公司分类
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetCompanyCategory()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetCompanyCategory();
|
|
return ds;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取公司编号和公司名称
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetCompanyIDName()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetCompanyIDName();
|
|
return ds;
|
|
}
|
|
|
|
#region 获取部门编号和部门名称
|
|
/// <summary>
|
|
/// 获取部门编号和部门名称
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetDepartmentIDName()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetDepartmentIDName();
|
|
return ds;
|
|
}
|
|
#endregion
|
|
|
|
/// <summary>
|
|
/// 获取公司部门
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataTable GetComDetDataTable()
|
|
{
|
|
return DataProvider.Instance.Common.GetComDetDataTable();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取员工信息
|
|
/// </summary>
|
|
/// <param name="ComId">公司编号</param>
|
|
/// <param name="DetId">部门编号</param>
|
|
/// <param name="UserName">员工名称</param>
|
|
/// <returns></returns>
|
|
public DataTable GetUserDataTable(string ComId, string DetId, string UserName)
|
|
{
|
|
return DataProvider.Instance.Common.GetUserDataTable(ComId, DetId, UserName);
|
|
}
|
|
|
|
#region 获取集团编号和集团名称
|
|
/// <summary>
|
|
/// 获取集团编号和集团名称
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetGroupIDName()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetGroupIDName();
|
|
return ds;
|
|
}
|
|
#endregion
|
|
|
|
#region 获取供应商类型
|
|
/// <summary>
|
|
/// 获取供应商类型
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetProviderType()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetProviderType();
|
|
return ds;
|
|
}
|
|
#endregion
|
|
|
|
#region 获取省份
|
|
/// <summary>
|
|
/// 获取省份
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetProvince()
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetProvince();
|
|
return ds;
|
|
}
|
|
#endregion
|
|
|
|
#region 根据省份编号获取城市
|
|
/// <summary>
|
|
/// 根据省份编号获取城市
|
|
/// </summary>
|
|
/// <param name="strProId">省份编号</param>
|
|
/// <returns></returns>
|
|
public DataSet GetCityByProId(string strProId)
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetCityByPRO_ID(strProId);
|
|
return ds;
|
|
}
|
|
#endregion
|
|
|
|
#region 根据城市编号获取区
|
|
/// <summary>
|
|
/// 根据城市编号获取区
|
|
/// </summary>
|
|
/// <param name="CityId">城市编号</param>
|
|
/// <returns></returns>
|
|
public DataSet GetTownByCityId(string strCityId)
|
|
{
|
|
DataSet ds = null;
|
|
ds = DataProvider.Instance.Common.GetTownByCityId(strCityId);
|
|
return ds;
|
|
}
|
|
#endregion
|
|
|
|
/// <summary>
|
|
/// 获取字典类型对照信息
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public DataSet GetDictionaryType()
|
|
{
|
|
DataSet ds = DataProvider.Instance.Common.GetDictionaryType();
|
|
return ds;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据类型代码查询出类型字典信息
|
|
/// </summary>
|
|
/// <param name="strTypeId">类型代码</param>
|
|
/// <returns></returns>
|
|
public DataSet GetTypeInfo(int strTypeId)
|
|
{
|
|
DataSet ds = DataProvider.Instance.Common.GetTypeInfo(strTypeId);
|
|
if (DataLogErrWrite(ds.Tables[0], ""))
|
|
{
|
|
return null;
|
|
}
|
|
return ds;
|
|
}
|
|
|
|
//#region 获取托盘下拉列表
|
|
///// <summary>
|
|
///// 获取托盘下拉列表
|
|
///// </summary>
|
|
///// <returns></returns>
|
|
//public DataSet GetPalletType()
|
|
//{
|
|
// DataSet ds = null;
|
|
// ds = DataProvider.Instance.Common.GetPalletType();
|
|
// return ds;
|
|
//}
|
|
//#endregion
|
|
|
|
}
|
|
}
|