public bool DeleteCloseAddressConfig(CloseAddressConfig obj)
{
try
{
ComDbOpen.DbOpen(_DBSession);
//清空参数
_DBSession.ClearParam();
string query = @"delete from CloseAddressConfig where id = @id";
// 设置SQL参数
_DBSession.SetInParam("@id", obj.Id);
_DBSession.ExecuteNonQuery(query);
_DBSession.Close();
return(true);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
public bool AddCloseAddressConfig(CloseAddressConfig obj)
{
try
{
ComDbOpen.DbOpen(_DBSession);
//清空参数
_DBSession.ClearParam();
string query = @"insert into CloseAddressConfig(sellerNick,receiverName,phone,status,createDate)
values(@sellerNick,@receiverName,@phone,@status,getdate())";
// 设置SQL参数
_DBSession.SetInParam("@sellerNick", obj.SellerNick);
_DBSession.SetInParam("@receiverName", obj.ReceiverName);
_DBSession.SetInParam("@phone", obj.Phone);
_DBSession.SetInParam("@status", obj.Status);
_DBSession.ExecuteNonQuery(query);
_DBSession.Close();
return(true);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
public static bool DeleteCloseAddressConfig(CloseAddressConfig obj)
{
ShieldRulesDAL objDal = new ShieldRulesDAL();
return(objDal.DeleteCloseAddressConfig(obj));
}
