254 lines
12 KiB
C#
254 lines
12 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Text;
|
|
using WMS.IData.IBase;
|
|
using WMS.IData;using Oracle.ManagedDataAccess.Client;
|
|
using WMS.Model.Base;
|
|
|
|
using WMS.DBUtility;
|
|
namespace WMS.SqlServerData.BaseData
|
|
{
|
|
/// <summary>
|
|
/// 数据访问类:T_BASE_CAPACITY
|
|
/// </summary>
|
|
public class CapacityData: ICapacity
|
|
{
|
|
#region BasicMethod
|
|
|
|
|
|
|
|
/// <summary>
|
|
/// 增加一条数据
|
|
/// </summary>
|
|
public void Add(WMS.Model.Base.CapacityModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("insert into T_BASE_CAPACITY(");
|
|
strSql.Append("CAR_ID,ID,CAR_DEPARTMENT,CAR_DRIVER,CAR_TYPE,SHORT_ID,CAR_CARRIER,CAR_PRIVATEID,CAR_MURR,CAR_PRODATE,CAR_MODEL,CAR_FRAME,CAR_REGDATE,CAR_FILEDATE,CAR_BUYDATE,CAR_INSUREDMONEY,CAR_INSUREDSRADATE,CAR_INSUREDEDDDATE,STATUS,CREATE_TYPE,CAR_CHASSIS,CAR_ENGINE,CAR_OILWEAR,CAR_DISPART,CAR_STATUS,REMARK)");
|
|
strSql.Append(" values (");
|
|
strSql.Append(":CAR_ID,:ID,:CAR_DEPARTMENT,:CAR_DRIVER,:CAR_TYPE,:SHORT_ID,:CAR_CARRIER,:CAR_PRIVATEID,:CAR_MURR,:CAR_PRODATE,:CAR_MODEL,:CAR_FRAME,:CAR_REGDATE,:CAR_FILEDATE,:CAR_BUYDATE,:CAR_INSUREDMONEY,:CAR_INSUREDSRADATE,:CAR_INSUREDEDDDATE,:STATUS,:CREATE_TYPE,:CAR_CHASSIS,:CAR_ENGINE,:CAR_OILWEAR,:CAR_DISPART,:CAR_STATUS,:REMARK)");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":CAR_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_DEPARTMENT",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_DRIVER",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_TYPE",OracleDbType.Varchar2),
|
|
new OracleParameter(":SHORT_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_CARRIER",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_PRIVATEID",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_MURR",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_PRODATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_MODEL",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_FRAME",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_REGDATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_FILEDATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_BUYDATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_INSUREDMONEY", OracleDbType.Decimal),
|
|
new OracleParameter(":CAR_INSUREDSRADATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_INSUREDEDDDATE", OracleDbType.Date),
|
|
new OracleParameter(":STATUS",OracleDbType.Varchar2),
|
|
new OracleParameter(":CREATE_TYPE",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_CHASSIS",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_ENGINE",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_OILWEAR",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_DISPART",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_STATUS",OracleDbType.Varchar2),
|
|
new OracleParameter(":REMARK",OracleDbType.Varchar2)
|
|
};
|
|
parameters[0].Value = model.CAR_ID;
|
|
parameters[1].Value = model.ID;
|
|
parameters[2].Value = model.CAR_DEPARTMENT;
|
|
parameters[3].Value = model.CAR_DRIVER;
|
|
parameters[4].Value = model.CAR_TYPE;
|
|
parameters[5].Value = model.SHORT_ID;
|
|
parameters[6].Value = model.CAR_CARRIER;
|
|
parameters[7].Value = model.CAR_PRIVATEID;
|
|
parameters[8].Value = model.CAR_MURR;
|
|
parameters[9].Value = model.CAR_PRODATE;
|
|
parameters[10].Value = model.CAR_MODEL;
|
|
parameters[11].Value = model.CAR_FRAME;
|
|
parameters[12].Value = model.CAR_REGDATE;
|
|
parameters[13].Value = model.CAR_FILEDATE;
|
|
parameters[14].Value = model.CAR_BUYDATE;
|
|
parameters[15].Value = model.CAR_INSUREDMONEY;
|
|
parameters[16].Value = model.CAR_INSUREDSRADATE;
|
|
parameters[17].Value = model.CAR_INSUREDEDDDATE;
|
|
parameters[18].Value = model.STATUS;
|
|
parameters[19].Value = model.CREATE_TYPE;
|
|
parameters[20].Value = model.CAR_CHASSIS;
|
|
parameters[21].Value = model.CAR_ENGINE;
|
|
parameters[22].Value = model.CAR_OILWEAR;
|
|
parameters[23].Value = model.CAR_DISPART;
|
|
parameters[24].Value = model.CAR_STATUS;
|
|
parameters[25].Value = model.REMARK;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
/// <summary>
|
|
/// 更新一条数据
|
|
/// </summary>
|
|
public void Update(WMS.Model.Base.CapacityModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("update T_BASE_CAPACITY set ");
|
|
strSql.Append("CAR_ID=:CAR_ID,");
|
|
strSql.Append("CAR_DEPARTMENT=:CAR_DEPARTMENT,");
|
|
strSql.Append("CAR_DRIVER=:CAR_DRIVER,");
|
|
strSql.Append("CAR_TYPE=:CAR_TYPE,");
|
|
strSql.Append("SHORT_ID=:SHORT_ID,");
|
|
strSql.Append("CAR_CARRIER=:CAR_CARRIER,");
|
|
strSql.Append("CAR_PRIVATEID=:CAR_PRIVATEID,");
|
|
strSql.Append("CAR_MURR=:CAR_MURR,");
|
|
strSql.Append("CAR_PRODATE=:CAR_PRODATE,");
|
|
strSql.Append("CAR_MODEL=:CAR_MODEL,");
|
|
strSql.Append("CAR_FRAME=:CAR_FRAME,");
|
|
strSql.Append("CAR_REGDATE=:CAR_REGDATE,");
|
|
strSql.Append("CAR_FILEDATE=:CAR_FILEDATE,");
|
|
strSql.Append("CAR_BUYDATE=:CAR_BUYDATE,");
|
|
strSql.Append("CAR_INSUREDMONEY=:CAR_INSUREDMONEY,");
|
|
strSql.Append("CAR_INSUREDSRADATE=:CAR_INSUREDSRADATE,");
|
|
strSql.Append("CAR_INSUREDEDDDATE=:CAR_INSUREDEDDDATE,");
|
|
strSql.Append("STATUS=:STATUS,");
|
|
strSql.Append("CREATE_TYPE=:CREATE_TYPE,");
|
|
strSql.Append("CAR_CHASSIS=:CAR_CHASSIS,");
|
|
strSql.Append("CAR_ENGINE=:CAR_ENGINE,");
|
|
strSql.Append("CAR_OILWEAR=:CAR_OILWEAR,");
|
|
strSql.Append("CAR_DISPART=:CAR_DISPART,");
|
|
strSql.Append("CAR_STATUS=:CAR_STATUS,");
|
|
strSql.Append("REMARK=:REMARK");
|
|
strSql.Append(" where ID=:ID");
|
|
OracleParameter[] parameters = {
|
|
new OracleParameter(":CAR_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_DEPARTMENT",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_DRIVER",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_TYPE",OracleDbType.Varchar2),
|
|
new OracleParameter(":SHORT_ID",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_CARRIER",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_PRIVATEID",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_MURR",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_PRODATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_MODEL",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_FRAME",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_REGDATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_FILEDATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_BUYDATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_INSUREDMONEY", OracleDbType.Decimal),
|
|
new OracleParameter(":CAR_INSUREDSRADATE", OracleDbType.Date),
|
|
new OracleParameter(":CAR_INSUREDEDDDATE", OracleDbType.Date),
|
|
new OracleParameter(":STATUS",OracleDbType.Varchar2),
|
|
new OracleParameter(":CREATE_TYPE",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_CHASSIS",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_ENGINE",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_OILWEAR",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_DISPART",OracleDbType.Varchar2),
|
|
new OracleParameter(":CAR_STATUS",OracleDbType.Varchar2),
|
|
new OracleParameter(":REMARK",OracleDbType.Varchar2),
|
|
new OracleParameter(":ID",OracleDbType.Varchar2)
|
|
};
|
|
parameters[0].Value = model.CAR_ID;
|
|
parameters[1].Value = model.CAR_DEPARTMENT;
|
|
parameters[2].Value = model.CAR_DRIVER;
|
|
parameters[3].Value = model.CAR_TYPE;
|
|
parameters[4].Value = model.SHORT_ID;
|
|
parameters[5].Value = model.CAR_CARRIER;
|
|
parameters[6].Value = model.CAR_PRIVATEID;
|
|
parameters[7].Value = model.CAR_MURR;
|
|
parameters[8].Value = model.CAR_PRODATE;
|
|
parameters[9].Value = model.CAR_MODEL;
|
|
parameters[10].Value = model.CAR_FRAME;
|
|
parameters[11].Value = model.CAR_REGDATE;
|
|
parameters[12].Value = model.CAR_FILEDATE;
|
|
parameters[13].Value = model.CAR_BUYDATE;
|
|
parameters[14].Value = model.CAR_INSUREDMONEY;
|
|
parameters[15].Value = model.CAR_INSUREDSRADATE;
|
|
parameters[16].Value = model.CAR_INSUREDEDDDATE;
|
|
parameters[17].Value = model.STATUS;
|
|
parameters[18].Value = model.CREATE_TYPE;
|
|
parameters[19].Value = model.CAR_CHASSIS;
|
|
parameters[20].Value = model.CAR_ENGINE;
|
|
parameters[21].Value = model.CAR_OILWEAR;
|
|
parameters[22].Value = model.CAR_DISPART;
|
|
parameters[23].Value = model.CAR_STATUS;
|
|
parameters[24].Value = model.REMARK;
|
|
parameters[25].Value = model.ID;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameters);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除一条数据
|
|
/// </summary>
|
|
public void Delete(string id)
|
|
{
|
|
//该表无主键信息，请自定义主键/条件字段
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("delete from T_BASE_CAPACITY ");
|
|
strSql.Append(" where ID=:ID");
|
|
OracleParameter[] parameter = new OracleParameter[]{
|
|
new OracleParameter(":ID",OracleDbType.Varchar2),
|
|
};
|
|
parameter[0].Value = id;
|
|
|
|
SystemDataObject.Instance.ExecuteSql(strSql.ToString(), parameter);
|
|
}
|
|
|
|
|
|
|
|
/// <summary>
|
|
/// 获得数据列表
|
|
/// </summary>
|
|
public DataTable GetList(WMS.Model.Base.CapacityModel model)
|
|
{
|
|
StringBuilder strSql=new StringBuilder();
|
|
strSql.Append("select ");
|
|
strSql.Append("CAR_ID,");
|
|
strSql.Append("ID,");
|
|
strSql.Append("CAR_DEPARTMENT,");
|
|
strSql.Append("CAR_DRIVER,");
|
|
strSql.Append("CAR_TYPE,");
|
|
strSql.Append("SHORT_ID,");
|
|
strSql.Append("CAR_CARRIER,");
|
|
strSql.Append("CAR_PRIVATEID,");
|
|
strSql.Append("CAR_MURR,");
|
|
strSql.Append("CAR_PRODATE,");
|
|
strSql.Append("CAR_MODEL,");
|
|
strSql.Append("CAR_FRAME,");
|
|
strSql.Append("CAR_REGDATE,");
|
|
strSql.Append("CAR_FILEDATE,");
|
|
strSql.Append("CAR_BUYDATE,");
|
|
strSql.Append("CAR_INSUREDMONEY,");
|
|
strSql.Append("CAR_INSUREDSRADATE,");
|
|
strSql.Append("CAR_INSUREDEDDDATE,");
|
|
strSql.Append("STATUS,");
|
|
strSql.Append("CREATE_TYPE,");
|
|
strSql.Append("CAR_CHASSIS,");
|
|
strSql.Append("CAR_ENGINE,");
|
|
strSql.Append("CAR_OILWEAR,");
|
|
strSql.Append("CAR_DISPART,");
|
|
strSql.Append("CAR_STATUS,");
|
|
strSql.Append("REMARK");
|
|
strSql.Append(" FROM T_BASE_CAPACITY WHERE 1=1");
|
|
if (!string.IsNullOrEmpty(model.CAR_ID))
|
|
{
|
|
strSql.Append(" AND CAR_ID LIKE '%" + model.CAR_ID + "%'");
|
|
}
|
|
if (!string.IsNullOrEmpty(model.CAR_TYPE))
|
|
{
|
|
strSql.Append(" AND CAR_TYPE = '" + model.CAR_TYPE + "'");
|
|
}
|
|
if (!string.IsNullOrEmpty(model.CAR_DEPARTMENT))
|
|
{
|
|
strSql.Append(" AND CAR_DEPARTMENT LIKE '%" + model.CAR_DEPARTMENT + "%'");
|
|
}
|
|
if (!string.IsNullOrEmpty(model.CAR_CARRIER))
|
|
{
|
|
strSql.Append(" AND CAR_CARRIER LIKE '%" + model.CAR_CARRIER + "%'");
|
|
}
|
|
|
|
return SystemDataObject.Instance.GetDataTable(strSql.ToString());
|
|
}
|
|
#endregion
|
|
}
|
|
}
|
|
|