public int Insert(int publishmentSystemId, StoreItemInfo storeItemInfo)
{
var storeItemId = 0;
IDataParameter[] parms = null;
var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(storeItemInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
storeItemId = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
DataProviderWx.StoreCategoryDao.UpdateStoreItemCount(publishmentSystemId);
return(storeItemId);
}
public void Update(int publishmentSystemId, StoreItemInfo storeItemInfo)
{
IDataParameter[] parms = null;
var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(storeItemInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
ExecuteNonQuery(sqlUpdate, parms);
DataProviderWx.StoreCategoryDao.UpdateStoreItemCount(publishmentSystemId);
}
public void Update(int publishmentSystemID, StoreItemInfo storeItemInfo)
{
IDataParameter[] parms = null;
var SQL_UPDATE = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(storeItemInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
ExecuteNonQuery(SQL_UPDATE, parms);
DataProviderWX.StoreCategoryDAO.UpdateStoreItemCount(publishmentSystemID);
}
public int Insert(int publishmentSystemID, StoreItemInfo storeItemInfo)
{
var storeItemID = 0;
IDataParameter[] parms = null;
var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(storeItemInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, SQL_INSERT, parms);
storeItemID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
DataProviderWX.StoreCategoryDAO.UpdateStoreItemCount(publishmentSystemID);
return(storeItemID);
}
