public int InsertSYS_Province(DbTransaction transaction, SYS_Province sys_province)
{
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_province.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_PARENTID, sys_province.ParentID, false));
para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_province.Code, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Province_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_ProvinceDataAccess.Insert: {0}", ex.Message));
}
}
public void DeleteSYS_Province(SYS_Province sys_provinces)
{
_sys_provinceDataAccess.DeleteSYS_Province(sys_provinces);
}
public void UpdateSYS_Province(SYS_Province sys_province)
{
_sys_provinceDataAccess.UpdateSYS_Province(sys_province);
}
public int InsertSYS_Province(SYS_Province sys_province)
{
return(_sys_provinceDataAccess.InsertSYS_Province(sys_province));
}