122 lines
5.6 KiB
C#
122 lines
5.6 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Linq;
|
||
using System.Text;
|
||
using System.Data;
|
||
using WMS.IData;using Oracle.ManagedDataAccess.Client;
|
||
using WMS.Model.Base;
|
||
|
||
using WMS.IData.IBase;
|
||
|
||
namespace WMS.SqlServerData.BaseData
|
||
{
|
||
class BaseRemarkDictionaryData : IBaseRemarkDictionary
|
||
{
|
||
/// <summary>
|
||
/// 获取备注信息集
|
||
/// </summary>
|
||
/// <param name="model">用于条件查询</param>
|
||
/// <returns>备注信息集</returns>
|
||
public DataTable GetRemarkDictionaryTable(BaseRemarkDictionaryModel model)
|
||
{
|
||
StringBuilder strSql = new StringBuilder();
|
||
|
||
strSql.AppendLine("select ");
|
||
strSql.AppendLine(" a.ID, ");
|
||
strSql.AppendLine(" a.CONTENT, ");
|
||
strSql.AppendLine(" a.COLOR_ID, ");
|
||
strSql.AppendLine(" a.operatorid, ");
|
||
strSql.AppendLine(" a.operatedate, ");
|
||
strSql.AppendLine(" a.remark_type, ");
|
||
strSql.AppendLine(" b.vc_dictionary_name ");
|
||
strSql.AppendLine("FROM T_BASE_REMARK_DICTIONARY a left join t_sys_dictionary_tab b ");
|
||
strSql.AppendLine(" on a.remark_type = b.vc_char_value and b.vc_dictionary_type = 'REMARK_TYPE' ");
|
||
strSql.AppendLine(" where 1=1 ");
|
||
if (!string.IsNullOrEmpty(model.REMARK_TYPE))
|
||
{
|
||
strSql.AppendLine(" and a.remark_type = '" + model.REMARK_TYPE + "' ");
|
||
}
|
||
if (!string.IsNullOrEmpty(model.CONTENT))
|
||
{
|
||
strSql.AppendLine(" and a.CONTENT = '" + model.CONTENT + "' ");
|
||
}
|
||
strSql.AppendLine("ORDER BY a.remark_type ");
|
||
|
||
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
||
}
|
||
|
||
/// <summary>
|
||
/// 新增或修改备注信息
|
||
/// </summary>
|
||
/// <param name="model">要被新增或修改的备注信息</param>
|
||
/// <param name="flag">flag 操作标示符 0：新增 1:修改</param>
|
||
public void InsOrUpdRemarkDictionary(BaseRemarkDictionaryModel model, int flag)
|
||
{
|
||
//新增
|
||
if (0 == flag)
|
||
{
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.AppendLine("insert into T_BASE_REMARK_DICTIONARY(");
|
||
strSql.AppendLine("CONTENT,COLOR_ID,operatorid,operatedate,remark_type)");
|
||
strSql.AppendLine(" values (");
|
||
strSql.AppendLine(":CONTENT,:COLOR_ID,:operatorid,getdate(),:remark_type)");
|
||
OracleParameter[] parameters = {
|
||
new OracleParameter(":CONTENT",OracleDbType.Varchar2),
|
||
new OracleParameter(":COLOR_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":operatorid",OracleDbType.Varchar2),
|
||
new OracleParameter(":remark_type",OracleDbType.Char)};
|
||
parameters[0].Value = model.CONTENT;
|
||
parameters[1].Value = model.COLOR_ID;
|
||
parameters[2].Value = model.OPERATORID;
|
||
parameters[3].Value = model.REMARK_TYPE;
|
||
|
||
SystemDataObject.Instance.ExecuteSqlCommit(strSql.ToString(), parameters);
|
||
}
|
||
//修改
|
||
else if (1 == flag)
|
||
{
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.AppendLine("update T_BASE_REMARK_DICTIONARY set ");
|
||
strSql.AppendLine("CONTENT=:CONTENT,");
|
||
strSql.AppendLine("COLOR_ID=:COLOR_ID,");
|
||
strSql.AppendLine("operatorid=:operatorid,");
|
||
strSql.AppendLine("operatedate=getdate(),");
|
||
strSql.AppendLine("remark_type=:remark_type");
|
||
strSql.AppendLine(" where ID=:ID ");
|
||
OracleParameter[] parameters = {
|
||
new OracleParameter(":CONTENT",OracleDbType.Varchar2),
|
||
new OracleParameter(":COLOR_ID",OracleDbType.Varchar2),
|
||
new OracleParameter(":operatorid",OracleDbType.Varchar2),
|
||
new OracleParameter(":remark_type",OracleDbType.Char),
|
||
new OracleParameter(":ID",OracleDbType.Varchar2)};
|
||
|
||
parameters[0].Value = model.CONTENT;
|
||
parameters[1].Value = model.COLOR_ID;
|
||
parameters[2].Value = model.OPERATORID;
|
||
parameters[3].Value = model.REMARK_TYPE;
|
||
parameters[4].Value = model.ID;
|
||
|
||
SystemDataObject.Instance.ExecuteSqlCommit(strSql.ToString(), parameters);
|
||
}
|
||
}
|
||
|
||
/// <summary>
|
||
/// 删除备注信息
|
||
/// </summary>
|
||
/// <param name="ID">备注ID</param>
|
||
public void DeleteRemarkDictionary(string ID)
|
||
{
|
||
|
||
StringBuilder strSql = new StringBuilder();
|
||
strSql.AppendLine("delete from T_BASE_REMARK_DICTIONARY ");
|
||
strSql.AppendLine(" where ID=:ID ");
|
||
OracleParameter[] parameters = {
|
||
new OracleParameter("ID",OracleDbType.Varchar2)
|
||
};
|
||
parameters[0].Value = ID;
|
||
|
||
SystemDataObject.Instance.ExecuteSqlCommit(strSql.ToString(), parameters);
|
||
}
|
||
}
|
||
}
|