示例#1
0
        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));
            }
        }
示例#2
0
 public void DeleteSYS_Province(SYS_Province sys_provinces)
 {
     _sys_provinceDataAccess.DeleteSYS_Province(sys_provinces);
 }
示例#3
0
 public void UpdateSYS_Province(SYS_Province sys_province)
 {
     _sys_provinceDataAccess.UpdateSYS_Province(sys_province);
 }
示例#4
0
 public int InsertSYS_Province(SYS_Province sys_province)
 {
     return(_sys_provinceDataAccess.InsertSYS_Province(sys_province));
 }