136 lines
4.8 KiB
C#
136 lines
4.8 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Data;
|
|
|
|
using WMS.DBUtility;
|
|
using WMS.IData.ICK;
|
|
using WMS.IData;using System.Data.SqlClient;
|
|
using WMS.Model.CK;
|
|
using WMS.Model.SC;
|
|
using WMS.IData.ISC;
|
|
|
|
namespace WMS.SqlServerData.SCData
|
|
{
|
|
/// <summary>
|
|
/// 数据访问类@PLANGOODS
|
|
/// </summary>
|
|
public class PlanGoodsData : IPlanGoods
|
|
{
|
|
#region BasicMethod
|
|
|
|
/// <summary>
|
|
/// 增加一条数据
|
|
/// </summary>
|
|
public void Add(PlanGoodsModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("insert into T_SC_PLANGOODS(");
|
|
strSql.Append("PLAN_ID,GOODS_ID,GOODS_NUM,GOODS_COMPLETENUM,COMPLETE_DATE,TEAM_ID)");
|
|
strSql.Append(" values (");
|
|
strSql.Append("@PLAN_ID,@GOODS_ID,@GOODS_NUM,@GOODS_COMPLETENUM,@COMPLETE_DATE,@TEAM_ID)");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@PLAN_ID", SqlDbType.VarChar),
|
|
new SqlParameter("@GOODS_ID", SqlDbType.VarChar),
|
|
new SqlParameter("@GOODS_NUM", SqlDbType.Decimal),
|
|
new SqlParameter("@GOODS_COMPLETENUM", SqlDbType.Decimal),
|
|
new SqlParameter("@COMPLETE_DATE", SqlDbType.Date),
|
|
new SqlParameter("@TEAM_ID", SqlDbType.VarChar)};
|
|
parameters[0].Value = model.PLAN_ID;
|
|
parameters[1].Value = model.GOODS_ID;
|
|
parameters[2].Value = model.GOODS_NUM;
|
|
parameters[3].Value = model.GOODS_COMPLETENUM;
|
|
parameters[4].Value = model.COMPLETE_DATE;
|
|
parameters[5].Value = model.TEAM_ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新一条数据
|
|
/// </summary>
|
|
public void Update(PlanGoodsModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("update T_SC_PLANGOODS set ");
|
|
strSql.Append("GOODS_NUM=@GOODS_NUM,");
|
|
strSql.Append("GOODS_COMPLETENUM=@GOODS_COMPLETENUM,");
|
|
strSql.Append("COMPLETE_DATE=@COMPLETE_DATE,");
|
|
strSql.Append("TEAM_ID=@TEAM_ID");
|
|
strSql.Append(" where PLAN_ID=@PLAN_ID and GOODS_ID=@GOODS_ID");
|
|
SqlParameter[] parameters = {
|
|
new SqlParameter("@GOODS_NUM", SqlDbType.Decimal),
|
|
new SqlParameter("@GOODS_COMPLETENUM", SqlDbType.Decimal),
|
|
new SqlParameter("@COMPLETE_DATE", SqlDbType.Date),
|
|
new SqlParameter("@TEAM_ID", SqlDbType.VarChar),
|
|
new SqlParameter("@PLAN_ID", SqlDbType.VarChar),
|
|
new SqlParameter("@GOODS_ID", SqlDbType.VarChar),};
|
|
|
|
parameters[0].Value = model.GOODS_NUM;
|
|
parameters[1].Value = model.GOODS_COMPLETENUM;
|
|
parameters[2].Value = model.COMPLETE_DATE;
|
|
parameters[3].Value = model.TEAM_ID;
|
|
parameters[4].Value = model.PLAN_ID;
|
|
parameters[5].Value = model.GOODS_ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除一条数据
|
|
/// </summary>
|
|
public void Delete(PlanGoodsModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("delete from T_SC_PLANGOODS ");
|
|
strSql.Append(" where 1=1 ");
|
|
if (!string.IsNullOrEmpty(model.PLAN_ID))
|
|
{
|
|
strSql.Append(" and PLAN_ID='" + model.PLAN_ID + "'");
|
|
}
|
|
if (!string.IsNullOrEmpty(model.GOODS_ID))
|
|
{
|
|
strSql.Append(" and GOODS_ID='" + model.GOODS_ID + "'");
|
|
}
|
|
SqlParameter[] parameters ={
|
|
};
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获得数据列表
|
|
/// </summary>
|
|
public DataTable GetList(PlanGoodsModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("select ");
|
|
strSql.Append("t.PLAN_ID,");
|
|
strSql.Append("p.PLAN_NAME,");
|
|
strSql.Append("t.GOODS_ID,");
|
|
strSql.Append("a.GOODS_NAME,");
|
|
strSql.Append("t.GOODS_NUM,");
|
|
strSql.Append("t.GOODS_COMPLETENUM,");
|
|
strSql.Append("t.COMPLETE_DATE,");
|
|
strSql.Append("t.TEAM_ID,");
|
|
strSql.Append("b.TEAM_NAME TEAM_NAME");
|
|
strSql.Append(" FROM T_SC_PLANGOODS t");
|
|
strSql.Append(" LEFT JOIN T_BASE_GOODS a ON a.GOODS_ID = t.GOODS_ID");
|
|
strSql.Append(" LEFT JOIN T_SYS_TEAM b ON b.TEAM_ID = t.TEAM_ID");
|
|
strSql.Append(" left join T_SC_PROCESS_PLAN p on t.plan_id =p.plan_id");
|
|
strSql.Append(" where 1=1 ");
|
|
if (!string.IsNullOrEmpty(model.PLAN_ID))
|
|
{
|
|
strSql.Append(" and t.PLAN_ID='" + model.PLAN_ID + "'");
|
|
}
|
|
if (!string.IsNullOrEmpty(model.GOODS_ID))
|
|
{
|
|
strSql.Append(" and t.GOODS_ID='" + model.GOODS_ID + "'");
|
|
}
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|
}
|
|
|
|
#endregion BasicMethod
|
|
}
|
|
}
|
|
|