Beispiel #1
0
        public bool Delete(int modelId)
        {
            ModelInfo modelInfoById = this.GetModelInfoById(modelId);

            if (modelInfoById.IsEshop)
            {
                OrderItem item = new OrderItem();
                if (item.ExistsProduct(modelInfoById.TableName))
                {
                    return(false);
                }
            }
            if (this.DeleteTable(modelId))
            {
                Parameters cmdParams = new Parameters();
                cmdParams.AddInParameter("@ModelId", DbType.Int32, modelId);
                string strSql = "DELETE FROM PE_Nodes_Model_Template WHERE ModelId = @ModelId";
                DBHelper.ExecuteNonQuerySql(strSql, cmdParams);
                if (DBHelper.ExecuteSql("DELETE FROM PE_Model WHERE ModelId = @ModelId", cmdParams))
                {
                    try
                    {
                        DBHelper.ExecuteSql("DELETE FROM PE_CommonModel WHERE ModelId = @ModelId", cmdParams);
                        if (modelInfoById.IsEshop)
                        {
                            DBHelper.ExecuteProc("PR_Shop_Product_DeleteModel", new Parameters("@TableName", DbType.String, modelInfoById.TableName));
                        }
                        return(true);
                    }
                    catch
                    {
                        return(false);
                    }
                }
            }
            return(false);
        }