public SKUATTModel(SKUATT att)
{
this.ID = att.ID;
this.Code = att.Code;
this.Name = att.Name;
this.ATTType = att.ATTType;
this.SKUCID = att.SKUID;
}
/// <summary>
/// 添加属性
/// </summary>
/// <param name="cgy"></param>
/// <returns></returns>
public int AddATT(SKUATT att)
{
int result = -1;
string sql = @"INSERT INTO SKUATT
(ID, CODE, NAME, ATTTYPE, SKUCID)
VALUES(@ID, @CODE, @NAME, @ATTTYPE, @SKUCID)";
using (DbCommand cmd = _database.GetSqlStringCommand(sql))
{
_database.AddInParameter(cmd, "@ID", DbType.Guid, att.ID);
_database.AddInParameter(cmd, "@CODE", DbType.String, att.Code);
_database.AddInParameter(cmd, "@NAME", DbType.String, att.Name);
_database.AddInParameter(cmd, "@ATTTYPE", DbType.Int16, att.ATTType);
_database.AddInParameter(cmd, "@SKUCID", DbType.Guid, att.SKUID);
result = _database.ExecuteNonQuery(cmd);
}
return result;
}
public bool AddATT(SKUATT att)
{
bool result = false;
try
{
int count = _dal.AddATT(att);
if (count > 0)
{
result = true;
}
}
catch (Exception e)
{
string excepMsg = string.Format(@"{0},{1}", DateTime.Now.ToString(), e.Message);
Trace.TraceError(excepMsg);
throw new Exception("添加属性出错:BLLAttManagement.AddATT(SKUATT att)", e);
}
return result;
}
/// <summary>
/// 更新属性名称
/// </summary>
/// <param name="att"></param>
/// <returns></returns>
public int UpdateATT(SKUATT att)
{
int result = -1;
string sql = @"UPDATE SKUATT
SET NAME = @NAME
WHERE ID = @ID";
using (DbCommand cmd = _database.GetSqlStringCommand(sql))
{
_database.AddInParameter(cmd, "@NAME", DbType.String, att.Name);
_database.AddInParameter(cmd, "@ID", DbType.Guid, att.ID);
result = _database.ExecuteNonQuery(cmd);
}
return result;
}
private List<SKUATT> GenerateSKUATTList(DataTable dt)
{
List<SKUATT> result = null;
if (dt != null && dt.Rows.Count > 0)
{
result = new List<SKUATT>();
SKUATT att = null;
foreach (DataRow dr in dt.Rows)
{
att = new SKUATT()
{
Code = dr[0].ToString(),
Name = dr[1].ToString(),
ATTType = this.SelectedAttType.ID,
SKUID = this.SelectedSKUCGY.ID,
};
result.Add(att);
}
}
return result;
}
/// <summary>
/// 根据SKUCID获取所有属性
/// </summary>
/// <param name="SKUCID"></param>
/// <returns></returns>
public List<SKUATT> GetSKUATTByCondition(Guid SKUCID)
{
List<SKUATT> result = null;
try
{
DataTable dt = _dal.GetSKUATTByCondition(SKUCID);
if (dt != null && dt.Rows.Count > 0)
{
result = new List<SKUATT>();
SKUATT attType;
foreach (DataRow dr in dt.Rows)
{
Guid ID = dr.GetFieldValue<Guid>("ID");
string code = dr.GetFieldValue<string>("CODE");
string name = dr.GetFieldValue<string>("NAME");
short attTypeID = dr.GetFieldValue<short>("ATTTYPE");
Guid skucid = dr.GetFieldValue<Guid>("SKUCID");
attType = new SKUATT(ID)
{
Code = code,
Name = name,
ATTType = attTypeID,
SKUID = skucid,
};
result.Add(attType);
}
}
}
catch (Exception e)
{
string excepMsg = string.Format(@"{0},{1}", DateTime.Now.ToString(), e.Message);
Trace.TraceError(excepMsg);
throw new Exception("获取属性列表出错:BLLAttManagement.GetSKUATTBySKUID(Guid SKUCID)", e);
}
return result;
}