/// <summary>
/// 根据ID获取适用产品类型
/// </summary>
/// <param name="SuitProductId">适用产品类型Id</param>
/// <returns>适用产品类型实体</returns>
public virtual EyouSoft.Model.PoolStructure.SuitProductInfo GetSuitProduct(int SuitProductId)
{
EyouSoft.Model.PoolStructure.SuitProductInfo model = new EyouSoft.Model.PoolStructure.SuitProductInfo();
if (SuitProductId <= 0)
{
return(model);
}
string strSql = Sql_SuitProduct_Select + " where ID = @ID ;";
DbCommand dc = this._db.GetSqlStringCommand(strSql);
this._db.AddInParameter(dc, "ID", DbType.Int32, SuitProductId);
using (IDataReader dr = EyouSoft.Common.DAL.DbHelper.ExecuteReader(dc, this._db))
{
if (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("ID")))
{
model.ProuctId = int.Parse(dr["ID"].ToString());
}
model.ProductName = dr["ProductName"].ToString();
}
}
return(model);
}
/// <summary>
/// 修改适用产品类型
/// </summary>
/// <param name="model">适用产品类型实体</param>
/// <returns>1：成功；0：失败</returns>
public int UpdateSuitProduct(EyouSoft.Model.PoolStructure.SuitProductInfo model)
{
if (model == null || model.ProuctId <= 0)
{
return(0);
}
return(dal.UpdateSuitProduct(model));
}
/// <summary>
/// 新增适用产品类型
/// </summary>
/// <param name="model">适用产品类型实体</param>
/// <returns>1：成功；0：失败</returns>
public int AddSuitProduct(EyouSoft.Model.PoolStructure.SuitProductInfo model)
{
if (model == null)
{
return(0);
}
return(dal.AddSuitProduct(model));
}
/// <summary>
/// 新增适用产品类型
/// </summary>
/// <param name="model">适用产品类型实体</param>
/// <returns>1：成功；0：失败</returns>
public virtual int AddSuitProduct(EyouSoft.Model.PoolStructure.SuitProductInfo model)
{
if (model == null)
{
return(0);
}
DbCommand dc = this._db.GetSqlStringCommand(Sql_SuitProduct_Insert);
this._db.AddInParameter(dc, "ProductName", DbType.String, model.ProductName);
return(EyouSoft.Common.DAL.DbHelper.ExecuteSql(dc, this._db) > 0 ? 1 : 0);
}
private void Add(string SuitName)
{
//新增
string strErr = "";
if (SuitName == "")
{
strErr += "客户类型名称不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
EyouSoft.Model.PoolStructure.SuitProductInfo ModelSuit = new EyouSoft.Model.PoolStructure.SuitProductInfo();
ModelSuit.ProductName = SuitName;
EyouSoft.BLL.PoolStructure.SuitProduct.CreateInstance().AddSuitProduct(ModelSuit);
return;
}
private void Eidt(string EidtID, string SuitName)
{
string strErr = "";
if (SuitName == "")
{
strErr += "客户类型名称不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
EyouSoft.Model.PoolStructure.SuitProductInfo ModelSuit = new EyouSoft.Model.PoolStructure.SuitProductInfo();
ModelSuit.ProductName = SuitName;
ModelSuit.ProuctId = EyouSoft.Common.Utils.GetInt(EidtID);
EyouSoft.BLL.PoolStructure.SuitProduct.CreateInstance().UpdateSuitProduct(ModelSuit);
return;
}
/// <summary>
/// 获取适用产品类型
/// </summary>
/// <returns>适用产品类型实体集合</returns>
public virtual IList <EyouSoft.Model.PoolStructure.SuitProductInfo> GetSuitProductList()
{
IList <EyouSoft.Model.PoolStructure.SuitProductInfo> list = new List <EyouSoft.Model.PoolStructure.SuitProductInfo>();
DbCommand dc = this._db.GetSqlStringCommand(Sql_SuitProduct_Select);
using (IDataReader dr = EyouSoft.Common.DAL.DbHelper.ExecuteReader(dc, this._db))
{
EyouSoft.Model.PoolStructure.SuitProductInfo model = null;
while (dr.Read())
{
model = new EyouSoft.Model.PoolStructure.SuitProductInfo();
if (!dr.IsDBNull(dr.GetOrdinal("ID")))
{
model.ProuctId = int.Parse(dr["ID"].ToString());
}
model.ProductName = dr["ProductName"].ToString();
list.Add(model);
}
}
return(list);
}
