public string GetNewClassCode()
{
using (PersistentManager persistentManager = new PersistentManager())
{
ProductClassDao dao = new ProductClassDao();
return(dao.GetNewClassCode());
}
}
public int GetRowCount(string filter)
{
using (PersistentManager persistentManager = new PersistentManager())
{
ProductClassDao dao = new ProductClassDao();
return(dao.GetRowCount(strTableView, filter));
}
}
public DataSet QueryProductClass(int pageIndex, int pageSize, string filter, string OrderByFields)
{
using (PersistentManager persistentManager = new PersistentManager())
{
ProductClassDao dao = new ProductClassDao();
return(dao.Query(strTableView, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableView));
}
}
public bool Delete(DataSet dataSet)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProductClassDao dao = new ProductClassDao();
dao.DeleteEntity(dataSet);
flag = true;
}
return(flag);
}
public bool Insert()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProductClassDao dao = new ProductClassDao();
string sql = string.Format("Insert into WMS_PRODUCTCLASS (CLASSCODE,CLASSNAME,MEMO) values('{0}','{1}','{2}')"
, this.CLASSCODE,
this.CLASSNAME,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public bool Update()
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
ProductClassDao dao = new ProductClassDao();
string sql = string.Format("update WMS_PRODUCTCLASS set CLASSCODE='{1}',CLASSNAME='{2}',MEMO='{3}' where ID='{0}'"
, this.ID,
this.CLASSCODE,
this.CLASSNAME,
this.MEMO);
dao.SetData(sql);
flag = true;
}
return(flag);
}
public ProductClassService()
{
dao = new ProductClassDao();
}