/// <summary>
/// 修改
/// </summary>
/// <param name="model">PromoShareConditionType對象</param>
/// <returns>更新結果</returns>
public int Update(PromoShareConditionType model)
{
try
{
return _psctDao.Update(model);
}
catch (Exception ex)
{
throw new Exception("PromoShareConditionTypeMgr-->Update-->" + ex.Message, ex);
}
}
/// <summary>
/// 通過id獲取PromoShareConditionType對象
/// </summary>
/// <param name="condtion_type_id">編號</param>
/// <returns>PromoShareConditionType對象</returns>
public PromoShareConditionType Get(int condtion_type_id)
{
PromoShareConditionType model = new PromoShareConditionType();
string sql = "SELECT condition_type_id,condition_type_desc,condition_type_name,condition_type_status FROM promo_share_condition_type WHERE condition_type_id=" + condtion_type_id;
try
{
model = _access.getSinggleObj<PromoShareConditionType>(sql);
}
catch (Exception ex)
{
throw new Exception("PromoShareConditionType-->Get-->" + ex.Message + sql, ex);
}
return model;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">PromoShareConditionType對象</param>
/// <returns>更新結果</returns>
public int Update(PromoShareConditionType model)
{
int result = 0;
StringBuilder sbSql = new StringBuilder();
sbSql.Append("set sql_safe_updates=0;");
sbSql.AppendFormat("UPDATE promo_share_condition_type set condition_type_desc='{0}',condition_type_name='{1}',condition_type_status='{2}' WHERE promo_id='{3}';", model.condition_type_desc, model.condition_type_name, model.condition_type_status, model.condition_type_id);
sbSql.Append("set sql_safe_updates=1;");
try
{
result = _access.execCommand(sbSql.ToString());
}
catch (Exception ex)
{
throw new Exception("PromoShareConditionTypeDao-->Update-->" + ex.Message + sbSql.ToString(), ex);
}
return result;
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model">PromoShareConditionType對象</param>
/// <returns>新增后的標識</returns>
public int Add(PromoShareConditionType model)
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append("INSERT INTO promo_share_condition(condition_type_desc,condition_type_name,condition_type_status) ");
sbSql.AppendFormat(" VALUES('{0}','{1}','{2}');SELECT @@IDENTITY;", model.condition_type_desc, model.condition_type_name, model.condition_type_status);
try
{
DataTable _dt = _access.getDataTable(sbSql.ToString());
if (_dt.Rows.Count > 0)
{
return Convert.ToInt32(_dt.Rows[0][0]);
}
else
{
return 0;
}
}
catch (Exception ex)
{
throw new Exception("PromoShareConditionTypeDao-->Add-->" + ex.Message + sbSql.ToString(), ex);
}
}